Speed up your MySQL database

Fast Track

Low-Hanging Fruit

When it comes to database performance tuning, people often expect fast results – preferably yesterday. Changes in the application code that would offer genuine benefits are time consuming, however. For this reason, you have to determine where you can quickly eke out a little more performance. The faster solutions are:

  • Hardware with more RAM and a fast I/O system: a large RAID 10 with hard disks, SSDs, or both.
  • Correctly configuring the database: using RAM correctly – with innodb_buffer_pool_size for read access and innodb_log_file_size for high write throughput. If you can live with minor data loss in the case of a database crash, you can additionally set innodb_flush_log_at_trx_commit to 0 or 2. If you have a larger number of tables, it can also help to choose a larger value for table_open_cache and table_definition_cache.
  • Finally, creating the right indexes will always help to accelerate queries significantly.

If you need to speed up your MySQL database, understanding the important parameters and applying these practical tips can make the task much easier.

Buy this article as PDF

Express-Checkout as PDF
Price $2.95
(incl. VAT)

Buy ADMIN Magazine

SINGLE ISSUES
 
SUBSCRIPTIONS
 
TABLET & SMARTPHONE APPS
Get it on Google Play

US / Canada

Get it on Google Play

UK / Australia

Related content

comments powered by Disqus