Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4.32, 10.5.23, 10.6.16, 10.11.5
-
docker mariadb:10.11
Description
docker run --restart=always --name mariadb1011enginevalidate -e MYSQL_ROOT_PASSWORD=123456 -d mariadb:10.11
> create database test;
> use test;
> source init_tables.sql;
> source select.sql;
When executing source select.sql normally, you will get that the empty set takes about 0.002s.
But when SET GLOBAL innodb_buffer_pool_size = 9223372036854775807; this value is the legal maximum value described in the document, and the execution time of source select.sql can reach about 50 seconds.
Performance drops greatly. Why is this?
https://mariadb.com/kb/en/innodb-system-variables/#innodb_buffer_pool_size
Attachments
Issue Links
- relates to
-
MDEV-29445 reorganise innodb buffer pool (and remove buffer pool chunks)
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue relates to |
| Assignee | Marko Mäkelä [ marko ] | |
| Status | Open [ 1 ] | Needs Feedback [ 10501 ] |
| Attachment | backup.sql [ 72508 ] |
| Status | Needs Feedback [ 10501 ] | Open [ 1 ] |
| Affects Version/s | 10.6.16 [ 29014 ] | |
| Affects Version/s | 10.5.23 [ 29012 ] | |
| Affects Version/s | 10.4.32 [ 29300 ] |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Fix Version/s | 10.11 [ 27614 ] |
| Assignee | Marko Mäkelä [ marko ] | Daniel Black [ danblack ] |
| Fix Version/s | 10.4 [ 22408 ] |
| Labels | foundation |