… when the database is cold, but uses less CPU time when the database is hot. I am …=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=…_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5… innodb_flush_method = O_DIRECT innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer… #56only loose-innodb_flush_neighbors=0 loose-metadata_locks_hash_instances=256 innodb_buffer_pool_instances=16 # MySQL 5.5 and 5…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… PowerEdge R720 box and varied cpu combinations with taskset. The …flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log…99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Percona Server for MySQL 5.5.28-29.3 which could cause a server to hang when binary log is enabled. Bug…_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed #1125248 (Alexey Kopytov). dialog.so used… (Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…two Intel(R) Xeon(R) CPU E5-2450 0 @ 2.10GHz,…mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing…flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Percona Server for MySQL 5.5.28-29.3 which could cause a server to hang when binary log is enabled. Bug…_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed #1125248 (Alexey Kopytov). dialog.so used… (Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
…; logging every query; MySQL was run with default settings except following: [mysqld] user=root max_connections=3000 innodb_log_file_size=128M innodb_flush_log_at_trx_commit=1 innodb_file_per_table table_cache=2000 Depending on workload different InnoDB buffer was used. In CPU…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…: Test how MySQL 5.6.7 performs Hardware specification Server: Dell PowerEdge R710 CPU: 2x Intel(R) Xeon(R) CPU E5-2660 0…_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 125G innodb_buffer_pool_instances=8 innodb_log…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
… Dimitri in his article MySQL Performance: Analyzing Percona’s TPCC-like Workload on MySQL 5.5 sounded doubt… innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file… see with 4096 block size USER and SYS CPU is utilized much better, meaning that IDLE is…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…= yes Speeds | 24×1600.000 Models | 24xIntel(R) Xeon(R) CPU X5650 @ 2.67GHz Caches | 24×12288 KB # Memory ##################################################### Total |…mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log…
