MySql Database In WordPress Multisite

I think you might be new with WP Multisite. That is OK. I’m using Multisite for last few years and I really don’t know any way to put the different site tables in different database.

The way WP Multisite works is a single WP installation for multiple WP site. Now suppose you have a database called my_multisite; within this database WordPress will create all the tables. Now if it is a Multisite installation and at the time of installation if you select the table prefix (say ex_) then your root site tables will be like ex_options ex_blah_blah. Now when you will create another site within that Multisite installation, the prefix value will be incremented by 1 and the new sites will have the same tables with the names like ex_2_options ex_2_blah_blah. For next site you create it will be ex_3_options ex_3_blah_blah, .... There is no way change this pattern.

Trust me this is all right for your site. If you want to have your different site tables to different database, you have to go with multiple WordPress single installations. But Multisite database does not degrade any performance for most of the good hosts. Just make sure you host your site with a legit and good hosting company.

Related Posts:

  1. find a random blogid across my multisite network that has at least one post published
  2. Split a database will improve performance?
  3. Within the database, where is the flag which says that a user has Super Admin rights?
  4. Bulk activate a theme on multisite
  5. Database Tables Lost Indexes? How to Recover?
  6. Will changing the folder name two directories above a fresh wordpress installation break the site?
  7. new multisite, old db
  8. WP MultiSite: Can’t select database error after changing to new domain
  9. Get multisite count without php?
  10. WordPress and SQL – Update and Insert from another table if column value doesn’t exist
  11. Plugin data shared in Multisite
  12. Merging versions of wp_posts based on post_title
  13. How can I trust switch_to_blog()?
  14. DB connection error after copying a WordPress Multisite instance to a second location
  15. Add WordPress MU Network Admin via Database
  16. How to tell which database tables belongs to which multisite site
  17. what are pmxi tables? [closed]
  18. Shared table across network
  19. WP-CLI methods for get_current_blog_id, get_blog_details or $wpdb->prefix
  20. Built to scale, or worry later?
  21. Uploading/Deploying a Multi Site Install
  22. Multisite database upgrade SSL error
  23. Configure WordPress to read from database only, never write
  24. Multiple Domains and Subdomains Using Multisite Installation
  25. SQL Query to Get list of all users along with their blogs
  26. Is it possible to fix/repair all Index, Primary Key, Unique (and all other) structure of a WordPress MS Database
  27. Synchronizing Two WordPress Sites Content
  28. How to clone and locally run a network for testing
  29. Two WordPress sites sharing the same database
  30. Using $wpdb Class to Pull Recent Comments Across a Network
  31. Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
  32. How to Move Local Singlesite Database to Remote Multsite Database?
  33. Multisite Subdomain Using More Resources Than Others?
  34. How to change the database prefix in multisite (WPMU) install
  35. Importing Multiple DB to one MU database
  36. Make WordPress Search for Both Main Domain and Subdomain
  37. Does WordPress MultiSite use separate MySql databases?
  38. Bootstrapping WordPress MultiSite Outsite of WordPress – No $wpdb
  39. Multisite setup creating custom table
  40. Is there a way to run upgrade.php for one blog?
  41. Performance on WPMS
  42. Migrating Multisite – Database error, missing wp_blogs table
  43. WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file! [closed]
  44. Removing a wordpress multisite installation and preserving the database before migrate to nginx
  45. Installed domain-based Multisite but can’t access wp-admin (redirect loop)
  46. Pushing stored procedure to a multisite database in WordPress
  47. Multiple multisite instances connecting to the same database
  48. Query to import data from one MultiSite table to another (pages/sub-pages)
  49. WordPress Multisite – can I somehow merge the tables?
  50. Create a database for each site created in multisite?
  51. Use WordPress MultiSite (WPMS) with a remote database for each created site
  52. WordPress Multisite blogs not working after domain swap
  53. Least expensive way to get table prefix in multisite installation
  54. 2 website 1 database… Local to online
  55. Obtaining user table for one site on multisite set up
  56. Removing Mutlisite lines stop DB connection
  57. Renaming admin user on multisite install by MySQL
  58. how to migrate wpmu from one host to the other?
  59. Share DB tables between two blogs on the same WP Multisite installation
  60. How can I create blog specific database table in multisite?
  61. How many databases do I need?
  62. How do I display offsite database info on my wordpress site?
  63. Locking one blog of many in a multi user/blog WordPress installation
  64. WordPress Multisites or Multiple WP Single sites?
  65. $wpdb->update prefixes database name to table when executing query
  66. Delete all user’s meta without knowing all the ‘key’
  67. Combining user database tables while keeping all other data in seperate for multiple sites?
  68. How to make multi site with single Database?
  69. Update WP install to WP network & it broke the DB connection
  70. Sharing users across multiple sites, each on their own database
  71. importing data into wordpress db
  72. How to share User Database between Two Multisite Installations + More
  73. add_blog_option blog ID
  74. How long is “as long as possible” in wp_cache_set()?
  75. WPMU on MySQL limited to 1GB of space?
  76. How does WP decide how to evaluate database integrity
  77. How to create a blogs category page with Blog-Types Plugin
  78. How to use the same users table on multiple wordpress sites
  79. A database for each category?
  80. Can I use the main Multisite as a backend only?
  81. Problems with WordPress multisite directories/url structures and admin access after migration
  82. allow multisite in the installation process
  83. Error establishing a database connection after moving local wordpressmultisite from one directory to another
  84. Search returns “Nothing Found” on a sub directory
  85. How To Upload Existing WordPress Site To WordPress Multisite Using SSH
  86. wordpress multisite – handle Database
  87. Importing Posts into New Website with Same User ID’s
  88. WordPress automatic Login on other page?
  89. How to reconnect database to existing wordpress multisite setup after changing site name
  90. Multi-site database upgrade claims success, but db_version not updated
  91. WordPress Multisite with thousands of blog
  92. Multiple domain with one database
  93. Problem in adding new site on WP multisite
  94. WP DB Location for “Next Post to Create” Index Value
  95. Multisite Tables the same as Single Install?
  96. Error establishing a database connection – Multi-site with subsite don’t exisit [duplicate]
  97. WordPress Multisite platform for different city for single db
  98. 4th Network Site Database Errors?
  99. Is there a full explanation on how to share a database with two WordPress sites on same server?
  100. Too much slow queries with my multisite