Tommi Lätti wrote:
You would want to up the log size also at the same time, but that you
can't do if your innodb is created already.
You need to dump your db, drop the db, restart mysql with new params and
then restore the db to increase the log size.
Are you sure?
From the manual:
--snip--
If you want to change the number or the size of your InnoDB log files,
use the following instructions. The procedure to use depends on the
value of innodb_fast_shutdown:
* If innodb_fast_shutdown is not set to 2: You must stop the MySQL
server and make sure that it shuts down without errors (to ensure that
there is no information for outstanding transactions in the logs). Then
copy the old log files into a safe place just in case something went
wrong in the shutdown and you need them to recover the tablespace.
Delete the old log files from the log file directory, edit my.cnf to
change the log file configuration, and start the MySQL server again.
mysqld sees that no log files exist at startup and tells you that it is
creating new ones.
* If innodb_fast_shutdown is set to 2: You should shut down the
server, set innodb_fast_shutdown to 1, and restart the server. The
server should be allowed to recover. Then you should shut down the
server again and follow the procedure described in the preceding item to
change InnoDB log file size. Set innodb_fast_shutdown back to 2 and
restart the server.
--/snip--
Copy pasted from:
http://www.mysql.org/doc/refman/5.0/en/adding-and-removing.html
Alex
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
