Hello, i did some changes in mysql, latest debian with latest phpmyadmin and php 7.4. For example change value key buffer size from 134 217 728 to xy, after that i used systemctl restart mariadb and when i refresh settings, i can see value 134 217 728 back. Any idea what should i check? In error log i can not see warnings/errors in mysql. Code: Dec 3 12:04:29 hd518 mariadbd[189943]: 2021-12-03 12:04:29 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown Dec 3 12:04:29 hd518 mariadbd[189943]: 2021-12-03 12:04:29 0 [Note] Event Scheduler: Purging the queue. 0 events Dec 3 12:04:29 hd518 mariadbd[189943]: 2021-12-03 12:04:29 0 [Note] InnoDB: FTS optimize thread exiting. Dec 3 12:04:29 hd518 mariadbd[189943]: 2021-12-03 12:04:29 0 [Note] InnoDB: Starting shutdown... Dec 3 12:04:29 hd518 mariadbd[189943]: 2021-12-03 12:04:29 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool Dec 3 12:04:29 hd518 mariadbd[189943]: 2021-12-03 12:04:29 0 [Note] InnoDB: Buffer pool(s) dump completed at 211203 12:04:29 Dec 3 12:04:29 hd518 mariadbd[189943]: 2021-12-03 12:04:29 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" Dec 3 12:04:29 hd518 mariadbd[189943]: 2021-12-03 12:04:29 0 [Note] InnoDB: Shutdown completed; log sequence number 142412521; transaction id 145168 Dec 3 12:04:29 hd518 mariadbd[189943]: 2021-12-03 12:04:29 0 [Note] /usr/sbin/mariadbd: Shutdown complete Dec 3 12:04:29 hd518 systemd[1]: mariadb.service: Succeeded. Dec 3 12:04:29 hd518 systemd[1]: Stopped MariaDB 10.5.12 database server. Dec 3 12:04:29 hd518 systemd[1]: mariadb.service: Consumed 1.065s CPU time. Dec 3 12:04:29 hd518 systemd[1]: Starting MariaDB 10.5.12 database server... Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.12-MariaDB-0+deb11u1) starting as process 190218 ... Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] InnoDB: Uses event mutexes Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] InnoDB: Number of pools: 1 Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] InnoDB: Using Linux native AIO Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] InnoDB: Completed initialization of buffer pool Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] InnoDB: 128 rollback segments are active. Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] InnoDB: 10.5.12 started; log sequence number 142412521; transaction id 145169 Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] Plugin 'FEEDBACK' is disabled. Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] Server socket created on IP: '::'. Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] Reading of all Master_info entries succeeded Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] Added new Master_info '' to hash table Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] /usr/sbin/mariadbd: ready for connections. Dec 3 12:04:29 hd518 mariadbd[190218]: Version: '10.5.12-MariaDB-0+deb11u1' socket: '/run/mysqld/mysqld.sock' port: 3306 Debian 11 Dec 3 12:04:29 hd518 mariadbd[190218]: 2021-12-03 12:04:29 0 [Note] InnoDB: Buffer pool(s) load completed at 211203 12:04:29 Dec 3 12:04:29 hd518 systemd[1]: Started MariaDB 10.5.12 database server. Dec 3 12:04:29 hd518 /etc/mysql/debian-start[190237]: Upgrading MySQL tables if necessary. Dec 3 12:04:29 hd518 /etc/mysql/debian-start[190240]: Looking for 'mysql' as: /usr/bin/mysql Dec 3 12:04:29 hd518 /etc/mysql/debian-start[190240]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Dec 3 12:04:29 hd518 /etc/mysql/debian-start[190240]: This installation of MariaDB is already upgraded to 10.5.12-MariaDB, use --force if you still need to run mysql_upgrade Dec 3 12:04:29 hd518 /etc/mysql/debian-start[190248]: Checking for insecure root accounts. Dec 3 12:04:29 hd518 /etc/mysql/debian-start[190252]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
You made changes to the running config values, you need to also make those to the mysql config files to be persistent. Search through /etc/mysql/* (all .cnf files in that directory and sub directories) and see if you find the setting you wish to change, or add it to a config file if not found (you can eg. create your own config file with local settings).
