…to minimize Key_reads because they are slow and …key_buffer_size until, when the buffer is full, Key_reads/Uptime reduces to a number you’re comfortable with. Set key_buffer_size…InnoDB tuning? You might be wondering, what about InnoDB tuning? What is the best way to choose an innodb_buffer_pool_size…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…will be free already. OS Waits are relatively slow, and if you get tens of thousands …table `test/child`: , CONSTRAINT `child_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`) ON DELETE …check if your innodb_log_buffer_size is optimal – if you see more than 30% of log buffer size being …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…key_buffer_sizeblogpercona.commanual key_cache_age_thresholdblogpercona.commanual key_cache_block_sizeblogpercona.commanual key_cache_division_limitblogpercona.commanual Key_read_requestsblogpercona.commanual Key_readsblogpercona.commanual Key…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…slow-queries.log max_connections=650 open_files_limit=6144 max_connect_errors=10000 interactive_timeout=3600 wait_timeout=3600 key_buffer_size…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…home/mysqld/mdmp/tmp slow_query_log=mdmp_slow_queries.log # binary logging and replication binlog_cache_size=1M binlog_…size = 128M join_buffer_size = 8M long_query_time=300 key_buffer_size = 500M concurrent_insert=2 myisam_sort_buffer_size = 64M # innodb innodb_additional_mem_pool_size=32M innodb…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…key_buffer_size…innodb_buffer_pool_size = 8000M #innodb_additional_mem_pool_size = 80M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…affect Innodb and other storage engines transaction logs, slow query… storage engines. key_buffer_size Key Buffer used to buffer Index blocks (row…buffer) and for reading rows in sorted order (read_rnd_buffer_size). Other storage engines such as Innodb to not use this variable. sort_buffer_size Buffer…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… using Innodb tables. Innodb tables are much more sensitive to buffer size compared to MyISAM. MyISAM may work kind of OK with default key_buffer_size even with large data set but it will crawl with default innodb_buffer_pool_size. Also Innodb buffer pool caches both… help. Do not set it too large as it may slow things down as its maintenance may get expensive. Values from…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…innodb max_connections = 600 #thread_stack= 150M key_buffer = 256M key_buffer_size = 256M myisam_sort_buffer_size = 16M join_buffer_size = 64M read_buffer_size = 16M sort_buffer_size…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…can a bit slow it down. Plus there were bunch of micro optimizations in Innodb in 5…. in an ascending order of the PRIMARY KEY, then InnoDB should have placed the rows in…innodb statusâ€. select * from table where id=5 show innodb status: Hash table size 10624987, used cells 1, node heap has 1 buffer…
