We're trying to avoid the following scenarios:
Using one database for every site, and having 100,000 subdirectories of the MySQL data directory;
-or-
Using one (or more) tables in a single database for each site, and having x00,000 table files.
Either of the above would make maintenance (backups, etc.) a chore.
Ruben Safir Secretary NYLXS wrote:
How does that help? The database itself should be allowed to organize everything.
Ruben
On Thu, Oct 07, 2004 at 04:57:39PM -0700, Justin Smith wrote:
Is it possible to create a database in a lower-level subdirectory of MySQL's data directory? We have almost 100,000 sites, and we would like to have a separate database for each site. However, it's very impractical from a filesystem maintenance standpoint to have 100,000 subdirectories of MySQL's data directory. What we would like to do is break up the directories into something like this:
for site #12345:
[mysql datadir]/01/23/45/[databasename]
This would greatly improve the manageability of the table space.
Is this possible?
--
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]
