… that I used: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb… innodb_read_io_threads = 8 innodb_write_io_threads = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer pool is sized at 55G and I…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
…-not-using-indexes query_cache_type=1 query_cache_size=32M thread_cache_size=30 table_cache=4096 join_buffer_size=6M key_buffer_size=12M server-id = 1…-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock When I start…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… 1 thread: 87 MiB/sec ext4 4 threads: 74 MiB/sec xfs 4 threads: 97 MiB/sec Dropping performance in case with 4 threads…-total-size=${size}G prepare sync echo 3 > /proc/sys/vm/drop_caches for numthreads in 4 do sysbench –test=fileio –file-total-size=${size}G –file-test-mode=rndwr –max-time=3600 –max-requests=0 –num-threads=$numthreads –rand-init=on…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…might see instead is flushing tables regularly or reducing table cache reduces memory consumption to be withing the reason. Connection …system 0 (0 + 0) Threads 425080 (406936 + 18144) Dictionary memory allocated 2623331 Buffer pool size 7864319 Buffer pool size, bytes 128849002496 Free buffers…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… –test=fileio –file-total-size=${size}G –file-test-mode=rndwr –max-time=18000 –max-requests=0 –num-threads=$numthreads –rand-init=on… wild guess about drops – the drive periodically cleans an internal cache or something. To understand better what kind of response time… getting to the peak throughput at 16-32 threads. And response time: For 16 threads, we may expect 0.96ms response time…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual thread_cache_sizeblogpercona.commanual thread_concurrencyblogpercona.commanual thread_handlingblogpercona.commanual thread_stackblogpercona.commanual Threads_cachedblogpercona.commanual Threads_connectedblogpercona.commanual Threads_createdblogpercona.commanual Threads_runningblogpercona…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… table_cache = 2048 max_allowed_packet = 16M binlog_cache_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…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’ ‘Table_locks_immediate’, ’895966639′ ‘Table_locks_waited’, ’20096′ ‘Threads_cached‘, ’0′ ‘Threads_connected’, ’260′ ‘Threads_created’, ’124272′ ‘Threads_running’, ’3′ ‘Uptime’, ’4433556′ # top 18:38… key_buffer_size=32M # Only for MyISAM which isnt used. sort_buffer_size=2M query_cache_size=10M # Might be increased thread_cache_size=40 table_cache=512…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…_table_size=64M max_prepared_stmt_count=1000000 query_cache_size=0 skip_grant_tables skip_locking sort_buffer_size=64K table_cache=2048 thread_cache_size=16 thread_concurrency=16 thread_stack=196K tmp_table_size=64M…
