Buy Percona ServicesBuy Now!

Rebuilding MySQL Binary

 | November 16, 2006 |  Posted In: Insight for DBAs

Running RPM based or other packaged MySQL Binary you may have a problem if you would like to rebuild binary for some reason – change some build settings, apply some third party patches or simply try latest snapshot (This time I was both applying patches for Innodb scalability and Vadim’s patches to get proper slow […]

Read More

Bug fix of InnoDB scalability problem

 | November 14, 2006 |  Posted In: Insight for DBAs

I was pretty busy last month with project which will be annonced very soon (I hope), but I can’t miss bug fix of my favorite bug 15815. I wrote about this problem before and also investigated in my presentation. Finally bug fix was pushed into 5.0-bk tree and now I have it in my hands. […]

Read More

Are PHP persistent connections evil ?

 | November 12, 2006 |  Posted In: Insight for Developers

As you probably know PHP “mysql” extension supported persistent connections but they were disabled in new “mysqli” extension, which is probably one of the reasons some people delay migration to this extension. The reason behind using persistent connections is of course reducing number of connects which are rather expensive, even though they are much faster […]

Read More

When EXPLAIN can be misleading

 | November 12, 2006 |  Posted In: Insight for Developers

One think I can see with people using EXPLAIN is trusting it too much, ie assuming if number of rows is reported by EXPLAIN is large query must be inefficient. It may not be the case. The question is not only about stats which may be wrong and which is why you may want to […]

Read More

Undo area size restriction needed for Innodb

 | November 9, 2006 |  Posted In: Insight for DBAs

As you can read from my Innodb Architecture and Performance Optimization presentation Innodb automatically manages undo area in system tablespace so you never need to care about it. I present it as positive feature reducing administration effort needed but it also can cause a troubles as it happened for me today: InnoDB: 11 transaction(s) which […]

Read More

Back from OpenSource Database Conference

 | November 9, 2006 |  Posted In: Events and Announcements

I’m just back from OpenSource Database Conference and PHP International Conference which took place in Frankfurt. I’ve uploaded slides for two talks I’ve been giving which you might want to check out. In general Database portion of the conference was a bit boring. May be because it was not widely announced or may be for […]

Read More

Wishes for new “Pure PHP” MySQL driver

 | October 28, 2006 |  Posted In: Insight for Developers

If you’re following MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If not – Here is FAQ . I’m to meet the team (Georg, Andrey etc) which will be developing this driver during my visit to Open Source Database Conference in November so I thought it would […]

Read More
Subscribe to the Percona Database Performance Blog for open source database help, technical resources, Percona Live updates and upcoming webinars.
Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.