kilikfr / mysql-admin Goto Github PK

SHOW [FULL] PROCESSLIST will be great

--with-fix is an option not implemented yet.

When enabled, changes reporting should output SQL queries to insert/update/delete records on slave.
Perhaps, a "--skip-write-binlog" could add "SET sql_log_bin = 0;" to first line (and "SET sql_log_bin = 1;" to last line) to avoid replication when running all queries in a master/master setup.

CHECKSUM TABLE don't works as expected in 5.7 servers when tables contains json fields (https://bugs.mysql.com/bug.php?id=87847)

A workaround - not really safe but better than nothing - could be based on a SUM of CRC32:

SELECT SUM(CRC32(CONCAT('id',':',IFNULL(id,''),'column_a',':',IFNULL(column_a,''),'column_b',':',IFNULL(column_b,'')) AS hash FROM table_demo ORDER BY id;

suggested option: --json-fix (will apply only for tables with at least one json field)

Slaves channels - on server view - are not displayed when channels are even (works with odd count, 1, 3)

The --ignore-table don't work

When one field contains a NULL value, CONCAT( ...., NULL, ...) returns NULL.

• use IFNULL(fieldnullable,'') on all nullable fields.
• add separators (ex: "fieldname:") in concat for each field, to prevents CONCAT('a','b') to have same result as CONCAT('ab','')