mysql variables
Posted: Mon Dec 06, 2010 12:54 am
I am receiving errors in my mysqld.log
Option '--set-variable' is deprecated. Use --variable-name=value instead
Here is my.cnf
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?
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"
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?