Mega Code Archive
Run the OPTIMIZE TABLE statement on that table
<![CDATA[
mysql> CREATE TABLE Manufacturers
-> (
-> ManfID CHAR(8)NOT NULL PRIMARY KEY,
-> ManfName VARCHAR(30) NOT NULL
-> )
-> ENGINE=INNODB;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql>
mysql> INSERT INTO Manufacturers VALUES
-> ('abc123', 'ABC Manufacturing'),
-> ('def456', 'DEF Inc.'),
-> ('ghi789', 'GHI Corporation'),
-> ('jkl123', 'JKL Limited'),
-> ('mno456', 'MNO Company');
Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0
mysql>
mysql> CREATE TABLE Parts
-> (
-> PartID SMALLINT NOT NULL PRIMARY KEY,
-> PartName VARCHAR(30) NOT NULL,
-> ManfID CHAR(8) NOT NULL
-> )
-> ENGINE=INNODB;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql>
mysql> INSERT INTO Parts VALUES
-> (101, 'DVD burner', 'abc123'),
-> (102, 'CD drive', 'jkl123'),
-> (103, '80-GB hard disk', 'mno456'),
-> (104, 'Mini-tower', 'ghi789'),
-> (105, 'Power supply', 'def456'),
-> (106, 'LCD monitor', 'mno456'),
-> (107, 'Zip drive', 'ghi789'),
-> (108, 'Floppy drive', 'jkl123'),
-> (109, 'Network adapter', 'def456'),
-> (110, 'Network hub', 'jkl123'),
-> (111, 'Router', 'mno456'),
-> (112, 'Sound card', 'ghi789'),
-> (113, 'Standard keyboard', 'mno456'),
-> (114, 'PS/2 mouse', 'jkl123'),
-> (115, '56-K modem', 'ghi789'),
-> (116, 'Display adapter', 'mno456'),
-> (117, 'IDE controller', 'def456');
Query OK, 17 rows affected (0.00 sec)
Records: 17 Duplicates: 0 Warnings: 0
mysql>
mysql> OPTIMIZE TABLE Parts;
+------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+------------+----------+----------+-------------------------------------------------------------------+
| test.parts | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| test.parts | optimize | status | OK |
+------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (0.01 sec)
mysql>
mysql>
mysql> drop table Parts;
Query OK, 0 rows affected (0.00 sec)
mysql> drop table Manufacturers;
Query OK, 0 rows affected (0.00 sec)
mysql>
]]>