Percona's got a great reputation in the community, and I would have no qualms using their builds.
On 11/18/10, Ewen Fortune <ewen.fort...@gmail.com> wrote: > 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=waynn...@gmail.com > > -- Sent from my mobile device ______________________________________________ Waynn Lue 626.429.6412 | waynn...@gmail.com Facebook: www.facebook.com/waynn LinkedIn: www.linkedin.com/in/waynn ______________________________________________ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
