centreon-plugins icon indicating copy to clipboard operation
centreon-plugins copied to clipboard

Published 20 hours ago • verified publisher icon centreon

[database::mysql::plugin] wrong data on table-frag with databases-size mode

Open gagzou opened this issue 1 year ago • 5 comments

Hi,

The following command gives me a surprising result : /usr/lib/centreon/plugins//centreon_mysql.pl --plugin=database::mysql::plugin --host=x.x.x.x --username='xxx' --password='***' --port='' --mode=databases-size --filter-database='^(?!(information_schema|performance_schema|test))' --filter-perfdata='database' --warning-table-usage='' --critical-table-usage='' --warning-table-free='' --critical-table-free='' --warning-table-frag='15' --critical-table-frag='30' --warning-db-usage='' --critical-db-usage='' --warning-db-free='' --critical-db-free='' --warning-total-usage='' --critical-total-usage='' --warning-total-free='' --critical-total-free='' --verbose

CRITICAL: Database 'xxx' Table 'acteur' Fragmentation: 85.33 % - Table 'xxx' Fragmentation: 85.33 % - Table 'xxx' Fragmentation: 64.00 % - Table 'xxx' Fragmentation: 256.00 % - Table 'xxxx' Fragmentation: 256.00 % - Table 'xxx' Fragmentation: 64.00 % - Table 'xxx' Fragmentation: 85.33 % - Table 'xxx' Fragmentation: 96.00 % - Table 'xxx' Fragmentation: 256.00 % - Table 'xxx' Fragmentation: 256.00 % - Table 'xxx' Fragmentation: 128.00 % - Table 'xxx' Fragmentation: 256.00 % - Table 'xxx' Fragmentation: 85.33 % - Table 'xxx' Fragmentation: 85.33 % - Table 'xxx' Fragmentation: 64.00 % - Table 'xxx' Fragmentation: 85.33 % - Table 'xxx' Fragmentation: 85.33 % - Table 'xxxx' Fragmentation: 160.00 % - Table 'xxx' Fragmentation: 128.00 %

Some results are greater than 100%

  • Environment: uname -a ; cat /etc/redhat-release Linux xxx 3.10.0-1160.102.1.el7.x86_64 #1 SMP Tue Oct 17 15:42:21 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux CentOS Linux release 7.9.2009 (Core)
  • Version of the plugin: centreon-plugin-Applications-Databases-Mysql-20231114-140340.el7.noarch
  • Information about the monitored resource: mysql 5.6 / centos 6.7

Expected result

A consistent result in % (0-100)

Actual result

exemple : Table 'xxx' Fragmentation: 256.00 %

Best regards,

gagzou avatar Dec 05 '23 22:12 gagzou

For exemple, result for sql command (Found in plugin pack script) :

mysql> SELECT table_schema, table_name, engine, data_free, data_length+index_length as data_used, (DATA_FREE / (DATA_LENGTH+INDEX_LENGTH)) as TAUX_FRAG FROM information_schema.tables WHERE table_type = 'BASE TABLE' AND engine IN ('InnoDB', 'MyISAM'); +----------------------------+----------------------------------------+--------+-----------+-----------+-----------+ | table_schema | table_name | engine | data_free | data_used | TAUX_FRAG | +----------------------------+----------------------------------------+--------+-----------+-----------+-----------+ | xxx | xxx | InnoDB | 4194304 | 49152 | 85.3333 | | xxx | xxx | InnoDB | 0 | 32768 | 0.0000 | | xxx | xxx | InnoDB | 5242880 | 376832 | 13.9130 | | xxx | xxx | InnoDB | 4194304 | 49152 | 85.3333 | | xxx | xxx | InnoDB | 0 | 16384 | 0.0000 | | xxx | xxx | InnoDB | 6291456 | 98304 | 64.0000 | | xxx | xxx | InnoDB | 7340032 | 344064 | 21.3333 | | xxx | xxx | InnoDB | 0 | 49152 | 0.0000 | | xxx | xxx | InnoDB | 0 | 16384 | 0.0000 | | xxx | xxx | InnoDB | 0 | 65536 | 0.0000 | | xxx | xxx | InnoDB | 4194304 | 163840 | 25.6000 | | xxx | xxx | InnoDB | 0 | 16384 | 0.0000 | | xxx | xxx | InnoDB | 4194304 | 16384 | 256.0000 | | xxx | xxx | InnoDB | 0 | 16384 | 0.0000 | | xxx | xxx | InnoDB | 0 | 16384 | 0.0000 | | xxx | xxx | InnoDB | 0 | 16384 | 0.0000 | | xxx | xxx | InnoDB | 4194304 | 16384 | 256.0000 | | xxx | xxx | InnoDB | 4194304 | 65536 | 64.0000 | | xxx | xxx | InnoDB | 4194304 | 49152 | 85.3333 | | xxx | xxx | InnoDB | 6291456 | 65536 | 96.0000 | | xxx | xxx | InnoDB | 0 | 16384 | 0.0000 | | xxx | xxx | InnoDB | 4194304 | 16384 | 256.0000 | | xxx | xxx | InnoDB | 4194304 | 16384 | 256.0000 | | xxx | xxx | InnoDB | 4194304 | 32768 | 128.0000 |

gagzou avatar Dec 05 '23 22:12 gagzou

Hi @gagzou, I think you're right. What does this query return for you?

SELECT table_schema, table_name, engine, data_free, data_length+index_length as data_used, 100 * DATA_FREE / (DATA_LENGTH + INDEX_LENGTH + DATA_FREE) as TAUX_FRAG FROM information_schema.tables WHERE table_type = 'BASE TABLE' AND engine IN ('InnoDB', 'MyISAM');

omercier avatar Dec 20 '23 17:12 omercier

Hi, I sent the file directly to your email. Best regards,

gagzou avatar Dec 20 '23 22:12 gagzou

I prefer not to mix communication channels, next time ;-)

Here is an extract of the result you sent me:

+----------------------------+----------------------------------------+--------+-----------+------------+-----------+
| table_schema               | table_name                             | engine | data_free | data_used  | TAUX_FRAG |
+----------------------------+----------------------------------------+--------+-----------+------------+-----------+
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1835008 |   69.5652 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   5242880 | 1308065792 |    0.3992 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |   15253504 |   21.5670 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   7340032 | 3471736832 |    0.2110 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1736704 |   70.7182 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1589248 |   72.5212 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |   18939904 |   18.1303 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    5816320 |   41.8985 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |  251002880 |    2.4452 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1589248 |   72.5212 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    2637824 |   61.3909 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    5619712 |   42.7379 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    6864896 |   37.9259 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    8454144 |   33.1606 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |  254525440 |    1.6212 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |   21217280 |   16.5055 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   5242880 |   40976384 |   11.3435 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |   54624256 |    7.1309 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   5242880 | 2174746624 |    0.2405 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 | 1130201088 |    0.5536 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   3145728 |   13221888 |   19.2192 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   3145728 |    1015808 |   75.5906 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |   12107776 |   25.7286 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |   34160640 |   10.9355 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1720320 |   70.9141 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1114112 |   79.0123 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   7340032 |  558825472 |    1.2964 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 | 1222213632 |    0.3420 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    3325952 |   55.7734 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1703936 |   71.1111 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1589248 |   72.5212 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      49152 |   98.8417 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   7340032 |     376832 |   95.1168 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      49152 |   98.8417 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   5242880 |     344064 |   93.8416 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      65536 |   98.4615 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |      65536 |   98.9691 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      49152 |   98.8417 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |      49152 |   99.2248 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |      49152 |   99.2248 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      32768 |   99.2248 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      32768 |   99.2248 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |      16384 |   99.7403 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      49152 |   98.8417 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |     114688 |   97.3384 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      49152 |   98.8417 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      49152 |   98.8417 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |     114688 |   97.3384 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   7340032 |     131072 |   98.2456 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |     131072 |   97.9592 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      32768 |   99.2248 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      16384 |   99.6109 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1851392 |   69.3767 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   7340032 |  549847040 |    1.3173 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    5816320 |   41.8985 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   5242880 |  118784000 |    4.2272 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   5242880 | 1875361792 |    0.2788 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    6340608 |   39.8134 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   5242880 |  119767040 |    4.1940 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    2048000 |   67.1916 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |   80527360 |    4.9507 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    2703360 |   60.8076 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |  114966528 |    5.1885 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |  148537344 |    4.0635 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |   17858560 |   19.0193 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   7340032 |   30474240 |   19.4107 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |   65617920 |    8.7491 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    2211840 |   65.4731 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    3260416 |   56.2637 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    8962048 |   31.8804 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |   22593536 |   15.6575 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |  427442176 |    0.9717 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 | 1188593664 |    0.3516 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1900544 |   68.8172 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1753088 |   70.5234 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1589248 |   72.5212 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1851392 |   69.3767 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   7340032 |  651575296 |    1.1140 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    5816320 |   41.8985 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |  126140416 |    4.7507 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 | 2263351296 |    0.2772 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1114112 |   79.0123 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |  135512064 |    4.4367 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    2048000 |   67.1916 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |   74235904 |    7.8128 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    2670592 |   61.0979 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   5242880 |  145391616 |    3.4805 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   5242880 |  183173120 |    2.7826 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |   21004288 |   16.6450 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |   35733504 |   14.9708 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |  182108160 |    3.3394 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   5242880 |  495747072 |    1.0465 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    3260416 |   56.2637 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |   15253504 |   21.5670 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |   46759936 |    8.2315 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   5242880 |  526270464 |    0.9864 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   7340032 | 1386987520 |    0.5264 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1900544 |   68.8172 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1753088 |   70.5234 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    2637824 |   61.3909 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      49152 |   98.8417 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |  623263744 |    0.9993 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      49152 |   98.8417 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   5242880 |     344064 |   93.8416 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      65536 |   98.4615 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      49152 |   98.8417 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |  132349952 |    4.5379 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      49152 |   98.8417 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |   72138752 |    5.4947 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      65536 |   98.4615 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   7340032 |      49152 |   99.3348 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      49152 |   98.8417 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      32768 |   99.2248 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   7340032 |      32768 |   99.5556 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |      16384 |   99.7403 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   5242880 |      65536 |   98.7654 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |     114688 |   97.3384 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      49152 |   98.8417 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      49152 |   98.8417 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   5242880 |     131072 |   97.5610 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   6291456 |     131072 |   97.9592 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1900544 |   68.8172 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      32768 |   99.2248 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |      16384 |   99.6109 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   4194304 |    1671168 |   71.5084 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | InnoDB |   5242880 |    2113536 |   71.2695 |
| XXXXXXXXXXXXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | MyISAM |   1292136 |    3307076 |   28.0947 |
+----------------------------+----------------------------------------+--------+-----------+------------+-----------+

It seems to make much more sense than the previous method. We'll implement this in a next release.

omercier avatar Dec 22 '23 14:12 omercier

Hi, do you have any news regarding the resolution of this bug ? Best regards,

gagzou avatar May 13 '24 21:05 gagzou

Hello, :) This issue is planned to be analyzed and solved (we need to add some tests) in the current month. Thanks for your contribution and patience

lucie-dubrunfaut avatar Jun 03 '24 12:06 lucie-dubrunfaut

Hi @gagzou the fix is on track for the next release. You can try it from this branch Thanks for your issue!

omercier avatar Jul 01 '24 13:07 omercier

The fix will be publicly available on july 11th.

omercier avatar Jul 05 '24 14:07 omercier