… gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, … result was a query that took half the time. An important conclusion of my presentation today … it pays to test all different solutions, and measure the resulting performance! Q: Bill, back to the…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… and benchmarks.) First, we set long_query_time to 0 in order to log every query….slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –… All graphs looked like this (we did 39 measurements), the next graph shows chunk 4’s …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… also will affect select performance, so we will need to measure that also. And, if you want to repeat this benchmark…-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time=18000 –report-interval… = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are…
Comment: MySQL and Percona Server in LinkBench benchmark
May 11, 2013 By 18 Comments
… 600sec measure after (maybe) enough warmup; PCI-e flash) threads ops/sec 64 around 8000 16 around 8000 4 around 5000 mysql… doublewrite) 64 around 13000 16 around 12000 4 around 6000 — mysql-5.6-dev (doublewrite) 64 around 16000 16 around 12000…. But should not has so much error (such as 2x times 
) * I added these settings for this workload-hardware innodb_io…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… that doesn’t help, though. Problem 2: Counters don’t measure time The reason you still can’t tell which server is… ratio is a waste of time! The Oracle folks arrived at this conclusion a long time before the MySQL world started to come… analysis, you need to measure elapsed time, not just the number of times something happens. In the absence of timing information, and if you…
Post: Measuring the amount of writes in InnoDB redo logs
October 8, 2012 By 4 Comments
…!) Something was obviously wrong in our understanding of how to measure the amount of writes in the redo logs. Let’s… add 1 second of write activity. Of course if you measure variations over 60s, this will not explain a 3x difference… very different numbers if you are not taking measures exactly at the same time for the 2 methods. However, the write workload…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… has published for example is good for measuring scalability of the system as concurrency growths….take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018… 1 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 800 BUSY_TIME: 775 CPU_TIME: 49 BYTES_RECEIVED: 21847267 BYTES…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance… project, I thought it would be interesting to measure the single-threaded insert throughput as sysbench ran …mean that we were IO-bound the whole time waiting on fsync operations. But we didn’t…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… MyISAM tables which are not ACID complaint. Plus we only measured Power to keep things simple. We tested 10G and 100G…. Times are given in seconds. Ratio is MySQL 6.0 time divided by MySQL 5.1 time so if it is less than 1 MySQL 6… set cut-off time to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio…
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 2 Comments
… the time threshold, then the SLAVE IO thread will disconnect and try to connect again. This means we now measure the connection time or latency, not the time without binary log events. We’re actively… to setup with negligible overhead: mysql_slave > STOP SLAVE; mysql_slave > CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD=1; mysql_slave > START SLAVE; MASTER…
