Where am I wasting resources? How to fix this problem?

[VeeJay]

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