Re: MySQL with SSD/HDD

[Rick James]

> Is it possible to tell MySQL not to use buffer pool for some queries?

No. ALL activity in InnoDB uses the buffer_pool. This is built into the design.

> read all product entries (at least the hash-column) once a day

I interpret that to mean that you read the entire table daily, and you read it _randomly_. If the entire table fits in 26GB, the table will be pulled into the buffer pool in less than a day, then it will sit there forever. That is, there will be I/O for several hours, then no I/O. SSDs would speed up requests for the first few hours, then be of no benefit.

> Our database contains a large amount of products

If this means that more than 26GB of data/indexes is touched (in, say, a day), then SSDs could be beneficial. That is, my comment above would not apply.

Let the mysql run for at least 2 days, then show me these:
SHOW VARIABLES;
SHOW GLOBAL STATUS;
I should be able to deduce a number of things from the thousand lines of output you get. (Just paste it into this forum.)