I have the latest version!
Server version: 3.23.42-log
The locking problem is only valid for MyISAM tables, and
the reason for switching to InnoDB. InnoDB have problems
with sorting Instead, so the final result i s similar: Our server
fills up its max_connections....
regards Johan
----- Original Message -----
From: "ryc" <iii@stripped>
To: "Johan Wahlström" <whejl@stripped>; <mysql@stripped>
Sent: Thursday, September 27, 2001 4:21 PM
Subject: Re: InnoDB Sorting problem. (performance)
> What version of mysql is this? There have been some known locking issues
> with certain versions. If you arent running the latest you should probably
> upgrade.
>
> ryan
>
> ----- Original Message -----
> From: "Johan Wahlström" <whejl@stripped>
> To: <mysql@stripped>
> Sent: Thursday, September 27, 2001 8:34 AM
> Subject: InnoDB Sorting problem. (performance)
>
>
> > Hello!
> >
> > I recently converted our 2GB (43 tables) database from MyISAM to InnoDB
> > tables.
> > The reasons was to avoid severe locking problems coused by many querrys
to
> a
> > few
> > important tables. This was accomplished nicely, and the locking errors
> went
> > away.
> >
> > However, we got a new problem instead, scince we moved to InnoDB the
> > "Sorting result"
> > may take "forever" (more than 8000s in some cases) to complete. The
> > processlist gets filled
> > up with these processes and then the server wont take any more
> connections.
> >
> > Is this a bug, or some configuration issue we may have missed? If so,
how
> > can we make
> > this work?
> >
> > regards Johan Wahlström
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <mysql-thread86504@stripped>
> > To unsubscribe, e-mail
<mysql-unsubscribe-iii=binary.net@stripped>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
