diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2013-11-04 21:46:16 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2013-11-04 21:46:16 +0100 |
| commit | bf603250b02c936a271d628c93078cba3d081823 (patch) | |
| tree | ff4d6f6a767464aec2c7c773b2bb7b939c7b7150 | |
| parent | 1ef87c5578a3a5d2a6481b7b0dfbca9b0f3d0e48 (diff) | |
| download | mariadb-git-bf603250b02c936a271d628c93078cba3d081823.tar.gz | |
increase the initial ibdata1 size, as explained in MySQL-5.6 revid:kevin.lewis@oracle.com-20120802192452-kmikiz990xzje18b
"
A maximum size of 10 Mb works in 5.1 because the initial
required size of ibdata1 was less than 10M. But in 5.5, a
change was made to allocate all 128 rollback segments at
bootstrap. Since then, the initial size has been 10M + the
default autoextend size of 8M.
In 5.6, worklog 6216 changes the autoextend size from 8M to
64M. This changes the initial size of ibdata1 from 18M in
5.5 and earlier releases of 5.6 to 74M in the current
mysql-5.6 and mysql-trunk. So this change is especially
needed in 5.6.
"
12M is enough to avoid autoextending during bootstrap
| -rw-r--r-- | mysql-test/include/default_mysqld.cnf | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/include/default_mysqld.cnf b/mysql-test/include/default_mysqld.cnf index 96848c39f11..12add65b387 100644 --- a/mysql-test/include/default_mysqld.cnf +++ b/mysql-test/include/default_mysqld.cnf @@ -39,7 +39,7 @@ loose-aria-pagecache-buffer-size=8M loose-feedback-user-info= mysql-test -loose-innodb_data_file_path= ibdata1:10M:autoextend +loose-innodb_data_file_path= ibdata1:12M:autoextend loose-innodb_buffer_pool_size= 8M loose-innodb_write_io_threads= 2 loose-innodb_read_io_threads= 2 |