1.查看当前的表空间:
[mysql@master ~]$ mysql -uroot -hlocalhost
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 55
Server version: 5.6.16-log Source distribution
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show variables like 'innodb_data%';
+-----------------------+------------------------+
| Variable_name | Value |
+-----------------------+------------------------+
| innodb_data_file
Mysql 独享表空间
最新推荐文章于 2023-11-22 21:59:57 发布
本文介绍了如何查看MySQL的表空间状态,并详细解释了独享表空间和共享表空间的区别。独享表空间中,每个表的数据存储在独立的.ibd文件中,与MyISAM数据存放位置相同;而共享表空间则所有表数据存储在ibdata文件中,多个表共享一个或多个文件。
摘要由CSDN通过智能技术生成