EmergencyEMERGENCY? Get 24/7 Help Now!

Active Cache for MySQL

 | January 10, 2010 |  Posted In: Insight for Developers, MySQL

One of the problems I have with Memcache is this cache is passive, this means it only stores cached data. This means application using Memcache has to has to special logic to handle misses from the cache, being careful updating the cache – you may have multiple data modifications happening at the same time. Finally […]

Read More

Few more ideas for InnoDB features

 | June 29, 2009 |  Posted In: Insight for DBAs

As you see MySQL is doing great in InnoDB performance improvements, so we decided to concentrate more on additional InnoDB features, which will make difference. Beside ideas I put before https://www.percona.com/blog/2009/03/30/my-hot-list-for-next-innodb-features/ (and one of them – moving InnoDB tables between servers are currently under development), we have few mores: – Stick some InnoDB tables / […]

Read More

Adjusting Innodb for Memory resident workload

 | March 25, 2009 |  Posted In: Insight for DBAs

As larger and larger amount of memory become common (512GB is something you can fit into relatively commodity server this day) many customers select to build their application so all or most of their database (frequently Innodb) fits into memory. If all tables fit in Innodb buffer pool the performance for reads will be quite […]

Read More

High-Performance Click Analysis with MySQL

 | December 22, 2008 |  Posted In: Insight for Developers

We have a lot of customers who do click analysis, site analytics, search engine marketing, online advertising, user behavior analysis, and many similar types of work.  The first thing these have in common is that they’re generally some kind of loggable event. The next characteristic of a lot of these systems (real or planned) is […]

Read More

SHOW OPEN TABLES – what is in your table cache

 | December 14, 2008 |  Posted In: Insight for DBAs

One command, which few people realize exists is SHOW OPEN TABLES – it allows you to examine what tables do you have open right now:

Read More

Thoughs on Innodb Incremental Backups

 | November 10, 2008 |  Posted In: Insight for DBAs

For normal Innodb “hot” backups we use LVM or other snapshot based technologies with pretty good success. However having incremental backups remain the problem. First why do you need incremental backups at all ? Why not just take the full backups daily. The answer is space – if you want to keep several generations to […]

Read More

Living with backups

 | November 6, 2008 |  Posted In: Insight for DBAs

Everyone does backups. Usually it’s some nightly batch job that just dumps all MySQL tables into a text file or ordinarily copies the binary files from the data directory to a safe location. Obviously both ways involve much more complex operations than it would seem by my last sentence, but it is not important right […]

Read More