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 andinnodb_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 setinnodb_flush_log_at_trx_commit
to0
or2
. If you have a larger number of tables, it can also help to choose a larger value fortable_open_cache
andtable_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.
Infos
Buy this article as PDF
Express-Checkout as PDF
Price $2.95
(incl. VAT)
(incl. VAT)