I got first Sun/MySQL Newsletter Today which among other things lead to the site publishing among other things links to various stuff related to Sun and MySQL and among other things – These Benchmarks This may be great piece of Benchmarks for Sales and Marketing needs as they show sun stuff is so much cooler [...]
MySQL Full Text Search in Action
February 7, 2008 By 9 Comments
Preparing to move I’m selling stuff on GumTree which is UK based clone of Craigslist offering similar functionality but with Ads Similarly to Craigslist GumTree is powered by MySQL but unlike craigslist it looks like they are shy in tuning their MySQL Full Text Search index configuration and setting proper ft_min_word_len value. Searching for Audi [...]
Site was down today, support and web hosting.
August 31, 2007 By 27 Comments
During last one and a half year we had pretty good track record with MySQL Performance Blog – there were times when site was slow (especially when backup was running) but I do not remember significant downtime, until today we went down for few hours. All this time the site was running on dedicated server [...]
Using index for ORDER BY vs restricting number of rows.
February 16, 2007 By 8 Comments
One interesting problem with MySQL Optimizer I frequently run into is making poor decision when it comes to choosing between using index for ORDER BY or using index for restriction. Consider we’re running web site which sell goods, goods may be from different categories, different sellers different locations which can be filtered on, and there [...]
Content delivery system design mistakes
February 11, 2007 By 9 Comments
This week I helped dealing with performance problems (part MySQL related and part related to LAMP in general) of system which does quite a bit of content delivery, serving file downloads and images – something a lot of web sites need to do these days. There were quite a bit of mistakes in design for [...]
Why do you need many apache children ?
February 5, 2007 By 15 Comments
I already wrote kind of about same topic a while ago and now interesting real life case makes me to write again Most Web applications we’re working with have single tier web architecture, meaning there is just single set of apache servers server requests and nothing else – no dedicated server for static content, no [...]
Performance impact of complex queries
January 17, 2007 By 11 Comments
What is often underestimated is impact of MySQL Performance by complex queries on large data sets(ie some large aggregate queries) and batch jobs. It is not rare to see queries which were taking milliseconds to stall for few seconds, especially in certain OS configurations, and on low profile servers (ie having only one disk drive) [...]
Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
As you probably know PHP “mysql” extension supported persistent connections but they were disabled in new “mysqli” extension, which is probably one of the reasons some people delay migration to this extension. The reason behind using persistent connections is of course reducing number of connects which are rather expensive, even though they are much faster [...]
Consulting for MySQL
July 31, 2006 By
Percona offers consulting (and training, and support, and development) services for MySQL and LAMP applications. We can help with all areas of the MySQL Server – Operations, Application Design, Custom Feature development, and so on. Please visit our company website to learn more about our MySQL consulting and other services for MySQL, our more than [...]
MySQL Sizing questions
June 23, 2006 By 4 Comments
I frequently get questions along the lines of “how many transactions per second MySQL can do” or “how many servers I need to handle 100.000 users” or “which hardware would be enough to handle my 40GB” database. There are two things which are very interesting about these questions which make them funny and annoying at [...]
