MySQL Performance
MySQL performance is mainly about 3 things:
- Benchmark
- Index optimization
- Schema improvements
Benchmark
There are many tools that can help you analyse how well your SQL is processing, where are the bottlenecks and which SQL commands are taking longer to execute. There some techniques you can apply to you code, however, that can give you insights about your DB server performace that can be very helpfull, and are free!
Index optimization
Each storage engine (MyISAM, InnoDB ...) has it's own indexation. Understanding how they work is excential for a good performance, but you shouldn't overuse it, it can make it slow to update and insert values.
Schema optimization
This part of you performance work is about choosing the right data types.
I've many PHP codes ready to be installed on any application. The ideal thing here is to have these scripts up and running for one week just storing data. There some bottlenecks that are visible from the first minute, but a serious system manager will want keep an eye on it all the time for prevention purposes.
Contact me for more information of how to improve your server's speed and how to use -- and read -- the techniques -- and it's results -- expressed on the above pages and articles.
