DataBase profiler
Posted: Thu Aug 13, 2009 2:07 pm
Hi all
I am getting to the end of a mammoth creation and learning curve or creating a PHP, JavaScript and MYSQL dynamic site and I am looking for any recommendations on profiling my database to find any bottlenecks or issues with my MYSQL.
I have implemented caching across the entire site using pear but I still want to make sure when the DB is being used it is as efficient as possible.
Has anyone got any personal recommendations for performing such profiling? As always money is tight here so an open source application would be ideal to test on my home Dev server before I release her into the wild.
Thanks in advance for any help.
I am getting to the end of a mammoth creation and learning curve or creating a PHP, JavaScript and MYSQL dynamic site and I am looking for any recommendations on profiling my database to find any bottlenecks or issues with my MYSQL.
I have implemented caching across the entire site using pear but I still want to make sure when the DB is being used it is as efficient as possible.
Has anyone got any personal recommendations for performing such profiling? As always money is tight here so an open source application would be ideal to test on my home Dev server before I release her into the wild.
Thanks in advance for any help.