…_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size…=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer_size=10G # Disabling symbolic-links is recommended to prevent assorted security…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… by reporting any bugs at http://bugs.percona.com/ key_buffer_size=52428800 read_buffer_size=131072 max_used_connections=13 max_threads=2002 thread… It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4432877 K bytes of memory Hope that…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…_table_size = 64M server-id = 10 #*** MyISAM Specific options key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size = 64M serverid = 101 key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… covered in the first post: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside… innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group… and indices to the buffer pool we use following queries: select avg(id) from sbtest$i force key (primary) select count(*) from…
Post: Beware: key_buffer_size larger than 4G does not work
February 14, 2007 By 17 Comments
…, so they set key_buffer_size to 16G… and every few days MySQL crashes. Why ? Because key_buffer_size over 4GB in size is not really supported… just fine until you have less than 4GB worth of key cache used and then it would crash. If you do… not only fix was not made available but even maximum key_buffer_size was not restricted to safe limit. Former would be close…
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
… “max size” and the corresponding buffers are allocated only as big as needed (key_buffer_size). There are many examples of this. What about join_buffer_size? I saw a my.cnf with a 128M join_buffer_size the…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…. Raise the key_buffer_size until, when the buffer is full, Key_reads/Uptime reduces to a number you’re comfortable with. Set key_buffer_size really big, and then measure its size…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
… the sum key buffer size (4000000000 in this case) and actual index size: select concat(“SET GLOBAL “, t.table_schema,”_”,t.table_name,”.key_buffer_size=”,round… (“a”,”b”); +———————————————+ | cmd | +———————————————+ | SET GLOBAL test_a.key_buffer_size=39514112; | | SET GLOBAL test_b.key_buffer_size=28390400; | +———————————————+ 2 rows in set (2 min 31…
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
Looking for documentation for read_rnd_buffer_size you would find descriptions such as “The read_rnd_buffer_size is used after a sort… very similar to read_buffer_size which is currently only used by MyISAM tables I thought read_rnd_buffer_size is also MyISAM only… having only row pointers together with key value – which are offsets for MyISAM and primary key values for Innodb or storing full…
