国产成人久久精品区一区二区,日韩欧美亚洲综合久久,色婷婷综合久久久久中文

mysql創建表空間的方法：【create tablespace 表空間 add datafile 保存路徑;】。如果要刪除表空間，可以執行sql語句【DROP TABLESPACE tablespace_name;】。

mysql怎么創建表空間

創建表空間

（推薦教程：mysql教程）

sql語句：

mysql&gt;?create?tablespace?big_data_in_mysql?add?datafile?'first.ibd'; Query?OK,?0?rows?affected?(0.57?sec)

上面這個語句就會創建一個名為big_data_in_mysql的表空間。同時這個表空間所對應的數據存放在first.ibd這個文件中。

因為這里沒有指定存儲目錄，所以使用的是默認存儲路徑。這時，可以到默認數據存儲文件夾下查看是否創建成功。

mysql怎么創建表空間

查看表空間

mysql&gt;?select?*?from?information_schema.INNODB_SYS_TABLESPACES?; +-------+---------------------------------+------+-------------+------------+-----------+---------------+------------+---------------+-----------+----------------+ |?SPACE?|?NAME????????????????????????????|?FLAG?|?FILE_FORMAT?|?ROW_FORMAT?|?PAGE_SIZE?|?ZIP_PAGE_SIZE?|?SPACE_TYPE?|?FS_BLOCK_SIZE?|?FILE_SIZE?|?ALLOCATED_SIZE?| +-------+---------------------------------+------+-------------+------------+-----------+---------------+------------+---------------+-----------+----------------+ |?????2?|?mysql/plugin????????????????????|???33?|?Barracuda???|?Dynamic????|?????16384?|?????????????0?|?Single?????|?????????65536?|?????98304?|??????????98304?| |?????3?|?mysql/servers???????????????????|???33?|?Barracuda???|?Dynamic????|?????16384?|?????????????0?|?Single?????|?????????65536?|?????98304?|??????????98304?| |?????4?|?mysql/help_topic????????????????|???33?|?Barracuda???|?Dynamic????|?????16384?|?????????????0?|?Single?????|?????????65536?|???9437184?|????????9437184?| ···· |????93?|?bas/t_bas_shop_item?????????????|???33?|?Barracuda???|?Dynamic????|?????16384?|?????????????0?|?Single?????|?????????65536?|????163840?|?????????163840?| |???119?|?insidemysql/student#p#p2????????|???33?|?Barracuda???|?Dynamic????|?????16384?|?????????????0?|?Single?????|?????????65536?|?????98304?|??????????98304?| |???120?|?insidemysql/t???????????????????|???33?|?Barracuda???|?Dynamic????|?????16384?|?????????????0?|?Single?????|?????????65536?|?????98304?|??????????98304?| |???122?|?test_tablespace?????????????????|?2048?|?Any?????????|?Any????????|?????16384?|?????????????0?|?General????|?????????65536?|?????65536?|??????????65536?| |???125?|?big_data_in_mysql???????????????|?2048?|?Any?????????|?Any????????|?????16384?|?????????????0?|?General????|?????????65536?|?????65536?|??????????65536?| +-------+---------------------------------+------+-------------+------------+-----------+---------------+------------+---------------+-----------+----------------+ 53?rows?in?set?(0.03?sec)

刪除表空間

DROP?TABLESPACE?tablespace_name [ENGINE?[=]?engine_name]