Take the 2-minute tour ×
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.

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
add comment

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.