![variable.jp [データベース,パフォーマンス,運用]](https://variable.jp/wp-content/uploads/2013/09/cropped-variable.jp_.jpg)
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