摘要:
SELECT TABLE_NAME,DATA_LENGTH+INDEX_LENGTH,TABLE_ROWS,concat(round((DATA_LENGTH+INDEX_LENGTH)/1024/1024,2), 'MB') as data_size FROM information_schema 阅读全文
摘要:
1.主库和备库都创建同步账号 grant replication slave,replication client on *.* to repl@'192.168.1.%' identified by 'password'; 2.主库my.cnf配置 log_bin = mysql-bin serv 阅读全文