Re: Optimizing the MySQL server performance

[bob ly]

Here is the output of running mysqlreport

__ Key _________________________________________________________________
Buffer usage 670.74M of 756.00M %Used: 88.72
Write ratio 0.34
Read ratio 0.01

__ Questions ___________________________________________________________
Total 102.94M 238.28/s
Slow 3.83k 0.01/s %Total: 0.00 %DMS: 0.01
DMS 71.74M 166.06/s 69.69
INSERT 71.49M 165.49/s 69.45 99.66
SELECT 239.24k 0.55/s 0.23 0.33
DELETE 4.04k 0.01/s 0.00 0.01
UPDATE 901 0.00/s 0.00 0.00
REPLACE 419 0.00/s 0.00 0.00
Com_ 78.78k 0.18/s 0.08
change_db 37.02k 0.09/s 0.04
show_status 16.81k 0.04/s 0.02
show_innodb 16.74k 0.04/s 0.02

__ Table Locks _________________________________________________________
Waited 67 0.00/s %Total: 0.00
Immediate 65.85M 152.42/s

__ Tables ______________________________________________________________
Open 215 of 512 %Cache: 41.99
Opened 7.66k 0.02/s

__ Connections _________________________________________________________
Max used 8 of 100 %Max: 8.00
Total 6.06k 0.01/s

__ Created Temp ________________________________________________________
Disk table 35 0.00/s
Table 313.88k 0.73/s
File 97 0.00/s



And I changed query_cache_min_res_unit to 8192 from 4k, Is there are anything which can be tweaked. Also I am using insert delayed while inserting records and this has not helped me either. Is there a way I could make read access more priority.

Thanks