Docker: Percona how to populate thesql server with initial data

dockerpercona

I have created percona container in the following way:

docker run –name=sql -v
/path/to/dump:/tmp/dump:ro -d -e MYSQL_ALLOW_EMPTY_PASSWORD=True -e MYSQL_DATABASE=config percona:5.6 mysqld
–max-allowed-packet=100M

Where the /tmp contains all data I need for restoring the dump. But I am getting error when trying to:

docker exec 75c4b8880156
/usr/bin/mysql -uroot config < /tmp/dump/performance_db.sql

bash: /tmp/dump/performance_db.sql: No such file or directory

Even despite the fact that the file is there:

$ docker exec 75c4b8880156 ls /tmp/dump/

performance_db.sql

And I can even less/tail the content 🙁

Best Answer

I suggest you to use the db initialization method recommended by Percona Docker image docs, "Initializing a fresh instance" section: put your init script in a directory mounted as /docker-entrypoint-initdb.d.

Related Solutions

Docker – How to override CMD when running a docker image

You could just enter via docker run -it --entrypoint=/bin/bash $IMAGE -i (you 'll launch a new container from the image and get a bash shell in interactive mode), then run the entrypoint command in that container.

You can then inspect the running container in the state it should be running.

EDIT: Since Docker 1.3 you can use exec to run a process in a running container. Start your container as you 'd normally do, and then enter it by issuing:

docker exec -it $CONTAINER_ID /bin/bash

Assuming bash is installed you will be given shell access to the running container.

Linux – 99% disk IO spikes with Percona

Which version of MySQL server do you use? After 5.5 you can use the performance_schema to get realtime statistics from the database. I'd start querying the

 table_io_waits_summary_by_table
 table_io_waits_summary_by_table
 table_lock_waits_summary_by_table

to see what is happening exactly.

An another solution would be if you check the buffer pool usage, it is not possible, that there are cold pages which needed to move to memory?

Best Answer

Related Solutions

Docker – How to override CMD when running a docker image

Linux – 99% disk IO spikes with Percona

Related Topic