購入に関するお問い合わせ
日本: 03-5843-1141
USA - Toll Free: +1-866-221-0634
USA - From abroad: +1-408-701-9009
USA - Subscription Renewals: +1-866-830-4410
UK: +44 845 399 1124
Ireland: +353 1 6919191
Germany: +49 89 420 95 98 95
France: +33 1 70 61 48 95
Sweden: +46 730 207 871
Benelux: +358 50 5710 528
Italy: +39 06-99268193
Israel: +358 50 5710 528
Spain & Portugal: + 34 933905461
Other EMEA countries: +353 1 6919191
Asia Pacific: +81 3 5843 1141
関連ページ:
MySQL の新しいリリース、技術情報、イベントなどの情報が記載されています。
毎月発行される MySQL ニュースレターを購読しませんか？
How To Resize InnoDB Data/Log files
When you use the InnoDB (transactions-capable) storage engine, you can resize InnoDB data and log files by following the instructions below.
Resizing the data files.
The easy way is to first use mysqldump to dump the data from all InnoDB tables. Then shut down MySQL properly and recreate the InnoDB data and log files. As last step, just restore data from the dump files back into MySQL.
Resizing the log files.
First do a proper MySQL shut down. Backup the log files and move them away from the logs directory, then change log file size settings and finally restart MySQL. Please note that if you do not move log files away, InnoDB will refuse to start and will complain about the log file size.