demo.phpmyadmin.net / phpMyAdmin demo - MySQL / performance_schema / events_statements_history

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken:

Always expand query messages

Show query history at start

Show current browsing query

Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.

Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

Showing rows 0 - 24 (61 total, Query took 0.0007 seconds.)

SELECT * FROM `events_statements_history`

Filter rows:

Partial texts

Full texts

Show binary contents

Show BLOB contents

Hide browser transformation

Well Known Text

Well Known Binary

THREAD_ID	EVENT_ID	END_EVENT_ID	EVENT_NAME	SOURCE	TIMER_START	TIMER_END	TIMER_WAIT	LOCK_TIME	SQL_TEXT	DIGEST	DIGEST_TEXT	CURRENT_SCHEMA	OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	OBJECT_INSTANCE_BEGIN	MYSQL_ERRNO	RETURNED_SQLSTATE	MESSAGE_TEXT	ERRORS	WARNINGS	ROWS_AFFECTED	ROWS_SENT	ROWS_EXAMINED	CREATED_TMP_DISK_TABLES	CREATED_TMP_TABLES	SELECT_FULL_JOIN	SELECT_FULL_RANGE_JOIN	SELECT_RANGE	SELECT_RANGE_CHECK	SELECT_SCAN	SORT_MERGE_PASSES	SORT_RANGE	SORT_ROWS	SORT_SCAN	NO_INDEX_USED	NO_GOOD_INDEX_USED	NESTING_EVENT_ID	NESTING_EVENT_TYPE	NESTING_EVENT_LEVEL	STATEMENT_ID
29	1	1	statement/sql/select	srv_session.cc:1107	1976373258000	1980011290000	3638032000	0	SELECT @@skip_networking, @@skip_name_resolve, @@h...	1ebda414995104bec2d678a2f3a337c8cc504cafa93982ba39...	SELECT @@`skip_networking` , @@`skip_name_resolve`...	NULL	NULL	NULL	NULL	NULL	0	NULL	NULL	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	NULL	NULL	0	2
3526	1	1	statement/sql/show_tables	init_net_server_extension.cc:95	178931073028000	178931196646000	123618000	50000000	SHOW TABLES FROM `phpmyadmin`	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	SHOW TABLES FROM `phpmyadmin`	NULL	NULL	NULL	NULL	NULL	1049	42000	Unknown database 'phpmyadmin'	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NULL	NULL	0	49636
3526	2	2	statement/com/Init DB	init_net_server_extension.cc:95	178931354520000	178931390134000	35614000	13000000	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1049	42000	Unknown database 'phpmyadmin'	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NULL	NULL	0	49637
3527	187	191	statement/sql/alter_table	init_net_server_extension.cc:95	192204426439000	192303448016000	99021577000	272000000	-- -- AUTO_INCREMENT de las tablas volcadas -- --...	014186377a1e21434bf40394ea71deb536a5e113917d46f6e5...	ALTER TABLE `achievements` MODIFY `ID` INTEGER (?)...	italianroleplay	NULL	NULL	NULL	NULL	0	00000	Registros: 116 Duplicados: 0 Peligros: 1	0	1	116	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NULL	NULL	0	53493
3527	154	158	statement/sql/alter_table	init_net_server_extension.cc:95	189683067692000	189781642437000	98574745000	346000000	-- -- Indices de la tabla `prendas` -- ALTER TABLE...	965bba8ff019dceea797a9de7bc8e107117b6eaa0b0a461ce8...	ALTER TABLE `prendas` ADD PRIMARY KEY ( `ID` )	italianroleplay	NULL	NULL	NULL	NULL	0	00000	Registros: 41 Duplicados: 0 Peligros: 0	0	0	41	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NULL	NULL	0	52628
3527	159	163	statement/sql/alter_table	init_net_server_extension.cc:95	189782044238000	189880614089000	98569851000	500000000	-- -- Indices de la tabla `propiedades` -- ALTER T...	0ff2334209eb4937fa4cebad9e2cb553b8e035f8dd666a2f6e...	ALTER TABLE `propiedades` ADD PRIMARY KEY ( `ID` )	italianroleplay	NULL	NULL	NULL	NULL	0	00000	Registros: 9 Duplicados: 0 Peligros: 0	0	0	9	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NULL	NULL	0	52670
3527	164	165	statement/sql/alter_table	init_net_server_extension.cc:95	189881076169000	190500555513000	619479344000	109000000	-- -- Indices de la tabla `p_vehicles` -- ALTER TA...	393d71dfa234a737f7db3f444f92ccc70ddeb16b1837299a3d...	ALTER TABLE `p_vehicles` ADD PRIMARY KEY ( `id` ) ...	italianroleplay	NULL	NULL	NULL	NULL	0	00000	Registros: 0 Duplicados: 0 Peligros: 0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NULL	NULL	0	52719
3527	166	170	statement/sql/alter_table	init_net_server_extension.cc:95	190500809406000	190598208959000	97399553000	126000000	-- -- Indices de la tabla `registros` -- ALTER TAB...	1c471cc1e4558f127dea6e9dc374d22d4ea89237c703663752...	ALTER TABLE `registros` ADD PRIMARY KEY ( `id` )	italianroleplay	NULL	NULL	NULL	NULL	0	00000	Registros: 0 Duplicados: 0 Peligros: 0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NULL	NULL	0	52913
3527	171	172	statement/sql/alter_table	init_net_server_extension.cc:95	190598693082000	190991942564000	393249482000	242000000	-- -- Indices de la tabla `registros_admin` -- ALT...	2d93c414510bb914b12a68c734b20a38be2468d69f1af60b65...	ALTER TABLE `registros_admin` ADD PRIMARY KEY ( `I...	italianroleplay	NULL	NULL	NULL	NULL	0	00000	Registros: 0 Duplicados: 0 Peligros: 0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NULL	NULL	0	52932
3527	173	174	statement/sql/alter_table	init_net_server_extension.cc:95	190992155473000	191496488853000	504333380000	110000000	-- -- Indices de la tabla `territorios` -- ALTER T...	7a0f9743b8099d12a4260b1adb9c4bfca986abcabe23f4036f...	ALTER TABLE `territorios` ADD PRIMARY KEY ( `ID` )	italianroleplay	NULL	NULL	NULL	NULL	0	00000	Registros: 0 Duplicados: 0 Peligros: 0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NULL	NULL	0	53068
3527	175	176	statement/sql/alter_table	init_net_server_extension.cc:95	191496911185000	191918376939000	421465754000	99000000	-- -- Indices de la tabla `tuning_objects` -- ALTE...	943f9452b2699adcbdf6b02172009c14b9812939bf2a740eda...	ALTER TABLE `tuning_objects` ADD PRIMARY KEY ( `ID...	italianroleplay	NULL	NULL	NULL	NULL	0	00000	Registros: 0 Duplicados: 0 Peligros: 0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NULL	NULL	0	53253
3527	177	181	statement/sql/alter_table	init_net_server_extension.cc:95	191918573978000	192107884605000	189310627000	1023000000	-- -- Indices de la tabla `usuarios` -- ALTER TABL...	a3157e00f98c060b38c51298895c574ed4a84309c56a1e11a1...	ALTER TABLE `usuarios` ADD PRIMARY KEY ( `ID` )	italianroleplay	NULL	NULL	NULL	NULL	0	00000	Registros: 58 Duplicados: 0 Peligros: 0	0	0	58	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NULL	NULL	0	53415
3527	182	186	statement/sql/alter_table	init_net_server_extension.cc:95	192108214600000	192204120121000	95905521000	285000000	-- -- Indices de la tabla `vehicles` -- ALTER TABL...	f447b4bc01ce64dee58e13568c319ba598ea72f90467c4ebe2...	ALTER TABLE `vehicles` ADD PRIMARY KEY ( `id` )	italianroleplay	NULL	NULL	NULL	NULL	0	00000	Registros: 265 Duplicados: 0 Peligros: 0	0	0	265	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NULL	NULL	0	53449
3782	1	1	statement/sql/show_tables	init_net_server_extension.cc:95	192132263035000	192132384541000	121506000	53000000	SHOW TABLES FROM `phpmyadmin`	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	SHOW TABLES FROM `phpmyadmin`	NULL	NULL	NULL	NULL	NULL	1049	42000	Unknown database 'phpmyadmin'	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NULL	NULL	0	53457
3782	2	2	statement/com/Init DB	init_net_server_extension.cc:95	192132500647000	192132546898000	46251000	16000000	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1049	42000	Unknown database 'phpmyadmin'	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NULL	NULL	0	53458
3783	28	28	statement/sql/select	init_net_server_extension.cc:95	192313490642000	192313557560000	66918000	0	SELECT CURRENT_USER()	3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f...	SELECT CURRENT_USER ( )	performance_schema	NULL	NULL	NULL	NULL	0	NULL	NULL	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	NULL	NULL	0	53524
3783	29	30	statement/sql/select	init_net_server_extension.cc:95	192317855079000	192318331276000	476197000	224000000	SELECT (COUNT(DB_first_level) DIV 100) * 100 from ...	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	NULL	NULL	NULL	NULL	0	NULL	NULL	0	0	0	1	11	0	2	1	0	0	0	2	0	0	0	0	1	0	NULL	NULL	0	53525
3783	31	32	statement/sql/select	init_net_server_extension.cc:95	192324087394000	192325142788000	1055394000	306000000	SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC...	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	NULL	NULL	NULL	NULL	0	NULL	NULL	0	0	0	31	156	0	3	3	0	0	0	3	0	0	62	2	1	0	NULL	NULL	0	53527
3783	33	34	statement/sql/select	init_net_server_extension.cc:95	192335283729000	192336022255000	738526000	315000000	SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_I...	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	NULL	NULL	NULL	NULL	0	NULL	NULL	0	0	0	1	31	0	2	1	0	0	0	2	0	0	0	0	1	0	NULL	NULL	0	53537
3783	35	36	statement/sql/select	init_net_server_extension.cc:95	192337213213000	192337671596000	458383000	189000000	SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_I...	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	NULL	NULL	NULL	NULL	0	NULL	NULL	0	0	0	1	31	0	2	1	0	0	0	2	0	0	0	0	1	0	NULL	NULL	0	53539
3783	37	38	statement/sql/select	init_net_server_extension.cc:95	192364331776000	192365045341000	713565000	243000000	SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR...	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	NULL	NULL	NULL	NULL	0	NULL	NULL	0	0	0	1	4	0	7	0	0	0	0	7	0	0	0	0	1	0	NULL	NULL	0	53549
3783	22	23	statement/sql/show_keys	init_net_server_extension.cc:95	192154493367000	192155002350000	508983000	266000000	SHOW INDEXES FROM `performance_schema`.`table_lock...	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	NULL	NULL	NULL	NULL	0	NULL	NULL	0	0	0	3	17	0	1	0	0	0	0	1	0	0	3	1	0	0	NULL	NULL	0	53472
3783	24	24	statement/sql/show_create_table	init_net_server_extension.cc:95	192156505910000	192156688820000	182910000	0	SHOW CREATE TABLE `performance_schema`.`table_lock...	bbd9b634d307ea4ea2b4db12cc479b75b75d3cfdb9ab395083...	SHOW CREATE TABLE `performance_schema` . `table_lo...	performance_schema	NULL	NULL	NULL	NULL	0	NULL	NULL	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NULL	NULL	0	53473
3783	25	26	statement/sql/show_fields	init_net_server_extension.cc:95	192179531153000	192180919983000	1388830000	397000000	SHOW FULL COLUMNS FROM `performance_schema`.`table...	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	NULL	NULL	NULL	NULL	0	NULL	NULL	0	0	0	68	343	0	1	0	0	0	0	1	0	0	68	1	0	0	NULL	NULL	0	53480
3783	27	27	statement/sql/show_variables	init_net_server_extension.cc:95	192309149991000	192309931191000	781200000	98000000	SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	SHOW SESSION VARIABLES LIKE ?	performance_schema	NULL	NULL	NULL	NULL	0	NULL	NULL	0	0	0	1	574	0	1	0	0	0	0	2	0	0	0	0	1	0	NULL	NULL	0	53520

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Currently running Git revision RELEASE_5_2_1-4905-ga02a35c003 from the master branch.