optimize my site

[Lock Down]

ERIC

E-elimination
R-reduce it
I-Isolation
C-control

as i reviewed your site, you should use 3rd party file host....thats called elimination
reduce your old data, make schedule
isolate your web from freak ip's
just keep your web activities in your supervisions...

He said he already had a 3rd party file host.

He said it is all Mysql load. So he should install mytop on his vps or run something like mysql-front on his home computer and monitor the processes as they are runing to see which commands are taking the longest or locking the server.

Also consider setting the iptables to allow only 2 connections from each ip. This will bring down the load also lowering needed mysql connections.

Lock Down Reviewed by Lock Down on 12th Jul 2012. optimize my site hello, i get lot of server load from my site http://www.mp3tx.com/, anyone please help me to solve the problem i can pay you, the script is written by me in php, but iam not that much knowledge in php... Rating: 5

[Apathetic]

Try using a different mysql configuration, `/usr/share/mysql`:

 my-huge.cnf
 my-innodb-heavy-4G.cnf 
 my-large.cnf 
 my-medium.cnf
 my-small.cnf

[kkrajdurai]

thank you dljawed