Heikki Tuuri wrote:
>
> Hi!
>
> Are you running mysqld under the safe_mysqld script, which automatically
> restarts mysqld after a crash?
>
Yes, mysqld started with safe_mysqld script
> If yes, look at the 'hostname'.err file and send its contents to me.
Nothing happens in the hostname.err
(I started mysqld this morning at 11:45)
020107 11:45:08 mysqld started
020107 11:45:08 Warning: setrlimit couldn't increase number of open files to more than
1024
020107 11:45:08 Warning: Changed limits: max_connections: 512 table_cache: 251
020107 11:45:10 InnoDB: Started
/opt/mysql/libexec/mysqld: ready for connections
With ps ..., I confirm that mysqld processes have NOT restarted
(running since 11:45)
>
> Or, if you run mysqld from the command prompt, capture what mysqld prints to
> the command prompt window.
>
> If mysqld does not crash, then the problem is probably some client/server
> issue.
>
> Regards,
>
> Heikki
Has we got a network error yesterday,
I have run another test this night with the following modifications :
max_connect_errors=65535
skip-host-cache
connection to 'localhost' (the client and the serveur run on the same machine)
I have got errors like :
MySQL server has gone away (12 occurences)
Commands out of sync; You can't run this command now (85 occurences)
Lost connection to MySQL server during query (only one occurence)
The transaction overload is about :
200848 Insert
486205 Update
334945 Select
for 8 hours
Before restarting the 2nd test I restart mysqld (yesterday at 22:28)
so here is the hotname.err
---------------------------------------------------
020107 11:45:08 mysqld started
020107 11:45:08 Warning: setrlimit couldn't increase number of open files to more
than 1024
020107 11:45:08 Warning: Changed limits: max_connections: 512 table_cache: 251
020107 11:45:10 InnoDB: Started
/opt/mysql/libexec/mysqld: ready for connections
020107 22:27:45 /opt/mysql/libexec/mysqld: Normal shutdown
020107 22:27:45 InnoDB: Starting shutdown...
020107 22:27:58 InnoDB: Shutdown completed
020107 22:27:58 /opt/mysql/libexec/mysqld: Shutdown Complete
020107 22:27:58 mysqld ended
020107 22:28:25 mysqld started
020107 22:28:26 Warning: setrlimit couldn't increase number of open files to more
than 1024
020107 22:28:26 Warning: Changed limits: max_connections: 512 table_cache: 251
020107 22:28:27 InnoDB: Started
/opt/mysql/libexec/mysqld: ready for connections
Status information:
Current dir: /opt/mysql/var/
Current locks:
lock: 83f3ed0:
lock: 8396308:
lock: 8395a28:
lock: 838cfa0:
lock: 8390c00:
lock: 838cf00:
lock: 838ce60:
lock: 838c588:
lock: 837e8b8:
lock: 837ee28:
lock: 837ed90:
lock: 83746e0:
key_cache status:
blocks used: 0
not flushed: 0
w_requests: 0
writes: 0
r_requests: 0
reads: 0
handler status:
read_key: 5704
read_next: 1706
read_rnd 47
read_first: 394
write: 1447
delete 0
update: 465
Table status:
Opened tables: 26
Open tables: 20
Open files: 2
Open streams: 0
--
Bernard CHAMBON
IN2P3 / CNRS (Centre de Calcul de LYON)
Tél : 04 72 69 42 18
http://www.in2p3.fr/CC
---------------------------------------------------------------------
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
