Re: FreeBSD + MySQL bottleneck

2003-03-15 Thread Dan Nelson
In the last episode (Mar 15), Jesse Guardiani said: > From: "Warren W. Gay VE3WWG" <[EMAIL PROTECTED]> > > The OP didn't indicate where the files are being kept, and under > > FreeBSD this can be significant. I know for example, that using UFS > > file systems, are very slow compared to newer file

Re: FreeBSD + MySQL bottleneck

2003-03-15 Thread Jesse Guardiani
- Original Message - From: "Warren W. Gay VE3WWG" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 14, 2003 4:45 PM Subject: Re: FreeBSD + MySQL bottleneck > The OP didn't indicate where the files are being kept, and under FreeBSD > th

Re: FreeBSD + MySQL bottleneck

2003-03-14 Thread Warren W. Gay VE3WWG
Jeremy Zawodny wrote: On Fri, Mar 14, 2003 at 12:03:14PM -0800, Joe Stump wrote: This may help - I just got this from a friend. http://jeremy.zawodny.com/blog/archives/000203.html Ugh. I *really* need to update that. It has become a popular reference. But I have some new information to a

Re: FreeBSD + MySQL bottleneck

2003-03-14 Thread Matthias Trevarthan
On Friday 14 March 2003 12:34, Jeremy Zawodny wrote: > On Fri, Mar 14, 2003 at 12:03:14PM -0800, Joe Stump wrote: > > This may help - I just got this from a friend. > > > > http://jeremy.zawodny.com/blog/archives/000203.html > > Ugh. > > I *really* need to update that. It has become a popular refe

Re: FreeBSD + MySQL bottleneck

2003-03-14 Thread walt
Matthias Trevarthan wrote: > > Howdy list, > > I run MySQL 3.23.54 with FreeBSD 4.6-RELEASE. > > We recently had a BBS get hammered by a lot of > concentrated traffic. > > I currently run a 'mysql-optimize.sh' script from > cron on Wednesday and Sunday that executes: > > ${bindir}/myisamchk -i

Re: FreeBSD + MySQL bottleneck

2003-03-14 Thread Jeremy Zawodny
On Fri, Mar 14, 2003 at 12:03:14PM -0800, Joe Stump wrote: > This may help - I just got this from a friend. > > http://jeremy.zawodny.com/blog/archives/000203.html Ugh. I *really* need to update that. It has become a popular reference. But I have some new information to add. The short version.

RE: FreeBSD + MySQL bottleneck

2003-03-14 Thread Joe Stump
This may help - I just got this from a friend. http://jeremy.zawodny.com/blog/archives/000203.html --Joe -- Joe Stump <[EMAIL PROTECTED]> http://www.joestump.net "Label makers are proof God wants Sys Admins to be happy." -Original Message- From: Matthias Trevarthan [mailto:[EMAIL PROTE

Re: FreeBSD + MySQL bottleneck

2003-03-14 Thread John Wards
> So, my questions are these: > --- > > Can any experienced MySQL-FreeBSD admins out there > give me some pointers for identifying bottlenecks? I have been running MySQl-FreeBSD for over a year now and we are now doing about 140-150,000 page views a day all dynamic from t