perfschema/include/transaction_setup.inc

181     SET @columns =                  ' LPAD(@thread_id, 9, " ")      AS thread_id,';
182     SET @columns = CONCAT(@columns, ' LPAD(@event_id, 10, " ")      AS "..event_id",');
183     SET @columns = CONCAT(@columns, ' RPAD(@event_name, 11, " ")    AS "event_name ",');
184     SET @columns = CONCAT(@columns, ' RPAD(@state, 11, " ")         AS "state      ",');
185     SET @columns = CONCAT(@columns, ' RPAD(@xid_format_id, 15, " ") AS "xid_format_id  ",');
186     SET @columns = CONCAT(@columns, ' RPAD(@xid_gtrid, 15, " ")     AS "xid_gtrid      ",');
187     SET @columns = CONCAT(@columns, ' RPAD(@xid_bqual, 15, " ")     AS "xid_bqual      ",');
188     SET @columns = CONCAT(@columns, ' RPAD(@xa_state, 12, " ")      AS "xa_state    ",');
189 …SET @columns = CONCAT(@columns, ' RPAD(@gtid, 38, " ")          AS "gtid                          …
190     SET @columns = CONCAT(@columns, ' RPAD(@access_mode, 11, " ")   AS access_mode,');
191     SET @columns = CONCAT(@columns, ' RPAD(@isolation_level, 16, " ") AS "isolation_level ",');
192     SET @columns = CONCAT(@columns, ' RPAD(@autocommit, 10, " ")    AS autocommit,');
193     SET @columns = CONCAT(@columns, ' LPAD(@savepoints, 10, " ")    AS savepoints,');
194     SET @columns = CONCAT(@columns, ' LPAD(@rb_savepoint, 21, " ")  AS rollback_to_savepoint,');
195     SET @columns = CONCAT(@columns, ' LPAD(@rel_savepoint, 17, " ") AS release_savepoint');
196 …SET @query2  = CONCAT('SELECT', ' LPAD(@expected, 13, " ")      AS ROWS_EXPECTED, ', @columns, ';'…
197 #   SET @query2  = CONCAT('SELECT "        " AS EXPECTED, ', @columns, ';');
202     SET @columns =                  ' LPAD(thread_id, 9, " ")        AS thread_id,';
203     SET @columns = CONCAT(@columns, ' LPAD(event_id, 10, " ")        AS "..event_id",');
204     SET @columns = CONCAT(@columns, ' RPAD(event_name, 11, " ")      AS "event_name ",');
205     SET @columns = CONCAT(@columns, ' RPAD(state, 11, " ")           AS "state      ",');
206 …SET @columns = CONCAT(@columns, ' RPAD(IFNULL(xid_format_id, "NULL"), 15, " ") AS "xid_format_id  …
207 …SET @columns = CONCAT(@columns, ' RPAD(IFNULL(xid_gtrid, "NULL"), 15, " ") AS "xid_gtrid      ",');
208 …SET @columns = CONCAT(@columns, ' RPAD(IFNULL(xid_bqual, "NULL"), 15, " ") AS "xid_bqual      ",');
209     SET @columns = CONCAT(@columns, ' RPAD(IFNULL(xa_state, "NULL"), 12, " ") AS "xa_state    ",');
210 …SET @columns = CONCAT(@columns, ' RPAD(IFNULL(gtid, "NULL"), 38, " ") AS "gtid                    …
211     SET @columns = CONCAT(@columns, ' RPAD(access_mode, 11, " ")     AS access_mode,');
212     SET @columns = CONCAT(@columns, ' RPAD(isolation_level, 16, " ") AS "isolation_level ",');
213     SET @columns = CONCAT(@columns, ' RPAD(autocommit, 10, " ")      AS autocommit,');
214     SET @columns = CONCAT(@columns, ' LPAD(number_of_savepoints, 10, " ") AS savepoints,');
215 …SET @columns = CONCAT(@columns, ' LPAD(number_of_rollback_to_savepoint, 21, " ") AS rollback_to_sa…
216 …SET @columns = CONCAT(@columns, ' LPAD(number_of_release_savepoint, 17, " ") AS release_savepoint'…
217 #   SET @query3  = CONCAT('SELECT "        " AS "ACTUAL  ", ', @columns, ' FROM ', table_name, ' OR…
218 …SET @query3  = CONCAT('SELECT', ' LPAD(@actual, 13, " ")        AS "ROWS_ACTUAL  ",', @columns, ' …