Re: CHECKSUM TABLE too slow on InnoDB engine
I've tried to debug some code and it looks like the checksum calculation is never added to the query cache. (see sql_parse.cc at case SQLCOM_CHECKSUM compared to a normal SELECT in case SQLCOM_SELECT).
I'm not sure if this is a bug or a design issue. For me it would help if I somehow could wrap the CHECKSUM TABLE into something that would make it be included in the query cache.
An alternative solution would be if it was possible to get the timestamp the table was last updated.
Subject
Views
Written By
Posted
2918
May 30, 2008 07:03AM
Re: CHECKSUM TABLE too slow on InnoDB engine
1735
June 03, 2008 02:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.