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 PROTECTED]
Subject: Re: MySQL bottleneck
Date: Sat, 16 Apr 2005 20:56:08 -0700
Incompetence is its
[EMAIL PROTECTED] wrote:
Hi Wiley,
snip
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
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:
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.com
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
]
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
might point you into the correct direction:
1) Is the data entered once
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 but that questions
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 given today's hardware.
On 4
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=getsearch=0x8B686E08
There's no place like 127.0.0.1
--
MySQL General Mailing List
For list archives:
- 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.
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 there
give me some pointers for identifying bottlenecks
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.
NOT maxed out. They 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
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
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
