[kronolith] Re: [imp] MySQL performance tuning.

[Chuck Hagenbuch]

Quoting Christopher Crowley <ccrowley@tulane.edu>:

> I added the following to my /etc/my.cnf file:
> 
> log-slow-queries
> log-long-format

Thanks for the tip; I've added this in my dev installation too.

> create index calendar_id_idx on kronolith_events (calendar_id(8));

I've added this one to CVS, too (though, by default, the whole thing, since
some dbs don't support partial indices). Keep 'em coming!

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
"After a few minutes the most aromatic and nice smelling Italian coffee 
 will come out of the exhaustpipe." - Our stove-top espresso pot