Re: QUERY cache not used with restricted privileges ?
The Query Cache and VIEWs were each hastily implemented (years ago). So, it would not surprise me if VIEWs bypass the QC. This would 'explain' the timings you saw.
Since there are several caches, I modified the 'Subject' to make it clear which cache you were talking about. The innodb_buffer_pool_size is of modest size; that is the main cache you will be using when not using the Query Cache.
It would take more work to validate user2, since it has to check which tables are in the query, and which tables user2 is allowed to see, but I would not expect 40ms on each query. (I would expect virtually 0 ms.)
But, alas, none of this really answers your question. I suggest you move on, and leave this as an unsolved (and hopefully not critical) mystery.
Subject
Views
Written By
Posted
1700
April 30, 2013 02:44AM
Re: QUERY cache not used with restricted privileges ?
814
May 03, 2013 09:32AM
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.