Add pid and progname from the connection attributes

…exists and if so whether it's a BASE TABLE, TEMPORARY table, or a VIEW

…ema for the global status

…e_exists procedure

Adding the table_exists() procedure which determines whether a table …

…e metrics views

Dev/metrics

…actors table has an ENABLED column.

…sactions, so the that the hierarchy can now start with transactions, or even stored procedures which start transactions etc.

Now that the sys.version view also has a definer, ensure that if a user replacement is requested, it is also done on the before_setup.sql file as well.

Cleaned up to not use apostrophe.

…L_GROUP_BY

…rather than just wait/io/file/%.

…rather than just wait/io/file/%.

Changing to metrics_56.sql is only used for MySQl 5.6 and will have the name metrics for all versions. This can be done as 5.7.9+ will support performance_schema.global_status for all configurations. Updated diagnostics() to always use metrics except when performance_schema = OFF in 5.7 as metrics requires the Performance_Schema engine to be available in 5.7.

Remove support for the pre-5.7.7 Performance Schema replication tables

…om set up that may include user changes), fix a warning along the way..

Pulled in upstream changes (also pulled in test changes in earlier test updates).

…ored by git

* Added using a new default user (that has the account locked) for the MySQL 5.7+ integration as the DEFINER for all objects
* Added a warning to the top of the generated integration file to also submit changes to the sys project
* Improved the the option of skipping binary logs, so that all routines can load as well - those that used SET sql_log_bin will now select a warning when being used instead of setting the option

…sql.sys user, rather than a generated one using PASSWORD().

…mt routine.

… to ensure we get the right timestamps etc.