Buy Percona ServicesBuy Now!

Only Design What You Can Implement

 | March 26, 2007 |  Posted In: Insight for Developers

Working with various projects using MySQL I observe a lot of problems are coming from very simple fact – product is designed containing features which developers do not know how to implement effectively. In many companies you would see “waterfall” like approach for web application development at least on business-development boundary. Business people would dream […]

Read More

To UUID or not to UUID ?

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

Brian recently posted an article comparing UUID and auto_increment primary keys, basically advertising to use UUID instead of primary keys. I wanted to clarify this a bit as I’ve seen it being problems in so many cases. First lets look at the benchmark – we do not have full schema specified in the article itself […]

Read More

Mail clients and Databases

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

I get a lot of mail and I prefer to store it for long time if not forever. With modern hard disk sizes it should not be problem at all, but because of how mailing programs are written it causes a lot of problems. I’ve tried a lot of programs – Kmail, Evolution, Thunderbird on […]

Read More

System size and Performance Optimization

 | February 27, 2007 |  Posted In: Insight for Developers

Performance optimization is never ending story, you can virtually always find something else to optimize but while on generic system, not tuned by expert you often can get significant performance increase in the matter of hours further performance improvements become more and more time consuming and expensive and gains smaller. This observation does not only […]

Read More

MySQL Error control changes

 | February 19, 2007 |  Posted In: Insight for Developers

In MySQL 5.0 mainly error control was improved, such as strict mode was added to change famous MySQL behavior of cutting too large strings, too big numbers and allowing you to use dates such as February 31st. In one case however reverse change was done – in regards to storage engine initialization. Previously if you […]

Read More

Getting use of Slave in MySQL Replication

 | February 14, 2007 |  Posted In: Insight for Developers

MySQL Replication is asynchronous which causes problems if you would like to use MySQL Slave as it can contain stale data. It is true delay is often insignificant but in times of heavy load or in case you was running some heavy queries on the master which not take time to replicate to the slave […]

Read More

Content delivery system design mistakes

 | February 11, 2007 |  Posted In: Insight for Developers

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 […]

Read More

Why do you need many apache children ?

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

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, […]

Read More