- 论坛徽章:
- 0
|
回复 4# onlinekof2001
1)你的root@localhost没查询权限问题,执行一下show grants for 'root'@'localhost'
2)第一次看错你为MySQL5.5.30了, p_s是5.5.3就有的,不过,有可能如你所说的,在MySQL5.5.3时默认是没相关的。
3)MySQL5.5.20等,这安装后,肯定是有p_s库的。之前从5.1到5.5做in-place 升级时,必须copy P_S库,否则启动MySQL会提示错误。
下面以MySQL5.5.30新安装的示例:
mysql> select @@version;
+------------+
| @@version |
+------------+
| 5.5.30-log |
+------------+
1 row in set (0.01 sec)
mysql> show variables like 'performance_schema';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| performance_schema | OFF |
+--------------------+-------+
1 row in set (0.00 sec)
mysql> select TABLE_SCHEMA,TABLE_NAME from information_schema.tables where TABLE_SCHEMA='performance_schema';
+--------------------+----------------------------------------------+
| TABLE_SCHEMA | TABLE_NAME |
+--------------------+----------------------------------------------+
| performance_schema | cond_instances |
| performance_schema | events_waits_current |
| performance_schema | events_waits_history |
| performance_schema | events_waits_history_long |
| performance_schema | events_waits_summary_by_instance |
| performance_schema | events_waits_summary_by_thread_by_event_name |
| performance_schema | events_waits_summary_global_by_event_name |
| performance_schema | file_instances |
| performance_schema | file_summary_by_event_name |
| performance_schema | file_summary_by_instance |
| performance_schema | mutex_instances |
| performance_schema | performance_timers |
| performance_schema | rwlock_instances |
| performance_schema | setup_consumers |
| performance_schema | setup_instruments |
| performance_schema | setup_timers |
| performance_schema | threads |
+--------------------+----------------------------------------------+
17 rows in set (0.00 sec)
CON9309_Profiling with Performance Schema.pdf
(2.91 MB, 下载次数: 533)
这里讲了5.5, 5.6我之前提的“打开”的具体含义。
别外看一下5.5手册里:Chapter 20. MySQL Performance Schema
|
|