1. I want to know if converting for my case to InnoDB is a must OR highly recomended???
if it is a must then this mean i dont have time and i have to convert right now or the database will be corrupted because xenforo is programmed for InnoDB .
if it is highly recomended then it mean xenforo can work with MyISAM with no serious issues and no fear of database corruption and i have plenty of time to convert to InnoDB any time i want
I really want the answer to be highly recomended so I can take all my time to think and plan to make a very carefull checklist for the conversion from MyISAM to InooDB
2. I have 2 tables that really concerns me because of thier size is very large which might lead to conversion failuer :
xf_post ( 3,726,212 rows and 2.1 GIB size )
xf_search_index ( 3,833,158 rows and 4.9 GIB size )
Edit: xf_search_index should be MyISAM so it wont need to be conveted
The total dabase size is 8 GIB and 20 millions rows
Do you think phpMyAdmin can handle the conversion? what other things i should consider?
Thanks in advance for any reply