[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