> 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
[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
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
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
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
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
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
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.
How do I debug my live mysql query on a specific database to find the query
time, memory usage, etc. ?
Thanks
--
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There's no place like 127.0.0.1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
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
- 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
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
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
elerator.
>
> Also, 'mysql> show status;' showed that I only had
> about 25 threads open at a time. And it also said I
> had 82 tables open.
>
> My T1s were NOT maxed out. They weren't even half full,
> and besides: I accessed the BBS from
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.
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
> 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
weren't even half full,
and besides: I accessed the BBS from our 100Mb switch,
and it was still dog slow (20-30 seconds for a page load),
which means it was purely a bottleneck in my machine.
So, my questions are these:
---
Can any experienced MySQL-FreeBSD admins out th
fibre channel, spread across 4 external raid 5 sets via
veritas).
iostat says very low utilization, no wait-for-io, minimal
usage, ie: 2MB per second copy. These disks can copy 40 MB
per second without breaks a sweat.
What is the bottleneck? Is it simply the internal MySQL copy
routine
19 matches
Mail list logo
