"partitioning" through separate DB's?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
LBmtb
Forum Newbie
Posts: 23
Joined: Wed May 14, 2008 11:14 am

"partitioning" through separate DB's?

Post by LBmtb »

Is one database protected from the load of another database on the same machine? A colleague claims that by having two databases, he's seen the load of one DB go very high (either just lots of users or bad SQL) while the second DB on the same machine performs normally.

Does that make any sense and is it even possible? It only seems logical that since they're on the same machine, both databases would get bogged down when load in one is very high. This is MySQL, btw.

Thanks for any insight! :drunk:
Post Reply