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: liu hickey (OCA)
• Status: Closed
• 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] liu hickey

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] MySQL Verification Team

Hello hui liu,

Thank you for the report.

Thanks,
Umesh

[17 Sep 2014 10:53] MySQL Verification Team

//

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.