и еще один вопрос :
(mysql я пересобрал с WITH_LINUXTHREADS=yes .. )несколько раз в месяц (до пересборки также було) в логах вот такое:
060814 16:48:36 mysqld restarted
060814 16:48:36 InnoDB: Started; log sequence number 0 43675
060814 16:48:36 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.21' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.21
mysqld got signal 4;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.
key_buffer_size=8388600
read_buffer_size=258048
max_used_connections=27
max_connections=100
threads_connected=4
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 84591 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
060814 17:47:34 mysqld restarted
060814 17:47:35 InnoDB: Started; log sequence number 0 43675
060814 17:47:35 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.21' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.21
bash-2.05b# mysqladmin version
mysqladmin Ver 8.41 Distrib 5.0.21, for portbld-freebsd6.0 on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.21
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 19 hours 18 min 34 sec
Threads: 2 Questions: 6902268 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 64 Queries per second avg: 99.293
bash-2.05b# mysqladmin processlist status -- показивает не более 10 одновременних конетка ,
mytop -- такие же результати ...
Железо:
CPU: Intel Pentium III (996.85-MHz 686-class CPU)
FreeBSD/SMP: Multiprocessor System Detected: 2 CPUs
SMP: AP CPU #1 Launched!
real memory = 536870912 (512 MB)
avail memory = 515878912 (491 MB)
используетса как веб-сервер(сайти на ПХП) ...
(может еще какая информация нужна ???)
Помогите решить проблему !!!