Имею вот такую систему,
mserver# uname -a
Код: Выделить всё
FreeBSD mserver 8.2-RELEASE FreeBSD 8.2-RELEASE #0: Fri Feb 18 02:24:46 UTC 2011 root@almeida.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC i386
mserver# pkg_info | grep mysql
Код: Выделить всё
mysql-client-5.5.14 Multithreaded SQL database (client)
mysql-server-5.5.14 Multithreaded SQL database (server)
php5-mysql-5.3.6_1 The mysql shared extension for php
mserver# tail /var/db/mysql/mserver.err
Код: Выделить всё
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 572454 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
111004 13:48:53 mysqld_safe mysqld from pid file /var/db/mysql/mserver.pid ended
Код: Выделить всё
Time Id Command Argument
/usr/local/libexec/mysqld, Version: 5.5.14-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
cat /etc/my.cnf
Код: Выделить всё
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
log=/var/log/mysql.log
bind-address=127.0.0.1
/usr/local/etc/rc.d/mysql-server start
Код: Выделить всё
111005 5:45:06 InnoDB: Waiting for the background threads to start
Как побороть, подскажите, пожалуйста?