Performance Issues

[David P]

Hello,

I use Xampp 1.6.3a with mysql 5.0.45 and I don; seem to be able to tune mysql server correctly.

Everything is working fine but I can see:-

- Created_tmp_disk_tables growing - currently at 1,911 after 2 days running
- Opened_tables growing - currently at 3,189 while open_tables is at 29!

See my my.cnf file below.

Any idea what I should do?

Thanks


skip-locking
key_buffer = 128M
max_allowed_packet = 16M
table_cache = 2000
sort_buffer_size = 128M
read_buffer_size = 16M
read_rnd_buffer_size = 1M
net_buffer_length = 2K
thread_stack = 64K
thread_cache = 32
query_cache_type = 1
query_cache_limit = 2M
query_cache_size = 64M
tmp_table_size = 384M
max_heap_table_size = 384M

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (using the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
server-id = 1

# Uncomment the following if you want to log updates
#log-bin=E:/xampp/mysql/data/mysql-bin

# Uncomment the following if you are NOT using BDB tables
skip-bdb

skip-innodb
[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
[isamchk]
key_buffer = 64M
sort_buffer = 64M
sort_buffer_size = 128M
read_buffer = 16M
write_buffer = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
sort_buffer_size = 128M
read_buffer = 16M
write_buffer = 16esieens

Posts: 3
Joined: 20. February 2010 20:44
Private message