The purpose for this question is we need to benchmark MemSQL performance in various workloads with different query and/or memsql optimization settings. So we need to avoid the impact from data caching from MemSQL.
The closest thing for this purpose I find out so far is drop all from plancache. But this from its words sounds like it only clear the compiled execution plans from MemSQL, not data cache itself. The MySQL cache clearing commands do not work on MemSQL.
Any idea?
What sorts of data caching are you interested in clearing?
To help me understand what types of cache clearing you are interested in, which MySQL cache clearing commands were you trying to use?
MemSQL doesn't do much caching of data. The main one is caching columnstore data in memory. If you want to test the performance of queries against cold data on disk, you can flush the disk cache with:
echo 3 | sudo tee /proc/sys/vm/drop_caches