We several relatively high traffic sites (averaging several thousand unique visitors per day) and have major performance issues loading the graphs on the front page. We are willing to provide a scrubbed snapshot of our MySQL database for testing purposes or will even investigate bugs if anyone has suggestions of places to start.
We work in a Solaris virtualized environment running a custom built latest version of the apache and php. Please see attached documents for a sample of the failed index page and the load on the server when attempting to access it.
Can we assume you're using 0.2.34 and you've disabled enable_browser_archiving_triggering and are using a cron job for archiving?
I wasn't aware of the archiving cron option; I will try it and post the results. Thanks!
There seems to be a random segmentation fault with PHP on Solaris 10. It happened more frequently on release 11/08 but is still appearing in 05/09. I will report if I can find anything.