List:General Discussion« Previous MessageNext Message »
From:Gustavo A. Baratto Date:September 18 2003 1:51pm
Subject:Re: Large number of Databases
View as plain text  
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"
  -------------------------------------------------------------------------

Thread
mysqldump with innoDBIrwin Boutboul17 Sep
  • Re: mysqldump with innoDBPaul DuBois17 Sep
    • Re: mysqldump with innoDBDaniel Kasak18 Sep
      • Re: mysqldump with innoDBPaul DuBois18 Sep
      • Re: mysqldump with innoDBFranky18 Sep
  • Re: mysqldump with innoDBHarald Fuchs18 Sep
  • Large number of DatabasesRichard18 Sep
  • Re: Large number of DatabasesHarald Fuchs18 Sep
    • Re: Large number of DatabasesGustavo A. Baratto18 Sep
      • Re: Large number of DatabasesJeremy Zawodny18 Sep
        • Re: Large number of DatabasesGustavo A. Baratto18 Sep
          • Re: Large number of DatabasesDan Nelson18 Sep
          • Re: Large number of DatabasesJeremy Zawodny18 Sep