Jon,
----- Original Message -----
From: ""Jon Frisby"" <jfrisby@stripped>
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 |
------------------------------------------