The buffer pool should basically be set to as high as your system can
afford, more or less. The example my.cnf files all have "Set buffer pool
size to 50-80% of your computer's memory" as a comment. That's actually
the most crucial InnoDB tuning adjustment you can make.
Bernard Johnson wrote:
Bernard Johnson wrote:
InnoDB: Your buffer pool size is 8 MB. Maybe you should make
InnoDB: the buffer pool bigger?
And yes, I did notice this part, but before I upped the buffer pool, I
wanted to make sure I wasn't hiding some bug with transactions.
If the default buffer pool size is not adequate for a busy server,
then it should probably be noted in the wiki somewhere.
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
