Eine aufbereitete Darstellung der Quelle

 
     
 
 
Anforderungen  |   Konzepte  |   Entwurf  |   Entwicklung  |   Qualitätssicherung  |   Lebenszyklus  |   Steuerung
 
 
 
 

Benutzer

Quelle  reset_slave.result   Sprache: Lisp

 

connect  slave,127.0.0.1,root,,,$SERVER_MYPORT_3;
change master 'master1' to 
master_port=MYPORT_1, 
master_host='127.0.0.1', master_ssl_verify_server_cert=0,
master_user='root';
start slave 'master1';
set default_master_connection = 'master1';
include/wait_for_slave_to_start.inc
connect  master1,127.0.0.1,root,,,$SERVER_MYPORT_1;
drop table if exists t1;
create table t1 (i int) engine=MyISAM;
insert into t1 values (1),(2);
connection slave;
stop slave 'master1';
show slave 'master1' status;
Slave_IO_State 
Master_Host 127.0.0.1
Master_User root
Master_Port MYPORT_1
Connect_Retry 60
Master_Log_File master-bin.000001
Read_Master_Log_Pos <read_master_log_pos>
Relay_Log_File mysqld-relay-bin-master1.000002
Relay_Log_Pos <relay_log_pos>
Relay_Master_Log_File master-bin.000001
Slave_IO_Running No
Slave_SQL_Running No
Replicate_Do_DB 
Replicate_Ignore_DB 
Replicate_Do_Table 
Replicate_Ignore_Table 
Replicate_Wild_Do_Table 
Replicate_Wild_Ignore_Table 
Last_Errno 0
Last_Error 
Skip_Counter 0
Exec_Master_Log_Pos <read_master_log_pos>
Relay_Log_Space <relay_log_space>
Until_Condition None
Until_Log_File 
Until_Log_Pos 0
Master_SSL_Allowed Yes
Master_SSL_CA_File 
Master_SSL_CA_Path 
Master_SSL_Cert 
Master_SSL_Cipher 
Master_SSL_Key 
Seconds_Behind_Master NULL
Master_SSL_Verify_Server_Cert No
Last_IO_Errno 0
Last_IO_Error 
Last_SQL_Errno 0
Last_SQL_Error 
Replicate_Ignore_Server_Ids 
Master_Server_Id 1
Master_SSL_Crl 
Master_SSL_Crlpath 
Using_Gtid Slave_Pos
Gtid_IO_Pos 0-1-3
Replicate_Do_Domain_Ids 
Replicate_Ignore_Domain_Ids 
Parallel_Mode optimistic
SQL_Delay 0
SQL_Remaining_Delay NULL
Slave_SQL_Running_State 
Slave_DDL_Groups 2
Slave_Non_Transactional_Groups 1
Slave_Transactional_Groups 0
Replicate_Rewrite_DB 
Connects_Tried 1
Master_Retry_Count 100000
mysqld-relay-bin-master1.000001
mysqld-relay-bin-master1.000002
mysqld-relay-bin-master1.index
reset slave 'master1';
show slave 'master1' status;
Slave_IO_State 
Master_Host 127.0.0.1
Master_User root
Master_Port MYPORT_1
Connect_Retry 60
Master_Log_File 
Read_Master_Log_Pos 4
Relay_Log_File 
Relay_Log_Pos <relay_log_pos>
Relay_Master_Log_File 
Slave_IO_Running No
Slave_SQL_Running No
Replicate_Do_DB 
Replicate_Ignore_DB 
Replicate_Do_Table 
Replicate_Ignore_Table 
Replicate_Wild_Do_Table 
Replicate_Wild_Ignore_Table 
Last_Errno 0
Last_Error 
Skip_Counter 0
Exec_Master_Log_Pos 0
Relay_Log_Space <relay_log_space>
Until_Condition None
Until_Log_File 
Until_Log_Pos 0
Master_SSL_Allowed Yes
Master_SSL_CA_File 
Master_SSL_CA_Path 
Master_SSL_Cert 
Master_SSL_Cipher 
Master_SSL_Key 
Seconds_Behind_Master NULL
Master_SSL_Verify_Server_Cert No
Last_IO_Errno 0
Last_IO_Error 
Last_SQL_Errno 0
Last_SQL_Error 
Replicate_Ignore_Server_Ids 
Master_Server_Id 0
Master_SSL_Crl 
Master_SSL_Crlpath 
Using_Gtid Slave_Pos
Gtid_IO_Pos 
Replicate_Do_Domain_Ids 
Replicate_Ignore_Domain_Ids 
Parallel_Mode optimistic
SQL_Delay 0
SQL_Remaining_Delay NULL
Slave_SQL_Running_State 
Slave_DDL_Groups 2
Slave_Non_Transactional_Groups 1
Slave_Transactional_Groups 0
Replicate_Rewrite_DB 
Connects_Tried 0
Master_Retry_Count 100000
reset slave 'master1' all;
show slave 'master1' status;
ERROR HY000: There is no master connection 'master1'
drop table t1;
include/reset_master_slave.inc
disconnect slave;
connection master1;
drop table t1;
include/reset_master_slave.inc
disconnect master1;

Messung V0.5 in Prozent
C=86 H=100 G=93

¤ Dauer der Verarbeitung: 0.10 Sekunden  (vorverarbeitet am  2026-10-08) ¤

*© Formatika GbR, Deutschland






Wurzel

Suchen

PVS Prover

Isabelle Prover

NIST Cobol Testsuite

Cephes Mathematical Library

Vienna Development Method

Haftungshinweis

Die Informationen auf dieser Webseite wurden nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit, noch Qualität der bereit gestellten Informationen zugesichert.

Bemerkung:

Die farbliche Syntaxdarstellung und die Messung sind noch experimentell.






                                                                                                                                                                                                                                                                                                                                                                                                     


Neuigkeiten

     Aktuelles
     Motto des Tages

Open Source Software

     Quellcodebibliothek
     Eigene Quellcodes
     Fremde Quellcodes
     Suchen

Jenseits des Üblichen ....

Besucherstatistik

Besucherstatistik

Statistik
#Sources=1126864
#Domains=1897691