Ewen thank you! You've opened my eyes to something I didn't even know about and made my "special purpose" tingle.
Have you used Percona personally? What are your opinions/thoughts? If you haven't used it, I'd be curious why not or what turned you "away" from it? > -----Original Message----- > From: Ewen Fortune [mailto:ewen.fort...@gmail.com] > Sent: Thursday, November 18, 2010 4:56 AM > To: Daevid Vincent > Cc: mysql > Subject: Re: Does mysql cache strip out /* comments */ first? > > Daevid, > > <snip> > > My concern is, my gut tells me that the built in mysql > cache system is > > "dumb". And by that I mean, I suspect that mySQL isn't > "smart" enough to > > strip out comments from the SQL statement string BEFORE > storing it as the > > cache hash key (yet I have no facts either way to back it > up and hence the > > reason for this email). > > > > http://dev.mysql.com/doc/refman/5.0/en/query-cache.html > > http://dev.mysql.com/tech-resources/articles/mysql-query-cache.html > > > > Can anyone please tell me I'm wrong and that it is smarter > than I give it > > credit for, as I think this would be a very useful > "feature" (or bug-fix as > > the case may be). > > Your suspicions are correct, the query cache does not strip comments > before storing the statement. > > This can however be done in the Percona build. > > http://www.percona.com/docs/wiki/percona-server:features:query > _cache_enhance#query_cache_strip_comments > http://www.percona.com/docs/wiki/percona-server:features:imple mentation_details:details_query_cache_with_comments > > Cheers, > > Ewen > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
