CodeFutures News & Industry Commentary Blog

Today’s InfoWorld Off The Record proposes that improving the performance of any application starts with optimizing the slowest thing. The stories are from 40 years ago. Nowadays, almost every business application uses a database and it is almost always the database that is the bottleneck. With the speed of multi-core processors, only exceptionally complex business logic could possibly take longer than even simple database reads or writes.

So that means that the rule “Optimizing the Slowest Thing” means database optimization. This is why CodeFutures is rolling out a free database performance analysis service, starting with MySQL.

The elements of the performance analysis are:

-MySQL configuration analysis
-Strategies for database reorganization and optimization
-How to perform database optimization without taking your application down
-Database size optimization (reclaiming unused disk space)
-Long-running query analysis
-Indexing strategy
-Reliability/availability/failover evaluation


CodeFutures has already developed a tool to gather the necessary information about a specific MySQL deployment. At the moment, the data analysis is manual. The tool will eventually evolve to include features providing immediate performance and configuration feedback. However, full analysis of the data requires someone with significant MySQL optimization experience - so there will always be a limit to what a tool can do.

You can your request free MySQL performance analysis here.

Labels: Application Development, Database Optimization, Database Performance, Database Scalability, MySQL performance, MySQL scalability