Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.1.32
-
None
Description
I have noticed that changing the tokudb_block_size variable with set global has no effect on subsequently created tables. A server restart is required. In Percona Server, this works as intended and the newly created tables have the new block size.
How to reproduce:
MariaDB [(none)]> show global variables like 'tokudb_block_size'; |
+-------------------+---------+ |
| Variable_name | Value |
|
+-------------------+---------+ |
| tokudb_block_size | 4194304 |
|
+-------------------+---------+ |
1 row in set (0.00 sec) |
|
|
MariaDB [mydb]> create table testtable (id int not null primary key) engine=TokuDB; |
Query OK, 0 rows affected (0.07 sec) |
|
|
MariaDB [mydb]>
|
[3]+ Stopped mysql -A
|
[root@rdba-c]# tokuftdump /var/lib/mysql/_mydb_testtable_main_89a9_2_1d.tokudb | grep nodesize
|
nodesize=4194304
|
basementnodesize=65536
|
[root@rdba-c]# fg
|
mysql -A
|
set global tokudb_block_size=132768; |
Query OK, 0 rows affected (0.00 sec) |
|
|
MariaDB [mydb]> show global variables like 'tokudb_block_size'; |
+-------------------+--------+ |
| Variable_name | Value |
|
+-------------------+--------+ |
| tokudb_block_size | 132768 |
|
+-------------------+--------+ |
1 row in set (0.00 sec) |
|
|
MariaDB [mydb]> create table testtable2 (id int not null primary key) engine=TokuDB; |
Query OK, 0 rows affected (0.06 sec) |
|
|
MariaDB [mydb]>
|
[3]+ Stopped mysql -A
|
[root@rdba-c]# tokuftdump /var/lib/mysql/_mydb_testtable2_main_89ab_2_1d.tokudb | grep nodesize
|
nodesize=4194304
|
basementnodesize=65536
|
[root@rdba-c]#
|