I have a complex query that is performing in subsecond time on my laptop, while the same query takes 70 seconds on my production server under no load against an identical schema.
The EXPLAIN plan is similar enough to not warrant such a massive increase in execution time, and identical in terms of the number of rows returned at each step.
This query is going against a query only database, so it's not a result of not having analyzed table statistics either.
I installed MySQL Workbench which seems to be a really nice tool, especially considering the fact that it's free. However, this section in the explorer interface for my connection that is completely grayed out:
PERFORMANCE Dashboard Performance Reports Performance Schema Setup
I did add the following line to my /etc/my.cnf file and restart my server:
And I followed the instructions in the MySQL Performance Schema Quick Start Guide and verified that this feature is indeed enabled.
I kicked off a job last night in order to have some statistics collected, but this morning only find:
while every other performance_schema-related variable is zero.
The error log is blank, so I have so idea how to find out how to make this work.
I am running MySQL 5.5.21, and MySQL Workbench 6.1 on Mac OSX Mavericks.