mysql query log analyzer

| Executed_gtid_set |+------------------+----------+--------------+------------------+-------------------+| mysql-bin.000002 | 120 | | | |+------------------+----------+--------------+------------------+-------------------+1 row in Set (0.00 sec)mysql> Reset Master; #重新开始Query OK, 0 rows Affected (0.00 sec)

Tags: Database sql MySQL DBAwith most relationship types database, log files are an important part of the MySQL database. MySQL has several different log files, usually including error log files, binary logs, generic logs, slow

Tags: SQL statement ASE log HTTP Query general table variables SSL Opening the general log will log all SQL statements that arrive at MySQL server. Generally does not open the function, because the amount of log can be very large.

Mysql> purge binary logs to ' mysql-bin.000018 ';Query OK, 0 rows affected (0.08 sec) Mysql> show binary logs;+------------------+-----------+| Log_name | File_size |+------------------+-----------+| mysql-bin.000018 | 117 ||

Redo log, undo log, and binlog of MySQL) There are six types of log files in MySQL: redo log, undo log, binlog, and errorlog) slow query

$ Master_ssl_verify_server_cert:noPanax NotoginsengLast_io_errno:1236 -Last_io_error:got Fatal Error1236 fromMaster when reading data fromBinary log:'Could not find first log file name in binary log index file' theLast_sql_errno:0 + Last_sql_error: A Replicate_ignore_server_ids: theMASTER_SERVER_ID: + +master_uuid:e4a43da7-5b58-11e5-a12f-00163e003632 -Maste

' or nid in (11,22,33); REF Find one or more values based on an index SELECT * from tb1 WHERE name = ' seven '; Eq_ref Use primary key or unique type when connecting Select Tb2.nid,tb1.name from TB2 left join tb1 on tb2.nid = Tb1.nid; CONST Constant The table has a maximum of one matching row, because only one row, the column values in this row can be considered constants by the remainder of the optimizer, and the const table is fast because they are read only once. Select Nid from tb1 where

, or stop information.2. general query logs, all SQL statements or MySQL commands run by the MySQL service instance.3. binary logs: All update statements executed on the database, excluding select and show statements.4. slow query log (slow), SQL statement with execution tim

shortcomings. D. The binlog_format operation can be performed at the global and session levels to ensure normal replication of slave databases. 3. log reading: A. mysqlbinlog tool 4. Log deletion: A. reset master. all binlog logs can be deleted. B. purge master logs to 'MySQL-bin. * 'will delete all logs before *. C. purge master logs before 'yyyy-mm-dd hh24: mi

| | innodb_autoextend_increment | 8 | | innodb_autoinc_lock_mode| 1 | | sql_auto_is_null| OFF | +-----------------------------+-------+ 7 rows in set (0.00 sec) 2. We see that autocommit is turned on and we set it to off mysql> set global autocommit=OFF; Query OK, 0 rows affected (0.00 sec) 3. Check if it is off, if it is not turned off, log back in again to vi

|+ ------------------ + ----------- +21 rows in set (0.03 sec) Delete bin-log (delete all binary log files before mysql-bin.000018) The Code is as follows: Mysql> purge binary logs to 'mysql-bin.20.18 ';