bennywong30 / tuning-primer

Tuning Primer SH for MySQL performance tuning
3 stars 4 forks source link

I have seen error message MariaDB #1

Open rmalenko opened 10 years ago

rmalenko commented 10 years ago

./tuning-primer.sh: 401: local: 2097152: bad variable name MySQL Version 5.5.39-MariaDB-1~lucid-log x86_64

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
skip-external-locking
bind-address            = 127.0.0.1
max_connections         = 500
connect_timeout         = 5
wait_timeout            = 600
max_allowed_packet      = 32M
thread_cache_size       = 300
sort_buffer_size        = 8M
bulk_insert_buffer_size = 16M
tmp_table_size          = 512M
max_heap_table_size     = 512M

binlog_cache_size       = 65536
#long_query_time                = 5s

myisam_recover          = BACKUP
key_buffer_size         = 2G
open-files-limit        = 5000
table_open_cache        = 5000
myisam_sort_buffer_size = 512M
concurrent_insert       = 2
read_buffer_size        = 4M
read_rnd_buffer_size    = 2M
join_buffer_size        = 1M

query_cache_limit               = 128M
query_cache_size                = 128M
query_cache_min_res_unit        = 1K
query_cache_type                = DEMAND
log-error                      = /var/log/mysql/mysql-error.log
#slow_query_log[={0|1}]
slow_query_log_file     = /var/log/mysql/mariadb-slow.log
long_query_time = 10
#log_slow_rate_limit    = 1000
log_slow_verbosity      = query_plan

#log-queries-not-using-indexes
#log_slow_admin_statements
log_bin                 = /var/log/mysql/mariadb-bin
log_bin_index           = /var/log/mysql/mariadb-bin.index
#sync_binlog            = 1
expire_logs_days        = 5
max_binlog_size         = 100M
default_storage_engine  = InnoDB
innodb_log_file_size    = 256M
innodb_buffer_pool_size = 12G
innodb_log_buffer_size  = 8M
innodb_file_per_table   = 1
innodb_open_files       = 500
innodb_io_capacity      = 500
innodb_flush_method     = O_DIRECT
[mysqldump]
quick
quote-names
max_allowed_packet      = 256M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer              = 32M

!includedir /etc/mysql/conf.d/
ysolis commented 9 years ago

same error for me, MariaDB 10 in my case.

tflidd commented 8 years ago

ref: https://bugs.launchpad.net/mysql-tuning-primer/+bug/1202940

vikas5914 commented 8 years ago

for MariaDB . use this version ..

https://github.com/serversetup/tuning-primer

this will only work with mariadb