MySQL Performance Tuning

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL Performance Tuning

Postby esieens » 26. February 2010 07:23


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?


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!
server-id = 1

# Uncomment the following if you want to log updates

# Uncomment the following if you are NOT using BDB tables


key_buffer = 64M
sort_buffer = 64M
sort_buffer_size = 128M
read_buffer = 16M
write_buffer = 16M

key_buffer = 64M
sort_buffer = 64M
sort_buffer_size = 128M
read_buffer = 16M
write_buffer = 16
Posts: 3
Joined: 20. February 2010 20:44

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 78 guests