Hi,
I have problem with my mysqld, when its receiving alot of connections and at the same time doing insert/delete/update/select on the same table mysqld segfaults and restarts
041108 0:59:08 Warning: Got signal 14 from thread 162602
Segmentation fault
041708 13:17:54 -e \nNumber of processes running now: 0
041708 13:17:54 mysqld restarted
041108 13:17:55 InnoDB: Started
/usr/pkg/libexec/mysqld: ready for connections.
Version: '4.0.21' socket: '/tmp/mysql.sock' port: 3306 Source distribution
041108 13:19:06 Warning: Got signal 14 from thread 2
I start mysqld with these flags:
--key_buffer_size=130M --table_cache=256 --sort_buffer_size=16M --read_buffer_size=4M --query_cache_size=64M
ulimit -n 8096 ulimit -l 800000 ulimit -d 800000 ulimit -m 800000 ulimit -p 9000 ulimit -s 600000
The table has about 450k rows and the size with indexes is ~1.4GB
Running NetBSD 1.6.2 and mysql 4.0.21
What can cause these segfaults? and is there anything i can tune to get rid of them?
Try lowering your sort_buffer_size and read_buffer_size - those are allocated per thread, and with a lot of connections can cause a memory shortage if they are large.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]