Wednesday, June 7, 2006

MySql Stored Procedure & query_cache

I was running some benchmarking and testing on MySql MyISAM and InnoDB database engines when I suddenly realized that the queries executed by MySql weren't cached, ie. the qcache_hits variable wasn't hit or get incremented. Apparently, if a stored procedure has one or more parameters (for example, sp_query_not_cache (int i)), the queries are not cached. Hmm.

So that means, not one of Covalentia's many queries to the database will be cached. Oh well.

No comments: