Bonjour,
Here is my setup :
Mysql-3.23.35 complied from sources with :
./configure --prefix=/usr/local/mysql --without-bench --enable-thread-safe-client
--with-innobase
====================================================================================================
System: SunOS sun01381 5.8 Generic_108528-04 sun4u sparc SUNW,Ultra-80
Architecture: sun4
Some paths: /bin/perl /usr/ccs/bin/make /usr/local/bin/gmake /usr/local/bin/gcc
/usr/ucb/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs
gcc version 2.95.2 19991024 (release)
====================================================================================================
/etc/my.cnf
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
skip-name-resolve
set-variable = key_buffer=128M
set-variable = max_allowed_packet=1M
set-variable = table_cache=256
set-variable = sort_buffer=5M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_cache=8
set-variable = thread_concurrency=8 # Try number of CPU's*2
myisam-recover = BACKUP,FORCE
# Innobase
innobase_data_home_dir = /usr/local/mysql/var/innobase_data/
innobase_data_file_path = ibdata1:500M
set-variable = innobase_mirrored_log_groups=1
innobase_log_group_home_dir = /usr/local/mysql/var/innobase_logs/
set-variable = innobase_log_files_in_group=3
set-variable = innobase_log_file_size=5M
set-variable = innobase_log_buffer_size=8M
innobase_flush_log_at_trx_commit=0
innobase_log_arch_dir = innobase_log_group_home_dir
innobase_log_archive=0
set-variable = innobase_buffer_pool_size=64M
set-variable = innobase_additional_mem_pool_size=2M
set-variable = innobase_file_io_threads=4
set-variable = innobase_lock_wait_timeout=50
====================================================================================================
Here is my problem :
With even no queries on the server, I continually have the
"Warning: Got signal 14 from thread X" in the log of Mysqld :
010320 10:48:46 mysqld started
Innobase: Started
/usr/local/mysql/libexec/mysqld: ready for connections
010320 10:49:32 Warning: Got signal 14 from thread 4
010320 10:49:34 Warning: Got signal 14 from thread 3
010320 10:49:36 Warning: Got signal 14 from thread 5
010320 10:49:38 Warning: Got signal 14 from thread 4
010320 10:49:40 Warning: Got signal 14 from thread 4
010320 10:49:42 Warning: Got signal 14 from thread 6
010320 10:49:44 Warning: Got signal 14 from thread 5
010320 10:49:46 Warning: Got signal 14 from thread 4
010320 10:49:48 Warning: Got signal 14 from thread 3
010320 10:49:50 Warning: Got signal 14 from thread 5
010320 10:49:52 Warning: Got signal 14 from thread 4
...
I did not have that with 3.23.32 ... but I did not have Innobase
with 3.23.32 ...
Is it a known bug ?
Regards,
Alex.
---------------------------------------------------------------------
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