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.
It looks like this: mysql> show status like 'Qcache_q%'; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | Qcache_queries_in_cache | 2 | +-------------------------+-------+ 1 row in set (0.00 sec) mysql> create table inn(a int) type=innodb; Query OK, 0 rows affected (0.01 sec) mysql> insert into inn values(1); Query OK, 1 row affected (0.00 sec) mysql> commit; Query OK, 0 rows affected (0.01 sec) mysql> select * from inn; +------+ | a | +------+ | 1 | +------+ 1 row in set (0.00 sec) mysql> show status like 'Qcache_q%'; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | Qcache_queries_in_cache | 2 | +-------------------------+-------+ 1 row in set (0.00 sec) And with myisam: mysql> show status like 'Qcache_q%'; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | Qcache_queries_in_cache | 2 | +-------------------------+-------+ 1 row in set (0.00 sec) mysql> create table myi(a int); Query OK, 0 rows affected (0.00 sec) mysql> insert into myi values(1); Query OK, 1 row affected (0.00 sec) mysql> select * from myi; +------+ | a | +------+ | 1 | +------+ 1 row in set (0.00 sec) mysql> show status like 'Qcache_q%'; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | Qcache_queries_in_cache | 3 | +-------------------------+-------+ 1 row in set (0.00 sec) -- Magnus --------------------------------------------------------------------- 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
