MemSQL on Debian – small notes

For installation requires at least 4 CPUs and 16 GB of RAM and for a good reason. If you have for example 10 GB of mysql data and you want to feed it into MemSQL you will need at least 15 GB of RAM just for these data. config files – in subdirectories of the...

MEMSQL – small notes

Small notes: MemSQL is compatible with MySQL client. You can connect to MemSQL from any DB GUI or programming language which already can connect to MySQL. MemSQL does NOT have stored procedures, foreign keys, integrity constrains MemSQL HAS window functions and...

MemSQL – commands cheat sheet

MemSQL SQL reference Every command can end with “;” (columns all in one row) or “\G” (every column on separate row). CREATE TABLE: SHARD KEY – sets column(s) for partitioning KILL: kill [ connection | query ] thread_id KILLALL: killall...