I can think of only one suggestion. See if there is a cron job or something
killing a process. I doubt it though. Hope it helps.
----- Original Message -----
From: "Joseph Bueno" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 1:31
Subject: index corruption and mysqld crash
> Hello,
>
> I have switched this morning our Web server from mSQL to MySQL.
> I am using MySQL 3.22.32 installed from MySQL-3.22.32-1.i386.rpm
> on a Linux server (RedHat 6.2).
>
> mysqld dies very ofen (uptime is between 2mn and 20mn) and
> the only messages I have in error file look like :
>
> Number of processes running now: 1
> mysqld process hanging, pid 10827 - killed
> mysqld restarted on jeu jan 11 17:35:58 CET 2001
> /usr/sbin/mysqld: ready for connections
>
> Number of processes running now: 1
> mysqld process hanging, pid 7973 - killed
> mysqld restarted on jeu jan 11 17:38:25 CET 2001
> /usr/sbin/mysqld: ready for connections
>
>
>
> I have shut down mysqld several times and run isamchk.
> Each time, I had to repair at least one table.
>
> Is it possible to run isamchk while mysqld is running ?
>
> In this case, is it enough to remove --skip-locking option
> (set in safe_mysqld) or should I also add --enable-locking ?
>
> Does anybody have any suggestion on where I could look
> in order to find what is causing these corruptions ?
>
> Thanks for your help
> --
> Joseph Bueno
> NetClub/Trader.com
>
> ---------------------------------------------------------------------
> 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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
