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

FreeBSD + MySQL bottleneck

2003-03-14 Thread Matthias Trevarthan
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 ${datadir}/*/*.MY

FreeBSD bin-log rotation script

2003-01-30 Thread Matthias Trevarthan
Howdy list, Does anyone have a FreeBSD/MySQL bin-log rotation script that I could use? I'm not sure how to go about rotating the binary logs. Doesn't the index have to stay in sync? Thanks! Matthias - Before posting, please ch

Re: FreeBSD bin-log rotation script

2003-01-30 Thread Matthias Trevarthan
On Thursday 30 January 2003 13:47, you wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query,queries,smallint > > If you just reply to this me

Re: UPDATE syntax dummy question...

2002-09-03 Thread Matthias Trevarthan
Thanks everyone! I see that I need double quotes now. I received about 12 different personal emails from various people with exactly the same answer. Thanks again! On Tuesday 03 September 2002 10:31, Matthias Trevarthan wrote: > Howdy, > > I'm trying to perform an update on a

UPDATE syntax dummy question...

2002-09-03 Thread Matthias Trevarthan
Howdy, I'm trying to perform an update on a php poll table. Here is the table description: mysql> describe vbooth_data; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ |