…0.02s. But the query times for MariaDB 5.5 are greater than both MySQL 5.5 and MySQL 5.6 IO bound workload Now let’s see how…in the buffer the more sequential the access pattern will be. There is one MRR related variable introduced in MySQL 5.6 and MariaDB 5.5…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…0.00 sec) Innodb Memory Usage Finally it is often helpful to check how much memory Innodb has allocated. In fact this is often one…in MySQL. Most suspected memory leaks end up being some run…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…one. MySQL 5.0 to 5.1 upgrade is a lot safer upgrade path than 4.1 to 5.1 just because so much more…in MySQL 4.1 or changing JOIN evaluation in 5.0 (which could both cause different result set or make query not runnable in MySQL 5.0) In…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…how many queries needed no io, needed 1 IO which was not queued (less than 10 ms) or needed more than…how much does it cost to run a query. With Cloud Computing being hot a lot of Directors would like to know the costs in…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…to storing the results of a query in…in set (43 min 10.11 sec) As an added benefit, if you build more than one complete refresh view from an incrementally refreshable one…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
…to be upgraded. It is a shared database used by tons of applications written by many people over more than 5…in the tables. It turned out one of the float columns stored “-0” in MySQL 5.0 but it was displayed as “0” when data loaded to Percona Server 5…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…one of the most common questions we hear is how to build high-performance systems to…queries do you have to run?” and they say “we can’t decide, so we want to…MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the work on a slave, then piping the results back up to…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…more than one node. This would not be the case in…to examine the differences in size. This will give us some interesting information about how Shard-Query will perform on each database. To…0.637 ms … Note: There is no need to put that hosts file on your other nodes unless you want to run…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…queries are running faster than one millisecond; some in the 50 to 100 microsecond range. At such speeds, how…query cache) are executing in no more than 12 microseconds, worst-case. So the contention that’s blocking these queries…to the MySQL source code are necessary. But in…
Post: MySQL VIEW as performance troublemaker
August 12, 2007 By 53 Comments
…in MySQL 5.0 and quite frequently VIEWs are used to help in writing the queries – to keep queries simple without really thinking how it affects server performance. Even worse than…
