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.
