BAUMEISTER Alexandre writes:
> 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.
Hi!
The above could indicate some timeout problem.
Can you build mysql --with-debug and start it with --debug and see in
the trace file when are the above timeouts reported ??
Also, do you have clients that do not call mysql_close at the end ,
like PHP programs ?
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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
