I don't know MySQL but I wanted to glance through some data in a table. I imported the database into Sequel Ace (MacOS) and had no trouble browsing through the tables, but when attempting to sort one column in a larger table I received an "Out of sort memory, consider increasing server sort buffer size" error.

How do I make that happen?

I have MySQL installed and running.

  • What is the current value? How much RAM do you have?
    – Rick James
    Aug 14, 2020 at 3:30
  • What version of MySQL?
    – Rick James
    Apr 26, 2021 at 0:18

1 Answer 1


see https://forums.mysql.com/read.php?11,366143,376017#msg-376017

how to create a my.cnf file and add

sort_buffer_size = 1M

And then increase it when it still makes troubles

  • Thank you. Problem solved!
    – Jay
    Sep 15, 2020 at 8:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.