Tagged Questions
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
179 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
1answer
159 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 ...
4
votes
2answers
126 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 ...
