Daevid, On Thu, Nov 18, 2010 at 11:41 PM, Daevid Vincent <dae...@daevid.com> wrote: > 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?
I work for Percona :o) So I think its best someone else chips in. Ewen > >> -----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