[MDEV-25073] INNODB_BUFFER_POOL_LOAD_PAGES_ABORT, INNODB_LRU_FLUSH_SIZE variables are not documented Created: 2021-03-06  Updated: 2021-03-07  Resolved: 2021-03-07

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: 10.3, 10.4, 10.5, 10.6
Fix Version/s: N/A

Type: Bug Priority: Trivial
Reporter: Elena Stepanova Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-18824 Document debug options Open

 Description   

Search in the KB doesn't return anything for this variable:

MariaDB [(none)]> select * from information_schema.system_variables where variable_name = 'INNODB_BUFFER_POOL_LOAD_PAGES_ABORT' \G
 
*************************** 1. row ***************************
 
        VARIABLE_NAME: INNODB_BUFFER_POOL_LOAD_PAGES_ABORT
 
        SESSION_VALUE: NULL
 
         GLOBAL_VALUE: 9223372036854775807
 
  GLOBAL_VALUE_ORIGIN: COMPILE-TIME
 
        DEFAULT_VALUE: 9223372036854775807
 
       VARIABLE_SCOPE: GLOBAL
 
        VARIABLE_TYPE: BIGINT UNSIGNED
 
     VARIABLE_COMMENT: Number of pages during a buffer pool load to process before signaling innodb_buffer_pool_load_abort=1
 
    NUMERIC_MIN_VALUE: 1
 
    NUMERIC_MAX_VALUE: 9223372036854775807
 
   NUMERIC_BLOCK_SIZE: 0
 
      ENUM_VALUE_LIST: NULL
 
            READ_ONLY: NO
 
COMMAND_LINE_ARGUMENT: REQUIRED
 
    GLOBAL_VALUE_PATH: NULL
 
1 row in set (0.003 sec)

Present in 10.3-10.6.

MariaDB [(none)]> select * from information_schema.system_variables where variable_name = 'INNODB_LRU_FLUSH_SIZE' \G
 
*************************** 1. row ***************************
 
        VARIABLE_NAME: INNODB_LRU_FLUSH_SIZE
 
        SESSION_VALUE: NULL
 
         GLOBAL_VALUE: 32
 
  GLOBAL_VALUE_ORIGIN: COMPILE-TIME
 
        DEFAULT_VALUE: 32
 
       VARIABLE_SCOPE: GLOBAL
 
        VARIABLE_TYPE: BIGINT UNSIGNED
 
     VARIABLE_COMMENT: How many pages to flush on LRU eviction
 
    NUMERIC_MIN_VALUE: 1
 
    NUMERIC_MAX_VALUE: 18446744073709551615
 
   NUMERIC_BLOCK_SIZE: 0
 
      ENUM_VALUE_LIST: NULL
 
            READ_ONLY: NO
 
COMMAND_LINE_ARGUMENT: REQUIRED
 
    GLOBAL_VALUE_PATH: NULL
 
1 row in set (0.003 sec)

Present in 10.5, 10.6

 Comments   
Comment by Ian Gilfillan [ 2021-03-07 ]

These are available in debug builds only.

Comment by Ian Gilfillan [ 2021-03-07 ]

Documented.

Comment by Elena Stepanova [ 2021-03-07 ]

That's not quite so. The first one (INNODB_BUFFER_POOL_LOAD_PAGES_ABORT) is debug only. The second one, INNODB_LRU_FLUSH_SIZE, is present in release builds as well:

10.5.9 bintar

 
MariaDB [test]> select @@innodb_lru_flush_size;
 
+-------------------------+
 
| @@innodb_lru_flush_size |
 
+-------------------------+
 
|                      32 |
 
+-------------------------+
 
1 row in set (0.000 sec)
 
 
 
MariaDB [test]> select @@version, @@version_comment;
 
+----------------+-------------------+
 
| @@version      | @@version_comment |
 
+----------------+-------------------+
 
| 10.5.9-MariaDB | MariaDB Server    |
 
+----------------+-------------------+
 
1 row in set (0.000 sec)

Generated at Thu Feb 08 09:34:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.