MySQL Conference & Expo 2010 schedule

Monday 12th April 2010

  • Beyond ’gem install MySQL’ in Ruby

    by Ilya Grigorik

    There is much more to MySQL performance in Ruby than ‘gem install mysql’ and syntactic optimizations. Whether you are running Ruby MRI (C version), or JRuby (JVM), or any other Ruby VM, and are looking to optimize your performance architecture (response times or throughput), the architecture and the MySQL driver you choose (yes, there is more than one!) have significant influence on the outcome. Different VM’s expose different behaviors: native threads vs. green threads, a global interpreter lock (GIL) vs. no lock, and result in dramatically different behaviors under load.

    In this talk we will look under the hood of the most popular Ruby VM’s and evaluate a number of alternative drivers (mysql gem, mysqlplus, evented-mysql, and others), which can help you significantly improve the performance and throughput of your Ruby+MySQL application.

    This talk will assume basic knowledge of Ruby and MySQL, and will cover:

    • High-level architecture of the Ruby VM’s and performance impacts on MySQL
    • Analysis of the MySQL gem and its performance implications
    • Discussion on architecture implications in different popular Ruby VM’s
    • Evaluating alternative drivers: MySQLplus and event-driven MySQL
    • Hands on examples & code

    On Monday 12th April

    Coverage slide deck