mysql 查询undo空间
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';
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博客 ” ，链接：https://blog.itpub.net/28371090/viewspace-1100536/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- POSTGRESQL16.9单机安装部署
- MYSQL5.7.22 源码安装 主从搭建 + KEEPALIVED高可用
- WINDOWS自动打包目录脚本 复制到远程备份服务器保存
- MYSQL5.7.22全库备份导入MYSQL8.0.20报错ERROR3554
- MYSQL8+CENTOS7.6 主从+keepalived搭建总结
- 通过ORACLE VM virtualbox环境安装oracle 11G RAC(ASM)
- 使用SCRT+XMING 图形界面
- postgresql10主从+keepalived高可用自动切换(切换关键在脚本)
- MYSQL5.6.40主从+keepalive高可用自动切换(已完善)
- WINDOWS2016想要使用NFS挂载，但是没有NFS服务，无法使用mount命令
