Failed to set stream size in mysql

Question

I am trying to increment the thread-stack variable . I can do this successfully using the command line option as such:

/usr/sbin/mysqld --thread-stack=256k

I can also do this using config files /etc/init/mysql.conf

or /etc/init.d/mysql

:

thread_stack=262144
thread_stack=256k
thread-stack=256k
thread-stack=262144

However, installing via /etc/mysql/my.cnf

doesn't work. show variables like'%thread_stack%';

still shows the default 196608

.

Why is n't the setting working /etc/mysql/my.cnf

?

How to fix it?

(MySQL 5.5, 5.5.38-0ubuntu0.14.04.1-log.)

+3

gobwas 10 Sep 14 at 9:59 am

1 answer

KillABug · Answer 1 · 2015-07-10T18:30:16+0000

The problem was starting multiple processes (threads) for mysql. The result pgrep

in the question made me use kill -15 -1

.

This kills all active processes for applications. Then I had to restart mysql and apache and I updated the value.