Minimize Performance Issues of MultiSite Large Number of Tables Created

Well, WordPress.com it’s the largest deployment of WordPress Multisite and they’re basically using the same setup (multiple tables for each site), so you could say that it’s a good strategy.

This kind of setup would let you to, for instance, keep your VIP users on a dedicated box, or add multiple DB servers as the network grows.

I’ve had experience with networks of about 500 sites and some basic tuning it’s enough to keep the sites working.

Also, check the HyperDB plugin, which it’s a replacement for WordPress’ default DB class that “supports replication, failover, load balancing, and partitioning”

Related Posts:

  1. How to share WordPress core library
  2. Memory needed to host 200 wordpress sites?
  3. wp-admin slow in multisite
  4. Is there a wordpress function to cleanly delete an entry in the signups table?
  5. SQL to check how many sites a user is a member of
  6. Max number of multisites
  7. How to Move Local Singlesite Database to Remote Multsite Database?
  8. Poor performance on multisite install
  9. Performance on WPMS
  10. WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file! [closed]
  11. Database Tables Lost Indexes? How to Recover?
  12. Multisite with 220+ sites painfully slow
  13. List recent 25 blogs across the network
  14. Performance disadvantge of second installation instead multisite feature?
  15. WordPress network vs Separate installs
  16. WP MultiSite: Can’t select database error after changing to new domain
  17. Can I replace the “Upgrade Network” with SQL query?
  18. What’s the best way to search for a UPC code in a Database?
  19. When should I use CROSS APPLY over INNER JOIN?
  20. Count(*) vs Count(1) – SQL Server
  21. Best way to test if a row exists in a MySQL table
  22. Efficient way to do batch INSERTS with JDBC
  23. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  24. What’s the best way to dedupe a table?
  25. How to use WordPress Multisite With Different Domain Names?
  26. How To Add Custom Form Fields To The User Profile Page?
  27. Where are available Roles Defined in the wp_ database?
  28. restore_current_blog() vs switch_to_blog()
  29. Can i merge 2 new WP_Query($variable) ‘s?
  30. How to disable a network enabled plugin for just one site?
  31. How to reliably flush rewrite rules on multisite?
  32. Site Redirecting to wp-signup.php
  33. Moving a WP Multisite to a subdirectory
  34. Cookies in multisite where network sites have their own domain name
  35. Convert a Multisite WordPress install into a Single site
  36. WordPress MultiSite Active Directory integration and site privacy
  37. WordPress Job Interview Preparation
  38. How to add Custom Blog Options to new blog setup form?
  39. How can I trust switch_to_blog()?
  40. Remove the blog slug from WordPress Multisite root node
  41. Why are my roles not visible in a Multi-site/Network?
  42. Site admin in a network install can’t edit users?
  43. How to use same email for multiple users
  44. How to run an activation function when plugin is network activated on multisite?
  45. Specific upload folder for PDFs in custom Post type in WP multisite
  46. What is the correct way to map multiple domains in a WordPress 4.1 multisite install?
  47. Where can I find documentation on what characters are allowed in user names and why?
  48. How to migrate subsite from dev multisite to production multisite
  49. How can I un-reserve a pending username registration?
  50. How do I remove/delete an old super admin user?
  51. DB connection error after copying a WordPress Multisite instance to a second location
  52. Redirect Main Site to Subsite in Multisite WordPress
  53. Is there a is_user_logged_in() for multisite?
  54. Switching MultiSite installation from HTTP to HTTPS
  55. Allow user to select a theme to install when they signup
  56. Setting up a wordpress network with third level domains
  57. Get upload URL by blog ID in multisite
  58. What’s the difference between get_site_option and get_blog_option?
  59. Need help sorting “My Sites” Alphabetically
  60. How to delete post revisions?
  61. Making my plugin multi-site compatible
  62. Create mobile site with same content just different theme
  63. Add additional Network constants to wp-config.php dynamically
  64. Multisite stuck at 1MB for max file size
  65. How to get blog name, when using WordPress Multisite
  66. What are options are there to implement a multi language site
  67. Switching primary site in WordPress Multisite
  68. Multisite Network Port Num Issues?
  69. Convert existing site to network
  70. Where is the robots.txt stored for a WordPress Multisite install?
  71. Settings API in Multisite – Missing update message
  72. Add WordPress MU Network Admin via Database
  73. How to get current site id? (WPMU)
  74. Multisite on Windows with wildcard subdomains
  75. Why is WordPress Multisite redirecting to wp-signup.php and how to fix it?
  76. Which asset URLs are acceptable in a “vanilla” MU install?
  77. $wpdb->base_prefix not get parent site prefix in multisite
  78. How to tell which database tables belongs to which multisite site
  79. what are pmxi tables? [closed]
  80. Using wp_insert_post() with Networking enabled
  81. Are nested subdomains possible with a subdomain multisite?
  82. Sharing Dynamic Sidebars across Multisite Blogs
  83. I want to develop locally with Multisite, then migrate each site to separate remote WP installs
  84. Password Reset for Users on a Multisite Subsite
  85. Anyone figured out how to use WordPress MultiSite with Domain Mapping & SSL?
  86. Can a multisite’s blogs be accessible from two different sub-domains?
  87. Querying posts from multiple sites in a network?
  88. Plugin for editing options on multisite?
  89. What do I need to do to convert my MultiSite from HTTP to HTTPS?
  90. is_front_page() malfunction?
  91. WP Multisite development with Mamp Pro and wildcard subdomains, not really working for me
  92. How do I change the Multisite URL?
  93. Create site programmatically for WPMU
  94. Can upload doc and pdf but not ppt – not permitted for security reasons
  95. How Can I Centralize Content Usage and Approval in a WordPress Multi-Site installation
  96. WordPress Multisite: Adding actions to only one site
  97. WordPress Multisite allow site admin to add user without email confirmation
  98. Domain mapping (without plugin) in 4.5.x multisite?
  99. wordpress multisite, how to keep user on subdomain throughout registration process?
  100. How will self-hosted WordPress work with Google Page Speed Service?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)