MySQL "sort_buffer_size" error only with this package. #826
Unanswered
frequentredundancy
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I utilise this package in a project of mine.
I have a table with 5000 rows and it works absolutely perfectly. Full sorting pagination full search everything.
I then make 100 activity logs with none of the things listed above except pagination, and instantly get an error about mysql "sort_buffer_size" even if I'm not doing anything that sorts them. My code is as simple as it gets;
Auth::user()->actions()->paginate(10)
Was hoping I can perhaps get an explanation of how to fix this? I tried upping the "sort_buffer_size" via mysql config file, but no matter how much I up it, as more "activity" gets recorded, it will eventually break again.
I'm quite confused as to how 5000 rows can work perfectly fine, but then this package if I create even 100 it causes a sort buffer error.
Hopefully someone can help!
Beta Was this translation helpful? Give feedback.
All reactions