Our cluster is suffering from extremely high disk read rates, resulting in hight disk wait times.
We’re investigating how much is due to slow storage…
However, this has raised a couple of points of interest
how do I work out which tables are being read – are there stats available per table for disk i/o ?
Does Singlestore allow the o/s to cache database file data ? (ie: does it use O_DIRECT or…)
How can I improve the caching of whatever is causing the high disk reads ?