Tagged Questions
1
vote
1answer
27 views
Allocating 8GB memory to MySQL on a 64bit system
Specs -
MySQL 5.0.x , Redhat 5.9 , Physical memory - 16GB
I am trying to set innodb buffer pool size to 8GB (innodb_buffer_pool_size=8G). When i do, and start mysql, i get following error -
...
0
votes
0answers
75 views
UPDATE / SELECT incredibly slow in MySQL InnoDB
I have 1 table with 2.5 billion records(2.5 Cr.) and I am trying to get count of records based on indexed column. it takes 115 seconds to execute same.
Query : Select count(1) from table1 where ...
1
vote
1answer
220 views
Where is the MySQL variable - innodb_flush_method?
I would like to tweak the value of innodb_flush_method to find out its performance impact on a database server. That variable is listed when I run the command SHOW VARIABLES.
But I could not find it ...
1
vote
1answer
228 views
How to know the current log sequence number in 5.0.X
I would like to test the optimal value for iblog files on my mysql which is 5.0.77
I found the below procedure in mysqlperformance blog:
...
3
votes
1answer
1k views
PostgreSQL 9.1 vs MySQL 5.6 with InnoDB ? Which is better for scaling?
PostgreSQL 9.1 vs MySQL 5.6 with InnoDB. I do know that PostgreSQL offers better SQL features.
I am currently using MySQL 5.6 lab release (the one with InnoDb full text search feature)(not in ...
5
votes
3answers
1k views
Maximum table size for MySQL database server running on Windows (NTFS) Table type InnoDB
I need to design database to store information contained in millions of log files generated by devices on trial on network.
I have designed 5 different tables to store log file information. But, as ...
3
votes
0answers
98 views
MySQL 1264 warning from libmysql
I'm using the libmysql.dll library to connect to my database from a 3rd party application (metatrader).
I managed to connect and things are going almost fine. I use mysql_real_connect and ...
1
vote
0answers
404 views
Tables don't exist after MySQL restart
I recently made changes to optimize performance for InnoDB engine-based DB and soon after when restarting I encounter into the following strange behavior:
I have some tables with data in them
I made ...
1
vote
1answer
152 views
some InnoDB settings in My.cnf are messing up everything, why?
When I edit my.cnf in MySQL 5.0 in filemanager and add the following settings, I get logged out automatically from Kloxo and when I remove these line and restart server everything is ok then:
...
3
votes
1answer
233 views
why is mysql still writing data two hours after all transactions have stopped
I have a mysql server used mostly as data warehouse. It loads about 4-5GB of data per day (actual database size, not the size of the source data).
Lately, I noticed something peculiar. After I ...
3
votes
1answer
2k views
What is the use of ibdata1 file in mysql?
I have application which has the backend db as Mysql(InnoDb engine), and currently my client wants to decrease the size of the ibdata file to some fixed size. I found the three below solutions.
...
2
votes
1answer
413 views
Are many NULL columns harmful in mysql InnoDB?
As I explored the clustered B-tree index system of InnoDB, I think that the presence of many NULL (or small) columns has no significant effect on InnoDB performance.
Does the presence of excess ...
1
vote
1answer
775 views
How to update mysql my.cnf without getting error?
I updated the MySQL my.conf file and and restarted my server without a problem.
As soon as I tried to access a table I received the error
mysql #1033 - Incorrect information in file:
I reverted ...
2
votes
1answer
360 views
Do I have duplicate key indexes?
CREATE TABLE relations (
object_id BIGINT(20) NOT NULL PRIMARY KEY,
object_term BIGINT(20) NOT NULL,
UNIQUE KEY link(object_id, object_term),
CONSTRAINT fk_term FOREIGN KEY(object_term)
...
1
vote
1answer
1k views
ERROR 1114 (HY000) at line 6308 in file & The table user_analysis is full
There is a SAN mounted 1TB partition for Mysql backups in our server with version 5.0.45-log. From two days, im seeing the log entries ERROR 1114 (HY000) at line 6308 in file & The table ...
3
votes
2answers
2k views
Query runs a long time in some newer MySQL versions
I have created a database on MySQL 5.0.15. I have a query and when I run this query on this MySQL version, I get 0.9 s run time. When I import this database to another MySQL server with same hardware ...
43
votes
7answers
23k views
How can I optimize a mysqldump of a large database?
I have a symfony application with an InnoDB database that is ~2GB with 57 tables. The majority of the size of the database resides in a single table (~1.2GB). I am currently using mysqldump to ...
