Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

3 Answers 3

up vote 3 down vote accepted

Running multiple instances on the same server would not be recommended as a solution to a connection limit.

If you mean multiple databases on the same instance on the same server that's primarily an architectural consideration and not necessarily a direct solution to a resource issue.

It sounds like your server has to be tuned. I've provided connection tuning recommendations before, this should help:

http://serverfault.com/questions/119468/how-do-i-set-my-cnf-in-mysql-so-that-there-are-no-limits-to-connections/119550#119550

share|improve this answer
    
Thanks. Yes, I mean the second, two DBs in the same instance. –  Petruza May 21 '10 at 14:54

You are correct, that won't help a connection problem (assuming you mean two dbs and one mysql binary running, not two different mysql installations on the same hardware, which might help but is a totally backwards way of doing it...)

share|improve this answer

You should investigate why you're running out of connections, first and foremost. Do clients grab a connection and then hold it for a long time? Does each child of a web server have its own connection, or does the server manage a connection pool?

I recommend turning on the general query log to investigate - it records connection details. Note that you probably don't want to have the general query log on in general production use!

Having multiple databases on the same server doesn't change the connections to the server.

Increase connections only because you genuinely have some large number of clients who are known to manage connections properly. However, it most cases, "too many connections" indicates a client-side problem.

share|improve this answer
    
Thanks, I'm not too much in control of the servers, actually we develop a site in php and only have access to the DB via phpMyAdmin, so there's not much we can do about server tuning and configuration. I was requested to split the DB and I was just justifying my position about that procedure. –  Petruza May 21 '10 at 19:08

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.