EmergencyEMERGENCY? Get 24/7 Help Now!

Win free MySQL Conference Passes!

 | April 7, 2011 |  Posted In: Events and Announcements, MySQL

Want a free pass to the O’Reilly MySQL Conference next week in Santa Clara, California? It’s the MySQL conference, and the session lineup is awesome this year. We’ve got several free passes to give away. Post a comment here to claim your spot. First come, first served! (But make sure you are serious about committing […]

Read More

More on MySQL Error Messages

 | April 6, 2011 |  Posted In: Insight for DBAs, MySQL

I wrote about MySQL Error Messages before and as you might guess I’m not very happy with quality for error messages it produces. Now I’m revisiting this subject with couple of more annoying examples I ran into during last couple of days.

Read More

Hot Indexing Part I: New Feature

 | April 5, 2011 |  Posted In: Tokutek, TokuView

From 31 minutes to 2 seconds Hot Indexing Overview TokuDB v5.0 introduces several features that are new to the MySQL world. Recently, we posted on HCAD: Hot Column addition and Deletion. In this post, we talk about Hot Indexing. What happens when you try to add a new index, as follows?

In standard MySQL […]

Read More

MySQL caching methods and tips

 | April 4, 2011 |  Posted In: Insight for Developers, MySQL

“The least expensive query is the query you never run.” Data access is expensive for your application. It often requires CPU, network and disk access, all of which can take a lot of time. Using less computing resources, particularly in the cloud, results in decreased overall operational costs, so caches provide real value by avoiding […]

Read More

Flexviews – part 3 – improving query performance using materialized views

 | April 4, 2011 |  Posted In: Insight for DBAs, MySQL

Combating “data drift” In my first post in this series, I described materialized views (MVs). An MV is essentially a cached result set at one point in time. The contents of the MV will become incorrect (out of sync) when the underlying data changes. This loss of synchronization is sometimes called drift. This is conceptually […]

Read More