suse:~ # cat /etc/*rele* NAME="openSUSE Leap" VERSION="15.6" ID="opensuse-leap" ID_LIKE="suse opensuse" VERSION_ID="15.6" PRETTY_NAME="openSUSE Leap 15.6" ANSI_COLOR="0;32" CPE_NAME="cpe:/o:opensuse:leap:15.6" BUG_REPORT_URL="https://bugs.opensuse.org" HOME_URL="https://www.opensuse.org/" DOCUMENTATION_URL="https://en.opensuse.org/Portal:Leap" LOGO="distributor-logo-Leap" suse:~ # systemctl restart mariadb suse:~ # ps -ef | grep mysqld | grep -v "grep" mysql 14001 1 0 08:04 ? 00:00:00 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --user=mysql --socket=/run/mysql/mysql.sock suse:~ # top -b -n 1 -p 14001 | tail -2 PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 14001 mysql 20 0 2166868 255308 24064 S 0.000 12.64 0:00.09 mysqld suse:~ # mariadb Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 5 Server version: 10.11.9-MariaDB-log MariaDB package Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> show global status like 'Memory_used'; +---------------+------------+ | Variable_name | Value | +---------------+------------+ | Memory_used | 1416357840 | +---------------+------------+ 1 row in set (0.000 sec) MariaDB [(none)]> drop schema if exists memtest; Query OK, 0 rows affected (0.008 sec) MariaDB [(none)]> create schema if not exists memtest; use memtest; Query OK, 1 row affected (0.000 sec) Database changed MariaDB [memtest]> CREATE TABLE `BIGMEMORY`(`col1` int(11) NOT NULL AUTO_INCREMENT,`col2` varchar(1024) DEFAULT NULL,PRIMARY KEY (`col1`)) ENGINE=MEMORY; Query OK, 0 rows affected (0.010 sec) MariaDB [memtest]> insert into memtest.BIGMEMORY (col2) -> select concat(md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand()),md5(rand())) -> from seq_1_to_358400; Query OK, 358400 rows affected (12.481 sec) Records: 358400 Duplicates: 0 Warnings: 0 MariaDB [memtest]> show global status like 'Memory_used'; +---------------+------------+ | Variable_name | Value | +---------------+------------+ | Memory_used | 2896703752 | +---------------+------------+ 1 row in set (0.010 sec) MariaDB [memtest]> \! top -b -n 1 -p 14001 | tail -2 PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 14001 mysql 20 0 3674496 1.606g 7168 S 0.000 83.39 0:12.08 mysqld MariaDB [memtest]> truncate table memtest.BIGMEMORY; Query OK, 0 rows affected (0.029 sec) MariaDB [memtest]> show global status like 'Memory_used'; +---------------+------------+ | Variable_name | Value | +---------------+------------+ | Memory_used | 1416693048 | +---------------+------------+ 1 row in set (0.000 sec) MariaDB [memtest]> \! top -b -n 1 -p 14001 | tail -2 PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 14001 mysql 20 0 3215744 1.165g 7680 S 0.000 60.47 0:12.11 mysqld MariaDB [memtest]> select @@version_malloc_library; +--------------------------+ | @@version_malloc_library | +--------------------------+ | system | +--------------------------+ 1 row in set (0.001 sec) MariaDB [memtest]> exit Bye suse:~ # suse:~ # ldd --version ldd (GNU libc) 2.38 Copyright (C) 2023 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Written by Roland McGrath and Ulrich Drepper.