MySQL Performance: MySQL => My dedicated server is to slow... why?

My dedicated server is to slow... why? [message #2635]

Fri, 15 February 2008 05:55

turha
Messages: 3
Registered: February 2008

Junior Member

Hi,

I realy need some help from you. I know notting about configuration of mysql. I recently transfer my website from a share server to a dedicated server and the site its slower. The html pages open fast, but when is needed to get informations from the DB averything freezes. In the share server I could work ok with 50 user conected. In the dedicated server with 20 everything freezes. Is to slow. I don't know what to do.

This are the specifications of my server:

CPU AuthenticAMD, AMD Athlon(tm) XP 2600+
psa v8.0.1_build80060713.16 os_FedoraCore 4
SO Linux 2.6.17-1.2142_FC4smp
ram: 471.21 MB
free ram: 18Mb
buffer: 3.40Mb
Cached: 221Mb

I have a DB of 200Mb

the my.cnf is like this:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with
mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

I really need help... Thanks,

Pedro

Report message to a moderator