…size. This will give us some interesting information about how Shard-Query will perform on each database. To do the size…internal [host list omitted] Now you need to set up the hosts file: sudo su – # cat hosts… innodb-write-io-threads=4 join-buffer-size=16M key-buffer-size=64M local-infile=on lock-…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…set is, say, 100 GB, then increasing the buffer pool size does not help. PZ: I should note for most application working set…random writes to them are actually slower than to a mechanical disk. I do not know how it … in an ascending order of the PRIMARY KEY, then InnoDB should have placed the rows …
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…buffers which are allocated at start and always where – these are key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…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… is unaware how to align files properly. 4. Partition table and file system properly aligned; sunit/swidth set during mkfs…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… starts like this – you have configured MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections…: NULL 3 rows in set (0.00 sec) Innodb Memory Usage Finally it is often helpful to check how much memory Innodb has…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…Buffer Pool 10% less than your database size you would not loose much anyway. You also may choose to set buffer… in. The next step would be to decide How Much Memory do you need for… include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, per thread sort buffer which can be…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… size and spindle speed. I need to know how many physical spindles are under the box, and how…s hard to read. If the InnoDB buffer pool is set to 22GB, it’s much easier to see 22GB …key-checker to find redundant indexes, and so on. As with settings and status, these set the stage for bigger gains to…
Comment: MySQL: what read_buffer_size value is optimal ?
September 21, 2008 By 25 Comments
… how do you properly set the buffers to 128 kbyte? I put this in my my.cnf: key_buffer_size = 256M sort_buffer_size = 128K read_buffer_size = 128K read_rnd_buffer_size = 128K join_buffer_size…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…how do you determine the memory consumption per connection in average? This leads to…savepoint’, ’0′ ‘Com_select’, ’378247551′ ‘Com_set_option’, ’285487367′ ‘Com_show_…key_buffer_size=32M # Only for MyISAM which isnt used. sort_buffer_size=2M query_cache_size=10M # Might be increased thread_cache_size…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…settings and installation configuration of the machine. I am interested in how many processors and processor type, processor cache, RAM size…size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size=185M key_buffer_size=157M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size…
