首页 > 数据库技术 > 详细

mysql free tablespace

时间:2015-01-01 02:04:19      阅读:314      评论:0      收藏:0      [点我收藏+]
mysql> create tablespace ts3 add datafile ‘ts3_1.dat‘ use logfile group lg1 initial_size=1G engine=ndb;
Query OK, 0 rows affected (9.41 sec)

mysql> select * from isf;
+-----------+-------------+------------+----------+----------------+
| FILE_NAME | Total | Free | % Free | EXTRA |
+-----------+-------------+------------+----------+----------------+
| ts1_1.dat | 10737418240 | 2147483648 | 20.0000 | CLUSTER_NODE=3 |
| ts1_1.dat | 10737418240 | 2147483648 | 20.0000 | CLUSTER_NODE=4 |
| ts2_1.dat | 1048576000 | 1048576000 | 100.0000 | CLUSTER_NODE=3 |
| ts2_1.dat | 1048576000 | 1048576000 | 100.0000 | CLUSTER_NODE=4 |
| ts3_1.dat | 1073741824 | 1073741824 | 100.0000 | CLUSTER_NODE=3 |
| ts3_1.dat | 1073741824 | 1073741824 | 100.0000 | CLUSTER_NODE=4 |
+-----------+-------------+------------+----------+----------------+
6 rows in set (0.00 sec)

mysql> create tablespace ts4 add datafile ‘ts4_1.dat‘ use logfile group lg1 initial_size=10G engine=ndb;
Query OK, 0 rows affected (1 min 28.91 sec)

mysql> select * from isf;
+-----------+-------------+------------+----------+----------------+
| FILE_NAME | Total | Free | % Free | EXTRA |
+-----------+-------------+------------+----------+----------------+
| ts1_1.dat | 10737418240 | 2147483648 | 20.0000 | CLUSTER_NODE=3 |
| ts1_1.dat | 10737418240 | 2147483648 | 20.0000 | CLUSTER_NODE=4 |
| ts2_1.dat | 1048576000 | 1048576000 | 100.0000 | CLUSTER_NODE=3 |
| ts2_1.dat | 1048576000 | 1048576000 | 100.0000 | CLUSTER_NODE=4 |
| ts3_1.dat | 1073741824 | 1073741824 | 100.0000 | CLUSTER_NODE=3 |
| ts3_1.dat | 1073741824 | 1073741824 | 100.0000 | CLUSTER_NODE=4 |
| ts4_1.dat | 10737418240 | 2147483648 | 20.0000 | CLUSTER_NODE=3 |
| ts4_1.dat | 10737418240 | 2147483648 | 20.0000 | CLUSTER_NODE=4 |
+-----------+-------------+------------+----------+----------------+

mysql free tablespace

原文:http://www.blogjava.net/ivanwan/archive/2014/12/31/421998.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!