/usr/sbin/mysqld, Version: 10.2.17-MariaDB-log (MariaDB Server). started with:
Tcp port: 0  Unix socket: (null)
Time                 Id Command    Argument
# Time: 180818 12:16:45
# User@Host: ipswichdba[ipswichdba] @  [192.168.163.128]
# Thread_id: 9  Schema:   QC_hit: No
# Query_time: 0.000331  Lock_time: 0.000187  Rows_sent: 1  Rows_examined: 1
# Rows_affected: 0
# Full_scan: Yes  Full_join: No  Tmp_table: Yes  Tmp_table_on_disk: No
# Filesort: No  Filesort_on_disk: No  Merge_passes: 0  Priority_queue: No
#
# explain: id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
# explain: 1	SIMPLE	SCHEMATA	ALL	NULL	NULL	NULL	NULL	NULL	1.00	NULL	100.00	Using where
#
SET timestamp=1534591005;
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='ipswichdb';
# User@Host: ipswichdba[ipswichdba] @  [192.168.163.128]
# Thread_id: 9  Schema:   QC_hit: No
# Query_time: 0.000251  Lock_time: 0.000146  Rows_sent: 1  Rows_examined: 1
# Rows_affected: 0
# Full_scan: Yes  Full_join: No  Tmp_table: Yes  Tmp_table_on_disk: No
# Filesort: No  Filesort_on_disk: No  Merge_passes: 0  Priority_queue: No
#
# explain: id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
# explain: 1	SIMPLE	SCHEMATA	ALL	NULL	NULL	NULL	NULL	NULL	1.00	NULL	100.00	Using where
#
SET timestamp=1534591005;
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='information_schema';
# User@Host: ipswichdba[ipswichdba] @  [192.168.163.128]
# Thread_id: 9  Schema:   QC_hit: No
# Query_time: 0.002011  Lock_time: 0.000477  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 0
# Full_scan: Yes  Full_join: No  Tmp_table: Yes  Tmp_table_on_disk: Yes
# Filesort: No  Filesort_on_disk: No  Merge_passes: 0  Priority_queue: No
#
# explain: id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
# explain: 1	SIMPLE	EVENTS	ALL	NULL	NULL	NULL	NULL	NULL	0.00	NULL	100.00	Using where
#
SET timestamp=1534591005;
SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='ipswichdb';
/usr/sbin/mysqld, Version: 10.2.17-MariaDB-log (MariaDB Server). started with:
Tcp port: 0  Unix socket: (null)
Time                 Id Command    Argument