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

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 (102 total, Query took 0.0006 seconds.)

SELECT * FROM `file_summary_by_instance`

Filter rows:

Partial texts

Full texts

Show binary contents

Show BLOB contents

Hide browser transformation

Well Known Text

Well Known Binary

FILE_NAME	EVENT_NAME	OBJECT_INSTANCE_BEGIN	COUNT_STAR	SUM_TIMER_WAIT	MIN_TIMER_WAIT	AVG_TIMER_WAIT	MAX_TIMER_WAIT	COUNT_READ	SUM_TIMER_READ	MIN_TIMER_READ	AVG_TIMER_READ	MAX_TIMER_READ	SUM_NUMBER_OF_BYTES_READ	COUNT_WRITE	SUM_TIMER_WRITE	MIN_TIMER_WRITE	AVG_TIMER_WRITE	MAX_TIMER_WRITE	SUM_NUMBER_OF_BYTES_WRITE	COUNT_MISC	SUM_TIMER_MISC	MIN_TIMER_MISC	AVG_TIMER_MISC	MAX_TIMER_MISC
/usr/share/mysql-8.0/english/errmsg.sys	wait/io/file/sql/ERRMSG	140248741454592	5	1549588560	3335820	309917500	600888030	3	1308579540	248099890	436193180	600888030	303507	0	0	0	0	0	0	2	241009020	3335820	120504510	237673200
/usr/share/mysql-8.0/charsets/Index.xml	wait/io/file/mysys/charset	140248741455296	3	341927380	2331470	113975705	328672080	1	328672080	328672080	328672080	328672080	19495	0	0	0	0	0	0	2	13255300	2331470	6627650	10923830
/var/lib/mysql/ibdata1	wait/io/file/innodb/innodb_data_file	140248741458112	138	1125354629130	1505200	8154743505	115538836120	20	5730991230	1505200	286549535	3055859160	2441216	60	7548129620	4556940	125802125	1160210810	10485760	58	1112075508280	1911710	19173715660	115538836120
/var/lib/mysql/ib_logfile0	wait/io/file/innodb/innodb_log_file	140248741458816	57	375587497680	244330	6589254150	25947366880	6	581923040	244330	96987085	580090830	4608	24	1333296620	11658940	55553805	526606410	12288	27	373672278020	536360	13839713775	25947366880
/var/lib/mysql/ib_logfile1	wait/io/file/innodb/innodb_log_file	140248741459520	571	3198655342270	442020	5601847985	60618217880	2	877410760	2969060	438705380	874441700	66048	356	94784504640	464280	266248415	7294225700	471552	213	3102993426870	442020	14568044015	60618217880
/var/lib/mysql/undo_001	wait/io/file/innodb/innodb_data_file	140248741460224	599	280010455950	445200	467463180	29572573240	388	35302666650	3925180	90986160	5232335430	6406144	188	7388911790	4196540	39302680	4500850630	3080192	23	237318877510	445200	10318211985	29572573240
/var/lib/mysql/undo_002	wait/io/file/innodb/innodb_data_file	140248741460928	605	323606262620	294150	534886335	47474005350	385	29350378160	2078130	76234670	2372613370	6356992	194	6286140260	4305190	32402610	412793680	3178496	26	287969744200	294150	11075759270	47474005350
/var/lib/mysql/ibtmp1	wait/io/file/innodb/innodb_data_file	140248741461632	147	248647060410	4803920	1691476450	239160156870	0	0	0	0	0	0	143	9443292490	4803920	66036940	1546816660	14729216	4	239203767920	8330010	59800941980	239160156870
/var/lib/mysql/#innodb_temp/temp_1.ibt	wait/io/file/innodb/innodb_temp_file	140248741462336	8	36175527890	5571890	4521940920	18320712990	0	0	0	0	0	0	3	69043100	11158620	23014190	32922540	114688	5	36106484790	5571890	7221296905	18320712990
/var/lib/mysql/#innodb_temp/temp_2.ibt	wait/io/file/innodb/innodb_temp_file	140248741463040	8	33968163220	5470130	4246020270	17545585340	0	0	0	0	0	0	3	66415360	10765890	22138365	42826650	114688	5	33901747860	5470130	6780349360	17545585340
/var/lib/mysql/#innodb_temp/temp_3.ibt	wait/io/file/innodb/innodb_temp_file	140248741463744	8	30141217130	5306890	3767652075	16173028440	0	0	0	0	0	0	3	55465560	8693590	18488520	33068290	114688	5	30085751570	5306890	6017150155	16173028440
/var/lib/mysql/#innodb_temp/temp_4.ibt	wait/io/file/innodb/innodb_temp_file	140248741464448	8	26595362370	5632840	3324420230	14556023880	0	0	0	0	0	0	3	63849100	8839340	21282945	41097260	114688	5	26531513270	5632840	5306302495	14556023880
/var/lib/mysql/#innodb_temp/temp_5.ibt	wait/io/file/innodb/innodb_temp_file	140248741465152	8	26385683240	4935360	3298210405	14725114020	0	0	0	0	0	0	3	73819460	9025900	24606310	51814920	114688	5	26311863780	4935360	5262372650	14725114020
/var/lib/mysql/#innodb_temp/temp_6.ibt	wait/io/file/innodb/innodb_temp_file	140248741465856	8	39896132130	5465890	4987016450	21661748720	0	0	0	0	0	0	3	54458030	10534280	18152500	30673750	114688	5	39841674100	5465890	7968334820	21661748720
/var/lib/mysql/#innodb_temp/temp_7.ibt	wait/io/file/innodb/innodb_temp_file	140248741466560	8	27714259150	4683080	3464282195	15985972890	0	0	0	0	0	0	3	60307110	9067770	20102370	31756010	114688	5	27653952040	4683080	5530790355	15985972890
/var/lib/mysql/#innodb_temp/temp_8.ibt	wait/io/file/innodb/innodb_temp_file	140248741467264	8	26875933240	4703220	3359491655	14511301950	0	0	0	0	0	0	3	77912120	9348670	25970530	47000400	114688	5	26798021120	4703220	5359604065	14511301950
/var/lib/mysql/#innodb_temp/temp_9.ibt	wait/io/file/innodb/innodb_temp_file	140248741467968	8	38684186430	5646620	4835523105	21666206550	0	0	0	0	0	0	3	70275350	10374220	23424940	36409410	114688	5	38613911080	5646620	7722782110	21666206550
/var/lib/mysql/#innodb_temp/temp_10.ibt	wait/io/file/innodb/innodb_temp_file	140248741468672	14	70317408680	4750390	5022671935	25923906430	0	0	0	0	0	0	7	433500250	19119750	61928380	127404050	311296	7	69883908430	4750390	9983415490	25923906430
/var/lib/mysql/mysql.ibd	wait/io/file/innodb/innodb_data_file	140248741469376	614	416607804860	299980	678514215	24634758810	403	82945310050	1601130	205819405	2354857310	6651904	179	3295996860	3804340	18413260	113428480	2932736	32	330366497950	299980	10323952945	24634758810
/var/lib/mysql/sys/sys_config.ibd	wait/io/file/innodb/innodb_data_file	140248741470080	3	323932290	2204270	107977430	311272180	1	311272180	311272180	311272180	311272180	65536	0	0	0	0	0	0	2	12660110	2204270	6330055	10455840
/var/lib/mysql/sakila/actor.ibd	wait/io/file/innodb/innodb_data_file	140248741470784	10	11128932580	690590	1112893205	5397895240	5	11060145470	17103630	2212028935	5397895240	131072	0	0	0	0	0	0	5	68787110	690590	13757210	37881220
/var/lib/mysql/sakila/address.ibd	wait/io/file/innodb/innodb_data_file	140248741471488	3	295018670	1273590	98339380	290072710	1	290072710	290072710	290072710	290072710	65536	0	0	0	0	0	0	2	4945960	1273590	2472980	3672370
/var/lib/mysql/sakila/category.ibd	wait/io/file/innodb/innodb_data_file	140248741472192	3	277162440	957710	92387480	270986350	1	270986350	270986350	270986350	270986350	65536	0	0	0	0	0	0	2	6176090	957710	3088045	5218380
/var/lib/mysql/sakila/city.ibd	wait/io/file/innodb/innodb_data_file	140248741472896	3	210442330	818320	70147355	205650600	1	205650600	205650600	205650600	205650600	65536	0	0	0	0	0	0	2	4791730	818320	2395865	3973410
/var/lib/mysql/sakila/country.ibd	wait/io/file/innodb/innodb_data_file	140248741473600	9	4300542430	1279420	477837930	1958543980	4	4164078560	47243140	1041019640	1958543980	114688	0	0	0	0	0	0	5	136463870	1279420	27292615	107505200

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Currently running Git revision RELEASE_5_2_1-5377-g8e721911f0 from the master branch.