change interactive timeout

[AndyII]

can someone assist me, How do I change this value, I found reference on the net that its in my.conf, but I see no file with that name

 

[nobaloney]

If /etc/my.cnf doesn't exist it's because your MySQL implementation doesn't use one; it uses the defaults.

If you create the file and restart MySQL, it'll use your custom settings.

Jeff

 

[AndyII]

Thanks Jeff
I see in Variables, this setting for interactive timeout 28,800
what controls it now?, do I have to have a "my.cnf" or can I make it global server wise?
Was informed to lower this setting to something more reasonable, like 800.
I seem to have quite a few word press sites on the server and they hold connections for an extremely long time, sometimes it seems to tie up MySQL with unnecessary connections causing it to clog and slow or jam the server.

 

[nobaloney]

Changes for mysql interactive timeout need to be made in /etc/my.cnf; create your own if you don't have one.

Jeff

 

[AndyII]

found some samples in /usr/share/mysql/
I see only this reference ,
[mysqlhotcopy]
interactive-timeout
would I put this? (as an example)
[mysqlhotcopy]
interactive-timeout = 800

And can this be the only directive found in my.cfg if that all that you wanted.......