# My dedicated server is to slow... why? **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [February 15, 2008, 5:25am UTC](https://forums.percona.com/t/my-dedicated-server-is-to-slow-why/637 "2008-02-15T05:25:36Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![turha](https://avatars.discourse-cdn.com/v4/letter/t/9fc348/32.png) [@turha](https://forums.percona.com/u/turha)\ **Post date:** [February 15, 2008, 5:25am UTC](https://forums.percona.com/t/my-dedicated-server-is-to-slow-why/637/1 "2008-02-15T05:25:36Z")
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 ---
**Author:** ![sterin](https://avatars.discourse-cdn.com/v4/letter/s/3ab097/32.png) [@sterin](https://forums.percona.com/u/sterin)\ **Post date:** [February 16, 2008, 9:09am UTC](https://forums.percona.com/t/my-dedicated-server-is-to-slow-why/637/2 "2008-02-16T09:09:39Z")
Are you using MyISAM or InnoDB tables? If you are using MyISAM then start by adding: key\_buffer\_size=70M To your [mysqld] section and restart. _OR_ if you are using InnoDB then add: innodb\_buffer\_pool\_size=200M to the [mysqld] section and restart. Because the default values for these are very small. Then come back and say if it made any difference. ---
**Author:** ![turha](https://avatars.discourse-cdn.com/v4/letter/t/9fc348/32.png) [@turha](https://forums.percona.com/u/turha)\ **Post date:** [February 16, 2008, 6:00pm UTC](https://forums.percona.com/t/my-dedicated-server-is-to-slow-why/637/3 "2008-02-16T18:00:01Z")
Hi Sterin, thanks for your reply. I had to point back the dns to the shared server because it was impossible to work in the dedicated one. So now I can’t test it with real users. Before I redirect again the Domain I will past here the “show variables” for you to see if there are other values that I should set up and configure, and after that I Will make the redirection of dns back to the dedicated server. ## Thanks show variables: | | join\_buffer\_size | 131072 | | key\_buffer\_size | 8388600 | | key\_cache\_age\_threshold | 300 | | key\_cache\_block\_size | 1024 | | key\_cache\_division\_limit | 100 | | language | /usr/share/mysql/english/ | | large\_files\_support | ON | | license | GPL | | local\_infile | ON | | locked\_in\_memory | OFF | | log | OFF | | log\_bin | OFF | | log\_error | | | log\_slave\_updates | OFF | | log\_slow\_queries | OFF | | log\_update | OFF | | log\_warnings | 1 | | long\_query\_time | 10 | | low\_priority\_updates | OFF | | lower\_case\_file\_system | OFF | | lower\_case\_table\_names | 0 | | max\_allowed\_packet | 1048576 | | max\_binlog\_cache\_size | 4294967295 | | max\_binlog\_size | 1073741824 | | max\_connect\_errors | 10 | | max\_connections | 100 | | max\_delayed\_threads | 20 | | max\_error\_count | 64 | | max\_heap\_table\_size | 16777216 | | max\_insert\_delayed\_threads | 20 | | max\_join\_size | 4294967295 | | max\_length\_for\_sort\_data | 1024 | | max\_prepared\_stmt\_count | 16382 | | max\_relay\_log\_size | 0 | | max\_seeks\_for\_key | 4294967295 | | max\_sort\_length | 1024 | | max\_tmp\_tables | 32 | | max\_user\_connections | 0 | | max\_write\_lock\_count | 4294967295 | | myisam\_data\_pointer\_size | 4 | | myisam\_max\_extra\_sort\_file\_size | 2147483648 | | myisam\_max\_sort\_file\_size | 2147483647 | | myisam\_recover\_options | OFF | | myisam\_repair\_threads | 1 | | myisam\_sort\_buffer\_size | 8388608 | | myisam\_stats\_method | nulls\_unequal | | net\_buffer\_length | 16384 | | net\_read\_timeout | 30 | | net\_retry\_count | 10 | | net\_write\_timeout | 60 | | new | OFF | | old\_passwords | ON | | open\_files\_limit | 1024 | | pid\_file | /var/run/mysqld/mysqld.pid | | port | 3306 | | preload\_buffer\_size | 32768 | | prepared\_stmt\_count | 0 | | protocol\_version | 10 | | query\_alloc\_block\_size | 8192 | | query\_cache\_limit | 1048576 | | query\_cache\_min\_res\_unit | 4096 | | query\_cache\_size | 0 | | query\_cache\_type | ON | | query\_cache\_wlock\_invalidate | OFF | | query\_prealloc\_size | 8192 | | range\_alloc\_block\_size | 2048 | | read\_buffer\_size | 131072 | | read\_only | OFF | | read\_rnd\_buffer\_size | 262144 | | relay\_log\_purge | ON | | relay\_log\_space\_limit | 0 | | rpl\_recovery\_rank | 0 | | secure\_auth | OFF | | server\_id | 0 | | skip\_external\_locking | ON | | skip\_networking | OFF | | skip\_show\_database | OFF | | slave\_net\_timeout | 3600 | | slave\_transaction\_retries | 0 | | slow\_launch\_time | 2 | | socket | /var/lib/mysql/mysql.sock | | sort\_buffer\_size | 2097144 | | sql\_mode | | | sql\_notes | ON | | sql\_warnings | ON | | storage\_engine | MyISAM | | sync\_binlog | 0 | | sync\_frm | ON | | sync\_replication | 0 | | sync\_replication\_slave\_id | 0 | | sync\_replication\_timeout | 0 | | system\_time\_zone | WET | | table\_cache | 64 | | table\_type | MyISAM | | thread\_cache\_size | 0 | | thread\_stack | 196608 | | time\_format | %H:%i:%s | | time\_zone | SYSTEM | | tmp\_table\_size | 33554432 | | tmpdir | | | transaction\_alloc\_block\_size | 8192 | | transaction\_prealloc\_size | 4096 | | tx\_isolation | REPEATABLE-READ | | version | 4.1.20 | | version\_bdb | Sleepycat Software: Berkeley DB 4.1.24: (May 24, 2006) | | version\_comment | Source distribution | | version\_compile\_machine | i386 | | version\_compile\_os | redhat-linux-gnu | | wait\_timeout | 28800 | ±--------------------------------±------------------------ -------------------------------+ 195 rows in set (0.00 sec)