diff options
| author |   Jenkins <jenkins@review.openstack.org> | 2017-02-02 04:17:53 +0000 |
|---|---|---|
| committer |   Gerrit Code Review <review@openstack.org> | 2017-02-02 04:17:53 +0000 |
| commit | 4ce73329aee671a6575103ffbb0522796ca84454 (patch) | |
| tree | cbd63e6e53236e4ad7c87bcea4d93805d3b62b34 /releasenotes | |
| parent | daaa7ce489bf6fe14fb22e499f652d6098399165 (diff) | |
| parent | 621ea892a299d2029348db2b56fea1338bd41c48 (diff) | |
Merge "set innodb_file_per_table to ON for MySQL / Galera"
Diffstat (limited to 'releasenotes')
| -rw-r--r-- | releasenotes/notes/innodb_file_per_table-f925b3bbf29d44ea.yaml | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/releasenotes/notes/innodb_file_per_table-f925b3bbf29d44ea.yaml b/releasenotes/notes/innodb_file_per_table-f925b3bbf29d44ea.yaml new file mode 100644 index 0000000..e0b7c3c --- /dev/null +++ b/releasenotes/notes/innodb_file_per_table-f925b3bbf29d44ea.yaml @@ -0,0 +1,20 @@ +--- +features: + - Enable innodb_file_per_table for MySQL/MariaDB databases +upgrade: + - | + Newly created MySQL database tables will be stored in their own datafiles, + instead of in a single monolithic ibdata file. + - | + Existing MySQL database tables that are persisted within the monolithic + ibdata file will remain so unless the database is migrated as well. + - | + Migration of all current database tables out of the monolithic ibdata + file is possible by dumping and restoring the whole database to a new data + directory, however when using Galera the entire cluster must be shut + down and upgraded at once. + - | + Migration of individual tables to datafiles is possible using the + MySQL command "ALTER TABLE <databasename>.<tablename> ENGINE=InnoDB;", + however this will not shrink the ibdata file and also is not safe to run + on a running Galera cluster for large tables. |