phpmysqlapache.com

Identifying slow db queries is critical for the optimal operation of the db server. There is an excellent guide that helps to accomplish this task: http://www.ducea.com/2006/11/06/identifying-mysql-slow-queries/

If your mysql database is not as fast as it used to be, maybe it is a good idea to activate the slow queries log. Add the following lines in your .my.cnf file:

All the queries that take more than 2sec to execute will be logged in the /var/log/mysql-slow-queries.log file

Cakephp rocks. I just stared making a new site with cakephp and I already had a problem. The mysql encoding did not work properly for my language (greek). I made my database using utf8_unicode_ci but certain character appear wrong.
This is the solution:

Create a new file app_model.php, place it in your app folder. Put the following contents in the file:

if you are working with scaffolding, put this line in your cake/libs/view/templates/layouts/default.thtml:

This info comes from: http://www.get-the-answer.info/comments.php?DiscussionID=5&page=1