Difference between revisions of "Using Linux native AIO"

From wikieduonline
Jump to navigation Jump to search
Line 29: Line 29:
 
  Version: '10.4.21-MariaDB-1:10.4.21+maria~bionic-log'  socket: '[[/var/run/mysqld/mysqld.sock]]'  port: 3306  mariadb.org binary distribution
 
  Version: '10.4.21-MariaDB-1:10.4.21+maria~bionic-log'  socket: '[[/var/run/mysqld/mysqld.sock]]'  port: 3306  mariadb.org binary distribution
 
  2023-12-26  5:52:16 0 [Note] InnoDB: Buffer pool(s) load completed at 231226  5:52:16
 
  2023-12-26  5:52:16 0 [Note] InnoDB: Buffer pool(s) load completed at 231226  5:52:16
 +
 +
 +
{{MariaDB logs}}

Revision as of 09:39, 18 December 2024

2023-12-26  5:52:14 0 [Note] InnoDB: Using Linux native AIO
2023-12-26  5:52:14 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-12-26  5:52:14 0 [Note] InnoDB: Uses event mutexes
2023-12-26  5:52:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-12-26  5:52:14 0 [Note] InnoDB: Number of pools: 1
2023-12-26  5:52:14 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-12-26  5:52:14 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-12-26  5:52:14 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2023-12-26  5:52:14 0 [Note] InnoDB: Completed initialization of buffer pool
2023-12-26  5:52:14 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2023-12-26  5:52:14 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=14814872210
2023-12-26  5:52:14 0 [Note] InnoDB: Last binlog file '/backupsXXX/logbin/mariadb-bin.000016', position 67304927
2023-12-26  5:52:14 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-12-26  5:52:14 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-12-26  5:52:14 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-12-26  5:52:14 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-12-26  5:52:14 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-12-26  5:52:14 0 [Note] InnoDB: Waiting for purge to start
2023-12-26  5:52:14 0 [Note] InnoDB: 10.4.21 started; log sequence number 14814872219; transaction id 48026822
2023-12-26  5:52:14 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-12-26  5:52:14 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-12-26  5:52:14 0 [Note] Recovering after a crash using /backups/logbin/mariadb-bin
2023-12-26  5:52:15 0 [Note] Starting crash recovery...
2023-12-26  5:52:15 0 [Note] Crash recovery finished.
2023-12-26  5:52:15 0 [Note] Server socket created on IP: '127.0.0.1'.
2023-12-26  5:52:15 0 [Note] Reading of all Master_info entries succeeded
2023-12-26  5:52:15 0 [Note] Added new Master_info  to hash table
2023-12-26  5:52:15 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.4.21-MariaDB-1:10.4.21+maria~bionic-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
2023-12-26  5:52:16 0 [Note] InnoDB: Buffer pool(s) load completed at 231226  5:52:16


/var/log/mysql/error.log, mariadbcheck, MariaDB binary log

Advertising: