Slide 63
Slide 63 text
information_schemaにアクセスするスクリプトが転け
る
mysql57 6> SELECT table_schema, table_name, data_length, index_length, data_free FROM information_schema.tables WHE
RE (table_schema, table_name)= ('d1', 't1');
+--------------+------------+-------------+--------------+-----------+
| table_schema | table_name | data_length | index_length | data_free |
+--------------+------------+-------------+--------------+-----------+
| d1 | t1 | 16384 | 0 | 0 |
+--------------+------------+-------------+--------------+-----------+
1 row in set (0.03 sec)
mysql80 11> SELECT table_schema, table_name, data_length, index_length, data_free FROM information_schema.tables WH
ERE (table_schema, table_name)= ('d1', 't1');
+--------------+------------+-------------+--------------+-----------+
| TABLE_SCHEMA | TABLE_NAME | DATA_LENGTH | INDEX_LENGTH | DATA_FREE |
+--------------+------------+-------------+--------------+-----------+
| d1 | t1 | 16384 | 0 | 0 |
+--------------+------------+-------------+--------------+-----------+
1 row in set (0.05 sec)
62/86