Subject: Re: mysql 4 Problems in Current (2.99.15)
To: =?ISO-8859-1?Q?Stefan_Kr=FCger?= <skrueger@meinberlikomm.de>
From: Chavdar Ivanov <ci@spidersweb.co.uk>
List: current-users
Date: 02/16/2005 15:19:27
On Tue, 15 Feb 2005, [ISO-8859-1] Stefan Kr=FCger wrote:

> Hisashi T Fujinaka wrote:
> > On Tue, 15 Feb 2005, Chuck Silvers wrote:
> >=20
> >> On Tue, Feb 15, 2005 at 09:48:06AM -0600, Francisco Valladolid=20
> >> Hernandez wrote:
> >>
> >>> Hi, thanks for your reply.
> >>>
> >>> The central problem is that i can't start the mysql daemon (mysqld_sa=
fe
> >>> --user=3Dmysql)
> >>> I has created the cluster with mysql_install_db ok, ... at the time t=
ha
> >>> i run the daemon it exit with no information and no backround process=
=2E
> >>
> >>
> >> I just set up mysql for the first time last weekend, and I had trouble
> >> with this too.  mysql's error log is /var/mysql/*.err.
> >>
> >> make sure that everything under /var/mysql is owned by the mysql user.
> >> that was the main problem I had.
> >=20
> >=20
> > I should start a new thread for this. I have the latest mysql4 from
> > pkgsrc up and running on -current but it dies sometimes. I'm pretty sur=
e
> > it's a memory corruption issue because running "show databases" gave me
> > a partial listing of a random directory.
> may I ask if you guys are running mysql on MP machines?
>=20
>=20
ci@loan8> ps -ax| grep  mysql
 6716 ttyp5  R+     0:00.00 egrep mysql
  764 ttyE0- IWa    2:38.21 /usr/pkg/libexec/mysqld --basedir=3D/usr/pkg
--datadir=3D/var/mysql -
  818 ttyE0- IW     0:00.01 /bin/sh /usr/pkg/bin/mysqld_safe
ci@loan8> pkg_info | grep -i mysql
mysql-client-4.0.18nb1 MySQL, a free SQL database (client)
mysql-server-4.0.18nb2 MySQL, a free SQL database (server)
php-mysql-4.3.6nb1  PHP4 extension for MySQL databases
ci@loan8> uname -a
NetBSD loan8 2.99.15 NetBSD 2.99.15 (GENERIC.MPACPI) #1: Tue Feb 15
12:06:53 GMT 2005
root@loan8:/d/obj1/netbsd-builds/2_0/i386/obj/sys/arch/i386/compile/GENERIC=
=2EMPACPI
i386
ci@loan8> dmesg | grep  'cpu[0|1]'\
cpu0 at mainbus0: apid 0 (boot processor)
cpu1 at mainbus0: apid 1 (application processor)
=2E..

Seems fine with 4.0.18.