MySQL sort_buffer_size

Question

I have received this error:

Bad SQL query Incorrect key file for table '/tmp/#sql_659_0.MYI'; try to repair it

So, following this suggesttion, I try to edit:

sort_buffer_size=4M
join_buffer_size=4M

But I can not find them. Where are they located on Ubuntu 14.04 machine? There are no such options in /etc/mysql/my.cnf

score 1 · Accepted Answer · edited May 23 '17 at 11:46

1

You can run the command find / -name my.cnf on the terminal.This would work as mentioned here

edited May 23 '17 at 11:46

Community

answered Oct 04 '14 at 18:11

Avinash Babu

I have /etc/mysql/my.cnf. But I can not find sort_buffer_size=4M. Do I need to add them to my.cnf? – torayeff Oct 04 '14 at 18:14
you would need to ..:) – Avinash Babu Oct 04 '14 at 18:16
@torayeff please accept it as an answer if it helps ..Thanks ..:) – Avinash Babu Oct 05 '14 at 03:08

score 0 · Answer 2 · edited May 23 '17 at 11:54

0

try finding the location of my.cnf as explained here

Secondly i think the title of this question should be:

Where to find my.cnf in Ubuntu 14.04

edited May 23 '17 at 11:54

Community

answered Oct 04 '14 at 18:13

S1LENT WARRIOR

score 0 · Answer 3 · answered Oct 04 '14 at 20:26

0

If you just want to change the values in the running instance you could do (just fire it as a query from anywhere):

SET @FourMegs = 1024 * 1024 * 4;
SET GLOBAL sort_buffer_size = @FourMegs;
SET GLOBAL join_buffer_size = @FourMegs;

answered Oct 04 '14 at 20:26

edlerd

3 Answers3