29 Kasım 2021 Pazartesi

SHOW SLAVE STATUS

Örnek
Şöyle yaparız
SHOW SLAVE STATUS\G;
Açıklaması şöyle 
If you issue this statement using the mysql client, you can use a \G statement terminator rather than a semicolon to obtain a more readable vertical layout
Örnek
Şöyle yaparız
# You can also watch the data changing. Try…
watch –interval=1 –differences 'mysql -uuser -ppassword -e "show slave status\G"'


Hiç yorum yok:

Yorum Gönder

LIMIT ve Covering Index + Subquery

Örnek Şöyle yaparız SELECT t1.name, t1.age, t1.gender, t1.create_time FROM student as t1    INNER JOIN     (SELECT id FROM student ORDER BY ...