…/ key_buffer_size=52428800 read_buffer_size=131072 max_used_connections=13 max_threads=2002 thread_count=6 connection_count=6 It is possible…_buffer_size)*max_threads = 4432877 K bytes of memory Hope that’s ok; if not, decrease some variables in the equation. Thread pointer… messages after this, something went terribly wrong… stack_bottom = 7f9244a8fdb8 thread_stack 0×40000 /usr/sbin/mysqld(my_print_stacktrace+0×35)[0x7d0765…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… innodb_purge_threads = 1 innodb_fast_shutdown = 1 #not innodb options (fixed) back_log = 50 wait_timeout = 120 max_connections = 5000 max_prepared… max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache…_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…_engine=tokudb –oltp_auto_inc=on –max-time=18000 –report-interval=10 –max-requests=0 –num-threads=32 –rand-type=pareto run and… max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache…_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… G6 (8cores/16 cpu threads) Cisco UCS C250 (12cores/24 cpu threads) Dell PowerEdge R720 (16 cores/32 cpu threads) All are NUMA… the single-node configuration used 16 threads (8 cores on a single socket x 2 threads per socket), while the second one…_table = true innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… a chart with top mutexes for each server at 64 threads: For MySQL 5.5.30 top mutex is &doublewrite->mutex… innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000 table_open…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… = $totalTimeFetch / 1000000; While this benchmark doesn’t show any multi-threading or other advanced operation, it is using identical code to…/cmd 0.2843 ms min per/cmd 0.3026 ms max per/cmd 0.0183 ms range per/cmd InnoDB Memcache…/cmd 0.3208 ms min per/cmd 0.4159 ms max per/cmd 0.0951 ms range per/cmd InnoDB MySQL…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be… report that it received a packet larger than the slave_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III… read operations as synchronous when they were actually asynchronous when Thread Pool feature was used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be… report that it received a packet larger than the slave_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III… read operations as synchronous when they were actually asynchronous when Thread Pool feature was used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal…
Comment: MySQL and Percona Server in LinkBench benchmark
May 11, 2013 By 18 Comments
… BP 600sec measure after (maybe) enough warmup; PCI-e flash) threads ops/sec 64 around 8000 16 around 8000 4 around… this workload-hardware innodb_io_capacity = 20000 innodb_io_capacity_max = 100000 innodb_read_ahead_threshold = 0 innodb_change_buffer…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…_max_rwlock_classesblogpercona.commanual performance_schema_max_rwlock_instancesblogpercona.commanual performance_schema_max_table_handlesblogpercona.commanual performance_schema_max_table_instancesblogpercona.commanual performance_schema_max_thread_classesblogpercona.commanual performance_schema_max_thread…
