…queries in Flight #3 that are faster using MyISAM, Q4.3 examines very little data. It seems that InnoDB performs…mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…cache = 10240 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…query_alloc_block_sizeblogpercona.commanual query_cache_limitblogpercona.commanual query_cache_min_res_unitblogpercona.commanual query_cache_sizeblogpercona.commanual query_cache_typeblogpercona.commanual query_cache_wlock_invalidateblogpercona.commanual query…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…CACHE | 400 | 1400 | | PORT | 5530 | 5610 | | QUERY_CACHE_TYPE | ON | OFF | | REPORT_PORT | 5530 | 5610 | | PERFORMANCE…MySQL 5.5 and before it was “ON” by default with query cache size of 0 which makes it disabled. I wish query_cache_size…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL…query_cache_size If your application is read intensive and you do not have application level caches…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…_pool_size, innodb_log_buffer_size, query_cache_size. If you’re using MyISAM seriously you can also add the size of Operation System cache you would like MySQL… will perform complex operations such as full table scans, sorts, or need temporary tables as much as read_buffer_size, sort_buffer_size…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…MySQL Performance. MyISAM Corruption – If you’re writting to MyISAM…MySQL server its caches (key_buffer, innodb_buffer_pool, query_cache,table_cache) are cleaned, so may be OS caches. This may reduce performance…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…to compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL …cache_size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… 2.00GHz stepping : 11 cpu MHz : 1995.022 cache size : 4096 KB physical id : 1 siblings : 4 core…MyISAM tables to InnoDB. (But then again, it might not be.) Or maybe the client is doing queries…performance system is virtually every query.) If it’s not possible to use a patched binary, we can use MySQL…
