First of all, I need to say I'm not a fan of WordPress at all and I have never fully understood it.
But I have inherited a multisite wordpress where anyone can register his own site. All in all, we have thousands of sites. Every site has 10 database tables. Every single mysql table has 3 files (MYD, MYI and sdi). It means meaybe 200 000 files in single directory, which is absolutely insane. Needless to say that working with this database is hell on earth. Many database UIs have problems to work with this amount of tables.
- Is there any possibility how to get rid of this database havoc? Some plugin or anything to put all the wp_*_options into something like wp_universal_options?
- Is WordPress Multisite even intended for this use case? How are you using it? For like 10 sites on one server?