Before starting to database performance tuning activities, Database Administrator requires different types of statistics like wait events, connection time, instance information, lock tables. MySQL 5.5 introduced a PERFORMANCE_SCHEMA storage engine to monitor the performance of data and different types of server events. One performance_schema database is created under the PERFORMANCE_SCHEMA storage engine. An INFORMATION_SCHEMA focuses … Continue reading MySQL 5.5: Introduced PERFORMANCE_SCHEMA storage engine to inspect the performance data