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

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

Should MySQL and Web Server share the same box ?

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

This is interesting question which I thought it would be good to write about. There are obviously benefits and drawbacks for each of methods. Smaller applications usually start with single server which has both MySQL and Web server on it. In this case it is not usually the question but once application growths larger and […]

Read More

Long PRIMARY KEY for Innodb tables

 | October 3, 2006 |  Posted In: Insight for DBAs

I’ve written and spoke a lot about using short PRIMARY KEYs with Innodb tables due to the fact all other key will refer to the rows by primary key. I also recommended to use sequential primary keys so you do not end up having random primary key BTREE updates which can be very expensive. Today […]

Read More

What to tune in MySQL Server after installation

 | September 29, 2006 |  Posted In: Insight for DBAs

My favorite question during Interview for people to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server straight after installation, assuming it was installed with default settings. I’m surprised how many people fail to provide any reasonable answer to this […]

Read More

Why Index could refuse to work ?

 | September 8, 2006 |  Posted In: Insight for DBAs

Have you ever seen index which refused to be used even if there is every reason for it to work (from the glance view):

Why on the earth index would not be used you would think, even if MySQL is mentioning it in “possible keys” ? Should you try to force it ?

Read More