SYS Schema on MySQLの再確認
SYS Schemaは元々ps_helperという名前だったが、Oracle、MS SQLと同じように
分かり易くする為にSYSにしたとの事。

The MySQL SYS Schema

インストール方法
以下の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 &#91;sys&#93;>

■ユーザ毎に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 &#91;sys&#93;>

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 &#91;sys&#93;>

■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

Comments are closed.

Post Navigation