MySQL Forums
Forum List  »  Knowledge Base

sql_log_bin
Posted by: Arindom Dam
Date: June 09, 2008 08:53AM

Hello,

Am on mysql v5.0.51a

Why am I not able to see the session variable; sql_log_bin when I do the following? ..

mysql> show session 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)

It does show up when I do this ..

mysql> select @@session.sql_log_bin;
+-----------------------+
| @@session.sql_log_bin |
+-----------------------+
| 1 |
+-----------------------+
1 row in set (0.00 sec)



Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
sql_log_bin
5278
June 09, 2008 08:53AM
2088
June 09, 2008 11:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.