When I execute my script I get the following:
euclid:~/utils> ./optimize_table
DBD::mysql::st execute failed: Lost connection to MySQL server during
query at ./optimize_table line 10.
dieing: Lost connection to MySQL server during query
> In this case its very likely that MySQL is waiting on a disk full
> condition!
Filesystem 1024-blocks Used Available Capacity Mounted on
/dev/hda2 3943284 1879155 1860104 50% /
Somehow, I doubt it.
> - Check what MySQL is doing with 'mysqladmin proc'
euclid:~> mysqladmin proc
+-----+--------+-----------+--------+-----------+------+----------------+-------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info
+-----+--------+-----------+--------+-----------+------+----------------+-------------------------------------------------------------------------------+
| 475 | euclid | localhost | euclid | Query | 14 | Sorting result | select distinct
configuration, hostname, type, timestamp, status from configs |
| 481 | euclid | localhost | | Processes | 0 | |
+-----+--------+-----------+--------+-----------+------+----------------+-------------------------------------------------------------------------------+
euclid:~> mysqladmin proc
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock'
exists!
> - Use 'top' to check that MySQL is running.
euclid:~# ps -aux | grep my
root 16181 0.0 0.2 952 312 p2 S 09:19 0:00 grep my
it just died.
> - Check the MySQL log files for any recent entries.
in /usr/local/var/euclid.err:
990512 9:17:51 Aborting
mysqld ended on Wed May 12 09:17:51 NZST 1999
I can't find anything else anywhere.
> - Check the MySQL documentation, Section 'Debugging MySQL'.
basedir: /usr/local/
datadir: /usr/local/var/
tmpdir: /tmp/
language: /usr/local/share/mysql/english/
pid file: /usr/local/var/euclid.pid
TCP port: 3306
Unix socket: /tmp/mysql.sock
system locking is not in use
Possible variables for option --set-variable (-O) are:
back_log current value: 5
connect_timeout current value: 5
delayed_insert_timeout current value: 300
delayed_insert_limit current value: 100
flush_time current value: 0
join_buffer current value: 131072
key_buffer current value: 8388600
long_query_time current value: 10
max_allowed_packet current value: 1048576
max_connections current value: 100
max_connect_errors current value: 10
max_delayed_insert_threads current value: 20
delayed_queue_size current value: 1000
max_join_size current value: 4294967295
max_sort_length current value: 1024
net_buffer_length current value: 16384
record_buffer current value: 131072
sort_buffer current value: 2097144
table_cache current value: 64
tmp_table_size current value: 1048576
thread_stack current value: 65536
wait_timeout current value: 28800
/usr/local/libexec/mysqld: ready for connections
Segmentation fault
--- SIGUSR1 (User defined signal 1) ---
<... sigsuspend resumed> ) = -1 EINTR (Interrupted system
call)
sigreturn() = ? (mask now [HUP QUIT USR1 TERM
TSTP])
oldselect(5, [3 4], NULL, NULL, NULL) = ? ERESTARTNOHAND (To be
restarted)
--- SIGSEGV (Segmentation fault) ---
+++ killed by SIGSEGV +++
Thanks for your help Monty, but this is all I can find.
James Tyson -- System Administrator - The Internet Group.
It's all good^Hf
