MySQL Bugs: #20413: sql_slave_skip_counter is not shown in show variables

Bug #20413	sql_slave_skip_counter is not shown in show variables
Submitted:	13 Jun 2006 6:31	Modified:	8 Mar 2010 1:43
Reporter:	Oli Sennhauser	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S3 (Non-critical)
Version:	5.0.23-BK, 5.0.22	OS:	Any (any)
Assigned to:		CPU Architecture:	Any

Description:
sql_slave_skip_counter is not shown in show variables

How to repeat:
SHOW VARIABLES LIKE 'sql%';

Suggested fix:
Add value to show variables list.

Thank you for a problem report. Verified just as described with 5.0.23-BK on Linux:

openxs@suse:~/dbs/5.0> bin/mysql -uroot test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.23

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like '%slave%';
+---------------------------+-------+
| Variable_name             | Value |
+---------------------------+-------+
| init_slave                |       |
| log_slave_updates         | OFF   |
| slave_compressed_protocol | OFF   |
| slave_load_tmpdir         | /tmp/ |
| slave_net_timeout         | 3600  |
| slave_skip_errors         | OFF   |
| slave_transaction_retries | 10    |
+---------------------------+-------+
7 rows in set (0.01 sec)

mysql> show variables like 'sql%';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| sql_big_selects | ON    |
| sql_mode        |       |
| sql_notes       | ON    |
| sql_warnings    | OFF   |
+-----------------+-------+
4 rows in set (0.00 sec)

Now it is shown, but reflects no value. See bug #37187 also.

note that it is shown in SHOW VARIABLES and INFORMATION_SCHEMA.GLOBAL_VARIABLES but it cannot be read as @@global.sql_slave_skip_counter, which is inconsistent

Pushed into 5.5.3-m3 (revid:alik@sun.com-20100306103849-hha31z2enhh7jwt3) (version source revid:vvaintroub@fedora12-20091225154921-x25a5pyw1pxiwobv) (merge vers: 5.5.99) (pib:16)

Noted in 5.5.3 changelog.

The value of sql_slave_skip_counter was empty when displayed by SHOW
VARIABLES or INFORMATION_SCHEMA.GLOBAL_VARIABLES.