Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.11.6
-
None
-
Not for Release Notes
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
Attachments
Issue Links
- duplicates
-
MDEV-32920 Innodb_buffer_pool_read_requests always 0
-
- Closed
-