…_DIRECT The next graphs show the frequency of IO, and you can see we can get more IO performance with the new… enables to control the number of the IO threads on Unix/Linux and makes the threads to be used equally for…, If you are using fast RAID storage, and/or observe performance decrease caused by shortage of free buffers you may try…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… prints out a lot of internal Innodb performance counters, statistics, information about transaction processing and … are executed by threads running queries. On Unix/Linux you will always see 4 helper …. This is parameters which is great for graphing and monitoring. “16384 avg bytes/read” shows …
Comment: Tools
June 1, 2008 By 31 Comments
…the_ tool for analyzing I/O activity (cause, performances, kernel paths, …) on Linux. – iogrind : another I… : a very underestimated old unix tool. included (but not often activated) in most unixes, this records system … can be re-used to draw nice graphes/charts) – ethtool/mii-tool : to check …
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
…without splitting the file? The answer lies in the Unix fifo. I created a script that reads lines …B-Tree indexes. The two curves on the Cacti graph actually show both files being loaded. It might …an I/O-bound server and see what the performance impact is, especially on other transactions running at …
Comment: MySQL 5.5-m2 scalability
March 9, 2010 By 17 Comments
…noone else pointed out the scaling of the graphs x-axis is not OK. actually, from my… the performance hit from adding more threads should not bring 16-core performance down to the performance of 2 threads…innodb up to the performace of a 128core unix iron + better scaling database. anyway, I think …
