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
I have a DB of 200Mb
the my.cnf is like this:
Default to using old password format for compatibility with
clients (those using the mysqlclient10 compatibility package).
I really need help… Thanks,