Jon,
----- Original Message ----- From: ""Jon Frisby"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, March 02, 2005 3:32 AM
Subject: RE: Switching to InnoDB turns out dissapointing
> set-variable =3Dinnodb_log_buffer_size=3D32M =20 The log buffer is too big.
Is there a performance penalty associated with making the log buffer size too large, or is just not beneficial?
it is not beneficial beyond 8 MB. In this case, the big log buffer is eating valuable RAM from the buffer pool where the memory would be more useful.
-JF
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php
------------------------------------------ Save the Pacific Northwest Tree Octopus! | http://zapatopi.net/treeoctopus.html | ------------------------------------------
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]