optimize my site

[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

[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.

[kkrajdurai]

thank you dljawed