2014-06-19, 02:22 AM
The row count in PHPMyAdmin for InnoDB isn't 100% accurate (You'll need to do a "SELECT COUNT (*) FROM
Also if your running InnoDB read up on your buffer_pool_size value, as performance will depend pretty heavily on it: http://www.mysqlperformanceblog.com/2007...pool_size/
And for having that many users online at once make sure to convert the sessions table to something that is not MyISAM (I recommend MEMORY as the contents are not that important and updating it won't need to touch the disk to update rows, InnoDB would also be alright). Additionally the mybb_users table and mybb_threads table would benefit from being InnoDB. Most other tables it won't make a huge difference being MyISAM or InnoDB.
mybb_posts" to get the real count).Also if your running InnoDB read up on your buffer_pool_size value, as performance will depend pretty heavily on it: http://www.mysqlperformanceblog.com/2007...pool_size/
And for having that many users online at once make sure to convert the sessions table to something that is not MyISAM (I recommend MEMORY as the contents are not that important and updating it won't need to touch the disk to update rows, InnoDB would also be alright). Additionally the mybb_users table and mybb_threads table would benefit from being InnoDB. Most other tables it won't make a huge difference being MyISAM or InnoDB.