mysql 查詢undo空間

germany006發表於2014-03-04
mysql> use information_schema;
mysql> select file_name,file_type,logfile_group_number,free_extents,total_extents,extra from files where file_type='UNDO LOG';
+------------+-----------+----------------------+--------------+---------------+-------------------------------------------+
| file_name  | file_type | logfile_group_number | free_extents | total_extents | extra                                     |
+------------+-----------+----------------------+--------------+---------------+-------------------------------------------+
| undo_2.log | UNDO LOG  |                   10 |         NULL |    2499993600 | CLUSTER_NODE=30;UNDO_BUFFER_SIZE=50003968 |
| undo_1.log | UNDO LOG  |                   10 |         NULL |    2499993600 | CLUSTER_NODE=30;UNDO_BUFFER_SIZE=50003968 |
| NULL       | UNDO LOG  |                   10 |   4703294591 |          NULL | UNDO_BUFFER_SIZE=50003968                 |
+------------+-----------+----------------------+--------------+---------------+-------------------------------------------+
3 rows in set (0.01 sec)


查詢data_file
 select file_name,file_type,logfile_group_number,free_extents,total_extents,extra from files where file_type='DATAFILE';

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28371090/viewspace-1100536/,如需轉載,請註明出處,否則將追究法律責任。

相關文章