mysql routines是什么_5.7 mysqldump routines

场景：

1 新建一个5.7.12的实例

2 导出全库

mysqldump --all-databases -uroot -ptest --set-gtid-purged=off

--single-transaction --quick -R --events > /tmp/a.sql

3 导出前检查：

mysql> select count(*) from mysql.proc;

+----------+

| count(*) |

+----------+

|  47

|

+----------+

1 row in set (0.00 sec)

mysql> select * from  host_summary;

+-----------+------------+-------------------+-----------------------+-------------+----------+-----------------+---------------------+-------------------+--------------+----------------+------------------------+

| host  | statements | statement_latency |

statement_avg_latency | table_scans | file_ios | file_io_latency |

current_connections | total_connections | unique_users |