Buy Percona ServicesBuy Now!

Lighttpd as reverse proxy

 | June 17, 2008 |  Posted In: Insight for Developers

We often recommend to set lighttpd in front of apache to handle http requests (more about https://www.percona.com/blog/2006/05/21/speedup-your-lamp-stack-with-lighttpd/ ) , redirect dynamic requests to apache and handle static files by itself. I just gathered step-by-step instruction how to do that in 10 minutes, as it may be not so obvious.

Read More

Speaking on Velocity and Book Signing

 | June 13, 2008 |  Posted In: Events and Announcements

I should have written about it a while ago but I never had a change. I’m speaking at Velocity conference taking place in the Bay Area 23-24 of June. At the same conference we will have a book signing event for our book High Performance MySQL 2nd Edition which is finally in printing and should […]

Read More

How would you compress your MySQL Backup

 | June 5, 2008 |  Posted In: Insight for DBAs

Backing up MySQL Database most people compress them – which can make a good sense in terms of backup and recovery speed as well as space needed or be a serious bottleneck depending on circumstances and approach used. First I should mention this question mainly arises for medium and large size databases – for databases […]

Read More

Confusing MySQL Replication Error Message

 | June 4, 2008 |  Posted In: Insight for DBAs

I already wrote about some MySQL Error Messages which are confusing, here is one more:

After setting up new slave Server I’m getting error log file flooded with messages like this and there is no hint in the message what would explain what is wrong. In fact the issue in this case is (because […]

Read More

How much overhead DRDB could cause ?

 | June 2, 2008 | 

I was working with the customer today investigating MySQL over DRBD performance issues. His basic question was why there is so much overhead with DRBD in my case, while it is said there should be no more than 30% overhead when DRBD is used. The truth is – because how DRBD works it does not […]

Read More

Tools to use for MySQL Performance Review

 | May 31, 2008 |  Posted In: Insight for DBAs

There are some tools we commonly use doing performance review and optimization and we often ask each other where that particular stuff is located on the web or what is exactly name of the command what does that. Initially I thought creating internal Percona Wiki page, but thought there is no reason this information should […]

Read More

Is DNS the Achilles heel in your MySQL installation?

 | May 31, 2008 |  Posted In: Insight for DBAs

Do you have skip_name_resolve set in your /etc/my.cnf? If not, consider it. DNS works fine, until it doesn’t. Don’t let it catch you off guard. Do you really need to restrict MySQL users based on hostnames? If you don’t, you should probably disable this feature of MySQL’s authentication system. You never know when your hosting […]

Read More

Should you name indexes while doing ALTER TABLE ?

 | May 28, 2008 |  Posted In: Insight for DBAs

MySQL Server does not require you to specify name of the index if you’re running ALTER TABLE statement – it is optional. Though what might be good practical reasons to specify the key name or omit ? Things what you should be looking at is how MySQL names indexes automatically as well as what maintaining […]

Read More

Percona’s widely read Percona Database Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! 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.