mysql variables

General Discussion of atomic repo and development projects.

Ask for help here with anything else not covered by other forums.
Post Reply
User avatar
webfeatus
Forum Regular
Forum Regular
Posts: 196
Joined: Wed Jan 13, 2010 9:11 am
Location: Bali

mysql variables

Unread post by webfeatus »

I am receiving errors in my mysqld.log
Option '--set-variable' is deprecated. Use --variable-name=value instead

Here is my.cnf

Code: Select all

[mysqld]
set-variable=local-infile=0
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
set-variable =  innodb_buffer_pool_size=2M
# innodb_additional_mem_pool_size=524288
set-variable =  innodb_additional_mem_pool_size=500K

[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"

set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
[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"
How do I clean up this file?
There are other innodb issues but I need some help regarding the above "set variable" error, first.
Can someone assist with the correct syntax for this?
They say that good intentions, pave the road to hell;
If a thing is not worth doing, it's not worth doing well.
Top
biggles
Forum Regular
Forum Regular
Posts: 806
Joined: Tue Jul 15, 2008 2:38 pm
Location: Sweden
Contact:
Contact biggles

Re: mysql variables

Unread post by biggles »

Remove the "set-variable =", keeping the rest of the configuration lines. Then try to restart mysql (/etc/init.d/mysqld restart). No errors? Great! Errors? post the error here and we can try to help you sort them out.

A backup copy of your my.cnf is also a good precation.

Example before:

Code: Select all

set-variable =  innodb_buffer_pool_size=2M
After:

Code: Select all

innodb_buffer_pool_size=2M
Top
User avatar
webfeatus
Forum Regular
Forum Regular
Posts: 196
Joined: Wed Jan 13, 2010 9:11 am
Location: Bali

Re: mysql variables

Unread post by webfeatus »

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"
They say that good intentions, pave the road to hell;
If a thing is not worth doing, it's not worth doing well.
Top
Kalimari
Forum Regular
Forum Regular
Posts: 526
Joined: Wed Jan 02, 2008 3:21 pm
Location: United Kingdom

Re: mysql variables

Unread post by Kalimari »

webfeatus wrote: set-variable=local-infile=0
#variable-name=local-infile=0
I think you need to remove the "set-variable" part entirely, just use:

Code: Select all

local-infile=0
The restart, should be OK.
Top
User avatar
webfeatus
Forum Regular
Forum Regular
Posts: 196
Joined: Wed Jan 13, 2010 9:11 am
Location: Bali

Re: mysql variables

Unread post by webfeatus »

Done, I assume this output is clean?

Code: Select all

Version: '5.1.53-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
101206 18:12:37 [Note] /usr/libexec/mysqld: Normal shutdown

101206 18:12:37 [Note] Event Scheduler: Purging the queue. 0 events
101206 18:12:39  InnoDB: Starting shutdown...
101206 18:12:41  InnoDB: Shutdown completed; log sequence number 1 2128201367
101206 18:12:41 [Note] /usr/libexec/mysqld: Shutdown complete

101206 18:12:41 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
101206 18:12:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
101206 18:12:42 [Note] Plugin 'ndbcluster' is disabled.
101206 18:12:42  InnoDB: Started; log sequence number 1 2128201367
101206 18:12:42 [Note] Event Scheduler: Loaded 0 events
101206 18:12:42 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.53-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distributio
It looks OK to me.
This was the first step in trying to work out what is wrong with the recent MySQL upgrade via yum from atomic.
I wanted to make sure that MySQL was operating OK.
As far as I can see, all SQL functions are working on the server.
But ASL is not.
I am seeing strange output - as if the associated asl database tables are not functioning correctly.
Do I add more information about this here - or start a new post?
They say that good intentions, pave the road to hell;
If a thing is not worth doing, it's not worth doing well.
Top
User avatar
webfeatus
Forum Regular
Forum Regular
Posts: 196
Joined: Wed Jan 13, 2010 9:11 am
Location: Bali

Re: mysql variables

Unread post by webfeatus »

Final issue resolved via support ticket.
Thank you for your help.
They say that good intentions, pave the road to hell;
If a thing is not worth doing, it's not worth doing well.
Top
Post Reply

Return to “General Help and Development Discussion”