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™ 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