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