Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My MVC framework (CodeIgniter) wants to know where my database (mysql 5.5) writes its query cache. My Ubuntu installation is unexceptional. Would that be /var/lib/mysql/ or further down the chain, even down to the dir that holds the particular db files? TIA

share|improve this question
3  
Query cache is in memory. Perhaps you are referring to something else? – ypercubeᵀᴹ May 9 '13 at 10:26
1  
CodeIgniter stores queries on disk and calls this the "query cache.“ This is unrelated to the MySQL query cache: ellislab.com/codeigniter/user-guide/database/caching.html... – Michael - sqlbot May 9 '13 at 12:26
    
Thanks very much. In my defense, I posted this question here only after I spent three hours reading the mysql manual and on CI's forums and irc trying to get this cleared up. In ...user_guide/database/configuration.html it was less clear to me. There it says, "cachedir - The absolute server path to your database query cache directory," and there was no mention in mysql manuals about a query cache location (didn't say that it's in memory, either), though it did mention index caches. – Shellsunder May 9 '13 at 15:58

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.