If you’ve upgraded from MySQL 5.1 to a newer version (5.5? 5.6? 5.7?) Mark Leith shows you why you should turn on performance_schema. Roland Bouman gave us Common_Schema to help improve the SQL user experience. Mark now lets us look inward at the IO latency to improve the system.
Mark has developed a great set of views and procedures to work with performance_schema that can give you things like:
- A list all statements who’s average runtime, in microseconds, are the top 5% slowest