I have checked and our tables are INNODB.
I have some new DB questions.
What consiquences do I face if I use any of the following
'OPTIMIZE TABLE table_name;'
'FLUSH HOSTS'
'FLUSH LOGS'
'FLUSH PRIVILEGES'
'FLUSH QUERY CACHE'
'FLUSH TABLES'
'FLUSH STATUS'
'FLUSH USER_RESOURCES'
on all my moodle tables.
I am trying to tune/cleanup our db but can't find much info on these commands other than how to run them.
Many Thanks