[MARIADB] CHECK PERFORMANCE INNODB CONFIG - fourslickz/notes GitHub Wiki

MariaDB [(none)]> SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool%';
+-----------------------------------------+--------------------------------------------------+
| Variable_name                           | Value                                            |
+-----------------------------------------+--------------------------------------------------+
| Innodb_buffer_pool_dump_status          |                                                  |
| Innodb_buffer_pool_load_status          | Buffer pool(s) load completed at 251212 18:23:16 |
| Innodb_buffer_pool_resize_status        |                                                  |
| Innodb_buffer_pool_load_incomplete      | OFF                                              |
| Innodb_buffer_pool_pages_data           | 778751                                           |
| Innodb_buffer_pool_bytes_data           | 12759056384                                      |
| Innodb_buffer_pool_pages_dirty          | 74624                                            |
| Innodb_buffer_pool_bytes_dirty          | 1222639616                                       |
| Innodb_buffer_pool_pages_flushed        | 574686                                           |
| Innodb_buffer_pool_pages_free           | 1                                                |
| Innodb_buffer_pool_pages_made_not_young | 1115523082                                       |
| Innodb_buffer_pool_pages_made_young     | 17299034                                         |
| Innodb_buffer_pool_pages_misc           | 0                                                |
| Innodb_buffer_pool_pages_old            | 287448                                           |
| Innodb_buffer_pool_pages_total          | 778752                                           |
| Innodb_buffer_pool_pages_lru_flushed    | 243762                                           |
| Innodb_buffer_pool_pages_lru_freed      | 1037208                                          |
| Innodb_buffer_pool_pages_split          | 82519                                            |
| Innodb_buffer_pool_read_ahead_rnd       | 0                                                |
| Innodb_buffer_pool_read_ahead           | 0                                                |
| Innodb_buffer_pool_read_ahead_evicted   | 8137                                             |
| Innodb_buffer_pool_read_requests        | 75813954006                                      |
| Innodb_buffer_pool_reads                | 17997738                                         |
| Innodb_buffer_pool_wait_free            | 451                                              |
| Innodb_buffer_pool_write_requests       | 94320856                                         |
+-----------------------------------------+--------------------------------------------------+
25 rows in set (0.001 sec)