Tagged Questions
1
vote
1answer
57 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.
...
1
vote
1answer
173 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 ...
4
votes
1answer
124 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 < ...
