Hi all, after random times not only about high usage, i have this message on Mysql Administrator ( Windows ), logged to my Dedicated Database ( Linux ).
Here is a print of error: http://img25.imageshack.us/img25/2342/mysqlthreaderror.jpg Here is a print of putty using 'top' on dedicated server: http://img15.imageshack.us/img15/2412/tophym.jpg Here is a print of ./mysqltuner.pl http://img5.imageshack.us/img5/8991/mysqltuner.jpg Here is a print of ./tuning-primer.sh http://img17.imageshack.us/img17/544/tunning.jpg And finally a print of my.cnf http://img6.imageshack.us/img6/2877/83767908.jpg Here my mysqladmin extended-status mysqladmin status Uptime: 188937 Threads: 10 Questions: 21396848 Slow queries: 1 Opens: 501 mysqlreport Flush tables: 3 Open tables: 124 Queries per second avg: 113.249 MySQL 5.0.77-log uptime 2 7:18:39 Thu May 7 23:31:40 2009 __ Key _________________________________________________________________ Buffer used 302.78M of 1.56G %Used: 18.92 Current 400.58M %Usage: 25.04 Write hit 79.26% Read hit 99.83% __ Questions ___________________________________________________________ Total 22.84M 114.7/s DMS 22.49M 113.0/s %Total: 98.50 Com_ 459.78k 2.3/s 2.01 -Unknown 174.07k 0.9/s 0.76 QC Hits 52.34k 0.3/s 0.23 COM_QUIT 5.14k 0.0/s 0.02 Slow 3 s 1 0.0/s 0.00 %DMS: 0.00 Log: ON DMS 22.49M 113.0/s 98.50 REPLACE 11.65M 58.5/s 51.01 51.79 SELECT 4.34M 21.8/s 18.99 19.28 DELETE 4.18M 21.0/s 18.29 18.56 INSERT 2.17M 10.9/s 9.51 9.65 UPDATE 160.05k 0.8/s 0.70 0.71 Com_ 459.78k 2.3/s 2.01 admin_comma 173.95k 0.9/s 0.76 show_status 140.38k 0.7/s 0.61 show_innodb 140.03k 0.7/s 0.61 __ SELECT and Sort _____________________________________________________ Scan 574.01k 2.9/s %SELECT: 13.24 Range 4.89k 0.0/s 0.11 Full join 0 0/s 0.00 Range check 0 0/s 0.00 Full rng join 0 0/s 0.00 Sort scan 208.82k 1.0/s Sort range 578.84k 2.9/s Sort mrg pass 0 0/s __ Query Cache _________________________________________________________ Memory usage 11.08M of 128.00M %Used: 8.65 Block Fragmnt 35.60% Hits 52.34k 0.3/s Inserts 4.25M 21.4/s Insrt:Prune 4.25M:1 21.4/s Hit:Insert 0.01:1 __ Table Locks _________________________________________________________ Waited 59.71k 0.3/s %Total: 0.26 Immediate 22.54M 113.2/s __ Tables ______________________________________________________________ Open 136 of 500 %Cache: 27.20 Opened 513 0.0/s __ Connections _________________________________________________________ Max used 13 of 50 %Max: 26.00 Total 5.28k 0.0/s __ Created Temp ________________________________________________________ Disk table 439 0.0/s Table 141.93k 0.7/s Size: 32.0M File 14 0.0/s __ Threads _____________________________________________________________ Running 1 of 10 Cached 3 of 200 %Hit: 99.75 Created 13 0.0/s Slow 0 0/s __ Aborted _____________________________________________________________ Clients 260 0.0/s Connects 7 0.0/s __ Bytes _______________________________________________________________ Sent 8.93G 44.8k/s Received 8.03G 40.3k/s __ InnoDB Buffer Pool __________________________________________________ Usage 0 of 0 %Used: 0.00 Read hit 0.00% Pages Free 0 %Total: 0.00 Data 0 0.00 %Drty: 0.00 Misc 0 0.00 Latched 0.00 Reads 0 0/s From file 0 0/s 0.00 Ahead Rnd 0 0/s Ahead Sql 0 0/s Writes 0 0/s Flushes 0 0/s Wait Free 0 0/s __ InnoDB Lock _________________________________________________________ Waits 0 0/s Current 0 Time acquiring Total 0 ms Average 0 ms Max 0 ms __ InnoDB Data, Pages, Rows ____________________________________________ Data Reads 0 0/s Writes 0 0/s fsync 0 0/s Pending Reads 0 Writes 0 fsync 0 Pages Created 0 0/s Read 0 0/s Written 0 0/s Rows Deleted 0 0/s Inserted 0 0/s Read 0 0/s Updated 0 0/s Thanks this erros is ending my life =D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
