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

[13 Jun 2006 6:31] Oli Sennhauser
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.
[13 Jun 2006 9:49] Valeriy Kravchuk
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)
[4 Jun 2008 21:14] Sveta Smirnova
Now it is shown, but reflects no value. See bug #37187 also.
[30 Sep 2009 18:04] Sergei Golubchik
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
[6 Mar 2010 11:03] Bugs System
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)
[8 Mar 2010 1:43] Paul Dubois
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.