May 22, 2013

More on MySQL transaction descriptors optimization

April 26, 2013 By Leave a Comment

Since my first post on MySQL transaction descriptors optimization introduced in Percona Server 5.5.30-30.2 and a followup by Dimitri Kravchuk, we have received a large number of questions on why the benchmark results in both posts look rather different. We were curious as well, so we tried to answer that question by retrying benchmarks on [...]

Filed Under: Benchmarks, MySQL Tagged With: ,

The write cache: Swap insanity tome III

April 19, 2013 By 5 Comments

Swapping has always been something bad for MySQL performance but it is even more important for HA systems. It is so important to avoid swapping with HA that NDB cluster basically forbids calling malloc after the startup phase and hence its rather complex configuration. Probably most readers of this blog know (or should know) about [...]

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , ,

MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown

March 14, 2013 By 2 Comments

While preparing the webinar I will deliver this Friday, I ran into a quite interesting (although not very impacting) optimizer issue: a “SELECT *” taking half the time to execute than the same “SELECT one_indexed_column” query in MySQL 5.6.10. This turned into a really nice exercise for checking the performance and inner workings of one [...]

Filed Under: Events and Announcements, Insight for Developers, MySQL Tagged With: , ,

MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

March 11, 2013 By 7 Comments

So far most of the benchmarks posted about MySQL 5.6 use the sysbench OLTP workload.  I wanted to test a set of queries which, unlike sysbench, utilize joins.  I also wanted an easily reproducible set of data which is more rich than the simple sysbench table.  The Star Schema Benchmark (SSB) seems ideal for this. [...]

Filed Under: MySQL Tagged With: , , , , ,

InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

I’ve never been a very big fan of MyISAM; I would argue that in most situations, any possible advantages to using MyISAM are far outweighed by the potential disadvantages and the strengths of InnoDB. However, up until MySQL 5.6, MyISAM was the only storage engine with support for full-text search (FTS). And I’ve encountered many [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Sphinx search performance optimization: multi-threaded search

January 16, 2013 By 6 Comments

Queries in MySQL, Sphinx and many other database or search engines are typically single-threaded. That is when you issue a single query on your brand new r910 with 32 CPU cores and 16 disks, the maximum that is going to be used to process this query at any given point is 1 CPU core and [...]

Filed Under: MySQL Tagged With: , , ,

Sphinx search performance optimization: attribute-based filters

January 15, 2013 By 9 Comments

One of the most common causes of a poor Sphinx search performance I find our customers face is misuse of search filters. In this article I will cover how Sphinx attributes (which are normally used for filtering) work, when they are a good idea to use and what to do when they are not, but [...]

Filed Under: Insight for Developers, MySQL Tagged With: , ,

How does MySQL Replication really work?

January 9, 2013 By 9 Comments

While we do have many blog posts on replication on our blog, such as on replication being single-threaded, on semi-synchronous replication or on estimating replication capacity, I don’t think we have one that covers the very basics of how MySQL replication really works on the high level. Or it’s been so long ago I can’t [...]

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

The Optimization That (Often) Isn’t: Index Merge Intersection

December 14, 2012 By 6 Comments

Prior to version 5.0, MySQL could only use one index per table in a given query without any exceptions; folks that didn’t understand this limitation would often have tables with lots of single-column indexes on columns which commonly appeared in their WHERE clauses, and they’d wonder why the EXPLAIN plan for a given SELECT would [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL

Percona XtraDB Cluster – installation and setup webinar follow up Q&A

October 28, 2012 By 4 Comments

Thanks for all, who attended my webinar, I got many questions and I wanted to take this opportunity to answer them. Q: Even ntp has a delay of 0.3-0.4 between servers does that mean a 0.25 as from logs can be an issue ? A: My demo vms were running for a few hours before [...]

Filed Under: MySQL, XtraDB Cluster
« Older Posts