…/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per…_cache=16384 innodb_flush_method=O_DIRECT key_buffer_size=10G # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there … been recommending for a while. innodb_stats_on_metadata = off Yet another change I actively recommended … simple and complicated queries efficiently automatically. join_buffer_size = 256k The default is now double of …
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
…’ve discovered even read_buffer_size selection may be less than obvious. What do we generally hear about read_buffer_size tuning ? If you… high value. Sample my.cnf values on large memory sizes recommend 1M settings and MySQL built-in default is 128K. Some people having…_buffer_sizeTime (sec)820045.216K44.832K45.664K43.4128K43.0256K51.9512K60.82M65.28M66.832M67.2 8200 bytes is the minimum size for read_buffer_size…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… [1] recommends using the innodb_max_dirty_pages_pct and innodb_io_capacity parameters to get stable throughput in MySQL 5.5…_method = O_DIRECT innodb_log_buffer_size = 64M innodb_buffer_pool_size = 26G innodb_buffer_pool_instances=16 innodb_log_file_size = 2000M innodb_log_files…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… read_rnd_buffer_size, while MariaDB introduces a different variable to control the MRR buffer size mrr_buffer_size. Both buffer sizes default to 256K in MySQL 5.6… query execution plan, is not sufficiently tuned and it is recommended to turn this off. The query used is: select c…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
… innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 1900M innodb_log_files_in_group… we were using SSD as storage, then I would recommend it. Vanilla MySQL performs equally bad on SSD and HDD, while for… results on Percona Server. So first recommendation you may hear in this case from the Oracle/MySQL engineers is to decrease “innodb…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…database size you need to check if there are any restrictions on Innodb Buffer Size … MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, per thread sort buffer…innodb buffer pool. I guess these clarifications work better than 70-80% recommendation and…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… is UNIQUE the drawback is insert buffer will not be able to be …I also would note there are some MySQL optimizer restrictions in how well it… them which are accessed frequently. The size of this “working set” can greatly… a difference though. Q: Would you recommend creating an index in every table you…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… writes to about 6 tables, what version of Innodb/MySQL would you recommend? I’ve been staying at 4.1.14 because… memory used for applications (of which Mysql is the main one with “innodb_buffer_pool_size=20480Mâ€) while the bulk of the… this matter the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…programs # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock bind-address=10.234.94.71 skip-locking key_buffer_size = 2000M max…recommended #log-bin # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname tmpdir =/mysql…
