Buy Percona ServicesBuy Now!

MySQL Installation and upgrade scripts.

 | May 21, 2007 |  Posted In: Insight for DBAs

I generally find MySQL Sever sufficiently tested, meaning at least minor version upgrades rarely cause the problems. Of course it is not perfect and I remember number of big issues when some releases could not be used due to behavior changes in them and when something had to be rolled back in the next release. […]

Read More

MySQL Storage Engines – PBXT

 | May 14, 2007 |  Posted In: Insight for DBAs

I promised to write little articles about all storage engines which sessions I attended during MySQL Users Conference but I did not get too far yet, too busy. So today it is time for PBXT. I was very interested about session about PBXT because this is storage engine does not target the same general purpose […]

Read More

Merge Tables Gotcha

 | May 9, 2007 |  Posted In: Insight for DBAs

I had the interesting customer case today which made me to do a bit research on the problem. You can create merge table over MyISAM tables which contain primary key and global uniqueness would not be enforced in this case, this is as far as most people will think about it. In fact however it […]

Read More

How to estimate time it takes Innodb to Recover ?

 | May 9, 2007 |  Posted In: Insight for DBAs

Today seems to be Innodb day in our Blog, but well this is the question which pops ups quite frequently in Innodb talks and during consulting engagements. It is well known to get better performance you should normally set innodb_log_file_size large. We however usually recommend caution as it may significantly increase recovery time if Innodb […]

Read More

Linux failing to boot screen on the plane

 | May 4, 2007 |  Posted In: Insight for DBAs

I’ve seen Windows Blue Screen of Death, stalled boot process or simply application error dialog on many big information screens in shops, airports and other places as well in other systems such as cache machines, airport self checking systems or photo print kiosk. Today coming back from US on NorthWest Airbus A330 we got stalled […]

Read More

Countless storage engines

 | May 3, 2007 |  Posted In: Insight for DBAs

Today everybody writes about MySQL Conference & Expo and I am not an exclusion. I am under impression of count of storage engines were presented. In good old time when Oracle bought InnoDB, MySQL did one step – announced MySQL supports Plugginable Storage Architecture. In that time nobody was able to predict what is the […]

Read More

Master-Master or Master with Many Slaves

 | April 6, 2007 |  Posted In: Insight for DBAs

I just found post by Kevin, in which he criticizes Master-Master approach, finding Master with many slaves more optimal. There is surely room for master-N-slaves systems but I find Master-Master replication much better approach in many cases. Kevin Writes “It requires extra hardware thats sitting in standby and not being used (more money and higher […]

Read More

MySQL Master-Master replication manager released

 | April 5, 2007 |  Posted In: Insight for DBAs

The MySQL Master-Master replication (often in active-passive mode) is popular pattern used by many companies using MySQL for scale out. Most of the companies would have some internal scripts to handle things as automatic fallback and slave cloning but no Open Source solution was made available. Few months ago we were asked to implement such […]

Read More

MySQL Replication and Slow Queries

 | March 28, 2007 |  Posted In: Insight for DBAs

I just filed a bug regarding slow queries executed by replication thread are not being logged to the slow query log. This is not a big deal but it is ugly little gotcha which I think few people know about. It is especially bad if you’re using tools to analyze slow query log to find […]

Read More

Beware large Query_Cache sizes

 | March 23, 2007 |  Posted In: Insight for DBAs

During last couple of months I had number of consulting projects with MySQL Query Cache being source of serious problems. One would see queries both for MyISAM and Innodb tables mysteriously stalling for few seconds with “NULL” in State column. These could be troubleshooted to waiting on Query Cache which at the same time had […]

Read More