Emergency

Tag Archives: GitHub

What would you like to hear about on MySQL Users Conference 2008 ?

It is submission time now, with about one week left till proposal submission deadline. Both me and Vadim had submitted few talks to the Grand Jury which will make elite selection of sessions for MySQL …

Read More
 

Traffic Tricks by Hosting Providers.

I already wrote once about hosting troubles which we had with this site a while back. Today we had another trouble to one of the European hit servers for ClickAider project. We had purchased this …

Read More
 

MySQL Performance – eliminating ORDER BY function

One of the first rules you would learn about MySQL Performance Optimization is to avoid using functions when comparing constants or order by. Ie use indexed_col=N is good. function(indexed_col)=N is bad because MySQL Typically will …

Read More
 

MySQL Northern European Customer Conference

Yesterday I’ve attended MySQL Customers Conference in London. This event is much smaller size than Users Conference (one day and about 170 people attending) and surely less geeky – there were no one from MySQL …

Read More
 

Be careful when joining on CONCAT

The other day I had a case with an awful performance of a rather simple join. It was a join on tb1.vid = CONCAT(‘prefix-‘, tb2.id) with tb1.vid – indexed varchar(100) and tb2.id – int(11) column. …

Read More
 

Managing Slave Lag with MySQL Replication

The question I often get is how far MySQL may fall behind and how to keep replication from lagging. The lag you will see will vary a lot from application to the application and from …

Read More
 

MyISAM Scalability and Innodb, Falcon Benchmarks

We many times wrote about InnoDB scalability problems, this time We are faced with one for MyISAM tables. We saw that several times in synthetic benchmarks but never in production, that’s why we did not …

Read More
 

Add an option to Fail on Innodb Initialize failure, Please ?

I already wrote about this issue but as I is third team I’m helping customers to resolve this “frm corruption” issue it is the time to return to it again. During MySQL 5.0 release cycle …

Read More
 

HighLoad 2007 Review

Almost two weeks have passed since HighLoad 2007 conference in Moscow, Russia so I’m pretty late with feedback and my only excuse I was pretty busy to spare some time for it. Lets start with …

Read More
 

UNION vs UNION ALL Performance

When I was comparing performance of UNION vs MySQL 5.0 index merge algorithm Sinisa pointed out I should be using UNION ALL instead of simple UNION in my benchmarks, and he was right. Numbers would …

Read More