RE: mysql frequently crash on 6.2

2007-05-19 Thread Albert Wong
d-stable@freebsd.org > Subject: Re: mysql frequently crash on 6.2 > > Albert Wong wrote: > > > [Usually it only shows about three or four of these repeated errors.] > > > > I am using FreeBSD 6.2 and MySQL 4.1. I am trying to use the libthr > > threading mechanism t

Re: mysql frequently crash on 6.2

2007-05-19 Thread Tom Judge
Albert Wong wrote: [Usually it only shows about three or four of these repeated errors.] I am using FreeBSD 6.2 and MySQL 4.1. I am trying to use the libthr threading mechanism through the libmap.conf setting, as to earlier in this thread post, as a possible fix. [Though, I don't know if I hav

Re: mysql frequently crash on 6.2

2007-05-17 Thread Tom Samplonius
- "Albert Wong" <[EMAIL PROTECTED]> wrote: > key_buffer = 32M key_buffer has the most influence over the performance of MyISAM database. You should increase it as much as possible. On a dedicated 2GB server, 1GB is good. But it only helps, if you actually have indexes. There is no po

RE: mysql frequently crash on 6.2

2007-05-17 Thread Albert Wong
Mark: Thanks for the tips about the placement of the log into [mysqld] -- maybe it will start to show some error messages if I put it up into the mysqld section. :-) I will also take a look at table_cache and query_cache and read_rnd_buffer_size. [I've got some reading / figuring out to do!] M

Re: mysql frequently crash on 6.2

2007-05-17 Thread Michael Schuh
Hello Albert, Hello @list, first, i be a native german speaker, so please excuse my ugly english. Greetings everyone... I am observing what appears to be a similar problem as well... I have a dedicated server with *very* light traffic. It looks like every day or so my server load slowly climbs

Re: mysql frequently crash on 6.2

2007-05-17 Thread Mark Saad
Hello In general This is what I use for my libmap.conf , it works fine for me any you may want to give it a try. [mysqld] libpthread.so libthr.so libpthread.so.2 libthr.so.2 Note nothing in MySQL 4.1 compiled on FreeBSD 6.2 should use libc_r.so . The other thing in your libmap that

Re: mysql frequently crash on 6.2

2007-05-17 Thread Abdullah Ibn Hamad Al-Marri
On 5/17/07, Albert Wong <[EMAIL PROTECTED]> wrote: Can you go for MySQL 5.0.37? -- Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net/ ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freeb

Re: mysql frequently crash on 6.2

2007-05-17 Thread Abdullah Ibn Hamad Al-Marri
l Message- > From: Abdullah Ibn Hamad Al-Marri [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 17, 2007 1:17 PM > To: Albert Wong > Cc: freebsd-stable@freebsd.org > Subject: Re: mysql frequently crash on 6.2 > > On 5/17/07, Albert Wong <[EMAIL PROTECTED]> wrote: &g

RE: mysql frequently crash on 6.2

2007-05-17 Thread Albert Wong
mailto:[EMAIL PROTECTED] > Sent: Thursday, May 17, 2007 1:17 PM > To: Albert Wong > Cc: freebsd-stable@freebsd.org > Subject: Re: mysql frequently crash on 6.2 > > On 5/17/07, Albert Wong <[EMAIL PROTECTED]> wrote: > > > > > Can you go for MySQL 5.0.37? > &

mysql frequently crash on 6.2

2007-05-17 Thread Albert Wong
Greetings everyone... I am observing what appears to be a similar problem as well... [referring to the posts from earlier this month with the same subject]... I have a dedicated server with *very* light traffic. It looks like every day or so my server load slowly climbs from 0.20 to 14.00 and then

mysql frequently crash on 6.2

2007-05-17 Thread Albert Wong
Greetings everyone... I am observing what appears to be a similar problem as well... I have a dedicated server with *very* light traffic. It looks like every day or so my server load slowly climbs from 0.20 to 14.00 and then stays there indefinitely locking down the system [until I do an "apa

Re: mysql frequently crash on 6.2

2007-05-02 Thread Olivier Mueller
On Wed, 2007-05-02 at 09:34 +0100, Tom Evans wrote: > You shouldn't have to recompile mysql, just restart (as long as it is > dynamically linked; default from ports is). I'd always use mysql from > ports, as it is more targeted to freebsd. ok. > We saw key file errors when using mysql 5.0(.27 iir

Re: mysql frequently crash on 6.2

2007-05-02 Thread Tom Evans
On Tue, 2007-05-01 at 22:44 +0200, Olivier Mueller wrote: > Hi, > > On Tue, 2007-05-01 at 16:26 +0100, Tom Evans wrote: > > On Tue, 2007-05-01 at 10:12 -0400, Mike Jakubik wrote: > > > I've had problems with 6.2 and mysql on a large server as well. High CPU > > > usage and crashes. I switched the

Re: mysql frequently crash on 6.2

2007-05-01 Thread Olivier Mueller
Hi, On Tue, 2007-05-01 at 16:26 +0100, Tom Evans wrote: > On Tue, 2007-05-01 at 10:12 -0400, Mike Jakubik wrote: > > I've had problems with 6.2 and mysql on a large server as well. High CPU > > usage and crashes. I switched the threading library to libthr and the > > problems went away. > If you d

Re: mysql frequently crash on 6.2

2007-05-01 Thread Tom Evans
On Tue, 2007-05-01 at 10:12 -0400, Mike Jakubik wrote: > I've had problems with 6.2 and mysql on a large server as well. High CPU > usage and crashes. I switched the threading library to libthr and the > problems went away. > ME_TOO++ If you don't know how to switch what threading library is use

Re: mysql frequently crash on 6.2

2007-05-01 Thread Mike Jakubik
On Tue, May 1, 2007 2:58 am, Ken Chen wrote: > 2007/5/1, Jeremy Chadwick <[EMAIL PROTECTED]>: >> >> >> I can confirm this problem. Normally sig11 is an indication that you >> have hardware-related problems, but in this particular case (at least in >> my experience), it can also be caused by some l

Re: mysql frequently crash on 6.2

2007-04-30 Thread Ken Chen
2007/5/1, Jeremy Chadwick <[EMAIL PROTECTED]>: I can confirm this problem. Normally sig11 is an indication that you have hardware-related problems, but in this particular case (at least in my experience), it can also be caused by some lack-of loader.conf tunables permitting mysqld to allocate

Re: mysql frequently crash on 6.2

2007-04-30 Thread Jeremy Chadwick
On Tue, May 01, 2007 at 09:11:28AM +0800, Ken Chen wrote: > After moving the database from Linux 2.4 to FreeBSD 6.2, the mysqld crash > very frequently! I think the problem is on FreeBSD when myusql is heaving > loading. > > I have another same machine with lower loading, the mysql is stable.

mysql frequently crash on 6.2

2007-04-30 Thread Ken Chen
After moving the database from Linux 2.4 to FreeBSD 6.2, the mysqld crash very frequently! I think the problem is on FreeBSD when myusql is heaving loading. I have another same machine with lower loading, the mysql is stable. = 8< Version: '5.0.37-log' socket: '/tmp/mysql2.