Hello, got this reproduced on different VMs. Here is my.cnf example:
[client] port = 3306 socket = /var/run/mysqld/mysqld.sock host=localhost
[mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 syslog core-file-size=unlimited
[mysqld] core-file user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /var/lib/mysql/tmp log_error = /var/log/mysql/error.log max_allowed_packet = 16M #myisam-recover-options = BACKUP max_connections = 200 event_scheduler = 1 server-id = 49161 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 2 max_binlog_size = 100M innodb_log_file_size = 256M innodb_fast_shutdown = 0 table_open_cache = 1024 query_cache_size = 0 thread_cache_size = 20 max_heap_table_size = 50M tmp_table_size = 50M innodb_buffer_pool_size = 1024Mb innodb_buffer_pool_instances = 2 join_buffer_size = 256K explicit_defaults_for_timestamp binlog_row_image = MINIMAL
[mysqldump] quick quote-names max_allowed_packet = 16M
[mysql] #no-auto-rehash # faster start of mysql but no tab completition
[isamchk] #key_buffer = 16M
Hello, got this reproduced on different VMs.
Here is my.cnf example:
[client] mysqld/ mysqld. sock
port = 3306
socket = /var/run/
host=localhost
[mysqld_safe] mysqld/ mysqld. sock size=unlimited
socket = /var/run/
nice = 0
syslog
core-file-
[mysqld] mysqld/ mysqld. pid mysqld/ mysqld. sock mysql/error. log recover- options = BACKUP mysql/mysql- bin.log log_file_ size = 256M fast_shutdown = 0 buffer_ pool_size = 1024Mb buffer_ pool_instances = 2 defaults_ for_timestamp
core-file
user = mysql
pid-file = /var/run/
socket = /var/run/
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /var/lib/mysql/tmp
log_error = /var/log/
max_allowed_packet = 16M
#myisam-
max_connections = 200
event_scheduler = 1
server-id = 49161
log_bin = /var/log/
expire_logs_days = 2
max_binlog_size = 100M
innodb_
innodb_
table_open_cache = 1024
query_cache_size = 0
thread_cache_size = 20
max_heap_table_size = 50M
tmp_table_size = 50M
innodb_
innodb_
join_buffer_size = 256K
explicit_
binlog_row_image = MINIMAL
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
#key_buffer = 16M