MySQL5.7.7引入的sys库可以看作是由information_schema引出的一套视图,更便于获取一些性能数据。
下面我会记录如何为MySQL5.6加上sys库。
首先从https://github.com/mysql/mysql-sys上克隆项目到本地
假设存放在/tmp/mysql-sys下(注意文件权限为root,执行的可以是拥有invoke权限的用户)
[root@237_21 tmp]# git clone https://github.com/mysql/mysql-sys.git
Initialized empty Git repository in /tmp/mysql-sys/.git/
remote: Counting objects: 3009, done.
remote: Total 3009 (delta 0), reused 0 (delta 0), pack-reused 3009
Receiving objects: 100% (3009/3009), 1.17 MiB | 205 KiB/s, done.
Resolving deltas: 100% (1770/1770), done.
[root@237_21 tmp]# ll mysql-sys/
total 380
-rw-r--r-- 1 root root 782 Oct 30 11:12 after_setup.sql
-rw-r--r-- 1 root root 891 Oct 30 11:12 before_setup.sql
-rw-r--r-- 1 root root 17987 Oct 30 11:12 COPYING
drwxr-xr-x 2 root root 4096 Oct 30 11:12 functions
-rwxr-xr-x 1 root root 7842 Oct 30 11:12 generate_sql_file.sh
-rw-r--r-- 1 root root 707 Oct 30 11:12 LICENSE
drwxr-xr-x 3 root root 4096 Oct 30 11:12 mysql-test
-rw-r--r-- 1 root root 20596 Oct 30 11:12 NEWS.md
drwxr-xr-x 2 root root 4096 Oct 30 11:12 procedures
-rw-r--r-- 1 root root 270716 Oct 30 11:12 README.md
-rw-r--r-- 1 root root 7613 Oct 30 11:12 sys_56.sql
-rw-r--r-- 1 root root 8366 Oct 30 11:12 sys_57.sql
drwxr-xr-x 2 root root 4096 Oct 30 11:12 tables
drwxr-xr-x 2 root root 4096 Oct 30 11:12 templates
drwxr-xr-x 2 root root 4096 Oct 30 11:12 triggers
drwxr-xr-x 4 root root 4096 Oct 30 11:12 views
导入出错
[root@237_21 tmp]# mysql -uroot -p -S /tmp/mysql3306.sock < ./mysql-sys/sys_56.sql
Enter password:
ERROR at line 16: Failed to open file './before_setup.sql', error: 2
修改文件权限:mysql:mysql后,可以正确导入了
参考文档:
https://github.com/mysql/mysql-sys
https://yq.aliyun.com/articles/36106