Hi! On Dec 16, Magnus Enbom wrote: > Hi, > > I'm trying out the new query cache features in mysql4. > Are the cache supposed to work with innodb tables? It's not according to the > output of show status, works fine with myisam tables. > I'm ran a 'bk pull -l' this morning and compiled with Suns cc on a Solaris-x86 > box.
As far as I know - though I can be wrong here - first version of query cache does not work with transaction-safe tables (or it works only when autocommit is on). Rules for invalidating cache entries are more complex when transactions are involved, so first Sanja will make the basic query cache logic to work, and then he will add support for transaction-safe tables. Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
