For those of us who were not able to attend this years Mysql Conference in Santa Clara, CA, the keynote videos have been posted online for your viewing pleasure!
Here is a link to another location (Youtube), that has some more of the videos from the Mysql Conference, including the one given on Oracle to Mysql migration given by NPR’s own Joanne Garlow.
Here is a quick link to a blog post that talks about RAID caching for various database workloads.Â The post also lists some of the popular RAID cards that are being put into use today, as well asÂ some interesting features that the author feels are missing from these current lineup of available RAID cards.
Joanne Garlow one of the Senior developers here at NPR , will be giving a talk this Tuesday at the 2010 O’Reilly MySQL Conference and Expo in Santa Clara, CA.Â The talk is entitled ‘Migration from Oracle to Mysql : An NPR Case Study’ and will focus on some of the ‘lessons learned’ during our recent Oracle to Mysql migration, it will also cover some of the tools that we found useful during the migration as well as some of the issues we encountered concerning character encoding and concurrency.
If you are thinking about converting your backend databases from Oracle to Mysql and you are attending this conference, you should attend this talk, as I am sure it will be very informative and quite helpful to you going forward.
One of the tools that is included with Maatkit is called ‘mk-query-digest’.Â If you have Mysql slow loggingÂ enabled, this perl script can me used to examine these entries, and provide a very useful and user friendly report that will help you understand the queries that are exceeding your current slow log threshold. You can then take the results and determine whether or not you have opportunity to do some schema and/or query optimization.
In order to get the ball rolling all you need to do is execute the following command:
‘perl /path/to/mk-query-digest /path/to/slow.log’
Once you do you will be presented with a report similar to the following:
# 200ms user time, 10ms system time, 9.59M rss, 11.17M vsz
# Overall: 199 total, 8 unique, 0.92 QPS, 3.44x concurrency ______________
#Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â totalÂ Â Â Â minÂ Â Â Â maxÂ Â Â Â avgÂ Â Â Â 95%Â stddevÂ median
# Exec timeÂ Â Â Â Â Â Â Â Â Â 745sÂ Â Â Â Â 1sÂ Â Â Â 15sÂ Â Â Â Â 4sÂ Â Â Â Â 9sÂ Â Â Â Â 3sÂ Â Â Â Â 3s
# Lock timeÂ Â Â Â Â Â Â Â Â Â Â 4msÂ Â Â Â Â Â 0Â Â 159usÂ Â Â 21usÂ Â Â 66usÂ Â Â 18usÂ Â Â 16us
# Rows sentÂ Â Â Â Â Â Â Â 16.35MÂ Â Â Â Â Â 0 381.59kÂ 84.16k 298.06kÂ 81.83kÂ 76.03k
# Rows examÂ Â Â Â Â Â Â Â 16.35MÂ Â Â Â Â Â 0 381.59kÂ 84.16k 298.06kÂ 81.83kÂ 76.03k
# Time rangeÂ Â Â Â Â Â Â 2010-03-04 18:32:44 to 2010-03-04 18:36:21
# bytesÂ Â Â Â Â Â Â Â Â Â Â Â 55.53kÂ Â Â Â Â Â 6Â Â 7.67kÂ 285.75Â 313.99Â 519.23Â 271.23