Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.5, 5.5.33a
-
None
-
None
-
None
-
CentOS 6 64-bit
Description
Looks like some variables have a maximum value of an unsigned 32bit integer, but the docs say they should be 64 bit.
https://mariadb.com/kb/en/server-system-variables/#delayed_insert_limit
In question:
delayed_insert_limit
delayed_queue_size
key_cache_age_threshold
log_warnings
max_seeks_for_key
min_examined_row_limit
net_retry_count
progress_report_time
query_alloc_block_size
query_cache_limit
query_cache_min_res_unit
query_prealloc_size
transaction_alloc_block_size
transaction_prealloc_size
Example:
MariaDB [(none)]> \! uname -a
|
Linux dev-100-11 2.6.32-358.23.2.el6.x86_64 #1 SMP Wed Oct 16 18:37:12 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
|
|
|
MariaDB [(none)]> \! rpm -qa|grep "MariaDB"
|
MariaDB-client-10.0.5-1.x86_64
|
MariaDB-compat-10.0.5-1.x86_64
|
MariaDB-server-10.0.5-1.x86_64
|
MariaDB-common-10.0.5-1.x86_64
|
|
|
MariaDB [(none)]> SELECT VERSION();
|
+----------------+
|
| VERSION() |
|
+----------------+
|
| 10.0.5-MariaDB |
|
+----------------+
|
1 row in set (0.00 sec)
|
|
|
MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'delayed_insert_limit';
|
+----------------------+-------+
|
| Variable_name | Value |
|
+----------------------+-------+
|
| delayed_insert_limit | 100 |
|
+----------------------+-------+
|
1 row in set (0.00 sec)
|
|
|
MariaDB [(none)]> SET GLOBAL delayed_insert_limit = 18446744073709547520;
|
Query OK, 0 rows affected, 1 warning (0.00 sec)
|
|
|
MariaDB [(none)]> SHOW WARNINGS;
|
+---------+------+------------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+------------------------------------------------------------------------+
|
| Warning | 1292 | Truncated incorrect delayed_insert_limit value: '18446744073709547520' |
|
+---------+------+------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
|
|
MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'delayed_insert_limit';
|
+----------------------+------------+
|
| Variable_name | Value |
|
+----------------------+------------+
|
| delayed_insert_limit | 4294967295 |
|
+----------------------+------------+
|
1 row in set (0.00 sec)
|
|
|
MariaDB [(none)]>
|