After doing some reading on MySQL performance tuning, it looks like innodb_buffer_pool_size, if memory permits, should be set to 110% of the database size. If you have a MySQL user setup you can use a SQL query to get the size of the DB. Otherwise, just look at the size of the ibdata file. In windows, that's in -...\Cache\MySQL\-. So, for instance, my ibdata file shows as 247,808K (242M), so I set innodb_buffer_pool to 267M.
-- bobkoure ------------------------------------------------------------------------ bobkoure's Profile: http://forums.slimdevices.com/member.php?userid=14646 View this thread: http://forums.slimdevices.com/showthread.php?t=70371 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
