MySQL Forums
Forum List  »  InnoDB

Re: CHECKSUM TABLE too slow on InnoDB engine
Posted by: Lennart Schedin
Date: June 03, 2008 02:08AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
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.