Buy Percona ServicesBuy Now!

Web Site Optimization: FrontEnd and BackEnd

 | June 26, 2008 |  Posted In: Insight for Developers

I spent Monday and Tuesday this week on Velocity Conference It was quite interesting event worth attending and it was very good to see the problems in this are going beyond Apache, PHP, Memcache and MySQL. A lot of talks on this conference was focusing on what is called “FrontEnd”. The meaning of Frontend is […]

Read More

Lighttpd as reverse proxy

 | June 17, 2008 |  Posted In: Insight for Developers

We often recommend to set lighttpd in front of apache to handle http requests (more about ) , redirect dynamic requests to apache and handle static files by itself. I just gathered step-by-step instruction how to do that in 10 minutes, as it may be not so obvious.

Read More

Apache PHP MySQL and Runaway Scripts

 | May 20, 2008 |  Posted In: Insight for Developers

Sometimes due to programming error or due to very complex query you can get your PHP script running too long, well after user stopped waiting for the page to render and went browsing other sites. Looking at Server-Status I’ve seen scripts executing for hours sometimes which is obviously the problem – they take Apache Slot, […]

Read More

Efficient Boolean value storage for Innodb Tables

 | April 23, 2008 |  Posted In: Insight for Developers

Sometimes you have the task of storing multiple of boolean values (yes/now or something similar) in the table and if you get many columns and many rows you may want to store them as efficient way as possible. For MyISAM tables you could use BIT(1) fields which get combined together for efficient storage:

Read More

Idea: Couple of more string types

 | April 18, 2008 |  Posted In: Insight for Developers

MySQL has a lot of string data types – CHAR, VARCHAR, BLOB, TEXT, ENUM and bunch of variants such as VARBINARY but I think it is not enough 🙂 I would also like to see type HEXCHAR which would be able to store hex strings, such as those returned as MD5() and SHA1() efficiently. With […]

Read More

Stored Function to generate Sequences

 | April 2, 2008 |  Posted In: Insight for Developers

Today a customer asked me to help them to convert their sequence generation process to the stored procedure and even though I have already seen it somewhere I did not find it with two minutes of googling so I wrote a simple one myself and posting it here for public benefit or my later use […]

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

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