…key caches. But I’ll give the simple version here. In my opinion, you should choose a 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: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…innodb-thread-concurrency-timer-based innodb-thread-sleep-delay=0 innodb-use-sys-stats-table innodb-write-io-threads=4 join-buffer-size=16M key-buffer-size…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…my.cnf to set global options, # mysql-data-dir/my.cnf… skip-locking key_buffer_size = 2000M max_allowed_packet = …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: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… is: set innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB‘s buffer pool. For… primary key lookups or not showed up in “show innodb statusâ€. select * from table where id=5 show innodb status: Hash table size 10624987, used cells 1, node heap has 1 buffer…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… 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… workload. P.S Note MySQL distribution contains bunch of sample my.cnf files which may be great templates to use. Typically they…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections”. This was never true … for InnoDB: specifically, the buffer pool. (There’s also an innodb_additional_mem_pool_size but … a my.cnf for a server, I usually calculate the Big Ones like the buffer pool…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…size=100G myisam_sort_buffer_size=185M key_buffer_size=157M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=256K #*** INNODB Specific options *** innodb_additional_mem_pool_size=20M innodb…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb…size = 16M max_heap_table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size = 8M myisam_sort_buffer_size…
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 116 Comments
… configuration is as follows::: [root@crm ~]$ vi /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/…key_buffer_size=64M read_buffer_size=1M read_rnd_buffer_size=1M sort_buffer_size=203K innodb_additional_mem_pool_size=2M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=1M innodb_buffer…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
…interesting scenario: foreign keys mysql> CREATE TABLE parent (id INT NOT NULL, -> PRIMARY KEY (id) -> ) ENGINE=INNODB; — 0 …my.cnf settings: innodb_buffer_pool_size=24G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size…
