title: unable to import large database to docker mysql container
body: <p>I'm trying to import a large database to a mysql container. I've mounted host directories as volumes for the mysql container. So the data is persistent on host. The importing sql file is <code>14 GB</code>+. The mysql container becomes unresponsive half way of through importing. When I run <code>docker stats</code> I can see the <code>CPU %</code> usage becomes <code>&lt; 1</code> once mysql container ate all the memory available. I tried increasing memory of docker up to <code>10 GB</code> and It creates more tables from import when I allocate more memory to Docker. But I cannot allocate more than <code>10GB</code> from host.</p>
  
  <p>Following is my <code>docker-compose.yml</code> file</p>
  
  <pre><code>mysql:
      image: mysql:5.6
      environment:
          - MYSQL_ROOT_PASSWORD=12345678
      volumes:
          - ./mysql/lib:/var/lib/mysql
          - ./mysql/conf.d:/etc/mysql/conf.d
          - ./mysql/log:/var/log/mysql
          - /tmp:/tmp
      ports:
          - "3306:3306"
  </code></pre>
  
  <p>I'm using <code>Docker for mac</code> which has docker version <code>1.12.1</code></p>
  
  <p>I was using <code>docker exec -it docker_mysql_1 /bin/bash</code> to login to container and import the sql file from <code>/tmp</code></p>
  
  <p>Also I tried the way recommended by mysql repo by mounting sql file to <code>/docker-entrypoint-initdb.d</code>. But that also halt the mysql init.</p>
  
  <p><strong>UPDATE 1</strong>  </p>
  
  <pre><code>$ docker info
  Containers: 1
   Running: 0
   Paused: 0
   Stopped: 1
  Images: 2
  Server Version: 1.12.1
  Storage Driver: aufs
   Root Dir: /var/lib/docker/aufs
   Backing Filesystem: extfs
   Dirs: 18
   Dirperm1 Supported: true
  Logging Driver: json-file
  Cgroup Driver: cgroupfs
  Plugins:
   Volume: local
   Network: host bridge null overlay
  Swarm: inactive
  Runtimes: runc
  Default Runtime: runc
  Security Options: seccomp
  Kernel Version: 4.4.20-moby
  Operating System: Alpine Linux v3.4
  OSType: linux
  Architecture: x86_64
  CPUs: 4
  Total Memory: 9.744 GiB
  Name: moby
  ID: 43S4:LA5E:6MTG:IFOG:HHJC:HYLX:LYIT:YU43:QGBQ:K5I5:Z6LP:AENZ
  Docker Root Dir: /var/lib/docker
  Debug Mode (client): false
  Debug Mode (server): true
   File Descriptors: 16
   Goroutines: 27
   System Time: 2016-10-12T07:52:58.516469676Z
   EventsListeners: 1
  No Proxy: *.local, 169.254/16
  Registry: https://index.docker.io/v1/
  Insecure Registries:
   127.0.0.0/8
  
  
  $ df -h
  Filesystem      Size   Used  Avail Capacity iused      ifree %iused  Mounted on
  /dev/disk1     233Gi  141Gi   92Gi    61% 2181510 4292785769    0%   /
  devfs          193Ki  193Ki    0Bi   100%     668          0  100%   /dev
  map -hosts       0Bi    0Bi    0Bi   100%       0          0  100%   /net
  map auto_home    0Bi    0Bi    0Bi   100%       0          0  100%   /home
  /dev/disk2s2   466Gi   64Gi  401Gi    14%    1857 4294965422    0%   /Volumes/mac
  /dev/disk2s3   465Gi   29Gi  436Gi     7%  236633    3575589    6%   /Volumes/PORTABLE
  /dev/disk3s1   100Mi   86Mi   14Mi    86%      12 4294967267    0%   /Volumes/Vagrant
  </code></pre>
  
  <p>I was using /dev/disk1 directories to mount volumes.</p>