… the conference with your friends and colleagues! Second prize is one of ten copies of the new High Performance MySQL, 3rd Edition… responsible for your own travel, lodging, and other expenses. Ten second prizes are a free copy of the new book “High Performance MySQL… (March 15th, depending on your timezone) through the 22nd, and we’ll announce the winners as soon afterwards as we can Good luck!
Post: What MySQL buffer cache hit rate should you target
June 29, 2006 By 5 Comments
… hit rate is good for optimal MySQL Performance” is typical question I’m asked. It could by …writes, how good was OS or SAN cache hit rate – something you would not see otherwise. The bad luck is …IO – no matter what your hit ratio is it is unlikely the problem for MySQL Performance. If it is however …
Post: Why Index could refuse to work ?
September 8, 2006 By 13 Comments
… 1 row in set (0.00 sec) No Luck. Even Force Index can’t cure… an INTEGER ? I see no good reason but It is quite frequently…is much better to define your columns as INT for many reasons, but …performing index lookup ? This can’t be done as it would result in wrong result for…
