[dev] horde/scripts/alarms.php

Matt Selsky selsky at columbia.edu
Mon Jul 21 07:40:04 UTC 2008


> Is there any chance that the speed of running the alarms.php script can
> be further increased?
>
> On my system it takes about 2 min. to run:
> real    1m55.010s
> user    0m40.431s
> sys     0m2.496s
>
> if this is running every 5 min. then the system is almost just doing
> the alarms job.

What does "SHOW GLOBAL STATUS LIKE 'Com_stmt_%';" show now?  If you  
run EXPLAIN on the SELECT queries that alarms.php runs, does it show  
all of the indexes being used?  Does the script still take 2 full  
minutes to run?


-- 
Matt


More information about the dev mailing list