I was trying to run some performance tests with mysqlslap and followed the procedure described here:
https://www.digitalocean.com/community/tutorials/how-to-measure-mysql-query-performance-with-mysqlslap
I did run into this error however. Any tips?
$ mysqlslap -u thommym -p --auto-generate-sql --verbose
mysqlslap: [ERROR] unknown variable 'default-character-set=utf8mb4'
$ mysql --version
mysql Ver 14.14 Distrib 5.7.11, for Linux (x86_64) using EditLine wrapper
$ uname -a
Linux leia.thompa.nu 4.4.3-300.fc23.x86_64 #1 SMP Fri Feb 26 18:45:40 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux
My /etc/my.cnf looks like this:
$ cat /etc/my.cnf
# For advice on how to change settings please see
#
http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
validate-password=OFF
#
http://dev.mysql.com/doc/refman/5.7/en/charset-server.html
skip-character-set-client-handshake
init-connect='SET NAMES utf8mb4'
collation-server=utf8mb4_unicode_ci
character-set-server=utf8mb4
[mysql]
default-character-set=utf8mb4
[client]
socket=/var/lib/mysql/mysql.sock
default-character-set=utf8mb4