J
juanchi
Guest
This is my actual my.cnf file:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Then I tried to include this three lines:
set-variable = interactive_timeout = 120
set-variable = wait_timeout = 120
set-variable = max_connections = 200
Like this:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = interactive_timeout = 120
set-variable = wait_timeout = 120
set-variable = max_connections = 200
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
But when I restart mysqld service the conection to the database is broken, I can't log to the plesk control panel.
This is part of my mysqld.log file:
050327 22:07:27 /usr/libexec/mysqld: unknown variable 'interactive_timeout = 120'
050327 22:07:27 mysqld ended
050327 22:07:29 mysqld started
050327 22:07:29 /usr/libexec/mysqld: unknown variable 'interactive_timeout = 120'
050327 22:07:29 mysqld ended
050327 22:08:11 mysqld started
050327 22:08:11 /usr/libexec/mysqld: unknown variable 'interactive_timeout = 120'
050327 22:08:11 mysqld ended
050327 22:09:03 mysqld started
050327 22:09:04 InnoDB: Started
/usr/libexec/mysqld: ready for connections.
Version: '4.0.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
050327 22:09:06 /usr/libexec/mysqld: Normal shutdown
050327 22:09:06 InnoDB: Starting shutdown...
A mysqld process already exists at Sun Mar 27 22:09:06 EST 2005
050327 22:09:08 InnoDB: Shutdown completed
050327 22:09:08 /usr/libexec/mysqld: Shutdown Complete
050327 22:09:08 mysqld ended
050327 22:10:54 mysqld started
050327 22:10:54 InnoDB: Started
/usr/libexec/mysqld: ready for connections.
Version: '4.0.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
050327 22:10:56 /usr/libexec/mysqld: Normal shutdown
050327 22:10:56 InnoDB: Starting shutdown...
A mysqld process already exists at Sun Mar 27 22:10:56 EST 2005
050327 22:10:58 InnoDB: Shutdown completed
050327 22:10:58 /usr/libexec/mysqld: Shutdown Complete
050327 22:10:58 mysqld ended
050327 22:12:11 mysqld started
If I reverse this changes everything works fine again, I don't know what I'm doing wrong, I used both pico and nano.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Then I tried to include this three lines:
set-variable = interactive_timeout = 120
set-variable = wait_timeout = 120
set-variable = max_connections = 200
Like this:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = interactive_timeout = 120
set-variable = wait_timeout = 120
set-variable = max_connections = 200
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
But when I restart mysqld service the conection to the database is broken, I can't log to the plesk control panel.
This is part of my mysqld.log file:
050327 22:07:27 /usr/libexec/mysqld: unknown variable 'interactive_timeout = 120'
050327 22:07:27 mysqld ended
050327 22:07:29 mysqld started
050327 22:07:29 /usr/libexec/mysqld: unknown variable 'interactive_timeout = 120'
050327 22:07:29 mysqld ended
050327 22:08:11 mysqld started
050327 22:08:11 /usr/libexec/mysqld: unknown variable 'interactive_timeout = 120'
050327 22:08:11 mysqld ended
050327 22:09:03 mysqld started
050327 22:09:04 InnoDB: Started
/usr/libexec/mysqld: ready for connections.
Version: '4.0.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
050327 22:09:06 /usr/libexec/mysqld: Normal shutdown
050327 22:09:06 InnoDB: Starting shutdown...
A mysqld process already exists at Sun Mar 27 22:09:06 EST 2005
050327 22:09:08 InnoDB: Shutdown completed
050327 22:09:08 /usr/libexec/mysqld: Shutdown Complete
050327 22:09:08 mysqld ended
050327 22:10:54 mysqld started
050327 22:10:54 InnoDB: Started
/usr/libexec/mysqld: ready for connections.
Version: '4.0.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
050327 22:10:56 /usr/libexec/mysqld: Normal shutdown
050327 22:10:56 InnoDB: Starting shutdown...
A mysqld process already exists at Sun Mar 27 22:10:56 EST 2005
050327 22:10:58 InnoDB: Shutdown completed
050327 22:10:58 /usr/libexec/mysqld: Shutdown Complete
050327 22:10:58 mysqld ended
050327 22:12:11 mysqld started
If I reverse this changes everything works fine again, I don't know what I'm doing wrong, I used both pico and nano.