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
Uh oh!
There was an error while loading. Please reload this page.
-
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