What can I do if the MySQL server is slow?
You can diagnose why your MySQL is slow by adding the following to your "my.cnf" template file below
slow-query-log = 1 slow-query-log-file = /applications/mamp/logs/mysql-slow.log long_query_time = 1 log-queries-not-using-indexes
Restart your MySQL server. Access your database. You should now see a log file named “mysql-slow.log” in your “/Applications/MAMP/logs” directory.