…_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage… innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer_size=10G # Disabling symbolic-links…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… ‘Table_locks_waited’ remains zero while the ‘Table_locks_immediate’ keeps increasing I have disabled the query cache by set global query_cache_size = 0; All this on a fairly decent size…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…+ spares + OS partition mirror) and I limited the ARC size to 4GB. I don’t want to start a…have to start the snapshot while holding a “flush tables with read lock” and the flush operation will take… maybe it is related to better raid controller write cache use. Even the fairly slow gzip-1 mode works…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… table_open_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_type = 0…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… table_open_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_type = 0…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io… = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…_per_table = true innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To warmup server… –num-threads=<1..1024> –test=oltp.lua –oltp_tables_count=8 –oltp-table-size=1000000 –rand-init=on –report-interval=1 –rand-type…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… a partitioned table, as, depending on the size of the partitions, the whole partition can be cached, as opposed to a single table, where probably only recently read records will be cached, resulting in more… have seen this happen in a MyIsam environment on similar sized tables). What I am really saying is that its not only…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
…, I described a solution for keeping the caches of a MySQL standby server hot using… the HUP signal also flushes tables in addition to logs. Flushing tables can impact running queries….slow_query.log { nocompress create 660 mysql mysql size 1G dateext missingok notifempty sharedscripts postrotate /usr…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…_cache_size=0 query_cache_type=0 MySQL 5.6.5 Configuration innodb_file_per_table=1 innodb_file_format=barracuda innodb_log_file_size…_trx_commit=2 innodb_flush_method=O_DIRECT query_cache_size=0 query_cache_type=0 optimizer_switch=’index_condition_pushdown=on’ optimizer…_trx_commit=2 innodb_flush_method=O_DIRECT query_cache_size=0 query_cache_type=0 optimizer_switch=’index_condition_pushdown=on’ optimizer…
