• 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 directory “/var/lib/memsql”
    • master-3306
    • leaf-3307
    • etc
  • set memory limitations example:
    • set global maximum_memory = 20480;
    • set global maximum_table_memory = 18432;
  • community edition does not allow you to create new users – you will get error message “Feature ‘CREATE USER’ is only available in MemSQL Enterprise Edition.”