Buy Percona ServicesBuy Now!

Percona welcomes Ewen Fortune and Piotr Biel

 | October 1, 2008 |  Posted In: Events and Announcements

Although we haven’t announced any new members in a while, the Percona team has continued to grow steadily behind the scenes. Our hiring policy is to have a few months’ provisional period to ensure the…, of course. Ewen has been a consultant and contractor before joining Percona, and has many years of experience in Oracle, MySQL, Unix systems ….

Piotr Biel lives in Poland, quite close to our other Polish team member (Maciek Dobrzanski). In his past as a system architect he … can do!

Ewen and Piotr, a very warm welcome to the Percona team from all of us, and we are so glad to …

Read More

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

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.