SYS Schema on MySQLの再確認
SYS Schemaは元々ps_helperという名前だったが、Oracle、MS SQLと同じように
分かり易くする為にSYSにしたとの事。
インストール方法
以下の2つのうちどちらか選択
1) Workbench6.1以上~
2) GitからScriptをダウンロード
root@localhost [sys]>select * from sys.version; +-------------+-------------------------------------------+ | sys_version | mysql_version | +-------------+-------------------------------------------+ | 1.1.0 | 5.6.22-enterprise-commercial-advanced-log | +-------------+-------------------------------------------+ 1 row in set (0.00 sec) root@localhost [sys]>select * from sys.schema_object_overview where db = 'sys'; +-----+-------------+-------+ | db | object_type | count | +-----+-------------+-------+ | sys | FUNCTION | 11 | | sys | VIEW | 78 | | sys | PROCEDURE | 22 | +-----+-------------+-------+ 3 rows in set, 3 warnings (0.40 sec) root@localhost [sys]>
x$はraw view (for tools to poll)
formatted viewはhumans and command lineの為に準備してある。(成形してある)
■■ user / Host Summary View
IO Usage
Stages
Statement Details
root@localhost [sys]>select * from user_summary\G *************************** 1. row *************************** user: background statements: NULL statement_latency: NULL statement_avg_latency: 0 ps table_scans: NULL file_ios: 1728 file_io_latency: 2.10 s current_connections: 18 total_connections: 21 unique_hosts: 0 *************************** 2. row *************************** user: root statements: 90 statement_latency: 1.37 s statement_avg_latency: 15.22 ms table_scans: 6 file_ios: 72340 file_io_latency: 2.59 s current_connections: 1 total_connections: 1 unique_hosts: 1 2 rows in set (0.01 sec) root@localhost [sys]>
■5.7では、メモリーの確認も出来る。
root@localhost [sys]>select * from sys.version; +-------------+---------------------+ | sys_version | mysql_version | +-------------+---------------------+ | 1.3.0 | 5.7.5-labs-http-log | +-------------+---------------------+ 1 row in set (0.00 sec) root@localhost [sys]>select * from user_summary\G *************************** 1. row *************************** user: root statements: 171 statement_latency: 569.90 ms statement_avg_latency: 3.33 ms table_scans: 5 file_ios: 1987 file_io_latency: 00:03:05.67 current_connections: 1 total_connections: 1 unique_hosts: 1 current_memory: 0 bytes total_memory_allocated: 0 bytes *************************** 2. row *************************** user: background statements: 0 statement_latency: 0 ps statement_avg_latency: 0 ps table_scans: 0 file_ios: 1940 file_io_latency: 1.59 s current_connections: 21 total_connections: 23 unique_hosts: 0 current_memory: 0 bytes <--- 5.7.5以上で追加された。 total_memory_allocated: 0 bytes <--- 5.7.5以上で追加された。 2 rows in set (0.01 sec) root@localhost [sys]>
■ユーザ毎にIOを確認出来る
root@localhost [sys]>select * from user_summary_by_file_io_type; +------------+--------------------------------------+-------+-----------+-------------+ | user | event_name | total | latency | max_latency | +------------+--------------------------------------+-------+-----------+-------------+ | background | wait/io/file/innodb/innodb_data_file | 608 | 798.30 ms | 37.70 ms | | background | wait/io/file/sql/FRM | 910 | 789.77 ms | 195.80 ms | | background | wait/io/file/innodb/innodb_log_file | 18 | 304.28 ms | 172.62 ms | | background | wait/io/file/sql/slow_log | 4 | 65.20 ms | 65.18 ms | | background | wait/io/file/sql/binlog | 32 | 45.77 ms | 19.03 ms | | background | wait/io/file/myisam/kfile | 67 | 27.08 ms | 7.97 ms | | background | wait/io/file/mysys/cnf | 5 | 21.57 ms | 21.51 ms | | background | wait/io/file/sql/binlog_index | 15 | 20.14 ms | 14.04 ms | | background | wait/io/file/mysys/charset | 3 | 13.95 ms | 13.87 ms | | background | wait/io/file/sql/ERRMSG | 5 | 10.38 ms | 7.82 ms | | background | wait/io/file/myisam/dfile | 42 | 4.91 ms | 1.40 ms | | background | wait/io/file/sql/query_log | 4 | 1.30 ms | 1.26 ms | | background | wait/io/file/sql/casetest | 10 | 473.97 us | 275.72 us | | background | wait/io/file/sql/pid | 3 | 197.44 us | 167.97 us | | background | wait/io/file/sql/global_ddl_log | 2 | 13.67 us | 11.35 us | | root | wait/io/file/csv/data | 69443 | 1.35 s | 277.94 ms | | root | wait/io/file/csv/metadata | 63 | 535.14 ms | 414.93 ms | | root | wait/io/file/sql/FRM | 676 | 379.57 ms | 69.12 ms | | root | wait/io/file/myisam/kfile | 1458 | 188.04 ms | 49.70 ms | | root | wait/io/file/myisam/dfile | 532 | 137.41 ms | 66.26 ms | | root | wait/io/file/sql/file_parser | 156 | 3.52 ms | 117.48 us | | root | wait/io/file/sql/dbopt | 16 | 494.32 us | 132.02 us | | root | wait/io/file/innodb/innodb_data_file | 2 | 24.08 us | 13.14 us | +------------+--------------------------------------+-------+-----------+-------------+ 23 rows in set (0.00 sec) root@localhost [sys]>
■STATEMENT_LATENCYなどを確認出来る。FULL_SCANなども確認可能。
root@localhost [sys]>select * from user_summary_by_statement_latency\G *************************** 1. row *************************** user: root total: 92 total_latency: 1.37 s max_latency: 952.59 ms lock_latency: 934.38 ms rows_sent: 203 rows_examined: 2968 rows_affected: 0 full_scans: 8 1 row in set (0.00 sec) root@localhost [sys]>
■ステートメントのタイプ毎に状況が確認出来る
root@localhost [sys]>select * from user_summary_by_statement_type\G *************************** 1. row *************************** user: root statement: select total: 10 total_latency: 839.20 ms max_latency: 766.46 ms lock_latency: 803.75 ms rows_sent: 36 rows_examined: 3133 rows_affected: 0 full_scans: 5 *************************** 2. row *************************** user: root statement: Field List total: 78 total_latency: 463.95 ms max_latency: 114.47 ms lock_latency: 130.78 ms rows_sent: 0 rows_examined: 0 rows_affected: 0 full_scans: 0
■IO処理とProcesslist_idが確認出来る。(Current)
root@localhost [sys]>select * from io_by_thread_by_latency\G *************************** 1. row *************************** user: root@localhost total: 72370 total_latency: 2.59 s min_latency: 4.68 ns avg_latency: 1.19 ms max_latency: 414.93 ms thread_id: 21 processlist_id: 1 *************************** 2. row *************************** user: main total: 1710 total_latency: 1.85 s min_latency: 24.96 ns avg_latency: 2.71 ms max_latency: 195.80 ms thread_id: 1 processlist_id: NULL
■どのファイル処理に時間がかかっているか確認出来る
root@localhost [sys]>select * from io_global_by_file_by_latency limit 2\G *************************** 1. row *************************** file: /usr/local/mysql-advanced-5.6.22-linux-glibc2.5-x86_64/data/mysql/general_log.CSV total: 64611 total_latency: 1.21 s count_read: 32253 read_latency: 1.14 s count_write: 101 write_latency: 1.18 ms count_misc: 32257 misc_latency: 66.27 ms *************************** 2. row *************************** file: /usr/local/mysql-advanced-5.6.22-linux-glibc2.5-x86_64/data/ibdata1 total: 532 total_latency: 706.08 ms count_read: 525 read_latency: 696.01 ms count_write: 2 write_latency: 87.71 us count_misc: 5 misc_latency: 9.98 ms 2 rows in set (0.00 sec) root@localhost [sys]>
■■ Analysis Views
Object Overview
Table Usage
Index Usage
Show users only
schema_*
root@localhost [sys]>select * from schema_table_statistics limit 1\G *************************** 1. row *************************** table_schema: mysql table_name: plugin total_latency: 0 ps rows_fetched: 0 fetch_latency: 0 ps rows_inserted: 0 insert_latency: 0 ps rows_updated: 0 update_latency: 0 ps rows_deleted: 0 delete_latency: 0 ps io_read_requests: 10 <---↓ IOの状況も確認可能 io_read: 1.46 KiB io_read_latency: 33.01 ms io_write_requests: 0 io_write: 0 bytes io_write_latency: 0 ps io_misc_requests: 14 io_misc_latency: 101.93 us 1 row in set (0.02 sec) root@localhost [sys]> root@localhost [sys]>select * from schema_index_statistics limit 1\G *************************** 1. row *************************** table_schema: sys table_name: sys_config index_name: PRIMARY rows_selected: 0 select_latency: 0 ps rows_inserted: 0 insert_latency: 0 ps rows_updated: 0 update_latency: 0 ps rows_deleted: 0 delete_latency: 0 ps 1 row in set (0.00 sec) root@localhost [sys]> root@localhost [sys]>select * from schema_tables_with_full_table_scans; +---------------+-------------+-------------------+ | object_schema | object_name | rows_full_scanned | +---------------+-------------+-------------------+ | test | T01_BKUP | 5 | | test | demo_test | 5 | +---------------+-------------+-------------------+ 2 rows in set (0.00 sec) root@localhost [sys]>
InnoDBはインスタンス、MyISAM I/Oはtemporary table IOでの待ちを示している
root@localhost [sys]>select * from waits_global_by_latency; +--------------------------------------+-------+---------------+-------------+-------------+ | events | total | total_latency | avg_latency | max_latency | +--------------------------------------+-------+---------------+-------------+-------------+ | wait/io/file/csv/data | 69530 | 1.35 s | 19.37 us | 277.94 ms | | wait/io/file/sql/FRM | 1664 | 1.17 s | 704.45 us | 195.80 ms | | wait/io/file/innodb/innodb_data_file | 625 | 855.73 ms | 1.37 ms | 37.70 ms | | wait/io/file/csv/metadata | 63 | 535.14 ms | 8.49 ms | 414.93 ms | | wait/io/file/innodb/innodb_log_file | 24 | 327.86 ms | 13.66 ms | 172.62 ms | | wait/io/file/myisam/kfile | 1591 | 215.86 ms | 135.68 us | 49.70 ms | | wait/io/file/myisam/dfile | 604 | 143.02 ms | 236.79 us | 66.26 ms | | wait/io/file/sql/slow_log | 10 | 68.33 ms | 6.83 ms | 65.18 ms | | wait/io/file/sql/binlog | 46 | 65.30 ms | 1.42 ms | 19.03 ms | | wait/io/table/sql/handler | 11 | 30.13 ms | 2.74 ms | 29.94 ms | | wait/io/file/sql/binlog_index | 31 | 29.84 ms | 962.71 us | 14.04 ms | | wait/io/file/mysys/cnf | 5 | 21.57 ms | 4.31 ms | 21.51 ms | | wait/io/file/mysys/charset | 3 | 13.95 ms | 4.65 ms | 13.87 ms | | wait/io/file/sql/ERRMSG | 5 | 10.38 ms | 2.08 ms | 7.82 ms | | wait/io/file/sql/query_log | 10 | 2.13 ms | 213.12 us | 1.26 ms | | wait/io/file/sql/file_parser | 78 | 653.66 us | 8.38 us | 21.38 us | | wait/io/file/sql/dbopt | 16 | 494.32 us | 30.89 us | 132.02 us | | wait/io/file/sql/casetest | 10 | 473.97 us | 47.40 us | 275.72 us | | wait/io/file/sql/pid | 3 | 197.44 us | 65.81 us | 167.97 us | | wait/io/file/sql/global_ddl_log | 2 | 13.67 us | 6.84 us | 11.35 us | | wait/lock/table/sql/handler | 8 | 4.71 us | 588.12 ns | 1.13 us | +--------------------------------------+-------+---------------+-------------+-------------+ 21 rows in set (0.01 sec) root@localhost [sys]>
ユーザー毎のファイルIOが確認出来る
root@localhost [sys]>root@localhost [sys]>select * from waits_by_user_by_latency; +------+--------------------------------------+-------+---------------+-------------+-------------+ | user | event | total | total_latency | avg_latency | max_latency | +------+--------------------------------------+-------+---------------+-------------+-------------+ | root | wait/io/file/csv/data | 69536 | 1.35 s | 19.37 us | 277.94 ms | | root | wait/io/file/csv/metadata | 63 | 535.14 ms | 8.49 ms | 414.93 ms | | root | wait/io/file/sql/FRM | 676 | 379.57 ms | 561.49 us | 69.12 ms | | root | wait/io/file/myisam/kfile | 1524 | 188.78 ms | 123.87 us | 49.70 ms | | root | wait/io/file/myisam/dfile | 562 | 138.12 ms | 245.76 us | 66.26 ms | | root | wait/io/table/sql/handler | 11 | 30.13 ms | 2.74 ms | 29.94 ms | | root | wait/io/file/innodb/innodb_data_file | 10 | 29.85 ms | 2.99 ms | 29.62 ms | | root | wait/io/file/sql/binlog | 14 | 19.53 ms | 1.40 ms | 12.48 ms | | root | wait/io/file/sql/binlog_index | 16 | 9.70 ms | 606.37 us | 6.12 ms | | root | wait/io/file/innodb/innodb_log_file | 2 | 3.96 ms | 1.98 ms | 3.94 ms | | root | wait/io/file/sql/file_parser | 156 | 3.52 ms | 22.54 us | 117.48 us | | root | wait/io/file/sql/slow_log | 6 | 3.13 ms | 521.60 us | 3.05 ms | | root | wait/io/file/sql/query_log | 6 | 830.11 us | 138.35 us | 793.00 us | | root | wait/io/file/sql/dbopt | 16 | 494.32 us | 30.89 us | 132.02 us | | root | wait/lock/table/sql/handler | 8 | 4.71 us | 588.12 ns | 1.13 us | +------+--------------------------------------+-------+---------------+-------------+-------------+ 15 rows in set (0.00 sec) root@localhost [sys]> root@localhost [sys]>select * from statement_analysis limit 2\G *************************** 1. row *************************** query: SELECT * FROM `sys` . `schema_ ... ATISTICS` . `TABLE_SCHEMA` ... db: sys full_scan: * exec_count: 1 err_count: 0 warn_count: 3 total_latency: 766.46 ms max_latency: 766.46 ms avg_latency: 766.46 ms lock_latency: 760.44 ms rows_sent: 3 rows_sent_avg: 3 rows_examined: 374 rows_examined_avg: 374 tmp_tables: 189 <--- Temp Tableの利用が確認出来る tmp_disk_tables: 33 <--- Temp Disk Tableの利用が確認出来る rows_sorted: 22 sort_merge_passes: 0 digest: 5170dc5f93bc1119d5ae4e33c35b9a9a first_seen: 2015-02-07 22:01:36 last_seen: 2015-02-07 22:01:36 *************************** 2. row *************************** query: SELECT `performance_schema` . ... a` . `accounts` . `HOST` = ... db: sys full_scan: exec_count: 1 err_count: 0 warn_count: 0 total_latency: 114.47 ms max_latency: 114.47 ms avg_latency: 114.47 ms lock_latency: 106.12 ms rows_sent: 0 rows_sent_avg: 0 rows_examined: 0 rows_examined_avg: 0 tmp_tables: 5 tmp_disk_tables: 0 rows_sorted: 0 sort_merge_passes: 0 digest: 46f73fffb370a0c58fe74b1f0c71f85b first_seen: 2015-02-07 21:55:46 last_seen: 2015-02-07 21:55:46 2 rows in set (0.00 sec) root@localhost [sys]>
■SQLステートメントのエラー回数などが確認出来る
root@localhost [sys]>select * from statements_with_errors_or_warnings limit 3\G *************************** 1. row *************************** query: `switch` db: sys exec_count: 1 errors: 1 error_pct: 100.0000 warnings: 0 warning_pct: 0.0000 first_seen: 2015-02-07 22:30:18 last_seen: 2015-02-07 22:30:18 digest: 1a34fb3cdd7b61d8f9a688cff4d8ef1b *************************** 2. row *************************** query: FLUSH `logsl` db: sys exec_count: 1 errors: 1 error_pct: 100.0000 warnings: 0 warning_pct: 0.0000 first_seen: 2015-02-07 22:30:43 last_seen: 2015-02-07 22:30:43 digest: ff6a6729c6f04b36d5f57c0cf1bacfd0 *************************** 3. row *************************** query: SELECT * FROM `statemanet_analysis` LIMIT ? db: sys exec_count: 1 errors: 1 error_pct: 100.0000 warnings: 0 warning_pct: 0.0000 first_seen: 2015-02-07 22:42:18 last_seen: 2015-02-07 22:42:18 digest: 577ed5b5d68f1e1cad11c030187cc58c 3 rows in set (0.00 sec) root@localhost [sys]>
■ SQL StatementのTemp Tableの利用状況が確認出来る。
root@localhost [sys]>select * from statements_with_temp_tables limit 1\G *************************** 1. row *************************** query: SELECT * FROM `sys` . `schema_ ... ATISTICS` . `TABLE_SCHEMA` ... db: sys exec_count: 1 total_latency: 766.46 ms memory_tmp_tables: 189 disk_tmp_tables: 33 avg_tmp_tables_per_query: 189 tmp_tables_to_disk_pct: 17 first_seen: 2015-02-07 22:01:36 last_seen: 2015-02-07 22:01:36 digest: 5170dc5f93bc1119d5ae4e33c35b9a9a 1 row in set (0.00 sec) root@localhost [sys]>
■SQLステートメントのFULLスキャンが確認出来る。
root@localhost [sys]>select * from statements_with_full_table_scans limit 1\G *************************** 1. row *************************** query: SELECT * FROM `sys` . `schema_ ... ATISTICS` . `TABLE_SCHEMA` ... db: sys exec_count: 1 total_latency: 766.46 ms no_index_used_count: 1 no_good_index_used_count: 0 no_index_used_pct: 100 rows_sent: 3 rows_examined: 374 rows_sent_avg: 3 rows_examined_avg: 374 first_seen: 2015-02-07 22:01:36 last_seen: 2015-02-07 22:01:36 digest: 5170dc5f93bc1119d5ae4e33c35b9a9a 1 row in set (0.00 sec) root@localhost [sys]>
■SHOW PROCESSLISTより多くの情報を確認出来る。
root@localhost [sys]>select * from processlist limit 2\G *************************** 1. row *************************** thd_id: 1 conn_id: NULL user: sql/main db: NULL command: NULL state: System lock time: 3410 current_statement: INTERNAL DDL LOG RECOVER IN PROGRESS lock_latency: NULL rows_examined: NULL rows_sent: NULL rows_affected: NULL tmp_tables: NULL tmp_disk_tables: NULL full_scan: NO last_statement: NULL last_statement_latency: NULL last_wait: NULL last_wait_latency: NULL source: NULL *************************** 2. row *************************** thd_id: 21 conn_id: 1 user: root@localhost db: sys command: Query state: Sending data time: 0 current_statement: select * from processlist limit 2 lock_latency: 283.00 us rows_examined: 0 rows_sent: 0 rows_affected: 0 tmp_tables: 2 tmp_disk_tables: 0 full_scan: YES last_statement: NULL last_statement_latency: NULL last_wait: NULL last_wait_latency: NULL source: NULL 2 rows in set (0.00 sec) root@localhost [sys]>
■ Functionsでデータを自動的に読みやすく変換してくれる。
root@localhost [sys]>select format_time(232222345) as time -> union select format_time(8323232323) -> union select format_time(8323232323234566); +-----------+ | time | +-----------+ | 232.22 us | | 8.32 ms | | 2.31h | +-----------+ 3 rows in set (0.00 sec) root@localhost [sys]> root@localhost [sys]>select format_bytes(23456) as bytes -> union select format_bytes(23456789); +-----------+ | bytes | +-----------+ | 22.91 KiB | | 22.37 MiB | +-----------+ 2 rows in set (0.00 sec) root@localhost [sys]>
Theadの情報をDUMPする事が可能
root@localhost [sys]>call ps_trace_thread(1,'/tmp/stack_1.dot',60,0.1,true,true,true); +-------------------+ | summary | +-------------------+ | Disabled 1 thread | +-------------------+ 1 row in set (0.01 sec) +--------------------------------------------+ | Info | +--------------------------------------------+ | Data collection starting for THREAD_ID = 1 | +--------------------------------------------+ +-----------------------------------------+ | Info | +-----------------------------------------+ | Stack trace written to /tmp/stack_1.dot | +-----------------------------------------+ 1 row in set (4.07 sec) +------------------------------------------------+ | Convert to PDF | +------------------------------------------------+ | dot -Tpdf -o /tmp/stack_1.pdf /tmp/stack_1.dot | +------------------------------------------------+ 1 row in set (4.07 sec) +------------------------------------------------+ | Convert to PNG | +------------------------------------------------+ | dot -Tpng -o /tmp/stack_1.png /tmp/stack_1.dot | +------------------------------------------------+ 1 row in set (4.07 sec) +------------------+ | summary | +------------------+ | Enabled 1 thread | +------------------+ 1 row in set (4.19 sec) Query OK, 0 rows affected (4.19 sec) root@localhost [sys]>
——メモ: GraphやPDF化するには以下のソフトが必要—–
PDF作成
[root@misc admin]# dot -Tpdf -o /tmp/stack_2.pdf /tmp/stack_2.dot [root@misc admin]# ls -l /tmp/ 合計 12 srwxrwxrwx. 1 mysql mysql 0 2月 7 21:55 mysql.sock -rw-rw-rw-. 1 mysql mysql 293 2月 7 23:15 stack_1.dot -rw-rw-rw-. 1 mysql mysql 293 2月 7 23:21 stack_2.dot -rw-r--r--. 1 root root 968 2月 7 23:30 stack_2.pdf [root@misc admin]#
以下、インストールログ
[root@misc admin]# wget http://www.graphviz.org/graphviz-rhel.repo --2015-02-07 23:26:22-- http://www.graphviz.org/graphviz-rhel.repo www.graphviz.org (www.graphviz.org) をDNSに問いあわせています... 204.178.9.49 www.graphviz.org (www.graphviz.org)|204.178.9.49|:80 に接続しています... 接続しました。 HTTP による接続要求を送信しました、応答を待っています... 200 OK 長さ: 1138 (1.1K) [text/plain] `graphviz-rhel.repo' に保存中 100%[==============================================================================================================>] 1,138 --.-K/s 時間 0.003s 2015-02-07 23:26:25 (321 KB/s) - `graphviz-rhel.repo' へ保存完了 [1138/1138] [root@misc admin]# ls -l 合計 320 drwx------. 4 root root 92 1月 24 22:59 backup drwx------. 4 root root 92 1月 25 21:15 backup0125manual -rwxr-xr-x. 1 root root 299008 1月 5 20:32 cpanm -rw-r--r--. 1 root root 1138 2月 17 2012 graphviz-rhel.repo -rwxr-xr-x. 1 root root 642 1月 5 14:18 memcached_fast.pl -rwxr-xr-x. 1 root root 316 1月 5 21:03 memcached_mysql.pl drwxrwxrwx. 4 mysql root 92 1月 24 23:37 mysqlbackup -rw-r--r--. 1 root root 12582 3月 21 2013 rpmforge-release-0.5.3-1.el5.rf.x86_64.rpm [root@misc admin]# yum install 'graphviz*' 読み込んだプラグイン:fastestmirror Loading mirror speeds from cached hostfile * base: ftp.riken.jp * extras: ftp.riken.jp * rpmforge: ftp.kddilabs.jp * updates: ftp.riken.jp 依存性の解決をしています --> トランザクションの確認を実行しています。 ---> パッケージ graphviz.x86_64 0:2.30.1-18.el7 を インストール --> 依存性の処理をしています: urw-fonts のパッケージ: graphviz-2.30.1-18.el7.x86_64 --> 依存性の処理をしています: librsvg-2.so.2()(64bit) のパッケージ: graphviz-2.30.1-18.el7.x86_64 --> 依存性の処理をしています: libpng15.so.15()(64bit) のパッケージ: graphviz-2.30.1-18.el7.x86_64 --> 依存性の処理をしています: libpangoft2-1.0.so.0()(64bit) のパッケージ: graphviz-2.30.1-18.el7.x86_64 [root@misc admin]# rpm -qa |grep -i graphviz graphviz-2.30.1-18.el7.x86_64 graphviz-perl-2.30.1-18.el7.x86_64 graphviz-ocaml-2.30.1-18.el7.x86_64 graphviz-gd-2.30.1-18.el7.x86_64 graphviz-php-2.30.1-18.el7.x86_64 graphviz-guile-2.30.1-18.el7.x86_64 graphviz-graphs-2.30.1-18.el7.x86_64 graphviz-devel-2.30.1-18.el7.x86_64 graphviz-lua-2.30.1-18.el7.x86_64 graphviz-ruby-2.30.1-18.el7.x86_64 graphviz-doc-2.30.1-18.el7.x86_64 graphviz-tcl-2.30.1-18.el7.x86_64 graphviz-python-2.30.1-18.el7.x86_64 graphviz-java-2.30.1-18.el7.x86_64 [root@misc admin]#
Sys Schema for MySQL 5.6 and MySQL 5.7
http://wiki.ducca.org/wiki/graphviz_%E3%81%AE%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB