Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
There are several size-related system variables that can be changed dynamically. e.g.:
- innodb_log_file_size
- innodb_buffer_pool_size
- max_heap_table_size
- tmp_table_size
- tmp_disk_table_size
- binlog_cache_size
- binlog_file_cache_size
- binlog_stmt_cache_size
- etc.
In configuration files, users are able to set these variables using SI prefixes. e.g.:
[mariadb]
|
innodb_log_file_size=2G
|
It would be great if users could do the same thing with SET:
SET GLOBAL innodb_log_file_size='2G'; |
Currently, users would have to do this instead:
SET GLOBAL innodb_log_file_size=(2 * 1024 * 1024 * 1024); |
Can we implement SI prefixes for SET?
Attachments
Issue Links
- relates to
-
MDEV-26400 ALTER TABLE does not remove KEY_BLOCK_SIZE for non-Compressed InnoDB tables
- Stalled
-
MDEV-27158 Humanize the number of bytes in InnoDB messages
- Closed