mysqld in malloc(): error: allocation failed
I get this error:mysqld in malloc(): error: allocation failed
2-3 times per day. Mysql restarts after this but its not ready for connections in next couple of minutes.. I can restart it during that time and everything will work fine or I can wait for couple of minutes..
It looks like it has nothing to do with number of users on the site / server..
Here's my.conf:
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=1000
max_connections=1500
interactive_timeout=10
wait_timeout=10
connect_timeout=10
thread_cache_size=128
key_buffer=400M
join_buffer=1M
max_allowed_packet=16M
table_cache=2048
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
Server:
AM P4 3.06
1GB RAM
FreeBSD 5.2.1
MySQL 4.1.12
Any ideas?
Thanks
