October 2006
mysql-query-profiler - Measure and analyze query performance on MySQL.
by mbertierThis is the homepage for mysql-query-profiler, a text-mode tool to measure the work a query or batch of queries causes MySQL to do.
How to profile a query in MySQL - Xaprb
by mbertier & 2 others (via)This article explains how to really profile a query — what to measure, how to do it as accurately as possible, and what it means.
MySQL performance tuning best practices video
by dzc & 1 other (via)"Conférence sur l'optimisation de performances pour MySQL
Une conférence Google, par Jay Pipe, un expert MySQL. Le tout est filmé en direct lors de la conférence, puis proposé via google video. Le tout est en anglais, assez abordable. La conférence est très intéressante " (nexen)
September 2006
August 2006
MySQL Reference Manual for version 3.22.32.: Performance
by fakechrisGetting maximum performance from MySQL
July 2006
ProfitPapers | Papers : Performance Tuning Mysql for Load
by springnet & 3 othersOn one of the largest Vbulletin based forums I operate we just finished a record month with a little over 217,000 uniques with just shy of half a million total users. As anyone else running a big board knows hitting these types of figures while maintainin
MySQL Performance Blog » Thoughts on MySQL Replication
by mbertierSo what would be my list of limits and watch outs in this case ?
June 2006
MySQL Performance Blog » INSERT ON DUPLICATE KEY UPDATE and summary counters.
by nhoizey & 1 otherINSERT ... ON DUPLICATE KEY UPDATE is very powerful but often forgotten MySQL feature.