- 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
snip
The OP didn't indicate where the files are being kept, and under FreeBSD
this can be significant. I know
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 systems.
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 -r --check --sort-index --analyze
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 the
PROTECTED]
Sent: Friday, March 14, 2003 7:16 AM
To: [EMAIL PROTECTED]
Subject: FreeBSD + MySQL bottleneck
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
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.
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 -r --check
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 reference.
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