Hello I am running an application install which requires
thread_stack = 256k
in my.cnf file. The location of the file is
etc/mysql/my.cnf and I updated the value and restarted the mysql server,but the value does not get updated even after the restart.
MySQL version is 5.5.35-0ubuntu0.12.04.2
On exeecuting the below query I get the size as
SHOW GLOBAL VARIABLES LIKE '%stack%'
I referred this thread and tried the start stop way but did not work.How can I make the file to be reloaded on restart?
service mysql start --thread_stack=256K
This command line option also did not work with error start: invalid option: --thread_stack=256K
I just checked that after running service mysql stop I am able to connect to mysql and if I do a pgrep,I can see two pid's. Is there another mysql instance running which is causing this issue? DO I need to kill the processes?
root@ip-10-155-22-27:/# service mysql status mysql stop/waiting root@ip-10-155-22-27:/# pgrep mysql 12813 13103 root@ip-10-155-22-27:/# mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 90524 Server version: 5.5.35-0ubuntu0.12.04.2 (Ubuntu) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>