We cache all of our output for 1 second. We have larger values for cache
timeouts for pages that change less often (hourly / daily), but the 1 second
cache allows the proxy web accelerator to serve content without
re-requesting the same thing as two milliseconds ago (reducing concurrent
MySQL acc
Andy Sharp wrote:
>
> Hi,
>
> I'm facing an issue with my primary mySQL server. It powers a web site,
> which loads almost 100% dynamic data. At peak times of the day, it
> seems to me that the Database is becomming maxxed. (Thus bogging the
> site)
>
> I'm aware that there are simply too ma
Two ideas that come immediately to mind--
1) Is the web server on the same machine as MySQL?
2) Have you looked at replication? You could have n slaves/webservers that
display data, and all wrtes go back to the master. There's a rather
detailed analysis in the docs that explain how to figure o
