Buy Percona ServicesBuy Now!

Speaking at MySQL Meetup in Raleigh,NC

 | January 30, 2012 |  Posted In: Events and Announcements, MySQL

I’ll be presenting at MySQL Meetup in Raleigh,NC February 21,2012. The talk with be about Optimizing MySQL Configuration which I believe is a great topic for my first talk at this meetup group as it covers something every MySQL user has to deal with, also being something both beginner and advanced MySQL Users can learn […]

Read More

1 Billion Insertions – The Wait is Over!

 | January 26, 2012 |  Posted In: Tokutek, TokuView

iiBench measures the rate at which a database can insert new rows while maintaining several secondary indexes. We ran this for 1 billion rows with TokuDB and InnoDB starting last week, right after we launched TokuDB v5.2. While TokuDB completed it in 15 hours, InnoDB took 7 days. The results are shown below. At the end of […]

Read More

MySQL Configuration Wizard Updated

 | January 26, 2012 |  Posted In: Insight for DBAs, MySQL

We’ve released an updated version of the MySQL Configuration Wizard we announced at the end of last year. If you don’t remember that announcement, here’s the short version: this is a tool to help you generate my.cnf files based on your server’s hardware and other characteristics. We’ve gotten really good feedback on this tool, including […]

Read More 2012 roundup

 | January 24, 2012 |  Posted In: Insight for DBAs, Insight for Developers

I spent last week at in Ballarat, Victoria (that’s the Victoria in Australia, not wherever else there may be one) which is only a pleasant two hour drive from my home town of Melbourne (Australia, not Florida). I sent an email internally to our experts detailing bits of the conference that may interest them […]

Read More

Preventing MySQL Emergencies Webinar

 | January 24, 2012 |  Posted In: Events and Announcements, MySQL

On the 25th of January at 10 am PST, I will present a webinar on preventing MySQL emergencies titled “Preventing Downtime in Production MySQL Servers”. The material I will present is based on in-depth research done by Percona across many production servers.  We analyzed more than 150 emergency cases and categorized our findings to help […]

Read More

What Are Full, Incremental, and Differential Backups?

 | January 23, 2012 |  Posted In: Insight for DBAs, MySQL

Sometimes you might hear people talk about full backups, and differential backups versus incremental backups. What is the difference? A full backup is pretty self-explanatory. It makes a copy of all of your MySQL data. A differential backup, on the other hand, simply records the differences since your last full backup. The advantage of taking […]

Read More

Announcing TokuDB v5.2: Improved Multi-Client Scaling and Faster Queries

 | January 19, 2012 |  Posted In: Tokutek, TokuView

TokuDB® v5.2, the latest version of Tokutek’s flagship storage engine for MySQL and MariaDB, is now available. This version offers performance enhancements over previous releases, especially for multi-client scale up and point queries, and extends the cases where ALTER TABLE is non-blocking, in particular adding Hot Column Rename. TokuDB v5.2 maintains all our established advantages: […]

Read More