Latest Announcemnent
New thread
Status
Not open for further replies.
12 comments
Then we really need the specs of your vps as 100 users is small.

How many connections for each ip and are the players running on your site for each connection??

Are you using some type of music/file convertor to gather the files to play??
 
iam using vps level 4 from hostgator, having 2 ips, none of the files are hosted in the server, no conversion i taken place in the server
 
@cyb3rg33k do cloudflare reduce mysql load, because i get load only from mysql, i just get 1k visitors daily i dont know why this happens...
 
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...
 
Try using a different mysql configuration, `/usr/share/mysql`:
Code: 
 my-huge.cnf
 my-innodb-heavy-4G.cnf 
 my-large.cnf 
 my-medium.cnf
 my-small.cnf
 
dljawed said:
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...
Click to expand...

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.
 
Status
Not open for further replies.
Back
Top