At 1:58 +0000 9/25/02, Jessica Thomale wrote: >On Wednesday, Sep 25, 2002, at 01:00 Etc/GMT, Paul DuBois wrote: > >>At 0:39 +0000 9/25/02, Jessica Thomale wrote: >>>Hi, >>> >>>Is it possible to use InnoDB tables that have transaction support >>>without using InnoDB for server logs? >> >>The InnoDB handler maintains its own logs, and it uses these for >>transaction support and crash recovery. You can't turn them off. >> >>However, these are different than the query log, the update log, the >>binary update log, the slow-query log, the error log, and the isam >>log. Are you referring to any of those when you say "server logs"? > >Yes, those were the logs I was referring to. The logs that are produced when >you run mysqld instead of an embedded server. > >When upgrading MySQL from 3.23.xx to 4.0.3, I forgot to uncomment >all the innodb >parameters except the data directory. It ran my queries as fast as >the embedded server, but >when these logs were reenabled, it was slower.
Uncommenting the parameters won't enable/disable the logs. InnoDB *always* logs, it just uses default parameter values when you comment out the parameter values. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
