I'm going to be working with a MySQL DB that is pretty large in size. I've never used Innodb before as the storage engine and was looking for some tips on performance tuning. I understand the concepts of Innodb and have read a lot about it but have no practical experience with it.
Ultimately I'm looking to maximize read/write performance, allocate as much memory to Innodb/MySQL without causing the OS to stall, and looking for best practices on file sizes/etc.
Thanks in advance.