…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops… and Percona Server shows much better results Configurations and how to run benchmark: [mysqld] user=root port=3306 innodb_buffer_pool_size = 30G innodb_flush_method = O_DIRECT innodb_log_file_size = 2000M innodb_log…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… with taskset. The following chart shows a results comparison on a single…DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M … –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… SSD config) which shows the most …mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…pool_size = 36G innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb_log_block_size…size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the…pool_read_requestsblogpercona.commanual Innodb_buffer_pool_readsblogpercona.commanual innodb_buffer_pool_sizeblogpercona.commanual Innodb_buffer_pool_wait_freeblogpercona.commanual Innodb_buffer_pool…commanual safe_show_databaseblogpercona.commanual safe_user_…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… problems with MySQL 5.5 with addition of user variables, stored…SHOW ENGINE INNODB STATUS and look for memory information block, which can use like this: ———————- BUFFER POOL…18144) Dictionary memory allocated 2623331 Buffer pool size 7864319 Buffer pool size, bytes 128849002496 Free …
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… Hostname | smt2 Uptime | 6 days, 6:21, 4 users, load average: 0.00, 0.01, 0.05… would be in the production over time: mysql> show table status like “post_channel” \G *************************** 1. row … approximately 30GB in size including indexes which is way more than buffer pool size and OS cache…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… however, which showed MySQL 5.6.10 to be much slower than MySQL 5….buffer pool. mysql> select * from information_schema.innodb_buffer_pool_stats\G *************************** 1. row *************************** POOL_ID: 0 POOL_SIZE:…p2.duration, p1.cpu_user + p1.cpu_system p1_cpu, p2.cpu_user + p2.cpu…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…pool_size=400M innodb_log_file_size…mysql> show global status like ‘wsrep_cluster_size‘; +——————–+——-+ | Variable_name | Value | +——————–+——-+ | wsrep_cluster_size…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…2010′; mysql> use ontime1; Database changed mysql> show table status …mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size…size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql…
