ItSolutionStuff.com

Solved - Mysql Out of sort memory, consider increasing server sort buffer size

By Hardik Savani • May 1, 2024
MySql

In this tutorial we will go over the demonstration of Out of sort memory. step by step explain consider increasing server sort buffer size mysql. you'll learn mysql 8 out of sort memory consider increasing server sort buffer size. i would like to show you out of sort memory consider increasing server sort buffer size ubuntu. Let's get started with Out of sort memory.

few days ago i was working on laravel project and when i run one following sql query, it was working on local mysql. but not working on ubuntu server in digitalocean. it tried to run using mysql command and i was able to found exactly error:

Query:

select * from `posts` where exists (select * from `categories` inner join `post_category` on `categories`.`id` = `post_category`.`category_id` where `posts`.`id` = `post_category`.`post_id` and `categories`.`slug` = 'phpexample.html') group by `posts`.`id` order by `posts`.`id` desc

Error Found:

i found following error:

ERROR 1038 (HY001): Out of sort memory, consider increasing server sort buffer size

Solution:

i search on google and find out solution with increasing size of "sort_buffer_size". so let's open my.cnf file update as like bellow:

sudo nano /etc/mysql/my.cnf

update as following:

/etc/mysql/my.cnf

[mysqld]

sort_buffer_size=5M

now you can restart mysql with following command:

sudo service mysql restart

I hope it can help you...

Tags: MySql
Hardik Savani

Hardik Savani

I'm a full-stack developer, entrepreneur, and founder of ItSolutionStuff.com. Passionate about PHP, Laravel, JavaScript, and helping developers grow.

📺 Subscribe on YouTube

We Are Recommending You

How to Import Database in Mysql using Command Line in Ubuntu?

Read Now →

Node JS Mysql Connection Example

Read Now →

How to add 1 day to the date column in MySQL?

Read Now →

MYSQL Query for Data between Two Dates Example

Read Now →

How to Use MySQL View in Laravel?

Read Now →

PHP AngularJS MySQL Pagination Example

Read Now →

PHP MySQL Column Sorting Example Tutorial

Read Now →

How to Get Query Log in Laravel Eloquent?

Read Now →

Mysql procedure with pagination in laravel?

Read Now →

Which MySQL Datatype use for Store an IP Address?

Read Now →

Mysql Hexadecimal Color Code Store in Binary Datatype Example

Read Now →