Re: MySQL bottleneck

2005-04-17 Thread Martijn Tonies
> So is karma :) It might be me - but: 1) the OP hi-jacked an existing thread 2) you guys keep on quoting everything in this thread 3) even the original (existing) thread gets quoted Please don't do that. -- Martijn -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

Starting a thread (Was Re: MySQL bottleneck)

2005-04-17 Thread Michael Stassen
[EMAIL PROTECTED] wrote: Hi Wiley, About posting: Just make Sure you create a new Subject line when starting a new thread or topic. That should do the trick and nobody gets confused. I hope that you find this information useful. Best regards Nils Valentin Tokyo / Japan Changing the Subject line is

Re: MySQL bottleneck

2005-04-16 Thread valentin_nils
ed. I hope that you find this information useful. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com > So is karma :) > > > >>From: sol beach <[EMAIL PROTECTED]> >>Reply-To: sol beach <[EMAIL PROTECTED]> >>To: B Wiley Snyder <[EMAIL PR

Re: MySQL bottleneck

2005-04-16 Thread B Wiley Snyder
So is karma :) From: sol beach <[EMAIL PROTECTED]> Reply-To: sol beach <[EMAIL PROTECTED]> To: B Wiley Snyder <[EMAIL PROTECTED]> Subject: Re: MySQL bottleneck Date: Sat, 16 Apr 2005 20:56:08 -0700 Incompetence is its own reward. Simply put, 360K is NOT a big number or DB give

Re: MySQL bottleneck

2005-04-16 Thread B Wiley Snyder
Oh wait, I see what happend. I stepped on MY OWN thread. I hate when I do that ! Sorry From: [EMAIL PROTECTED] To: "B Wiley Snyder" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: MySQL bottleneck Date: Sun, 17 Apr 2005 01:21:36 - (UTC) Hello there, no offence bu

Re: MySQL bottleneck

2005-04-16 Thread B Wiley Snyder
ROTECTED] To: "B Wiley Snyder" <[EMAIL PROTECTED]> Subject: Re: MySQL bottleneck Date: Sun, 17 Apr 2005 01:19:32 - (UTC) Hello there, no offence but that questions is not answerable. I wouldnt expect many replies. Let me try to help you out by asking YOU a few questions which mi

Re: MySQL bottleneck

2005-04-16 Thread valentin_nils
Hello there, no offence but that questions is not answerable. I wouldnt expect many replies. Let me try to help you out by asking YOU a few questions which might point you into the correct direction: 1) Is the data entered once and than mostly read access or is it frequently updated ? 2) Do you

MySQL bottleneck

2005-04-16 Thread B Wiley Snyder
Hello there, let's say I have 365,000 users I need to enter their data, pull from it and modify it regularly. Is MySql the way to go ? Or do I need to buy an oracle or ms server ? thanks in advance for a clue From: [EMAIL PROTECTED] To: "B Wiley Snyder" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.

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
n [mailto:[EMAIL 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

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

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