EmergencyEMERGENCY? Get 24/7 Help Now!

Four ways to optimize paginated displays

 | September 24, 2008 |  Posted In: Insight for Developers

A paginated display is one of the top optimization scenarios we see in the real world. Search results pages, leaderboards, and most-popular lists are good examples. You know the design pattern: display 20 results in some most-relevant order. Show a “next” and “previous” link. And usually, show how many items are in the whole list […]

Read More

Fighting MySQL Replication Lag

 | September 22, 2008 |  Posted In: Insight for DBAs

The problem of MySQL Replication unable to catch up is quite common in MySQL world and in fact I already wrote about it. There are many aspects of managing mysql replication lag such as using proper hardware and configuring it properly. In this post I will just look at couple of query design mistakes which […]

Read More

Finding what Created_tmp_disk_tables with log_slow_filter

 | September 22, 2008 |  Posted In: Percona Software

Whilst working with a client recently I noticed a large number of temporary tables being created on disk.

Read More

Speaking on HighLoad++, Moscow, Russia

 | September 21, 2008 |  Posted In: Events and Announcements

I’ll be speaking at HighLoad++ conference in Moscow,Russia taking place 6,7 Oct 2008. This conference was quite success with very interesting presentation last year and I’m hoping it would be even better this year. I also will have a full dayMaster Class focused on Scaling MySQL w Sharding and Replication based on material in our […]

Read More

A common problem when optimizing COUNT()

 | September 20, 2008 |  Posted In: Insight for Developers

When optimizing queries for customers, the first thing I do with a slow query is figure out what it’s trying to do. You can’t fully optimize a query unless you know how to consider alternative ways to write it, and you can’t do that unless you know what the query “means.” I frequently run into […]

Read More

When is it a time to upgrade memory ?

 | September 16, 2008 |  Posted In: Insight for DBAs

Quite commonly I get a question similar to this – “My Innodb Buffer Pool is already 90% full, should I be thinking about upgrading memory already?” This is a wrong way to put the question. Unless you have very small database (read as database which is less than innodb_buffer_pool_size) You will have all buffer pool […]

Read More

Unused indexes by single query

 | September 12, 2008 |  Posted In: Percona Software

Usually unused indexes are devil, they waste diskspace, cache, they make INSERT / DELETE / UPDATE operations slower and what makes them worse – it is hard to find them. But now ( with userstatsV2.patch) you can find all unused indexes (since last restart of mysqld) by single query

As you see query […]

Read More

Google’s user_statistics V2 port and changes

 | September 12, 2008 |  Posted In: Percona Software

Recently Google published V2 release of patches, one of them user_statistics we use in our releases. New features are quite interesting so we decided to port it to fresh releases of MySQL. Features includes: New statistics per user (Cpu_time, Bytes_received, Bytes_sent, etc) New command SHOW CLIENT_STATISTICS, which shows statistics per client’s hostname, not per user […]

Read More