I am having some performance tests with different MemSQL data warehouse architectures and I faced 2 problems:
After executing a query, the server stores the result in cache memory and the query times fall considerably to later runs of the same query. Is there any way to clear the cache memory in MemSQL? (DROP ALL FROM PLANCACHE)?
For query manipulation, do you use MemSQL Studio or another tool? it is somewhat unproductive to have only one space for queries. I was able to connect to the MySQL Workbench and it improved a bit, however, it does not recognize reserved words from MemSQL itself.
I’m testing rowstore, columnstore, different fields for shard keys, normalization. How big is the amount of techniques in MemSQL, in your opinion, what other possibilities can be tested for modeling?