I wanted to write a few administrative updates in one so I didn’t spam everyone’s feed readers too much. Here we go:
- We’ve had reports of some lost comments. Â We reported this via Twitter a while ago, but thought it was fixed. Â We’ll try and pay more attention to spam filtering, but we wanted to reach out and say – let us know if you are one of the people having problems. Â We’re listening. Â (Of course if you have any suggestions on how to manage/filter through thousands of spam items/week, we’d like to know as well).
- Pingbacks were recently dropped when we upgraded to WordPress 2.8. Â Miss them? Â We’ve turned them back on.
- Our training sales for Santa Clara and San Francisco are going well. Â As a result we’re planning to have an east coast location at some point in the future. Â Please feel free to comment where you would like that to be!
- We have notified the winners of of our training competition. Â I wanted to share their comments:1My favorite Percona patch : innodb fast recovery patch.11Reason: 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.
And:1My 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. - And the last item is a reminder: the deadline for our early bird registration on training is Monday.
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.