Hi,

I am currently running mysql (Ver 7.11 Distrib 3.22.23b, for sun-solaris2.6 on sparc) on a Sun Ultra 1.

Safe_mysqld is ran with the following options:

safe_mysqld --skip-networking -O table_cache=128 -O sort_buffer=3M -O record_buffer=1M -O flush_time=3600 -O max_allowed_packet=256k

Everything has been running fine, however about 20 mins ago the daemon restarted for some reason:

Here are the last few entries from the .err logfile in the data directory:

991130 13:00:14 Aborted connection 272 to db: 'flash' user: 'root' 991201 6:51:42 Aborted connection 697 to db: 'flash' user: 'root' 991201 10:52:55 Aborted connection 909 to db: 'flash' user: 'root' 991201 10:53:12 Aborted connection 930 to db: 'flash' user: 'root' 991201 10:53:35 Aborted connection 920 to db: 'flash' user: 'root' 991201 10:53:42 Aborted connection 933 to db: 'flash' user: 'root' 991201 11:03:17 Aborted connection 942 to db: 'flash' user: 'root' 991201 11:03:25 Aborted connection 945 to db: 'flash' user: 'root' mysqld restarted on Wednesday December 1 11:03:32 GMT 1999 /usr/local/mysql-3.22.23b-sun-solaris2.6-sparc/bin/mysqld: ready for connections

Any idea as to why this would do this? Also, any advice on tuning etc would be very much appreciated.... keep up the great work by the way....

Regards, Matt.

Here is the current extended-status outuput from mysqladmin: +--------------------------+---------+ | Variable_name | Value | +--------------------------+---------+ | Aborted_clients | 0 | | Aborted_connects | 0 | | Created_tmp_tables | 184 | | Delayed_insert_threads | 1 | | Delayed_writes | 34 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 530 | | Handler_read_first | 777 | | Handler_read_key | 7243 | | Handler_read_next | 336007 | | Handler_read_rnd | 3972410 | | Handler_update | 178 | | Handler_write | 1807 | | Key_blocks_used | 321 | | Key_read_requests | 90564 | | Key_reads | 321 | | Key_write_requests | 1350 | | Key_writes | 892 | | Max_used_connections | 12 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 40 | | Open_files | 71 | | Open_streams | 0 | | Opened_tables | 40 | | Questions | 62605 | | Running_threads | 12 | | Slow_queries | 0 | | Uptime | 1447 | +--------------------------+---------+

Here is the current processlist:

+----+------+-----------+-------+----------------+------+-----------------+-----------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------+-------+----------------+------+-----------------+-----------+ | 2 | root | localhost | flash | Sleep | 42 | | | | 3 | | | flash | Delayed_insert | 110 | Waiting on cond | followups | | 4 | root | localhost | flash | Sleep | 49 | | | | 5 | root | localhost | flash | Sleep | 99 | | | | 6 | root | localhost | flash | Sleep | 93 | | | | 7 | root | localhost | flash | Sleep | 52 | | | | 8 | root | localhost | flash | Sleep | 7 | | | | 12 | root | localhost | flash | Sleep | 44 | | | | 13 | root | localhost | flash | Sleep | 41 | | | | 14 | root | localhost | flash | Sleep | 42 | | | | 25 | root | localhost | flash | Sleep | 18 | | | | 36 | root | localhost | | Processes | 0 | | | +----+------+-----------+-------+----------------+------+-----------------+-----------