Skip to content

Instantly share code, notes, and snippets.

@rollick

rollick/gist:696953e92ae3fd34995f9f25ef347407 Secret

Created November 18, 2017 12:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rollick/696953e92ae3fd34995f9f25ef347407 to your computer and use it in GitHub Desktop.
Save rollick/696953e92ae3fd34995f9f25ef347407 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
2017-11-18T13:32:01.116+0100 I NETWORK [conn3] parsing "SELECT @@session.tx_isolation"
2017-11-18T13:32:01.116+0100 I ALGEBRIZER [conn3] generating query plan for sql: "SELECT @@session.tx_isolation"
2017-11-18T13:32:01.116+0100 D OPTIMIZER [conn3] optimizing query plan:
↳ Project(@@session.tx_isolation):
↳ Dual
2017-11-18T13:32:01.116+0100 I OPTIMIZER [conn3] running optimization stage 'subqueries'
2017-11-18T13:32:01.116+0100 I OPTIMIZER [conn3] running optimization stage 'evaluations'
2017-11-18T13:32:01.116+0100 D OPTIMIZER [conn3] optimized plan after 'evaluations':
↳ Project(@@session.tx_isolation):
↳ Dual
2017-11-18T13:32:01.116+0100 I OPTIMIZER [conn3] running optimization stage 'cross joins'
2017-11-18T13:32:01.116+0100 I OPTIMIZER [conn3] running optimization stage 'inner join'
2017-11-18T13:32:01.116+0100 I OPTIMIZER [conn3] running optimization stage 'filtering'
2017-11-18T13:32:01.116+0100 I OPTIMIZER [conn3] running optimization stage 'pushdown'
2017-11-18T13:32:01.116+0100 D EXECUTOR [conn3] executing query plan:
↳ Project(@@session.tx_isolation):
↳ Dual
2017-11-18T13:32:01.116+0100 I NETWORK [conn3] returned 1 row (20B)
2017-11-18T13:32:01.116+0100 I NETWORK [conn3] done executing query in 0ms
2017-11-18T13:32:01.116+0100 I NETWORK [conn3] parsing "select @@session.tx_read_only"
2017-11-18T13:32:01.116+0100 I ALGEBRIZER [conn3] generating query plan for sql: "select @@session.tx_read_only"
2017-11-18T13:32:01.116+0100 D OPTIMIZER [conn3] optimizing query plan:
↳ Project(@@session.tx_read_only):
↳ Dual
2017-11-18T13:32:01.116+0100 I OPTIMIZER [conn3] running optimization stage 'subqueries'
2017-11-18T13:32:01.116+0100 I OPTIMIZER [conn3] running optimization stage 'evaluations'
2017-11-18T13:32:01.116+0100 D OPTIMIZER [conn3] optimized plan after 'evaluations':
↳ Project(@@session.tx_read_only):
↳ Dual
2017-11-18T13:32:01.116+0100 I OPTIMIZER [conn3] running optimization stage 'cross joins'
2017-11-18T13:32:01.116+0100 I OPTIMIZER [conn3] running optimization stage 'inner join'
2017-11-18T13:32:01.116+0100 I OPTIMIZER [conn3] running optimization stage 'filtering'
2017-11-18T13:32:01.117+0100 I OPTIMIZER [conn3] running optimization stage 'pushdown'
2017-11-18T13:32:01.117+0100 D EXECUTOR [conn3] executing query plan:
↳ Project(@@session.tx_read_only):
↳ Dual
2017-11-18T13:32:01.117+0100 I NETWORK [conn3] returned 1 row (6B)
2017-11-18T13:32:01.117+0100 I NETWORK [conn3] done executing query in 0ms
2017-11-18T13:32:01.117+0100 I NETWORK [conn3] parsing "SET autocommit=0"
2017-11-18T13:32:01.117+0100 I ALGEBRIZER [conn3] generating query plan: "set autocommit = 0"
2017-11-18T13:32:01.117+0100 D OPTIMIZER [conn3] optimizing query plan:
↳ Set:
@@session.autocommit := 0
2017-11-18T13:32:01.117+0100 I OPTIMIZER [conn3] running optimization stage 'subqueries'
2017-11-18T13:32:01.117+0100 I OPTIMIZER [conn3] running optimization stage 'evaluations'
2017-11-18T13:32:01.117+0100 I OPTIMIZER [conn3] running optimization stage 'cross joins'
2017-11-18T13:32:01.117+0100 I OPTIMIZER [conn3] running optimization stage 'inner join'
2017-11-18T13:32:01.117+0100 I OPTIMIZER [conn3] running optimization stage 'filtering'
2017-11-18T13:32:01.117+0100 I OPTIMIZER [conn3] running optimization stage 'pushdown'
2017-11-18T13:32:01.117+0100 D EXECUTOR [conn3] executing query plan:
↳ Set:
@@session.autocommit := 0
2017-11-18T13:32:01.117+0100 I NETWORK [conn3] done executing query in 0ms
2017-11-18T13:32:01.117+0100 I NETWORK [conn3] parsing "SET autocommit=0"
2017-11-18T13:32:01.117+0100 I ALGEBRIZER [conn3] generating query plan: "set autocommit = 0"
2017-11-18T13:32:01.117+0100 D OPTIMIZER [conn3] optimizing query plan:
↳ Set:
@@session.autocommit := 0
2017-11-18T13:32:01.117+0100 I OPTIMIZER [conn3] running optimization stage 'subqueries'
2017-11-18T13:32:01.117+0100 I OPTIMIZER [conn3] running optimization stage 'evaluations'
2017-11-18T13:32:01.117+0100 I OPTIMIZER [conn3] running optimization stage 'cross joins'
2017-11-18T13:32:01.117+0100 I OPTIMIZER [conn3] running optimization stage 'inner join'
2017-11-18T13:32:01.117+0100 I OPTIMIZER [conn3] running optimization stage 'filtering'
2017-11-18T13:32:01.117+0100 I OPTIMIZER [conn3] running optimization stage 'pushdown'
2017-11-18T13:32:01.117+0100 D EXECUTOR [conn3] executing query plan:
↳ Set:
@@session.autocommit := 0
2017-11-18T13:32:01.117+0100 I NETWORK [conn3] done executing query in 0ms
2017-11-18T13:32:01.118+0100 I NETWORK [conn3] parsing "-- Metabase:: userID: 1 queryType: native queryHash: df094c3ee0002d2cd694c7eb0ae60c6d11d987d0b6765038a9afaba4063cc76a
select _id from users"
2017-11-18T13:32:01.118+0100 I ALGEBRIZER [conn3] generating query plan for sql: "-- Metabase:: userID: 1 queryType: native queryHash: df094c3ee0002d2cd694c7eb0ae60c6d11d987d0b6765038a9afaba4063cc76a
select _id from users"
2017-11-18T13:32:01.118+0100 D OPTIMIZER [conn3] optimizing query plan:
↳ Project(_id):
↳ MongoSource: '[users]' (db: 'db_prod', collection: '[users]') as '[users]'
2017-11-18T13:32:01.118+0100 I OPTIMIZER [conn3] running optimization stage 'subqueries'
2017-11-18T13:32:01.118+0100 I OPTIMIZER [conn3] running optimization stage 'evaluations'
2017-11-18T13:32:01.118+0100 I OPTIMIZER [conn3] running optimization stage 'cross joins'
2017-11-18T13:32:01.118+0100 I OPTIMIZER [conn3] running optimization stage 'inner join'
2017-11-18T13:32:01.118+0100 I OPTIMIZER [conn3] running optimization stage 'filtering'
2017-11-18T13:32:01.118+0100 I OPTIMIZER [conn3] running optimization stage 'pushdown'
2017-11-18T13:32:01.118+0100 D OPTIMIZER [conn3] optimized plan after 'pushdown':
↳ MongoSource: '[users]' (db: 'db_prod', collection: '[users]') as '[users]':
{"$project":{"users_DOT__id":"$_id"}}
2017-11-18T13:32:01.118+0100 D EXECUTOR [conn3] executing query plan:
↳ MongoSource: '[users]' (db: 'db_prod', collection: '[users]') as '[users]':
{"$project":{"users_DOT__id":"$_id"}}
2017-11-18T13:32:01.125+0100 I NETWORK [conn3] returned 791 rows (22.4KiB)
2017-11-18T13:32:01.125+0100 I NETWORK [conn3] done executing query in 6ms
2017-11-18T13:32:01.126+0100 I NETWORK [conn3] parsing "rollback"
2017-11-18T13:32:01.126+0100 E NETWORK [conn3] dispatch error: ERROR 1064 (42000): parse sql 'rollback' error: syntax error at position 9 near rollback
2017-11-18T13:32:01.126+0100 I NETWORK [conn3] parsing "SHOW FULL TABLES FROM `db_prod` LIKE 'PROBABLYNOT'"
2017-11-18T13:32:01.126+0100 I ALGEBRIZER [conn3] generating query plan for show statement: "SHOW FULL TABLES FROM `db_prod` LIKE 'PROBABLYNOT'"
2017-11-18T13:32:01.127+0100 D OPTIMIZER [conn3] optimizing query plan:
↳ Project(Tables_in_db_prod, Type):
↳ OrderBy(TABLES.Tables_in_db_prod ASC):
↳ Filter (TABLES.TABLE_SCHEMA = db_prod and TABLES.Tables_in_db_prod like PROBABLYNOT):
↳ Subquery(TABLES):
↳ Project(Tables_in_db_prod, Type, TABLE_SCHEMA):
↳ DynamicSource (TABLES):
2017-11-18T13:32:01.127+0100 I OPTIMIZER [conn3] running optimization stage 'subqueries'
2017-11-18T13:32:01.127+0100 I OPTIMIZER [conn3] running optimization stage 'evaluations'
2017-11-18T13:32:01.127+0100 I OPTIMIZER [conn3] running optimization stage 'cross joins'
2017-11-18T13:32:01.127+0100 I OPTIMIZER [conn3] running optimization stage 'inner join'
2017-11-18T13:32:01.127+0100 D OPTIMIZER [conn3] attempting to optimize inner join in subquery 'TABLES'
2017-11-18T13:32:01.127+0100 I OPTIMIZER [conn3] running optimization stage 'filtering'
2017-11-18T13:32:01.127+0100 D OPTIMIZER [conn3] optimized plan after 'filtering':
↳ Project(Tables_in_db_prod, Type):
↳ OrderBy(TABLES.Tables_in_db_prod ASC):
↳ Filter (TABLES.TABLE_SCHEMA = db_prod and TABLES.Tables_in_db_prod like PROBABLYNOT):
↳ Subquery(TABLES):
↳ Project(Tables_in_db_prod, Type, TABLE_SCHEMA):
↳ DynamicSource (TABLES):
2017-11-18T13:32:01.127+0100 I OPTIMIZER [conn3] running optimization stage 'pushdown'
2017-11-18T13:32:01.127+0100 D EXECUTOR [conn3] executing query plan:
↳ Project(Tables_in_db_prod, Type):
↳ OrderBy(TABLES.Tables_in_db_prod ASC):
↳ Filter (TABLES.TABLE_SCHEMA = db_prod and TABLES.Tables_in_db_prod like PROBABLYNOT):
↳ Subquery(TABLES):
↳ Project(Tables_in_db_prod, Type, TABLE_SCHEMA):
↳ DynamicSource (TABLES):
2017-11-18T13:32:01.128+0100 I NETWORK [conn3] returned 0 rows (0B)
2017-11-18T13:32:01.129+0100 I NETWORK [conn3] parsing "rollback"
2017-11-18T13:32:01.129+0100 E NETWORK [conn3] dispatch error: ERROR 1064 (42000): parse sql 'rollback' error: syntax error at position 9 near rollback
2017-11-18T13:32:01.129+0100 I NETWORK [conn3] parsing "SHOW FULL TABLES FROM `db_prod` LIKE 'PROBABLYNOT'"
2017-11-18T13:32:01.129+0100 I ALGEBRIZER [conn3] generating query plan for show statement: "SHOW FULL TABLES FROM `db_prod` LIKE 'PROBABLYNOT'"
2017-11-18T13:32:01.129+0100 D OPTIMIZER [conn3] optimizing query plan:
↳ Project(Tables_in_db_prod, Type):
↳ OrderBy(TABLES.Tables_in_db_prod ASC):
↳ Filter (TABLES.TABLE_SCHEMA = db_prod and TABLES.Tables_in_db_prod like PROBABLYNOT):
↳ Subquery(TABLES):
↳ Project(Tables_in_db_prod, Type, TABLE_SCHEMA):
↳ DynamicSource (TABLES):
2017-11-18T13:32:01.129+0100 I OPTIMIZER [conn3] running optimization stage 'subqueries'
2017-11-18T13:32:01.129+0100 I OPTIMIZER [conn3] running optimization stage 'evaluations'
2017-11-18T13:32:01.129+0100 I OPTIMIZER [conn3] running optimization stage 'cross joins'
2017-11-18T13:32:01.129+0100 I OPTIMIZER [conn3] running optimization stage 'inner join'
2017-11-18T13:32:01.129+0100 D OPTIMIZER [conn3] attempting to optimize inner join in subquery 'TABLES'
2017-11-18T13:32:01.129+0100 I OPTIMIZER [conn3] running optimization stage 'filtering'
2017-11-18T13:32:01.129+0100 D OPTIMIZER [conn3] optimized plan after 'filtering':
↳ Project(Tables_in_db_prod, Type):
↳ OrderBy(TABLES.Tables_in_db_prod ASC):
↳ Filter (TABLES.TABLE_SCHEMA = db_prod and TABLES.Tables_in_db_prod like PROBABLYNOT):
↳ Subquery(TABLES):
↳ Project(Tables_in_db_prod, Type, TABLE_SCHEMA):
↳ DynamicSource (TABLES):
2017-11-18T13:32:01.129+0100 I OPTIMIZER [conn3] running optimization stage 'pushdown'
2017-11-18T13:32:01.129+0100 D EXECUTOR [conn3] executing query plan:
↳ Project(Tables_in_db_prod, Type):
↳ OrderBy(TABLES.Tables_in_db_prod ASC):
↳ Filter (TABLES.TABLE_SCHEMA = db_prod and TABLES.Tables_in_db_prod like PROBABLYNOT):
↳ Subquery(TABLES):
↳ Project(Tables_in_db_prod, Type, TABLE_SCHEMA):
↳ DynamicSource (TABLES):
2017-11-18T13:32:01.132+0100 I NETWORK [conn3] returned 0 rows (0B)
2017-11-18T13:32:01.132+0100 I NETWORK [conn3] parsing "SET autocommit=1"
2017-11-18T13:32:01.132+0100 I ALGEBRIZER [conn3] generating query plan: "set autocommit = 1"
2017-11-18T13:32:01.133+0100 D OPTIMIZER [conn3] optimizing query plan:
↳ Set:
@@session.autocommit := 1
2017-11-18T13:32:01.133+0100 I OPTIMIZER [conn3] running optimization stage 'subqueries'
2017-11-18T13:32:01.133+0100 I OPTIMIZER [conn3] running optimization stage 'evaluations'
2017-11-18T13:32:01.133+0100 I OPTIMIZER [conn3] running optimization stage 'cross joins'
2017-11-18T13:32:01.133+0100 I OPTIMIZER [conn3] running optimization stage 'inner join'
2017-11-18T13:32:01.133+0100 I OPTIMIZER [conn3] running optimization stage 'filtering'
2017-11-18T13:32:01.133+0100 I OPTIMIZER [conn3] running optimization stage 'pushdown'
2017-11-18T13:32:01.133+0100 D EXECUTOR [conn3] executing query plan:
↳ Set:
@@session.autocommit := 1
2017-11-18T13:32:01.133+0100 I NETWORK [conn3] done executing query in 0ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment