mysql> show variables like '%per_table%'; +-----------------------+-------+ | Variable_name | Value | +-----------------------+-------+ | innodb_file_per_table | OFF | +-----------------------+-------+ 1 row in set (0.00 sec)
如果是OFF，肯定不是獨立表空間。如果是ON的話，也不一定是獨立表空間。最直接的方法就是查看硬盤上的文件，獨立表空間，每個表都對應了一個空間。 [/code] [root@localhost tg]# ll 總用量 64 -rw-rw----. 1 mysql mysql 65 12月 30 20:09 db.opt -rw-rw----. 1 mysql mysql 8658 12月 30 23:17 gb.frm -rw-rw----. 1 mysql mysql 8658 12月 30 23:19 qr.frm -rw-rw----. 1 mysql mysql 8658 12月 30 23:19 qy.frm -rw-rw----. 1 mysql mysql 8658 12月 30 23:19 tg.frm -rw-rw----. 1 mysql mysql 8658 12月[/code]
111231 20:54:44 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 512 MB InnoDB: Database physically writes the file full: wait... InnoDB: Progress in MB: 100 200 300 400 500 111231 20:54:50 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 512 MB InnoDB: Database physically writes the file full: wait... InnoDB: Progress in MB: 100 200 300 400 500 InnoDB: Cannot initialize created log files because InnoDB: data files are corrupt, or new data files were InnoDB: created when the database was started previous InnoDB: time but the database was not shut down InnoDB: normally after that. 111231 20:54:55 [ERROR] Plugin 'InnoDB' init function returned error. 111231 20:54:55 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 111231 20:54:55 [Note] Event Scheduler: Loaded 0 events
