Buy Percona ServicesBuy Now!

MySQL Error Message Nonsenses

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

What MySQL honestly was never good at is giving good helpful error messages. Start with basics for example – The error message in case of syntax error gives you information about tokens near by but little details:

It would be much better if MySQL would give error give exact position of error (with complex […]

Read More

Sharding and Time Base Partitioning

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

For large number of online applications once you implemented proper sharding you can consider your scaling problems solved – by getting more and more hardware you can grow. As I recently wrote it however does not mean it is the most optimal way by itself to do things. The “classical” sharding involves partitioning by user_id,site_id […]

Read More

Economics of Performance Optimization

 | March 13, 2008 |  Posted In: Insight for Developers

I think every person responsible for Development or Operations of growing application sooner or later have to decide on couple few questions on how to tackle application performance. These questions are: Should we Optimize Application or get more Hardware ? Should we do things ourselves or hire an experts to help us ? The answer […]

Read More

Tradeoff: Insertions versus Point Queries

 | March 11, 2008 |  Posted In: Tokutek, TokuView

I’ve been waving my hands about lower bounds. Well, sometimes I haven’t been waving my hands, because the lower bounds are tight. But in other cases (lenient insertions, range queries), the lower bounds are very far from what we’re used to. So now, for a bit of math: Brodal and Fagerberg showed in 2003 that […]

Read More

Speeding up GROUP BY if you want aproximate results

 | March 7, 2008 |  Posted In: Insight for Developers

Doing performance analyzes today I wanted to count how many hits come to the pages which get more than couple of visits per day. We had SQL logs in the database so It was pretty simple query:

Unfortunately this query ran for over half an hour badly overloaded server and I had to kill […]

Read More

Sphinx 0.9.8 reaches RC stage, Docs updated

 | March 6, 2008 |  Posted In: Insight for Developers

Andrew Aksenoff is pretty slow with release numbers for Sphinx. By MySQL Users Conference 2007 Sphinx version 0.9.7 was released and today we had just 0.9.8-rc1 announced This minor change in version number corresponds to about double source size (looking at download size) and major rewrite for many portions. Sphinx 0.9.8 snapshots were more stable […]

Read More