EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL net_write_timeout vs wait_timeout and protocol notes

 | July 8, 2007 |  Posted In: Insight for DBAs

In my previous post I mentioned you might need to increase net_write_timeout to avoid connection being aborted and now I think I should have better explained that. MySQL uses a lot of different timeout variables at different stages. For example when connection is just being established connect_timeout is used. When server waits for another query […]

Read More

PHP Large result sets and summary tables.

 | July 6, 2007 |  Posted In: Insight for Developers

We’re working with web site preparing for massive growth. To make sure it handles large data sets as part of the process we work on generation test database of significant size as testing your application on table with 1000 rows may well give you very dangerous false sense of security. One of the process web […]

Read More

Working with large data sets in MySQL

 | July 5, 2007 |  Posted In: Insight for Developers

What does working with large data sets in mySQL teach you ? Of course you have to learn a lot about query optimization, art of building summary tables and tricks of executing queries exactly as you want. I already wrote about development and configuration side of the problem so I will not go to details […]

Read More

Top 5 MySQL wishes – what is next ?

 | July 4, 2007 |  Posted In: Insight for DBAs

I’ve read through Top 5 (or more) wishes posted by number of MySQL employees as well as by a lot of community members. It was great to see so wide coverage as people with different backgrounds wish different things – Developers have some wishes to ease development process, MySQL DBAs would like stuff related to […]

Read More

Speaking on OSCON 2007

 | July 3, 2007 |  Posted In: Events and Announcements

Vadim and me will be speaking on OSCON 2007, taking place in Portland,OR July 23-27. Our talk will be about Open Source Transactional Storage Engines meaning Innodb, Falcon, Solid and PBXT. We’ll look into architecture of these storage engines as well as compare performance in number of Benchmarks. If you will be visiting OSCON please […]

Read More

Implementing efficient counters with MySQL

 | July 1, 2007 |  Posted In: Insight for Developers

On many web sites you would see a counter how many time given object – blog post, forum thread, image, movie etc was viewed. This is sometimes handy feature but it can be rather expensive from performance point of view. The nasty thing with counters as they are implemented the most trivial way – they […]

Read More