…IO_r_wait you can see how much time (in seconds) it took InnoDB to actually read the data …database traffic, it’s considered experimental and as such I don’t recommend using it in production or on any important system! The patch is available for MySQL Community 5.0.45 on Linux. May not work on …
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
Post: Living with backups
November 6, 2008 By 28 Comments
…one-liners) On Linux there is also a utility called ionice. It allows to affect how I/O…at runtime anyway. To check what is the current setting you need to query your block devices….to happen on the working instance of MySQL. Such danger may for example come from an unexpected spike in load or traffic…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…how to run configure command, which needs to be done prior to…to check the platform specific part of the reference manual for hints about installing MySQL on…to slow log to only those from every (1/log_slow_rate_limit) session. With high traffic coming to…
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
… Can’t connect to MySQL server on ‘mydb’ (110). If…queue overflow. You can check if it is the …to consider if this is what is happening. First – Linux…how MySQL accepts connection. There is single main thread which is accepting connections coming to… “random arrivals” nature of traffic you will see some…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
…on newer Linux versions, which also can be used. Using PHP to serve files This usually comes in play if security control for files or traffic limit per user needs to…to use X-send-file or similar custom headers which make PHP script just to check restrictions and have web server to…
