List:General Discussion« Previous MessageNext Message »
From:Waynn Lue Date:November 19 2010 1:23am
Subject:Re: Does mysql cache strip out /* comments */ first?
View as plain text  
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.fortune@stripped> wrote:
> Daevid,
>
> On Thu, Nov 18, 2010 at 11:41 PM, Daevid Vincent <daevid@stripped> 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.fortune@stripped]
>>> 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=1
>
>

-- 
Sent from my mobile device

______________________________________________

Waynn Lue
626.429.6412 | waynnlue@stripped
Facebook: www.facebook.com/waynn
LinkedIn: www.linkedin.com/in/waynn
______________________________________________
Thread
Does mysql cache strip out /* comments */ first?Daevid Vincent18 Nov
  • Re: Does mysql cache strip out /* comments */ first?Johan De Meersman18 Nov
    • RE: Does mysql cache strip out /* comments */ first?andrew.2.moore18 Nov
      • Re: Does mysql cache strip out /* comments */ first?Johan De Meersman18 Nov
  • Re: Does mysql cache strip out /* comments */ first?Ewen Fortune18 Nov
    • RE: Does mysql cache strip out /* comments */ first?Daevid Vincent18 Nov
      • Re: Does mysql cache strip out /* comments */ first?Ewen Fortune18 Nov
        • Re: Does mysql cache strip out /* comments */ first?Waynn Lue19 Nov