1
vote
1answer
357 views

MySQL MyISAM multi-core optimization

I've noticed that our app does not respond to requests when a demanding request is in execution. Running top seems to identify the source of the problem: top - 13:54:25 up 1 day, 13:43, 2 users, ...
1
vote
1answer
781 views

Tuning MySQL of 1.3 G DB, 8GB Ram, High IO Wait

I am having MySQL database of size 1.3 GB on 8 core virtual machine, 8 GB of memory and I am having troubles optimizing the configuration. There is a lot of small rows and lot of joins going on. I've ...
1
vote
1answer
508 views

How can I lower MySQL single-page reads?

My innodb buffer pool size is 8GB and my database is 6GB in size but I see this: Innodb_buffer_pool_reads 263.5k - The number of logical reads that InnoDB could not satisfy from buffer pool and had ...
0
votes
3answers
7k views

Optimal MySQL my.cnf setting for large Magento site on a dedicated server

Our dedicated server is running a large Magento store with a MySQL database approximately 250MB in size. The server spec is listed as having 5 Xeon 2Ghz processors (4MB cache) and 12GB of memory. ...
4
votes
2answers
705 views

Disk I/O utilization up to 100% after tuning InnoDB-related MySQL configuration

I have added following lines to "my.conf": query_cache_size=128M innodb_buffer_pool_size=512M innodb_flush_method=O_DIRECT After that Disk utilization started raising, reached 100% and holds ...
0
votes
2answers
591 views

MySQL InnoDB database 'hangs'

I have a problem with a MySql server causing it to freeze all the time. In phpMyAdmin when this happens I can see in "Show Processlist" are lots of processes for User "unauthenticated user" with ...
1
vote
1answer
217 views

MySQL: view read/write proportion, per specific table

I'm optimizing the configuration of a MySQL server, running only Bromine. This is non specific to application, and was just noted for completeness. I am trying to determine if switching from MyISAM to ...
0
votes
2answers
634 views

changing innodb_buffer_pool_size makes error

i want to increase my innodb_buffer_pool_size value to get some more performance and when i try, my select queries arises error such as "Incorrect information file in .." i'm just adding ...
1
vote
1answer
289 views

What is the fastest way to optimize a MySQL table?

I've ran many different DELETE queries against many tables in the huge database (hundreds of millions records). What would be faster - to run OPTIMIZE TABLE against each modified table. Or just to ...