Where am I wasting resources? How to fix this problem?
VeeJay
maanjee at gmail.com
Tue Apr 28 09:38:08 UTC 2009
Hi folks
then if I check with the process: I get following output:
# ps ax | grep mysqld
797 con- I 0:00.00 /bin/sh /usr/local/bin/mysqld_safe
--defaults-extra-file=/var/db/mysql/my.cnf --user=mysql
--datadir=/var/db/mysql --pid-file=/var/db/mysql/localhost.server1.pid
835 con- S 8:17.81 /usr/local/libexec/mysqld
--defaults-extra-file=/var/db/mysql/my.cnf --basedir=/usr/local
--datadir=/var/db/mysql --pid-file=/var/db/mysql/localhost.server1.pid
--port=3306 --
I am running FreeBSD, Apache, MySQL on a Dell PowerEdge 2950 III having 2 x
CPU 3,0 GHz Intel Xeon L5450 Quad-Core 2x6MB cache WITH 16 GB RAM
Below is the output from my my.cnf, may be that can help to fix this
problem:
-------------------------------------start
# The following options will be passed to all MySQL clients
[client]
port = 3306
socket = /tmp/mysql.sock
default-character-set=utf8
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 1024M
max_allowed_packet = 16M
table_cache = 1024
sort_buffer_size = 3M
read_buffer_size = 12M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
user=mysql
set-variable=local-infile=0
init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
default-character-set=utf8
character-set-server = utf8
collation-server = utf8_general_ci
bind-address=127.0.0.1
skip-innodb
skip-name-resolve
default-storage-engine = MyISAM
wait_timeout = 60
log_slow_queries = /var/db/mysql/mysqld.slow.log
long_query_time=3
log-queries-not-using-indexes
connect_timeout=10
join_buffer=3M
max_connections = 2000
query_cache_type = 1
query_cache_limit = 2M
query_cache_size = 128M
skip-name-resolve
thread_cache_size = 8
thread_concurrency = 8
interactive_timeout=100
join_buffer_size=2M
key_buffer_size=1024M
max_connect_errors=1000
ft_min_word_len=2
ft_max_word_len=15
skip-networking
log-bin=mysql-bin
expire_logs_days=7
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
default-character-set=utf8
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
-------------------------------------end
--
Thanks!
BR / vj
More information about the freebsd-questions
mailing list