Re: Large number of Databases

2003-09-18 Thread Jeremy Zawodny
On Thu, Sep 18, 2003 at 12:49:09PM -0300, Gustavo A. Baratto wrote: > I already use linuxthreads for freebsd... Ah, okay. Most don't, which is why I mentioned it. > Do you think mysql would run well with the new threads for freebsd 5.XX? > Did anybody try it? In theory, yes. In practice, not

Re: Large number of Databases

2003-09-18 Thread Dan Nelson
In the last episode (Sep 18), Gustavo A. Baratto said: > I already use linuxthreads for freebsd... > > Do you think mysql would run well with the new threads for freebsd > 5.XX? Did anybody try it? I've been running mysql 4.1 on a -current box with likse threads and haven't had any problems. I

Re: Large number of Databases

2003-09-18 Thread Gustavo A. Baratto
I already use linuxthreads for freebsd... Do you think mysql would run well with the new threads for freebsd 5.XX? Did anybody try it? thanks Jeremy Zawodny wrote: On Thu, Sep 18, 2003 at 10:51:49AM -0300, Gustavo A. Baratto wrote: no problem for me... 1000+ DBs on RH linux (ext3 fs), then mov

Re: Large number of Databases

2003-09-18 Thread Jeremy Zawodny
On Thu, Sep 18, 2003 at 10:51:49AM -0300, Gustavo A. Baratto wrote: > 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. If you use LinuxThreads on FreeBSD, it's nearly

Re: Large number of Databases

2003-09-18 Thread Gustavo A. Baratto
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 oft

Large number of Databases

2003-09-18 Thread Richard
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? Regards Richard - Original Message - From: "Harald Fuchs" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Se