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 (110 total, Query took 0.0012 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	139624384516864	5	1694772288	4320096	338954352	665446848	3	1421638944	314554944	473879472	665446848	303507	0	0	0	0	0	0	2	273133344	4320096	136566672	268813248
/usr/share/mysql-8.0/charsets/Index.xml	wait/io/file/mysys/charset	139624384517568	3	261934992	3318480	87311664	241479744	1	241479744	241479744	241479744	241479744	19495	0	0	0	0	0	0	2	20455248	3318480	10227624	17136768
/var/lib/mysql/ibdata1	wait/io/file/innodb/innodb_data_file	139624384520384	257	2078210331120	1421904	8086421376	40335684048	20	17819129856	1421904	890956440	8417042832	2441216	120	15528795216	5772096	129406464	1292571456	17416192	117	2044862406048	1737648	17477456304	40335684048
/var/lib/mysql/ib_logfile0	wait/io/file/innodb/innodb_log_file	139624384521088	105	785987628096	225984	7485596448	40052983344	6	585809136	225984	97634856	583755744	4608	48	3496277664	14357904	72838920	1187641488	24576	51	781905541296	1554960	15331481088	40052983344
/var/lib/mysql/ib_logfile1	wait/io/file/innodb/innodb_log_file	139624384521792	1068	6103317193248	532224	5714716392	58601708352	2	6603218160	6050352	3301609080	6597167808	66048	670	192042999456	532224	286631136	7478890320	908800	396	5904670975632	1108800	14910785208	58601708352
/var/lib/mysql/undo_001	wait/io/file/innodb/innodb_data_file	139624384522496	742	730987259904	2134704	985157976	44064709920	388	90379612752	10426416	232936968	3062394192	6406144	301	12439012080	4006464	41325504	4188666240	4931584	53	628168635072	2134704	11852238288	44064709920
/var/lib/mysql/undo_002	wait/io/file/innodb/innodb_data_file	139624384523200	691	628803437856	1358016	909990312	34685478432	384	69681942000	9563136	181463304	7903604016	6340608	259	15945548256	5205552	61565592	4371394368	4243456	48	543175947600	1358016	11316165432	34685478432
/var/lib/mysql/ibtmp1	wait/io/file/innodb/innodb_data_file	139624384523904	147	312427885440	20943648	2125359720	297045098592	0	0	0	0	0	0	143	15265981104	20943648	106755000	1314207840	14729216	4	297161904336	25620144	74290475952	297045098592
/var/lib/mysql/#innodb_temp/temp_1.ibt	wait/io/file/innodb/innodb_temp_file	139624384524608	8	67107534912	22179696	8388441864	38640730128	0	0	0	0	0	0	3	243305040	42304416	81101592	121891440	114688	5	66864229872	22179696	13372845816	38640730128
/var/lib/mysql/#innodb_temp/temp_2.ibt	wait/io/file/innodb/innodb_temp_file	139624384525312	8	69450764064	21266256	8681345376	43967187792	0	0	0	0	0	0	3	246850032	41893104	82283256	135223440	114688	5	69203914032	21266256	13840782648	43967187792
/var/lib/mysql/#innodb_temp/temp_3.ibt	wait/io/file/innodb/innodb_temp_file	139624384526016	8	88490979984	23705616	11061372432	59589249456	0	0	0	0	0	0	3	370718304	79796640	123572592	189586320	114688	5	88120261680	23705616	17624052336	59589249456
/var/lib/mysql/#innodb_temp/temp_4.ibt	wait/io/file/innodb/innodb_temp_file	139624384526720	8	74283475728	22157520	9285434400	50392065504	0	0	0	0	0	0	3	346069680	77169312	115356384	190287504	114688	5	73937406048	22157520	14787481104	50392065504
/var/lib/mysql/#innodb_temp/temp_5.ibt	wait/io/file/innodb/innodb_temp_file	139624384527424	8	79157656512	42763776	9894707064	45967400688	0	0	0	0	0	0	3	356771712	44581152	118923816	238469616	114688	5	78800884800	42763776	15760176960	45967400688
/var/lib/mysql/#innodb_temp/temp_6.ibt	wait/io/file/innodb/innodb_temp_file	139624384528128	8	74709189456	21047136	9338648616	50963792880	0	0	0	0	0	0	3	300089328	44730576	100029600	187465872	114688	5	74409100128	21047136	14881819920	50963792880
/var/lib/mysql/#innodb_temp/temp_7.ibt	wait/io/file/innodb/innodb_temp_file	139624384528832	8	62360851872	8622240	7795106352	35990647440	0	0	0	0	0	0	3	224915856	21247776	74971776	178749120	114688	5	62135936016	8622240	12427186992	35990647440
/var/lib/mysql/#innodb_temp/temp_8.ibt	wait/io/file/innodb/innodb_temp_file	139624384529536	8	63091694688	21922032	7886461704	33460102896	0	0	0	0	0	0	3	190810752	39973824	63603408	75895776	114688	5	62900883936	21922032	12580176576	33460102896
/var/lib/mysql/#innodb_temp/temp_9.ibt	wait/io/file/innodb/innodb_temp_file	139624384530240	8	57919146384	22362384	7239893232	33444844224	0	0	0	0	0	0	3	259462368	42941712	86487456	137375040	114688	5	57659684016	22362384	11531936592	33444844224
/var/lib/mysql/#innodb_temp/temp_10.ibt	wait/io/file/innodb/innodb_temp_file	139624384530944	85	236668755840	13282896	2784338304	87125762064	0	0	0	0	0	0	76	90031645440	13282896	1184626872	87125762064	1572864	9	146637110400	22296384	16293012120	32617640352
/var/lib/mysql/mysql.ibd	wait/io/file/innodb/innodb_data_file	139624384531648	771	1008593704800	1269312	1308163032	26607077376	348	146442434688	3968976	420811512	7445653776	5750784	354	11604768912	3793152	32781672	659224896	5799936	69	850546501200	1269312	12326760864	26607077376
/var/lib/mysql/sys/sys_config.ibd	wait/io/file/innodb/innodb_data_file	139624384532352	3	524348880	2279376	174782784	513224976	1	513224976	513224976	513224976	513224976	65536	0	0	0	0	0	0	2	11123904	2279376	5561952	8844528
/var/lib/mysql/sakila/actor.ibd	wait/io/file/innodb/innodb_data_file	139624384533056	9	1486832160	1381248	165203544	767122752	4	1443755280	22636416	360938688	767122752	114688	0	0	0	0	0	0	5	43076880	1381248	8615376	18014832
/var/lib/mysql/sakila/address.ibd	wait/io/file/innodb/innodb_data_file	139624384533760	14	1808398944	1349568	129171240	353130096	9	1768265664	5835984	196473816	353130096	196608	0	0	0	0	0	0	5	40133280	1349568	8026656	20260416
/var/lib/mysql/sakila/category.ibd	wait/io/file/innodb/innodb_data_file	139624384534464	9	6257382384	1385472	695264592	5748669696	4	6232278096	25341360	1558069392	5748669696	114688	0	0	0	0	0	0	5	25104288	1385472	5020752	8690880
/var/lib/mysql/sakila/city.ibd	wait/io/file/innodb/innodb_data_file	139624384535168	12	1444964400	1189584	120413568	339301248	7	1410563616	10943856	201509088	339301248	163840	0	0	0	0	0	0	5	34400784	1189584	6880104	16653120
/var/lib/mysql/sakila/country.ibd	wait/io/file/innodb/innodb_data_file	139624384535872	9	908660016	1293072	100962048	316460496	4	877207584	29317200	219301896	316460496	114688	0	0	0	0	0	0	5	31452432	1293072	6290328	12215280

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.