… MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6.0… time to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737.540.99… and may be MySQL 6.0 performance will improve. Though considering a lot of talks about optimizer improvements in MySQL 6.0 I expected drastically…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…server. The server is running a Percona build of 5.0.84, so I have microsecond logging in the slow … to see queries that have mostly very fast performance, and occasionally have much worse, and — here’s … it — and that’s where improvements to the MySQL source code are necessary. But in many cases …
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
…queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there is …but in batches reads. So let us see how perform 5.1 and 6.0 in cold mode (I dropped OS caches …avgqu-sz await svctm %util sda 0.00 0.41 317.83 0.82 2570.49 9.84 1285.25 4.92 8….
Post: Extending Index for Innodb tables can hurt performance in a surprising way
May 22, 2010 By 9 Comments
…be different in different MySQL versions. These tests were done with 5.1.45 though I’ve seen same behavior with MySQL 5.0 too.
Post: mysql-proxy, urgh performance and scalability ?
June 9, 2009 By 27 Comments
… question which come in mind is what performance penalty we have using mysql-proxy, version 0.7.1. So it is easy to… better) ThreadsMySQL-5.0.77MySQL-proxy+MySQL-5.0.77 1 660.02 349.86 2 1158.66 477.77 4 1223.84 485.21 8… thread). MySQL per-request statistics: min: 1.31ms avg: 1.51ms max: 5.30ms approx. 95 percentile: 1.56ms Proxy+MySQL per-request…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…or benchmarked) system performance to provide our estimates. If we’re running Innodb with MySQL we can …5.15k 3.88k 258.55k 1.46k # Merge passes 0 0 0 0 0 0 0 # Tmp tables 21.36k 0 2 0.01 0 0.11 0… 18 6.84 9.83 2.20 7.70 # queue wait 0 0 0 0 0 0 0 0 # rec lock wai 0 0 0 0 0 0 0 0 # String: # Databases…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…Innodb performance counters, statistics, information about transaction processing and all kinds of other things. In MySQL 5 number of Innodb performance counters…Log sequence number 84 3000620880 Log flushed up to 84 3000611265 Last checkpoint at 84 2939889199 0 pending log writes, 0 pending chkp …
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
… performance, workload and scalability: MySQL has always been focused on OLTP workloads. In fact, both Percona Server and MySQL 5.5.7rc have numerous performance improvements…:white;font-family:arial,sans,sans-serif;font-size:100.0%;font-weight:normal;font-style:normal;color:#000000;text-decoration…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…-64bit x86_64 Percona Server 5.5.11 with XtraDB. Requires m1…. ontime8 2.1G ontime9 212K performance_schema 0 test ICE size on disk: 2… 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘…84) bytes of data. 64 bytes from shard20 (10.126.15.34): icmp_seq=1 ttl=61 time=0…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
….9 0.1 277.6 401.6 43.8 421.5 | 336.8 1.6 239.7 414.8 44.0 | 84.7 0.1… indirect address blocks are cached and ext3 resumes the “raw” performance. But once the snapshot is created it plummets again. It… + snapshot performance. “randomio” might not be a good representation of what MySQL is doing so we are currently testing xfs with MySQL. But…
