• There are no recent tables.
  • There are no favorite tables.
Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Binary log

Select binary log to view 2 Files, 4,045 B 
SHOW BINLOG EVENTS LIMIT 0, 25
[ Edit inline ] [ Edit ] [ Create PHP code ] [ Refresh ]
Show full queries - »
Log name Position Event type Server ID Original position Information
mysql-bin.000001 4 Format_desc 2 126 
Server ver: 8.0.35, Binlog ver: 4
mysql-bin.000001 126 Previous_gtids 2 157
mysql-bin.000001 157 Anonymous_Gtid 2 236 
SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
mysql-bin.000001 236 Query 2 480 
CREATE USER 'replica_user'@'%' IDENTIFIED WITH 'caching_sha2_password' AS '$A$005$\n#i,gS`1\Z\'Om~1jhaIP5DQfZslkiZ9Ck75RPvGuXpFV83PuJIn30/M29' /* xid=3 */
mysql-bin.000001 480 Anonymous_Gtid 2 557 
SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
mysql-bin.000001 557 Query 2 708 
GRANT REPLICATION SLAVE ON *.* TO 'replica_user'@'%' /* xid=4 */
mysql-bin.000001 708 Anonymous_Gtid 2 785 
SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
mysql-bin.000001 785 Query 2 875 
FLUSH PRIVILEGES
mysql-bin.000001 875 Anonymous_Gtid 2 952 
SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
mysql-bin.000001 952 Query 2 1079 
DROP DATABASE `replication` /* xid=267 */
mysql-bin.000001 1079 Anonymous_Gtid 2 1158 
SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
mysql-bin.000001 1158 Query 2 1340 
CREATE DATABASE `replication` DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci /* xid=309 */
mysql-bin.000001 1340 Anonymous_Gtid 2 1419 
SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
mysql-bin.000001 1419 Query 2 1750 
use `replication`; CREATE TABLE `test` (
  `tid` int NOT NULL,
  `customer_name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `adddate` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci /* xid=444 */
mysql-bin.000001 1750 Anonymous_Gtid 2 1827 
SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
mysql-bin.000001 1827 Query 2 1982 
use `replication`; ALTER TABLE `test`
  ADD PRIMARY KEY (`tid`) /* xid=452 */
mysql-bin.000001 1982 Anonymous_Gtid 2 2059 
SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
mysql-bin.000001 2059 Query 2 2223 
use `replication`; ALTER TABLE `test`
  MODIFY `tid` int NOT NULL AUTO_INCREMENT /* xid=460 */
mysql-bin.000001 2223 Anonymous_Gtid 2 2302 
SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
mysql-bin.000001 2302 Query 2 2392 
BEGIN
mysql-bin.000001 2392 Table_map 2 2457 
table_id: 174 (replication.test)
mysql-bin.000001 2457 Write_rows 2 2510 
table_id: 174 flags: STMT_END_F
mysql-bin.000001 2510 Xid 2 2541 
COMMIT /* xid=603 */
mysql-bin.000001 2541 Anonymous_Gtid 1 2627 
SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
mysql-bin.000001 2627 Query 1 2704 
BEGIN