From: Dan Nelson
Date: December 15 2003 11:23pm
Subject: Re: Performance Question
List-Archive: http://lists.mysql.com/mysql/155787
Message-Id: <20031215232358.GI17799@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Dec 15), Jeremy Zawodny said:
> On Mon, Dec 15, 2003 at 02:31:16PM -0800, Rob Brackett wrote:
> > How hard would it be to modify the MySQL code, and what sort of
> > performance hits would I take, if I was to try to run a hundred
> > thousand MySQL DBs on the same server?  Obviously, some tweaks
> > would be necessary to be able to break up the directory structure
> > of /var/lib/mysql, and I may be souding uninformed, but would there
> > be much to do beyond that?
> 
> Or you could use a filesystem that's smarter about large directories.

InnoDB may help here also.

-- 
	Dan Nelson
	dnelson@stripped