title: Mysql2::Error: Out of sort memory, consider increasing server sort buffer size using docker-compose.yml
body: <p>Hi I'm building a rails app and I imported lots of data and inserted into the database. Some tables are okay and some tables have some errors that says out of sort memory.</p>
  <p><strong>SQL ERROR</strong></p>
  <pre><code>Mysql2::Error: Out of sort memory, consider increasing server sort buffer size
  </code></pre>
  <p>How do you increase server sort buffer size using the <code>docker-compose.yml</code> command?</p>
  <p>I've tried this one:</p>
  <pre><code>version: '3'
  services:
    db:
      image: mysql:latest
      command:
        - --default-authentication-plugin=mysql_native_password
        - --innodb-buffer-pool-size=402653184
  </code></pre>
  <p>I did add this command:</p>
  <pre><code>--innodb-buffer-pool-size=402653184
  </code></pre>
  <p>but I'm still getting the same error that it is out of memory. Is there any way to increase the buffer size using the <code>docker-compose.yml</code></p>