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
21 matches
Mail list logo
