List:Cluster« Previous MessageNext Message »
From:Jon Stephens Date:October 27 2009 9:45am
Subject:Re: why i can not use SHOW VARIABLES LIKE 'binlog_format' get result??
View as plain text  
ch huang wrote:
> *i see the following text in manual, but can not get any result using this
> command "*
> 
> *SHOW VARIABLES LIKE 'binlog_format' " ,and my mysql version is 5.0*

Please use MySQL Cluster NDB-6.3 or NDB-7.0.

We do not recommend MySQL 5.0 for new Cluster deployments, and we 
encourage anyone using MySQL 5.0 for Cluster to upgrade as soon as possible.

BTW, binlog_format does not exist before MySQL 5.1 (and current Cluster 
versions are based on MySQL 5.1).


> 
> *
> 16.3.4.10: ** How do I tell whether a master server is using statement-based
> or row-based binary logging format? *
> 
> Check the value of the
>
> binlog_format<http://dev.mysql.com/doc/refman/5.1/en/replication-options-binary-log.html#sysvar_binlog_format>system
> variable:
> 
> mysql> *SHOW VARIABLES LIKE 'binlog_format';*
> 
> 
> mysql> show variables like 'binlog_format';
> Empty set (0.00 sec)
> 


-- 


Jon Stephens - jon.stephens@stripped
Technical Writer
MySQL Documentation Team
Sun Microsystems AB
MySQL and Software Infrastructure Group
Liljeholmen (Stockholm), Sweden
Summer: UTC +02.00 / Winter: UTC +01.00
Mobile: +46 (0) 736 773 993
Skype: plastic-fish
MySQL: www.mysql.com
Sun: www.sun.com

Thread
why i can not use SHOW VARIABLES LIKE 'binlog_format' get result??ch huang27 Oct
  • Re: why i can not use SHOW VARIABLES LIKE 'binlog_format' get result??Adam Robertson27 Oct
  • Re: why i can not use SHOW VARIABLES LIKE 'binlog_format' get result??Jon Stephens27 Oct