XF 2.2 Does XenForo need to further tune and optimize the database architecture?

[NealC]

Anyone seeing messages like this from phpMyAdmin's Advisor? It could be needed improvements. Curious if XF needs to take a look at some of the DB architecture to tune these items? Some are for me, most are for XF.

 

[bzcomputers]

Two of those can be easily fixed just by changing the few remaining MyISAM tables to InnoDB.

XF 2.2 - Is there any reason why MyISAM tables still exist within XenForo?

There are still currently 4 tables that by default are set to MyISAM storage engine: xf_search_index xf_session xf_session_admin xf_session_install Is there any reason a modern version of MySQL or MariaDB couldn't safely use the InnoDB storage engine for these tables without a noticeable...

xenforo.com

--------------------------------------------------------------------------------------------------------------------------------


This is kind of necessary and not unusual for a forum to have lots of data results sorted. For this one you should look at your sort_buffer_size to make sure most of this is making it into memory.

---------------------------------------------------------------------------------------------------------------------------------


There may be room for improvement here but in general from what I've seen most XenForo tables have the needed indexes for joins. You may be looking at your add-ons specifically here to find the issue.

---------------------------------------------------------------------------------------------------------------------------------