Splitting a MySQL DB in two may ease server from "Too many connetions"? I don't think so
- by Petruza
I was requested to split a MySQL in two, it's kind of a horizontal partition, in which some rows correspond to one site, and some other correspond to another site.
But they want to split it in two DBs in the same MySQL server.
I'm no DB expert but I guess keeping them in the same MySQL server with the same amount of memory and processor and the same platform won't improve things.
What we're trying to avoid is the "Too many connections" problem.