I wanted to write a few administrative updates in one so I didn’t spam everyone’s feed readers too much. Here we go:
|
1 |
My favorite Percona patch : innodb fast recovery patch. |
|
1 |
|
1 |
Reason: Innodb recovery has always been a big headache for any DBA since it used to take ages to complete a recovery after crash. Now with the patch I am able to do a recovery in less than a tenth of the time it used to take. Great job by Yasufumi in hacking the code(not just this patch :) ) which has been a nightmare for all DBA's. |
|
1 |
My favorite patch is "Micro second slow query patch" as it actively allows me to identify the queries which takes few seconds to execute but their frequencies is just too high i.e. few hundred times a hour. By optimizing these queries I can freeup the server resources to do other useful work. |
Boston would be a great location for east coast workshops.
new york city, of course!
Morgan,
Small update re: trackbacks – I installed plugin to show trackbacks at the end of page, after comments.
Washington DC is right in the middle. Perfect location.
Might Montreal be a contender?
brianb08, Jim B, Salim, MLBR: Thank you for the suggestions. Keep them coming!
brianb08, if you want free training in the Boston area, there’s always the Boston MySQL User Group — http://www.meetup.com/mysqlbos — the user group meetings are technical and chock full of really good content.
Sheeri, Thanks for the info on the Boston MySQL User Group… wasn’t aware but will definitely check that out.
>>>My favorite patch is “Micro second slow query patch” as it
>>actively allows me to identify the queries
>>which takes few seconds to execute ??? but their frequencies is just too high
hah? I don’t understand why would micro second slow query patch help in this case.
‘@yingkuan – The microsecond slow query patch has no minimum threshold, so you can set it to zero and grab everything (we do this ourselves on customer machines).
Commenters might suggest that this is what the general log is for (but this doesn’t work). Since the general log is used before the parser it can’t provide any execution statistics.