Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.11.6
-
None
-
None
Description
Hello,
I recently found out with my matomo application (5.3), that on my database Mariadb (10.11.6), no reads are being done on my innodb, but are rather being done on disc :
MariaDB [(none)]> show global status like 'innodb_buffer_pool_read%';~
-------------------------------------------------+
Variable_name | Value |
-------------------------------------------------+
Innodb_buffer_pool_read_ahead_rnd | 0 |
Innodb_buffer_pool_read_ahead | 868224377 |
Innodb_buffer_pool_read_ahead_evicted | 240088434 |
Innodb_buffer_pool_read_requests | 0 |
Innodb_buffer_pool_reads | 2448464392 |
-------------------------------------------------+
5 rows in set (0,000 sec)
Important note:
1. All tables in matomo are innodb engine (not MyISAM)
2. The database is up for 133 days, so the statistics of the innodb_buffer_pool_% are reliable.
3. My Innodb_buffer_pool_size is 10Gb
Thank you in advance for clarifying this.
Regards,
Noor BEEGUM