David,
Tuesday, July 16, 2002, 3:55:46 PM, you wrote:
DB> Same thing here, mysql 3.23.51 works well during about 2 hours then
DB> suddently load average grow up to 200 and more ...
DB> Load average is less than 4 with 3.23.49.
DB> We're using binary tar.gz non max versions from Mysql.com
DB> OS
7;Mysql'" < [EMAIL PROTECTED] >
Sent: Friday, July 12, 2002 6:17 PM
Subject: RE: Load problems with 3.23.51
> Just a note: I tried MySQL 4.0.2 and it works fine. Seems to be only
> 3.23.51 built by MySQL itself that has the issue. Releases before, and
> now a release af
7;Mysql'" < [EMAIL PROTECTED] >
Sent: Friday, July 12, 2002 6:17 PM
Subject: RE: Load problems with 3.23.51
> Just a note: I tried MySQL 4.0.2 and it works fine. Seems to be only
> 3.23.51 built by MySQL itself that has the issue. Releases before, and
> now a release af
Just a note: I tried MySQL 4.0.2 and it works fine. Seems to be only
3.23.51 built by MySQL itself that has the issue. Releases before, and
now a release after (albeit a 4.0.x version) work fine.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
>
> I have MySQL 3.23.47 running on our sever.
Just an update: I installed a new fresh version of RedHat 7.3 (smp
Athlon) and a new copy of MySQL 3.23.51, but the problem remains.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
Before posting, please check:
http
, 2002 11:20 pm
> To: Steven Roussey
> Subject: Re: Load problems with 3.23.51
>
> Can you humor me and try running the command:
>
> ps -eo pid,tt,user,fname,tmout,f,wchan
>
> on that system a few times? Mine was far too hosed for this command
> to ever get off
On Sat, Jun 29, 2002 at 10:47:47PM -0700, Steven Roussey wrote:
>
> Tomorrow I'll try doing my own compile with gcc3.1. Note the other
> guy that had the same problem that went away after he compiled it
> himself:
Even gcc 2.95.3 or .4 will work well based on what I've seen. We can
still sustai
> Another option is to run the 3.23.51 server for a while and when you
> get a load problem do 'mysqladmin proc ext'. This command should show
> us if MySQL is using more table scans than usual.
The load problem shows up immediately.
+--++
| Variable_name
Hi!
> "Steven" == Steven Roussey <[EMAIL PROTECTED]> writes:
Steven> I tried the skip-name-resolve and it had no effect. So there goes my
Steven> hypothesis.
Steven> Here are the results from test:
Steven> Benchmark DBD suite: 2.14
Steven> Date of test:2002-06-24 11:19:19
Steven>
I used the mysql builds myself. Funny thing is that I use your tool
'mytop', which is very cool by the way, to watch things and it pauses
for about 5-8 seconds when refreshing with .51 and is almost instant
with .47
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
> -Original Message
]>
Newsgroups: mailing.database.mysql
Sent: Monday, June 24, 2002 4:14 PM
Subject: Re: Load problems with 3.23.51
> Jeremy Zawodny writes:
> > On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote:
> >
> > As another data point for you, I've got 3.23.51 running on our master
>
On Mon, Jun 24, 2002 at 12:43:47PM -0700, Jeremy Zawodny wrote:
> > I will second this.
> >
> > I attempted an upgrade from 3.23.50 to 3.23.51 and hit immediate
> > performance problems. I tried for about 20 minutes to see what was
> > causing it but to no avail. I reverted to 3.23.50.
> >
> > A
On Mon, Jun 24, 2002 at 03:11:53PM -0400, Michael Bacarella wrote:
> I will second this.
>
> I attempted an upgrade from 3.23.50 to 3.23.51 and hit immediate
> performance problems. I tried for about 20 minutes to see what was
> causing it but to no avail. I reverted to 3.23.50.
>
> At first I t
4:24 am
> > To: [EMAIL PROTECTED]
> > Cc: Steven Roussey; [EMAIL PROTECTED]
> > Subject: Re: Load problems with 3.23.51
> >
> >
> > Hi!
> >
> > >>>>> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes:
> >
&g
EMAIL PROTECTED]
> Subject: Re: Load problems with 3.23.51
>
>
> Hi!
>
> >>>>> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes:
>
> Jeremy> On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey
wrote:
> >> Hi all
//Network54.com/?pp=e
> -Original Message-
> From: Michael Widenius [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 24, 2002 4:24 am
> To: [EMAIL PROTECTED]
> Cc: Steven Roussey; [EMAIL PROTECTED]
> Subject: Re: Load problems with 3.23.51
>
>
> Hi!
>
> &g
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and
> tried 51. No dice. It does not handle load, CPU and the load average go
> through the roof. I'm using Red Hat Linux 7.2 and the official mysql
> binaries. It appears to be slo
Jeremy Zawodny writes:
> On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote:
>
> As another data point for you, I've got 3.23.51 running on our master
> quite well. The difference is that I built it from source (to get a
> critical InnoDB patch). I don't recall which compiler the My
Hi!
> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes:
Jeremy> On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote:
>> Hi all,
>>
>> I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and
>> tried 51. No dice. It does not handle load, CPU and the load avera
" <[EMAIL PROTECTED]>
Cc: "'Mysql'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, June 23, 2002 2:55 AM
Subject: Re: Load problems with 3.23.51
> On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote:
> > Hi all,
> >
> > I
On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote:
> Hi all,
>
> I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and
> tried 51. No dice. It does not handle load, CPU and the load average go
> through the roof. I'm using Red Hat Linux 7.2 and the official mysql
> b
Hi all,
I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and
tried 51. No dice. It does not handle load, CPU and the load average go
through the roof. I'm using Red Hat Linux 7.2 and the official mysql
binaries. It appears to be slow to connect, causing 0.5 to 1.0 second
delay o
22 matches
Mail list logo