Change in mysql are back after reload

Discussion in 'Installation/Configuration' started by pecka33, Dec 3, 2021.

  1. pecka33

    pecka33 Member

    Hello, i did some changes in mysql, latest debian with latest phpmyadmin and php 7.4. For example change value key buffer size[​IMG] 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
    
     
  2. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    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).
     

Share This Page