I also experienced a lot of weird problems with MySQL5 on 3.9 , specially
with high traffic sites using Wordpress . A bunch of this appear, and
everything
that uses mysql starts to get veeery slow:

060814 23:13:05 [ERROR] /usr/local/libexec/mysqld: Sort aborted
060814 23:14:05 [ERROR] /usr/local/libexec/mysqld: Sort aborted
060814 23:14:05 [ERROR] /usr/local/libexec/mysqld: Sort aborted
060814 23:14:12 [ERROR] /usr/local/libexec/mysqld: Sort aborted
060814 23:20:35 [ERROR] /usr/local/libexec/mysqld: Sort aborted
060814 23:22:25 [ERROR] /usr/local/libexec/mysqld: Sort aborted
060814 23:23:04 [ERROR] /usr/local/libexec/mysqld: Sort aborted
060814 23:23:17 [ERROR] /usr/local/libexec/mysqld: Sort aborted
060814 23:24:22 [ERROR] /usr/local/libexec/mysqld: Sort aborted
060814 23:24:32 [ERROR] /usr/local/libexec/mysqld: Sort aborted
060814 23:24:51 [ERROR] /usr/local/libexec/mysqld: Sort aborted
060814 23:24:51 [ERROR] /usr/local/libexec/mysqld: Sort aborted
060815  2:00:10 [ERROR] /usr/local/libexec/mysqld: Sort aborted

Now the problem is gone, so are the Wordpress sites , had to shut them down
and the guy put them on some other hosting company , on linux servers .

All this MySQL problems are related to threads librarys on OpenBSD only?
Other OSes do not have such issues?

Regards,
Marcos Laufer

----- Original Message ----- 
From: "Edgars" <[EMAIL PROTECTED]>
To: "Toni Mueller" <[EMAIL PROTECTED]>
Cc: <misc@openbsd.org>
Sent: Thursday, September 07, 2006 8:57 AM
Subject: Re: Opinion of MySQL 5.xx on OpenBSD 3.9...


Same here, a lot of problems since 3.7. :(
Because of that, two client servers was migrated to freebsd :/

-----Original message-----
From: Toni Mueller [EMAIL PROTECTED]
Date: Thu,  7 Sep 2006 13:09:09 +0300
To: misc@openbsd.org
Subject: Re: Opinion of MySQL 5.xx on OpenBSD 3.9...

> Hello,
>
> On Thu, 22.06.2006 at 12:49:22 +0200, Henning Brauer
<[EMAIL PROTECTED]> wrote:
> > I haven't seen stability problems with mysql on OpenBSD in a long time.
> > not even on sparc64.
>
> then you are very lucky, imho.
>
> On a variety of OpenBSD boxes, and with a variety of MySQL versions, I
> experience random crashes or, mostly, hangs where the server does not
> respond anymore, but also doesn't crash. In such cases, a violent kill
> and a restart of the MySQL server is required to get going again. This
> is from 3.7 to 3.9 with MySQL versions from 4.0.x to 5.0.x (from
> ports), all on several i386 machines with different (PC-) hardware,
> with _low_ traffic and _ample_ resources (enough to hold all databases
> in RAM).
>
> When pushed, I see like 10 (15?) queries a second, but on average, I
> see less than 1 query every two seconds.
>
> > Unless you're really pushing the limits, performance is not much of a
> > problem either. with really extreme load, our threading library
> > shows why we wanna go for rthreads. for the vast majority of uses out
> > there, you will not see a difference.
>
> I very much hope to see a significant difference (or otherwise, more
> apps that don't depend as much on MySQL).
>
>
> Best,
> --Toni++
>
>
> -- 
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.

Reply via email to