Bug #57798 performance_schema tables cannot be read with lower case table names

• Submitted: 28 Oct 2010 10:27
• Modified: 28 Oct 2010 11:18
• Reporter: Christian Lox
• Status: Duplicate
• Category: MySQL Server: Performance Schema
• Severity: S3 (Non-critical)
• Version: 5.5.6-rc
• OS: Linux (Red Hat Enterprise Linux Server 5.5)
• CPU Architecture: Any
• Tags: performance_schema lower case table names

[28 Oct 2010 10:27] Christian Lox

Description:
When running MySQL configured with lower_case_table_names=1 the tables in performance_schema are no longer accessible.

How to repeat:
Install MySQL 5.5.6-rc :)

Activate performance_schema.
Set lower_case_table_names=1 in my.cnf

mysql> use performance_schema
mysql> show tables;
+----------------------------------------------+
| Tables_in_performance_schema                 |
+----------------------------------------------+
| COND_INSTANCES                               |
| EVENTS_WAITS_CURRENT                         |
| EVENTS_WAITS_HISTORY                         |
| EVENTS_WAITS_HISTORY_LONG                    |
| EVENTS_WAITS_SUMMARY_BY_INSTANCE             |
| EVENTS_WAITS_SUMMARY_BY_THREAD_BY_EVENT_NAME |
| EVENTS_WAITS_SUMMARY_GLOBAL_BY_EVENT_NAME    |
| FILE_INSTANCES                               |
| FILE_SUMMARY_BY_EVENT_NAME                   |
| FILE_SUMMARY_BY_INSTANCE                     |
| MUTEX_INSTANCES                              |
| PERFORMANCE_TIMERS                           |
| RWLOCK_INSTANCES                             |
| SETUP_CONSUMERS                              |
| SETUP_INSTRUMENTS                            |
| SETUP_TIMERS                                 |
| THREADS                                      |
+----------------------------------------------+
17 rows in set (0.00 sec)

mysql> select * from COND_INSTANCES;
ERROR 1146 (42S02): Table 'performance_schema.cond_instances' doesn't exist
mysql> select * from cond_instances;
ERROR 1146 (42S02): Table 'performance_schema.cond_instances' doesn't exist
mysql> Bye

[28 Oct 2010 10:42] Peter Laursen

looks like a duplicate of #57609

[28 Oct 2010 11:18] Valeriy Kravchuk

Duplicate of bug #57609.