Bug #76990 | MySQL 5.7 tablespace info doesn't seem to clearly show how to view tablespaces | ||
---|---|---|---|
Submitted: | 9 May 2015 10:25 | Modified: | 24 Jun 2015 7:19 |
Reporter: | Simon Mudd (OCA) | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
Version: | 5.7.7 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | documentation, I_S.tablespaces, show create tablespace, Tablespace |
[9 May 2015 10:25]
Simon Mudd
[9 May 2015 10:39]
Simon Mudd
I notice also that the way to change back is to do: root@myserver [db]> alter table mytable tablespace = innodb_file_per_table; Query OK, 0 rows affected (51.73 sec) Records: 0 Duplicates: 0 Warnings: 0 So also quite a long time, but shorter than the previous command. However, it seems doing this changes the standard or previous way a table definition is shown as I now see: root@myserver [db]> show create table mytable\G *************************** 1. row *************************** Table: Currency Create Table: CREATE TABLE `mytable` ( ... ) /*!50100 TABLESPACE innodb_file_per_table */ ENGINE=InnoDB AUTO_INCREMENT=255 DEFAULT CHARSET=latin1 1 row in set (0.00 sec) The db/mytable.ibd file is there so the change was completed, yet the show CREATE TABLE now shows a different output from the previous definition (currently on the master). This seems somewhat confusing and perhaps should be documented more clearly.
[9 May 2015 10:40]
Simon Mudd
Adjust as version I saw this on was 5.7.7
[10 May 2015 12:55]
MySQL Verification Team
Also, Bug #76182
[10 May 2015 16:52]
Daniël van Eeden
This could be a (partly) duplicate of Bug #74358
[18 May 2015 14:15]
Andrii Nikitin
Performance problem should be duplicate of bug #74472
[24 Jun 2015 7:19]
Andrii Nikitin
Closing as duplicate of problems covered in bugs 74358 , 74472 and 77093