no problem for me... 1000+ DBs on RH linux (ext3 fs), then moved it to
freebsd 5.1 (almost 1500). Linux is probably faster because of the
kernel based thread, but I like BSD.
You definetely have to tune your my.cnf... use thread and query cache,
increase the key buffer, optimize tables very often (I do it every
day... takes 7 minutes in a dual xeon 2Ghz), increase sort and join size.
good luck
Harald Fuchs wrote:
> In article <013b01c37dcf$3c2b0360$8864a8c0@stripped>,
> "Richard" <richardc@stripped> writes:
>
>
>>Does anybody know of any issues when have a large (+1000) databases in
>>MySQL?
>>It will be running on RedHat 9. Would there be any problems running backups
>>with this many DBs on
>>one box?
>
>
> Some filesystems become slow if you have +1000 subdirectories.
> ReiserFS doesn't have that problem.
>
>
--
--------------------------------------------------------------------------
Gustavo Baratto - Systems Engineer
GBaratto@stripped * (604) 638-2525 ext. 408
Technical support web-site: http://support.superb.net
Superb Internet Corp. "Ahead of the Rest"
-------------------------------------------------------------------------
