Quote:
Originally Posted by nestle
Something like:
Code:
UPDATE site_table SET columnCounter = columnCounter + 1 WHERE siteID = 2134;
What else is that Sempron box doing (or approx how many selects are being done?) and what's the average load on high-traffic periods? You sure it's mysql that is hitting the bottleneck? If a web server is being hosted on the same server, that could be it as well. |
It's serving up to 250K pages/day, all dynamic (php & mysql select) w/ mod_rewrite plus a C app runs about 10 times for each page. Serving a page to a SE bot takes 3-6 seconds. Mysql seems to use most of the RAM, followed by Apache.
A bigger server is overdue, but I wondered if I should even plan to include the hit tracking on the same server. Sounds like it should work from what you say.