[Secureideas-base-devel] Re: [Secureideas-base-user] re: Base has become unuseable. (Jacob, Raymond A Jr) some success

[Michael S. <ms...@ma...>]

On Tue, Apr 04, 2006 at 02:28:14PM -0400, Jacob, Raymond A Jr wrote:
>I turned on slow-query-log and found that when base fired up,
>the Refresh Stat directive in the html along with the other
>queries that start when the page opened caused the CPU to Max
>out. So turned off Refresh Stat and autoupdate cache in the
>base_conf.php.

That's definately a prerequisite for large installations.

>Checking the machineName-slow.log. I found the query
>SELECT COUNT(DISTINCT acid_event.ip_src, acid_event.ip_dst, acid_event.ip_proto) FROM acid_event;
>took 340 secs(5:40 mins) at a minimum. 

Check out main_page_detail and show_summary_stats in base_conf.php; 
setting them to 0 will avoid those huge queries, which are 
non-optimizable and fairly useless for a large database. 

Mike Stone


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Secureideas-base-user mailing list
Sec...@li...
https://lists.sourceforge.net/lists/listinfo/secureideas-base-user