Re: Load problems with 3.23.51 ( same here )

2002-07-16 Thread David BORDAS
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 after (albeit a 4.0.x version) work fine. Sincerely, Steven Roussey http

3.23.51 bug ? ( was RE: Load problems with 3.23.51 )

2002-07-16 Thread David BORDAS
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 after (albeit a 4.0.x version) work fine. Sincerely, Steven Roussey http

Re: 3.23.51 bug ? ( was RE: Load problems with 3.23.51 )

2002-07-16 Thread Victoria Reznichenko
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 :

RE: Load problems with 3.23.51

2002-07-12 Thread Steven Roussey
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.

RE: Load problems with 3.23.51

2002-07-02 Thread Steven Roussey
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:

Re: Load problems with 3.23.51

2002-06-30 Thread Jeremy Zawodny
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 sustain

RE: Load problems with 3.23.51

2002-06-30 Thread Steven Roussey
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 the ground. I think that'd help determine if there's

RE: Load problems with 3.23.51

2002-06-29 Thread Michael Widenius
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 Running tests

RE: Load problems with 3.23.51

2002-06-29 Thread Steven Roussey
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

Re: Load problems with 3.23.51

2002-06-24 Thread Jeff Kilbride
, 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 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

Re: Load problems with 3.23.51

2002-06-24 Thread Michael Widenius
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 average go through

Re: Load problems with 3.23.51

2002-06-24 Thread Sinisa Milivojevic
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 MySQL

Re: Load problems with 3.23.51

2002-06-24 Thread Jayce^
-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 slow

RE: Load problems with 3.23.51

2002-06-24 Thread Steven Roussey
/?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! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy

RE: Load problems with 3.23.51

2002-06-24 Thread Steven Roussey
] 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, I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and tried 51. No dice. It does not handle

Re: Load problems with 3.23.51

2002-06-24 Thread Michael Bacarella
to see if there is any difference. Sincerely, Steven Roussey http://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

Re: Load problems with 3.23.51

2002-06-24 Thread Jeremy Zawodny
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 thought

Re: Load problems with 3.23.51

2002-06-24 Thread Michael Bacarella
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. At first I

Re: Load problems with 3.23.51

2002-06-24 Thread Heikki Tuuri
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 quite well. The difference is that I built it from

RE: Load problems with 3.23.51

2002-06-24 Thread Steven Roussey
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

Re: Load problems with 3.23.51

2002-06-23 Thread Jeremy Zawodny
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