Updated my.cnf
Code: Select all
[mysqld]
port=3306
bind-address = 0.0.0.0
variable-name=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
wait_timeout=3600
old_passwords=1
max_connections=100
max_user_connections=20
key_buffer_size=512M
query_cache_size=156M
join_buffer_size=2M
thread_cache_size=4
open_files_limit=7500
table_cache=3000
table_definition_cache=512
max_heap_table_size=32M
slow_query_log_file=/var/log/mysql-slow.log
slow_query_log=1
innodb_buffer_pool_size=128M
innodb_additional_mem_pool_size=524288
innodb_log_buffer_size=500K
innodb_thread_concurrency=2
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
# To allow mysqld to connect to a MySQL Cluster management daemon, uncomment
# these lines and adjust the connectstring as needed.
#ndbcluster
#ndb-connectstring="nodeid=4;host=localhost:1186"
[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"
[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186"
Restart MySQL
FAIL
Code: Select all
101206 16:41:11 [Note] /usr/libexec/mysqld: Normal shutdown
101206 16:41:11 [Note] Event Scheduler: Purging the queue. 0 events
101206 16:41:13 InnoDB: Starting shutdown...
101206 16:41:15 InnoDB: Shutdown completed; log sequence number 1 2128138008
101206 16:41:15 [Note] /usr/libexec/mysqld: Shutdown complete
101206 16:41:16 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
101206 16:41:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
101206 16:41:17 [Note] Plugin 'ndbcluster' is disabled.
101206 16:41:17 InnoDB: Started; log sequence number 1 2128138008
101206 16:41:17 [ERROR] /usr/libexec/mysqld: unknown variable 'variable-name=local-infile=0'
101206 16:41:17 [ERROR] Aborting
edit these lines:
Code: Select all
set-variable=local-infile=0
#variable-name=local-infile=0
Restart MySQL
OK
Code: Select all
101206 16:42:02 InnoDB: Starting shutdown...
101206 16:42:07 InnoDB: Shutdown completed; log sequence number 1 2128138008
101206 16:42:07 [Note] /usr/libexec/mysqld: Shutdown complete
101206 16:42:07 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
101206 16:43:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
101206 16:43:08 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101206 16:43:08 [Note] Plugin 'ndbcluster' is disabled.
101206 16:43:09 InnoDB: Started; log sequence number 1 2128138008
101206 16:43:09 [Note] Event Scheduler: Loaded 0 events
101206 16:43:09 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.53-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
101206 16:43:25 [Note] /usr/libexec/mysqld: Normal shutdown
101206 16:43:25 [Note] Event Scheduler: Purging the queue. 0 events
101206 16:43:25 InnoDB: Starting shutdown...
101206 16:43:29 InnoDB: Shutdown completed; log sequence number 1 2128138057
101206 16:43:29 [Note] /usr/libexec/mysqld: Shutdown complete
101206 16:43:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
101206 16:43:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
101206 16:43:30 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101206 16:43:30 [Note] Plugin 'ndbcluster' is disabled.
101206 16:43:30 InnoDB: Started; log sequence number 1 2128138057
101206 16:43:30 [Note] Event Scheduler: Loaded 0 events
101206 16:43:30 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.53-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
Current my.cnf
Code: Select all
[mysqld]
port=3306
bind-address = 0.0.0.0
set-variable=local-infile=0
#variable-name=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
wait_timeout=3600
old_passwords=1
max_connections=100
max_user_connections=20
key_buffer_size=512M
query_cache_size=156M
join_buffer_size=2M
thread_cache_size=4
open_files_limit=7500
table_cache=3000
table_definition_cache=512
max_heap_table_size=32M
slow_query_log_file=/var/log/mysql-slow.log
slow_query_log=1
innodb_buffer_pool_size=128M
innodb_additional_mem_pool_size=524288
innodb_log_buffer_size=500K
innodb_thread_concurrency=2
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
# To allow mysqld to connect to a MySQL Cluster management daemon, uncomment
# these lines and adjust the connectstring as needed.
#ndbcluster
#ndb-connectstring="nodeid=4;host=localhost:1186"
[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"
[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186"
var/log/mysqld.log
Code: Select all
101206 16:54:28 [Note] /usr/libexec/mysqld: Normal shutdown
101206 16:54:28 [Note] Event Scheduler: Purging the queue. 0 events
101206 16:54:30 InnoDB: Starting shutdown...
101206 16:54:35 InnoDB: Shutdown completed; log sequence number 1 2128144984
101206 16:54:35 [Note] /usr/libexec/mysqld: Shutdown complete
101206 16:54:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
101206 16:54:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
101206 16:54:36 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101206 16:54:36 [Note] Plugin 'ndbcluster' is disabled.
101206 16:54:36 InnoDB: Started; log sequence number 1 2128144984
101206 16:54:36 [Note] Event Scheduler: Loaded 0 events
101206 16:54:36 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.53-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
Are these lines relevent & required?
[mysqld]
port=3306
bind-address = 0.0.0.0
set-variable=local-infile=0
#variable-name=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
Plus:
[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"
[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186"