…storage 64-bit platform I/O Performance: High API name: m2.4xlarge As for the IO configuration I…I am using 4 buffer pool instances to reduce the contention caused by buffer pool mutexes. Another important configuration that I am using is that I am using…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…MySQL 5.6 and MariaDB 5.5 Now let’s take a look at what this optimization actually is and what…However, when MRR is used then there are two separate calls made to the storage engine to perform the index … and specifically with Block Access Join Algorithms. So I am not going to cover it here, but will …
Post: Countless storage engines
May 3, 2007 By 6 Comments
…MySQL Conference & Expo and I am not an exclusion. I am under impression of count of storage engines…what is the outcoming of such feature, but currently we all see it. Let me list Transactional Storage Engines I…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… what has changed and what exactly changed for worse. I am speaking about MySQL…storage engine at the same time eather. Make sure you’re looking at fully warmed up system. Rather often people panic and what…storage engines it is possible for stats to be different for the same data because it uses…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, I…I present to you what…engine_logsblogpercona.commanual Com_show_engine_mutexblogpercona.commanual Com_show_engine…use_native_aioblogpercona.commanual innodb_use… storage_…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…Galera supports the XtraDB storage engine. Support for multi-threaded slaves. Using custom scripts …is not guaranteed to be applied – what is guaranteed is that every…MySQL master-slave setup. Potential performance penalty: Although to have performance numbers I am going to run different benchmarks, I…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…storage engine, is to get rid of–purge–the old versions of the records as they become obsolete. In MySQL… and find out what benefits, if any, …the InnoDB team advises using just one thread …I am sure that next MySQL 5.6 versions will contain a fixed and much better performing implementation, which I am…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…cover what is the most popular HA solution for MySQL, replication. High Availability solution for MySQL: …MySQL storage engines including MyISAM (NDB is a special discussed later) but it suffers from the limitation of MySQL…, a stonith device must be used to fence it. I am far from being an expert…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
…, I am not getting too much people feedback on what would they like to hear about on MySQL Users Conference, so I went …Transactional Storage engine MySQL – Innodb, Falcon, SolidDB, PBXT and analyzing how things have changed since last summer. Using Slave Server Without Breaking User Experience MySQL…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
…” mode. What to do? I whish I could say you should use Percona Server with XtraDB. If we were using SSD as storage, then I would recommend…. I am going to followup with results on Percona Server. So first recommendation you may hear in this case from the Oracle/MySQL engineers…
