Good morning,
I am currently running RHEL 7.5 and MariaDB 10.3.9. After setting
"large_pages=on" I noticed that MariaDB is reporting an error on startup
and shutdown as per below output.
To use large pages I modified /etc/sysctl.conf, /etc/security/limits.conf
and the systemd unit file. By monitoring /proc/meminfo I verified that
largepage are being used.
Configuration:
mysqld would have been started with the following arguments:
--port=3306 --socket=/var/lib/mysql/mysql.sock --thread_stack=256K
--large_pages=on --key_buffer_size=16K --max_allowed_packet=512M
--table_open_cache=32 --sort_buffer_size=512K --net_buffer_length=8K
--read_buffer_size=256K --read_rnd_buffer_size=256K --slow_query_log=1
--slow_query_log_file=mysql-slow.log --long_query_time=0.1
--log-queries-not-using-indexes=on --thread_handling=pool-of-threads
--thread_pool_idle_timeout=60 --thread_pool_max_threads=1000
--thread_pool_size=8 --innodb_buffer_pool_size=256M --innodb_strict_mode=1
--innodb_file_per_table=1 --innodb_flush_method=O_DIRECT
--innodb_log_files_in_group=4 --innodb_log_file_size=50331648
--innodb_undo_logs=128 --innodb_undo_tablespaces=8 --slow_query_log=1
--slow_query_log_file=mysql-slow.log --long_query_time=30
--log-queries-not-using-indexes=off --log_bin=mariadblog
--binlog_format=ROW --binlog_row_image=MINIMAL --max_binlog_size=10240000
--expire_logs_days=1 --server-id=1 --innodb_flush_log_at_trx_commit=1
--sync_binlog=1 --relay-log=mariadb-relay-bin --performance_schema=off
--histogram_size=255 --histogram_type=SINGLE_PREC_HB
--use_stat_tables=preferably --optimizer_use_condition_selectivity=4
Startup messages:
Sep 25 10:40:53 srv1 mysqld: 2018-09-25 10:40:52 0 [Note] InnoDB: Opened 8
undo tablespaces
Sep 25 10:40:53 srv1 mysqld: 2018-09-25 10:40:53 0 [Warning] InnoDB: Failed
to set memory to DODUMP: Invalid argument ptr 0x2aaac5400000 size 2097152
Sep 25 10:40:53 srv1 mysqld: 2018-09-25 10:40:53 0 [Note] InnoDB: 128 out
of 128 rollback segments in 8 undo tablespaces are active.
Shutdown messages:
Sep 25 10:41:18 srv1 mysqld: 2018-09-25 10:41:18 0 [Note] InnoDB: Buffer
pool(s) dump completed at 180925 10:41:18
Sep 25 10:41:19 srv1 mysqld: 2018-09-25 10:41:19 0 [Warning] InnoDB: Failed
to set memory to DODUMP: Invalid argument ptr 0x2aaac3400000 size 33554432
Sep 25 10:41:19 srv1 mysqld: 2018-09-25 10:41:19 0 [Note] InnoDB: Shutdown
completed; log sequence number 1522725; transaction id 22
Do you have ideas on what is causing "InnoDB: Failed to set memory to
DODUMP: Invalid argument ptr .. " warning?
Kenneth
