Cc: mysql@lists.mysql.com
Subject: Re: Server Load Question
Eric, I sent you a note about hardware this morning as well, but here's
a further thought -
Don't know if this is the case, but is this the exact same application
served to 100 different customers? And are Database-2 and Dat
Eric, I sent you a note about hardware this morning as well, but here's
a further thought -
Don't know if this is the case, but is this the exact same application
served to 100 different customers? And are Database-2 and Database-3
the same for every customer? Some kind of reference info per
72K is a lot of tables. You might get clobbered by the OS trying to handle open files. Something you may need to tweak if you are
running a Unix variant. As an aside, if I have a database with 500 tables, I would think of redesigning it.
I would suggest looking into virtual servers. Each server
On Monday 19 June 2006 10:01 am, Robinson, Eric wrote:
> Q: In terms of performance, is it better for each customer to have its
> own instance of MySQL, each serving 3 databases, or is it better to have
> one instance of MySQL serving 300 databases?
>
> --Eric
Can you clarify a bit on instance? A
