Quote:
|
Originally Posted by marcmac su - zimbra
logmysql
use zimbra_logger;
alter table mta add index i_arrive_time (arrive_time);
alter table amavis add index i_arrive_time (arrive_time);
alter table mta_aggregate add index i_period_start (period_start);
alter table mta_aggregate add index i_period_end (period_end);
alter table amavis_aggregate add index i_period_start (period_start);
alter table amavis_aggregate add index i_period_end (period_end); |
Yeah, that fixed it. It used to take 2 minutes at 100% processor. Now it takes 3 seconds at 7%.
Thanks for the quick turnaround.
bp