Tagged Questions
0
votes
0answers
15 views
Should store procedure cached in Mysql
Should store procedure cached in Mysql? If yes, How long it is stay in cache?
In my case, When I call one store procedure first time, It is giving me result in 1sec, after that it gives me result in ...
0
votes
0answers
21 views
Req: Typical location of mysql query cache
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, ...
0
votes
1answer
43 views
If MySQL isn't caching, then what is?
I ran a few commands to see whether MySQL is caching queries/result sets. It looks like this is not the case.
mysql> show variables like 'query_cache_size';
--------------
show variables like ...
1
vote
1answer
56 views
Does MySQL's MyISAM use cache before insert?
I want to test two different Disks, one of them is HDD and another is SSD
I use exactly same information and app for both servers. They are exactly same, just one of them is SSD and another is HARD.
...
0
votes
1answer
141 views
Qcache_free_memory not full yet I get alot of Qcache_lowmem_prunes
I just started dabbling with query cache for our CMS.
Can anyone tell me why (or at least a good guess) I get alot of Qcache_lowmem_prunes when more than half of Qcache_free_memory is free?
...
2
votes
1answer
366 views
query_cache_type = 0 vs query_cache_type = 1
Recently, I moved from standard MySQL to Percona, and used the Percona Wizard to generate my.cnf.
However, I can see that, by default, the generated settings for my.cnf use query_cache_type = 0. ...
1
vote
1answer
169 views
MySQL: To use MYISAM or INNODB engine? (plot twist enclosed)
We use INNODB for all of our tables, but I have one special table, a 100+ GB reference table (only read-queries against it).
We are loading changes to this table in a nightly batch job using LOAD ...
1
vote
2answers
130 views
Cache all mysql table
Maybe it sound's like i'm an idiot... But i'm developing app with huge db on RoR. Also i see that if i do some query and after that do it one more it is doing much faster, becouse it has been ...
5
votes
2answers
192 views
mysql performance / cache configuration enigma [closed]
I have two mysql 5.1 instances (say A, B) hosting the same database schema. If I run (with mysql workbench) the same query on both instances I don't understand why I get very different response times ...
4
votes
1answer
123 views
Can I partially invalidate the MySQL table cache?
I want to set a fairly large table to MyISAM mode to keep it cached proactively. The table file is approximately 3GB.
After several hours, MySQL invalidates the entire table from cache, while < ...
7
votes
2answers
699 views
Is the overhead of frequent query cache invalidation ever worth it?
I'm currently working on a MySQL database where we are seeing a large number of invalidations from the query cache, primarily because of the high number of INSERT, DELETE and UPDATE statements that ...
1
vote
1answer
157 views
Mysql: Tell InnoDB to keep a specific table or database out of pool/cache?
I have some tables that are used primarily to keep historical data, or that are only used once a day.
I do not want any operations on these tables to disrupt the more important tables present in ...
1
vote
1answer
68 views
how to use mysql temporal cache tables
I took this example from a book where visitors_today is the cache table from visitor_stored. The idea is to store all the visitors per day (visitors_stored) using a cache table.
Create table ...
3
votes
2answers
203 views
MySQL cache is not getting hit by subqueries
I noticed something weird on MySQL query_cache behavior and I would like to know if this is a normal behavior.
Let's say I have an item table
ID | Item
-----------
1 | Item_1
2 | Item_2
3 | ...
0
votes
1answer
90 views
getting error while installing memcached_function
now i am working with memcached with mysql cluster 7.2
for that i am installed
libevent-1.4.14b-stable.tar.gz
memcached-1.4.5.tar.gz
libmemcached-0.8.tar.gz
then
...
4
votes
2answers
125 views
MySQL: Is it safe to have a table with multiple millions of rows?
I have a very complex search query to write that will touch many tables, have conditions and joins. For efficiency reasons, I am strongly considering creating a "cache table" where I would maybe once ...
1
vote
1answer
198 views
MySQL: How do I limit or prevent caching for specific tables?
I'm currently working on a database schema for tables to hold user information on a website with integrated forums.
Right now my idea is to have all the data in two separate tables: one table with ...
3
votes
5answers
2k views
Why is MySQL caching data on our dynamic PHP site?
We are having an annoyance with our PHP/MySQL site in that it seems to cache data from the database and our PHP pages are showing out of date records. In fact, there are pages that link to URLs that ...
