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 has it's own system image, so if load is becoming and issue, you can
easily move that client to another box. You could also have a "default" image, that you can replicate to easily setup new clients.
If you have 3 instances of mysql running on 1 box, you would need to monitor the system OS for issues as well as mysql. With a
single instance of mysql, you just need to monitor mysql (i.e. open_tables, opened_tables) and tweak paramters just for one
instance. Either way, it would be possible to get Mysql constantly open and closing tables because of certain limits, causing
performance issues.
----- Original Message -----
From: "Robinson, Eric" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Monday, June 19, 2006 1:01 PM
Subject: Server Load Question
I asked this question previously but didn't get much response so I'll
try again.
Our server will be home to 100 separate clients. Each client will have
their own set of databases that will be accessed by 10-60 users at
each client's site.
Each client has 3 databases.
Database-1: 500 tables. 13 tables sized 10-100MB. Remaining tables all
less that 10MB. (This is the only database that is updated. The others
are just for reference.) Main table grows at a rate of a few hundred
MB/year.
Database-2: 50 tables. 3 tables sized 10-100MB. All other tables less
than 10MB. No data growth.
Database-3: 179 tables. 10 tables sized 1-15MB. All other tables less
than 1MB. No data growth.
So...
Total databses: 300
Total tables: 72,900
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
Disclaimer - June 19, 2006
This email and any files transmitted with it are confidential and intended solely for [EMAIL PROTECTED] If you are not the
named addressee you should not disseminate, distribute, copy or alter this email. Any views or opinions presented in this email are
solely those of the author and might not represent those of Physician Select Management (PSM) or Physician's Managed Care (PMC).
Warning: Although the message sender has taken reasonable precautions to ensure no viruses are present in this email, neither PSM
nor PMC can accept responsibility for any loss or damage arising from the use of this email or attachments.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
