Change Permanently Session System Variable in MySQL

Question

I added this line to my.ini

wait_timeout=2000000

When I type

show global variables

It prints wait_timeout=2000000,

but when I type

show variables

It prints wait_timeout=28800

I can set with

set wait_timeout=2000000

But I do not want to set it all the time manually.

Do you have any suggestion to set permanently session system variable?

Remember to restart MySQL after changing my.ini

Amy B
– Amy B

2010-09-06 06:53:07 +00:00
Commented Sep 6, 2010 at 6:53 — Amy B
– Amy B, Commented Sep 6, 2010 at 6:53

Paul Dixon · Accepted Answer · 2010-09-06 07:01:06Z

4

You probably need to check the interactive_timeout is set also - regular client connections are probably picking up your new setting, but when you check it manually using an interactive client, MySQL will set the timeout from this setting:

On thread startup, the session wait_timeout value is initialized from the global wait_timeout value or from the global interactive_timeout value, depending on the type of client (as defined by the CLIENT_INTERACTIVE connect option to mysql_real_connect()). See also interactive_timeout.

See manual for details.

answered Sep 6, 2010 at 7:01

Paul Dixon

302k54 gold badges315 silver badges349 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Change Permanently Session System Variable in MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related