in a web application I am working on each user has an own table set, so total amount of tables is hundreds of thousands. All tables are InnoDB.
And, as you have probably already guessed, we have some performance problems.
Reviewing all possible ways of improving performance, would changing table types to MyISAM, while keeping an own table set per user, increase performance?
And taking in account the fact that MyISAM does table-level locks, as opposed to InnoDB’s row-level locks, is that a huge risk to merge all tables into a single MyISAM table set?