Building Container
| Code Block | ||||
|---|---|---|---|---|
| ||||
CONTAINER=mysql
IMAGE=mysql:5.5.59
docker stop $CONTAINER
docker rm $CONTAINER
#docker rmi $IMAGE
docker run -d \
--restart=always \
-p 3306:3306 \
--name $CONTAINER \
-v /share/Volume/CONTAINERS/mysql/conf:/etc/mysql \
-v /share/Volume/CONTAINERS/mysql/data:/var/lib/mysql \
-e MYSQL_DATABASE=mydb \
-e MYSQL_ROOT_PASSWORD=xxx \
$IMAGE
docker logs -f $CONTAINER |
Optimize Database
> mysqlcheck -o <database>
> mysqlcheck -o mydb
| Code Block |
|---|
mydb.authorized |
Optimize Database
> mysqlcheck -o <datbase>
ex:
> mysqlcheck -o diabetease
| Code Block |
|---|
diabetease.authorized Table is already up to date diabetease.authrequest Table is already up to date diabetease.dbinfo Table is already up to date diabetease.dbvar OK diabetease.event OK diabetease.groups Table is already up to date diabetease.job Table is already up to date diabetease.meter mydb.authrequest Table is already up to date diabetease.patient_info Table is already up to date diabetease.report OK diabetease.results OK diabetease.results_archive1 OK diabetease.results_archive2 OK diabetease.secretKeys mydb.dbinfo OK diabetease.uploadhistory Table is already up to date diabeteasemydb.user dbvar OK diabeteasemydb.user_infoevent OK diabetease.user_pref OK diabetease.week_avg OK |