… were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w…_ahead 0 20920 23669 20920 23734 Innodb_buffer_pool_read_requests 1361851 1264739 1235472 1263290 1235781 Innodb_buffer_pool_reads 120548… with MRR are performing badly. The interesting thing is that though both MariaDB and MySQL 5.6 are reporting high numbers for Innodb…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…23228 130731 131497 Innodb_buffer_pool_read_requests 12947073 10228611 7816154 10251697 9319281 9393396 Innodb…become sequential. The two other most important numbers are values for Innodb_buffer_pool_…possible performance gain. This is not entirely visible in the manual either for MariaDB or MySQL,…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
…of the requests. So that’s it. Ladies and gentlemen (drum roll please), the two basic performance metrics:… maybe a bit longer. This is common in MySQL servers I work with when they’re …about the same number of extra completions from the previous interval. And anyway, the number of requests that span…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
… can see performance throughout the day. If you’re not familiar with the diskstats tool, the columns are the number of seconds… of time the device was busy, and the average number of requests in progress at the time the samples were taken. [baron… output of iostat.) I would characterize this as very good performance. Sub-millisecond latencies to disk, pretty much consistently, for reads…
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 use …. Collecting these at regular intervals and correlating to number of queries running will give average CPU usage… 1 row may take up to 8 io requests (could happen due to looking to undo space …
Post: Performance or Stability ???
April 1, 2011 By 16 Comments
…5000 q/sec number as I need my system to always be able to reach performance requirements. …called “random arrivals” rather than uniform pace of requests, the more you slice the time the … this minimal performance depends of response time your application can tolerate. In the MySQL Benchmarks Vadim …
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… much more complex than an average MySQL master-slave setup. Potential performance penalty: Although to have performance numbers I am going to run different… with MariaDB/Galera 0.8 I have one serious feature request for the Galera team: provide the ability for incremental node…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…MySQL Query Cache so it once again is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL…there are multiple connection requesting the same item. What MySQL will do ? It …. Many applications in MySQL have very large number of queries doing updates …
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… the system. What I usually look for MySQL is performance in random reads and random writes….128Mb total file size Block size 16Kb Number of random requests for random IO: 1000000 Read/Write … can get multiple outstanding requests. Performance with 64 threads was 2334.63 Requests/sec which is perfect …
