Category to track posts in PlanetMySQL
A week or so ago at the MySQL conference, I visited one of the backup vendors in the Expo Hall. I started to chat with them about their MySQL backup product. One of the representatives told me that their backup product uses FLUSH TABLES WITH READ LOCK, which he admitted takes a global lock […]Read more
MySQL-5.5.4 ® is the great release with performance improvements, let’s see how it performs in
The full details are on Wiki page
I took MySQL-5.5.4 with InnoDB-1.1, tpcc-mysql benchmark with 200W ( about 18GB worth of data),
InnoDB log files are 3.8GB size, and run with different buffer pools from 20GB to 6GB. The storage […]
I’ve heard this question a lot, but never thought to blog about the answer. “Is there a performance difference between putting the JOIN conditions in the ON clause or the WHERE clause in MySQL?”
No, there’s no difference. The following queries are algebraically equivalent inside MySQL and will have the same execution plan.
SELECT […]Read more
While the majority of Percona gang travelled to California for the MySQL event of the year, I headed in the opposite direction to Moscow for RIT++ 2010 conference where I presented a talk on Sphinx. You can get the PDF file here – Improving MySQL-based applications performance with Sphinx.
I have been invited to […]Read more
The notice is hereby given that next version 1.2 of XtraBackup software is released.
The list of changes in this version includes:
XtraBackup supports now XtraDB 10
tar4ibd supports variable page size and fast_checksum of XtraDB
Supported 32bit platform for Centos 5, Centos 4, Debian lenny and etch, Ubuntu Karmic, Jaunty, Intrepid, Hardy, FreeBSD
When replication runs out of sync first question you often ask is if someone could be writing to the slave. Of course there is read_only setting which is good to set in the slave but it is not set always and also users with SUPER privilege bypass it.
Looking into binary log is obvious […]
Percona will have 14 members of our team at next week’s O’Reilly MySQL Conference in California. Drop by and meet us at booth 308 (for Percona) or 216 (for Maatkit). Bring your technical questions and problems to our experts. To make it easier for you to meet specific Perconians, check this […]Read more
Every so often I am working on the system with custom compiled MySQL. How to upgrade to the new MySQL Options while preserving as much of original compilation options as possible if original build scripts are not available ?
MySQL distribution has a great script called mysqlbug which was supposed to be used […]