…, and projected InnoDB performance on this size will be the same or worse, but will require 1TB in size. Now to … 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 #…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…which shows the most consistent performance. The others all have assorted performance drops scattered throughout the …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: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
… benchmarking insert performance on Amazon EC2, and …buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer…, PRIMARY KEY (`transactionid`), KEY `marketsegment` (`price`,`customerid`), KEY `registersegment` (`cashregisterid`,`price`,`customerid`), KEY `pdc` (`…
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… Cores Inserting data to about 20 tables I’ve seen performance gains as much as 10x compared to using single shared key cache…
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…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…. Good for performance but tables will be badly corrupted on crash. delayed_insert_limit, delayed_insert_timeout, delayed_queue_size Delayed inserts configuration. …by SQL layer so applies to all storage engines. key_buffer_size Key Buffer used to buffer Index blocks (row data is not cached). Used …
Post: Predicting how long data load would take
May 24, 2007 By 14 Comments
… are built by inserts in Btree order in which entries are inserted in the index can affect performance dramatically. Table Size This is the… bulk_insert_tree_size increase myisam_sort_buffer_size or key_buffer_size increase. Innodb typically needs large innodb_buffer_pool_size and large innodb_log_file_size to perform load…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…size = 8 query_cache_size = 128M join_buffer_size = 8M long_query_time=300 key_buffer_size = 500M concurrent_insert=2 myisam_sort_buffer_size…
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… Neither IO alignment nor file size made any difference. Adding LVM here reduced single-thread performance by 5-10%. …
