Public | Automated Build

Last pushed: a month ago
Short Description
run memsql analyze on all tables in all databases
Full Description

memsql-analyze-tables

simple container that runs analyze tables on all tables in all schemas (excluding the 'information_schema', "memsql" and "sharding schemas) in memsql.
docker version can be found at docker hub at https://hub.docker.com/r/vidazoohub/memsql-analyze-tables/

requires the following envvars:

HOST = memsql master host
PORT = memsql port
USER = memsql user
PASSWORD = memsql password

the container will run on all tables on all databases (excluding the 'information_schema', "memsql" and "sharding schemas) in the memsql master host it's pointed to and will proceed to exit with code 0 if everything ok and another code otherwise so it's easy to use as a cronjob or a metronome (DC/OS) job as in the example below:

{
  "id": "memsql-analyze-tables-weekly",
  "run": {
    "cmd": "docker pull vidazoohub/memsql-analyze-tables:latest && docker run --rm -e HOST=memsql-example-master.exampledomain.com -e PORT=3306 -e USER=root -e PASSWORD=examplepass vidazoohub/memsql-analyze-tables:latest",
    "cpus": 0.1,
    "mem": 512,
    "disk": 100
  },
  "schedules": [
    {
      "id": "default",
      "enabled": true,
      "cron": "0 5 * * 6",
      "timezone": "UTC",
      "concurrencyPolicy": "ALLOW",
      "startingDeadlineSeconds": 600
    }
  ]
}
Docker Pull Command
Owner
vidazoohub
Source Repository

Comments (0)