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. How to disable a network enabled plugin for just one site?
  19. What are options are there to implement a multi language site
  20. Where is the robots.txt stored for a WordPress Multisite install?
  21. Settings API in Multisite – Missing update message
  22. WordPress Multisite: How to make all media library items available for every site?
  23. How to setup LDAP authentication with WP multisite
  24. Set default avatar network-wide
  25. WordPress Multisite. Can domain be used instead of subdomain?
  26. Multisite Subdomains result in 403 Forbidden
  27. Set subdomains live in a next step
  28. Multisite: Develop locally using production images with .htaccess
  29. latest 5 posts using switch_to_blog loop
  30. How to prevent hotlinking with htaccess in WordPress and why most common use about it doesn’t work?
  31. restore_current_blog() vs. multiple switch_to_blog() followed by removing $GLOBALS[‘_wp_switched_stack’]
  32. Multisite Installation: how do I setup global search?
  33. Two WordPress sites sharing the same database
  34. Multisite use language code as subdirectory
  35. Help with updating a wp_get_sites to get_sites and sorting by alphebetical order
  36. Sub-subdomain getting redirected to main domain
  37. Multisite – create new site with precreated pages, menu etc
  38. WordPress (+WPMU) Import/Export ALL settings?
  39. WordPress multisite change language
  40. How to work on a live WPMS blog when domain is unresolved? [closed]
  41. How do you load WordPress from an external script when using MultiSite? [duplicate]
  42. Hook up MU site creation
  43. Migrate a WP website from a single-server single-domain to a multi-server multi-domain installation
  44. Fresh Multisite Install – Can’t Log In
  45. current_user_can() always returns true if user is super admin
  46. Displaying a message upon user registration
  47. Upload file type not permitted even if explicitly registered as upload_filetypes in the db (multisite)
  48. ReWriteRules and WordPress Multi-Sites with Sub Directories
  49. How can i redirect my Blog to a Subdomain?
  50. WordPress Multisite Redirection Issue
  51. migrating content from a single wordpress installation to a multisite
  52. Multisite user roles – capabilities not working
  53. WordPress: how to change URL for individual MultiSites?
  54. Move Multiple WP Installs on a single domain to WP Multisite
  55. Widget not displaying in WMPU sites
  56. Enable “My blogs” in a custom installation
  57. HTTPS Warning and Certificate Error when Updating Network
  58. Where to set individual blog quotas?
  59. Create sub-domain for multisite and multi languages?
  60. Changing the language for each individual site in wordpress multisite
  61. how to have __() translating in languages different from admin?
  62. How to temporarily redirect front page of a network to one of the sites/blogs?
  63. Set a default page template to load for multi-site
  64. Move existing WordPress install to Multisite
  65. Delete user from multisite when removed from subsite
  66. how to control display switch_to_blog( $subsite->blog_id ); $tags = wp_tag_cloud
  67. WordPress multisite with domains and subdomains
  68. Which Multi-language option for WordPress is best from an SEO and Woocommerce perspective?
  69. Multisite 404 page
  70. Sort posts according to date
  71. How much resources are good enough for 3.9.2
  72. Forward and mask a WordPress website
  73. Best Practise: Linking to WPMU sites from other sites
  74. Subdomain is not working
  75. Common user login for two different wordpress installation and bbpress
  76. How to automatically create an index of child sites at the root url for a multisite installation?
  77. WordPress Multisite and how to apply sef urls only to specific sites
  78. Custom css – WordPress Multisite
  79. Migration: previous URL redirection after migrating
  80. how to convert a wp multisite into a single site with content from subsites
  81. Getting stylesheet error after setting subdomain to false in multisite
  82. String translation within WordPress multisite with i18n not working on all sites
  83. URLs for (MultiSite) link images are always relative
  84. Add radio button on theme at the select of the theme the same theme should be activated after generation of new site in multi site
  85. Moving wordpress multisite to new domain
  86. How to allow mixed case characters in multisite site name?
  87. Which action hook to update custom field at network/site-info.php in multisite on update site info
  88. multisite shared settings
  89. Multi Site Translate Strings
  90. Should I use MultiSite for a subdomain based wp site?
  91. Can’t import posts in multisite
  92. User registration problem on multisites web
  93. Admin user getting redirected to /wp-admin/user
  94. Getting 404 after Update in Multisite
  95. personal_options hook on WordPress multisite
  96. Multi site and media uploader
  97. There is no featured image in my post in wordpress multisite theme [closed]
  98. Subdomain add comment redirect to 404 not found page iis server
  99. get_category_link() or get_tag_link() return wrong category/tag base in wordpress multisite
  100. Multisite subdomain microsite on secondary domain
techhipbettruvabetnorabahisbahis forumutaraftarium24edueduedueduseduseduseduseduseduedu