I'm not sure if this will help, but have you considered ext3, or any of
those experimental file systems (although I believe they are pretty darn
stable, I know several places that use ext3). I haven't read much of the
specs on ext3, but by chance it might support huge directories like that.
-------------------------
On Mon, 03 Sep 2001 15:21:03 GMT, Carl wrote:
-------------------------
>
> Damned, I forgot to change the To: address again.
> Sorry 'bout that.
>
> BTW, does anyone else get lots of error messages from
> [EMAIL PROTECTED]?
>
>
> Oliver Krapp - etracker.de e.K. writes:
>
> > I'm dealing with a large (think so) production mysql server. There are
up to
> > ~2500 small databases (each ~1-4 MB Data in 10 Tables). The system is
> > growing and the CPU gets more and more loaded.
>
> Eek, 2500 databases? As in 2500 directories in one directory?
> Does the file system handle that well? I have little experience
> with ext2, but I've seen other file systems turning into molasses
> before 1000 files per dir. OTOH, with the traditionally messy
> unix layout the FS had better be used to things like that.
>
> > At the moment the system is running on one machine, however the
concept is
> > scalable. I have no feeling/experience where are the limits with
mysql. When
> > I have to setup the next db-server? Are ~300 queries per sec. a joke
for
> > mysql? It's difficult to valuate if I'm going towards the hard limit
or if I
> > have a problem with my db design.
>
> The figures I've seen suggest that 300 q/s isn't all that much for a
> system like yours, but I guess it depends on the queries. I can imagine
> there being a horrible number of openings and closings of files if you
> have 25000 tables, and that can't be good for performance.
>
> > Are there people who can share there knowledge about large mysql
servers?
>
> Sorry, very little experience as of now. Once I get the system
> I'm working on running I might get some experience of hitting
> the 2GB barrier. :-o
>
> //C
>
> --
> Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
> [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
> Amiga user since '89, and damned proud of it too.
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
