1
'#--------------------FN_DYNVARS_044_02-------------------------#'
2
SET @@global.innodb_max_dirty_pages_pct = 80;
3
'connect (con1,localhost,root,,,,)'
5
SELECT @@global.innodb_max_dirty_pages_pct;
6
@@global.innodb_max_dirty_pages_pct
8
SET @@global.innodb_max_dirty_pages_pct = 70;
9
'connect (con2,localhost,root,,,,)'
11
SELECT @@global.innodb_max_dirty_pages_pct;
12
@@global.innodb_max_dirty_pages_pct
14
'#--------------------FN_DYNVARS_044_02-------------------------#'
16
'---Check when innodb_max_dirty_pages_pct is 10---'
17
SET @@global.innodb_max_dirty_pages_pct = 10;
21
CALL add_records(500);
23
'We expect dirty pages pct to be BELOW_MAX'
27
DROP PROCEDURE add_records;
28
DROP PROCEDURE add_until;
29
DROP PROCEDURE check_pct;
30
DROP FUNCTION dirty_pct;