Another plug for Bradley’s talk Thursday morning at the MySQL User’s conference. Spending the day talking to DBA’s and other potential users of TokuDB, I (Zardosht) noticed the same question/theme come up numerous times in conversation. “Oh, so your indexes are in memory, that is why iiBench is so much faster for TokuDB than […]Read more
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
I forgot to include the titles for my talks.
The ignite talk Wednesday at 7pm is “What Is a Performance Model for SSDs?“
The ignite talk is a 5-minute talk at tonight’s Ignite MySQL session organized by Brian Aker. I’ll present some performance measurements on the Intel X25E SSD. The bottom line is […]
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
I (Bradley C. Kuszmaul) am presenting two talks at the MySQL User Conference.
The first talk is a 5-minute talk at tonight’s Ignite MySQL session organized by Brian Aker. I’ll present some performance measurements on the Intel X25E SSD. The bottom line is that although I can get the 3,300 random 4KB writes […]
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 […]
Fast insertion – what Tokutek excels at – isn’t only important for handling high data rates. It also enables a new way to extract value from an existing database called ad hoc indexing. KAYAK has a billion rows stored in TokuDB and adding an index for a traditional MySQL storage engine would take too […]Read more
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