May 23, 2012

Comment: Percona Server 5.5.23-25.3 released!

@ James Ubuntu Precise (12.04 LTS) will be officially supported with the next Percona Server releases. Percona Server 5.5.24-26.0 is currently scheduled for release in the first week of June.

Comment: Benchmarking single-row insert performance on Amazon EC2

… think I can explain the performance you are seeing. But first I’d like to note that this experiment isn’t… graph correctly, you didn’t graph the performance on the first 100M rows). The minimum performance troughs occur just as the…

Comment: Multi Column indexes vs Index Merge

… of mins gap on the same mysql prod instance . The first SQL query executed in 0.03 secs whereas the second… using a single index. I would greatly appreciate your answer. First explain —————– explain SELECT LinksTbl2.id, LinksTbl2.title, LinksTbl2.url, PersonTbl2…

Post: Testing Intel SSD 520

… in previous posts, so let me jump directly to results. First case is random write asynchronous 8 threads IO, the test… uses async IO for writes. Maybe 8 threads in the first graph is too much and we should go with 1…

Post: Benchmarking single-row insert performance on Amazon EC2

…. OK, let’s start off with the configuration details. Configuration First of all let me describe the EC2 instance type that…

Post: Announcement of Percona XtraDB Cluster 5.5.23

… addresses for a new node, it will connect to the first available Binaries are available from downloads area or from our…

Comment: Joining many tables in MySQL - optimizer_search_depth

… optimizer, that should be doing a good job in the first place. In addition, hints need to be built into the…

Comment: How to load large files safely into InnoDB with LOAD DATA INFILE

… load up huge chunks of data in the slave(s) first and then run it on master (BEWARE: you should make…

Comment: Announcing Percona Server 5.5.19-24.0

Jonathan – It was a one-off experimental build for Mac OS X. We might support Mac OS as a first-class binary package platform at some point in the future. OTOH, Percona Server compiled from sources on Mac OS should work just fine, although obviously this packaging option is not as convenient.

Post: Load management Techniques for MySQL

… are overloading the system causing user experience to degrade. The first thing you need to know it is not MySQL problem…