Title: Large Multisite Database keep Crashing
Last modified: August 2, 2018

---

# Large Multisite Database keep Crashing

 *  [dbmasters](https://wordpress.org/support/users/dbmasters/)
 * (@dbmasters)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/large-multisite-database-keep-crashing/)
 * So I recently got a new job managing wordpress sites among other things…I have
   all instances up and running except one, this one is a large, multisite install…
   40+ sites, almost 3000 tables.
 * Now, the site works fine (or so it seems) after migrating the parent site and
   a couple sub sites to new staging domains and all that…I can surf the site(s),
   get around, adjust admin settings, etc.
 * As soon as I open a database management tool (So far MySQL Workbench and Navicat)
   the database halts leaving behind logs about InnoDB data dictionary problems 
   and the like…I can’t restart it unless I restart my computer (Mac OSX)…sometimes
   if I close the editor it will restart.
 * I have tuned my.cnf with MyISAM and InnoDB buffers (4G each) and various other
   tunings…
 * Any advice? I have never run this big of a multisite, personally, I assume it’s
   simply database size…even though it’s only a couple hundred megs in a dump, it’s
   a big table count.
 * This has been driving me nuts for a couple days now. I can get into my other 
   databases for other localhost sites (I have 5 or 6) with no problem, as soon 
   as I open a connection to THAT database it crashes, even if it’s the only one
   I am connected too…if I don’t make the editor connection I can surf the site 
   all day it seems like…or I can connect to dev and stage version of all the others
   at the same time with no problem.
    -  This topic was modified 7 years, 10 months ago by [dbmasters](https://wordpress.org/support/users/dbmasters/).

Viewing 1 replies (of 1 total)

 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [7 years, 10 months ago](https://wordpress.org/support/topic/large-multisite-database-keep-crashing/#post-10552682)
 * There should be error logs from MySQL/MariaDB that you can use to Google a solution.
   This is probably best addressed in the various MySQL or MariaDB support forums.

Viewing 1 replies (of 1 total)

The topic ‘Large Multisite Database keep Crashing’ is closed to new replies.

 * In: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/)
 * 1 reply
 * 2 participants
 * Last reply from: [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * Last activity: [7 years, 10 months ago](https://wordpress.org/support/topic/large-multisite-database-keep-crashing/#post-10552682)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics