MySQL Shared table space extension

InnoDB table Space Extension:

In the case of configuring shared tablespace, there will be a file ibdata1 under the MySQL data directory, and as the data grows, it continues to increase,

Deleting a database does not reduce the capacity of ibdata1.

This is due to the configuration of the MY.CNF:

Innodb_data_file_path = Ibdata1:10m:autoextend

Configuration instructions, the InnoDB shared tablespace file is Ibdata1 and is initially set to 10M space and automatically expands when table space is low

This can lead to a problem, when more and more data increases, the ibdata will continue to swell, some to dozens of G, hundreds of G

So, how do you extend the data space when the disk partition that is currently storing the data is full?

You can configure the following:

example, the new data space partition is/new_data

Then you can add a new shared tablespace file, point to the new partition

Innodb_data_file_path = Ibdata1:60690m;/new_data/ibdata2:10g:autoextend

This allows you to create a new tablespace file into the/new_data directory

MySQL Shared table space extension