I have two mysql servers in a machine. OS is linux and system is dell.
I ran the servers in a separate datadir, socket and port yesterday. But
after six hours from the start two of them corrupted accidently.
I ran two servers from remote terminal. And there was no problem until
I exited from the terminal. But... as soon as I typed "exit" to exit
from
terminal, some error messages appeared on my screen. And two
servers stopped. After corruption one of them restarted automatically
but the other couldn't restart automatically. This is error message
from the server
FIRST ONE
020409 04:03:03 mysqld started
/usr/local/libexec/mysqld: ready for connections
Number of processes running now: 20
mysqld process hanging, pid 18761 - killed
mysqld process hanging, pid 18811 - killed
mysqld process hanging, pid 18832 - killed
020409 14:34:04 mysqld restarted
/usr/local/libexec/mysqld: ready for connections
~
~
SECOND ONE
020409 04:03:03 mysqld started
/usr/local/libexec/mysqld: ready for connections
Number of processes running now: 94
mysqld process hanging, pid 18762 - killed
020409 14:34:03 mysqld restarted
Number of processes running now: 0
020409 14:34:03 mysqld restarted
020409 14:34:03 mysqld ended
020409 14:34:04 mysqld ended
The accident occured at 14:34 2002/04/09.
Do you have any idea why the server corrupted?
I can show you my mysql.server script. Here is this.
$bindir/safe_mysqld --datadir=$datadir \
--pid-file=$pid_file \
-O max_heap_table_size=512M \
-O key_buffer=256M \
-O table_cache=256 \
-O sort_buffer=4M -O record_buffer=1M \
-O max_allowed_packet=1M \
-O max_connections=400 \
-O back_log=100 \
&
$bindir/safe_mysqld --datadir=/usr/local/mysql/other \
--socket=/usr/local/mysql/other/mysql.sock \
--port=3307 \
-O max_heap_table_size=512M \
-O key_buffer=256M \
-O table_cache=256 \
-O sort_buffer=4M -O record_buffer=1M \
-O max_allowed_packet=1M \
-O max_connections=400 \
-O back_log=100 \
&
Any answer will be appreciated. Thank you for reading.
---------------------------------------------------------------------
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
