… simple problem on the surface becomes challenge with MySQL because there are no clear resource usage metrics available, and so in most… Check for Table Cache Related Allocations There are cases when MySQL will allocate a lot of memory for table cache, especially if you… and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us…
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: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… case of MySQL 5.5 and ~5 hours in case of MySQL 5.6 and MariaDB 5.5. Note that query cache is… MySQL 5.5 and MySQL 5.6/MariaDB 5.5 This is another area of improvement in the optimizer, as it is clearly… queries are just a bit slower as compared to MySQL 5.5 MRR clearly changes the access pattern to sequential, and hence…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
….9.x version numbers for betas of 2.0 to clearly differentiate beta releases from the final 2.0 release. We…. The new xbstream format works with parallel compression to (without caching) stream several compressed files at once. tar4ibd functionality is replaced…
Post: Getting real life query speeds with MySQL
January 10, 2007 By 10 Comments
… of page caches inside MySQL (key_buffer and innodb_buffer_pool_size) which can be cleared by MySQL restart. Even if you restart MySQL server there is significant chance data will still remain in Operation System cache speeding…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…barracuda innodb_file_per_table max_connections=2000 table_cache=2000 Percona Server 5.1 Results For better …not to penalize further TPS. MySQL 5.6.2 Results Now let’s test MySQL 5.6.2. It is… data presented the other way: Here it becomes very clear that there are no significant differences caused by …
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… few things happen – MySQL kept being “simple” and introduced relatively simple performance boosters – Query Cache and Replication, which were clearly not enough to…. There were a lot of custom technologies created for caching or scalability issues MySQL could not solve well. There are inhouse and…
Comment: MySQL caching methods and tips
April 7, 2011 By 4 Comments
… cached? How long of an expiration time do you want? How do you clear cache entries manually when your data changes before the cache expiration? Nice things about the query cache: it’s nearly… yourself more fine control over which queries deserve to be cached, but still let MySQL handle cache invalidation transparently.
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… make sure caches were clean. OLTP benchmark As the goal was to compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have… I launched the system that I was benchmarking, I could clearly see the difference in production as I had another machine…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received | … output, so it’s clear what I’m showing them…
