Bug #73947 [doc] default value for slave_pending_jobs_size_max is 16M
Submitted: 17 Sep 2014 9:51 Modified: 25 Sep 2014 14:00
Reporter: hui liu (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.6 OS:Any
Assigned to: David Moss CPU Architecture:Any
Tags: doc slave_pending_jobs_size_max

[17 Sep 2014 9:51] hui liu
Description:
http://dev.mysql.com/doc/refman/5.6/en/replication-options-slave.html

slave_pending_jobs_size_max

Introduced	5.6.3
System Variable Name	slave_pending_jobs_size_max
Variable Scope	Global
Dynamic Variable	Yes
 	Permitted Values
Type	numeric
Default	0
Min Value	1024
Max Value	18EB
Block Size	1024

"Default	0" is not correct, it should be 16M.

How to repeat:
read manual
[17 Sep 2014 10:51] Umesh Shastry
Hello hui liu,

Thank you for the report.

Thanks,
Umesh
[17 Sep 2014 10:53] Umesh Shastry
//

Manual page also has "The minimum possible value for this variable is 1024; the default is 16MB" just below the table. 

// 5.6
mysql> show variables like 'slave_pending_jobs_size_max';
+-----------------------------+----------+
| Variable_name               | Value    |
+-----------------------------+----------+
| slave_pending_jobs_size_max | 16777216 |
+-----------------------------+----------+
1 row in set (0.00 sec)

// 5.6
static Sys_var_ulonglong Sys_mts_pending_jobs_size_max(
       "slave_pending_jobs_size_max",
       "Max size of Slave Worker queues holding yet not applied events."
       "The least possible value must be not less than the master side "
       "max_allowed_packet.",
       GLOBAL_VAR(opt_mts_pending_jobs_size_max), CMD_LINE(REQUIRED_ARG),
       VALID_RANGE(1024, (ulonglong)~(intptr)0), DEFAULT(16 * 1024*1024),
       BLOCK_SIZE(1024), ON_CHECK(0));
[25 Sep 2014 14:00] David Moss
This has been fixed with commit 40237.