We had 40,000 on our site, we now have 350,000 on it. Since we added that many links linkssql can not handle the load. I am unable to preform admin functions, and no one can add a site to it through the web site.
I asked our server admin (we have a dedicated server specs of test are below) -what the problem was their response was
"That script is a hog (using 90.7% and 17.0% of all CPU resources), and is just taking forever to read in/process data from the MySQL database."
How do we get it to move faster? Its killing our traffic that the linkssql can't handle this big of a database - any ideas????
[server info]
443 processes: 1 running, 441 sleeping, 1 zombie
CPU states: 3.9% user, 0.0% nice, 2.5% system, 0.4% interrupt, 93.2% idle
Mem: 107M Active, 23M Inact, 66M Wired, 2780K Cache, 112M Buf, 806M Free Swap: 512M Total, 512M Free
Basically, you've got 800 MB of RAM free out of 1 GB, and both processors stay between 80% and 95% idle.
thanks
pelslvr
I asked our server admin (we have a dedicated server specs of test are below) -what the problem was their response was
"That script is a hog (using 90.7% and 17.0% of all CPU resources), and is just taking forever to read in/process data from the MySQL database."
How do we get it to move faster? Its killing our traffic that the linkssql can't handle this big of a database - any ideas????
[server info]
443 processes: 1 running, 441 sleeping, 1 zombie
CPU states: 3.9% user, 0.0% nice, 2.5% system, 0.4% interrupt, 93.2% idle
Mem: 107M Active, 23M Inact, 66M Wired, 2780K Cache, 112M Buf, 806M Free Swap: 512M Total, 512M Free
Basically, you've got 800 MB of RAM free out of 1 GB, and both processors stay between 80% and 95% idle.
thanks
pelslvr