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.0009 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	140464740754176	5	1232995632	3235584	246598968	369688176	3	965560464	244980912	321853488	369688176	303507	0	0	0	0	0	0	2	267435168	3235584	133717584	264199584
/usr/share/mysql-8.0/charsets/Index.xml	wait/io/file/mysys/charset	140464740754880	3	304270560	2156880	101423520	262034784	1	262034784	262034784	262034784	262034784	19495	0	0	0	0	0	0	2	42235776	2156880	21117888	40078896
/var/lib/mysql/ibdata1	wait/io/file/innodb/innodb_data_file	140464740757696	742	5615382174336	1429824	7567900296	118341434112	20	12274171536	1429824	613708392	5361241248	2441216	362	27554919216	5040288	76118328	2268856128	48021504	360	5575553083584	1867536	15487647384	118341434112
/var/lib/mysql/ib_logfile0	wait/io/file/innodb/innodb_log_file	140464740758400	317	2000700222048	238128	6311356920	29816092944	6	544128816	238128	90687960	542310912	4608	154	5328103968	6345504	34597992	932664480	78848	157	1994827989264	369600	12705910536	29816092944
/var/lib/mysql/ib_logfile1	wait/io/file/innodb/innodb_log_file	140464740759104	2972	15085093948848	307296	5075738184	232667263488	2	811211808	2426688	405605904	808785120	66048	1835	420730236960	453024	229280568	115221619392	2189312	1135	14663552500080	307296	12919429512	232667263488
/var/lib/mysql/undo_001	wait/io/file/innodb/innodb_data_file	140464740759808	1542	1267078837728	402336	821711088	42988670736	389	38791934016	3867072	99722040	4488255552	6422528	997	24744323472	3634752	24818640	3980491680	16334848	156	1203542580240	402336	7715016408	42988670736
/var/lib/mysql/undo_002	wait/io/file/innodb/innodb_data_file	140464740760512	1533	1249803263808	269808	815266056	24374848608	385	30389686800	2159520	78934152	2437422768	6356992	985	31629031104	3538128	32110584	3908235408	16138240	163	1187784545904	269808	7287021720	24374848608
/var/lib/mysql/ibtmp1	wait/io/file/innodb/innodb_data_file	140464740761216	147	210212583504	4731408	1430017512	198498515952	0	0	0	0	0	0	143	11624158656	4731408	81287712	1803055056	14729216	4	198588424848	19435152	49647106080	198498515952
/var/lib/mysql/#innodb_temp/temp_1.ibt	wait/io/file/innodb/innodb_temp_file	140464740761920	8	42757886688	7874064	5344735704	27617799264	0	0	0	0	0	0	3	94640304	15201648	31546680	45525216	114688	5	42663246384	7874064	8532649224	27617799264
/var/lib/mysql/#innodb_temp/temp_2.ibt	wait/io/file/innodb/innodb_temp_file	140464740762624	8	26891173056	4621584	3361396632	15209469792	0	0	0	0	0	0	3	77761200	11598576	25920312	43441728	114688	5	26813411856	4621584	5362682160	15209469792
/var/lib/mysql/#innodb_temp/temp_3.ibt	wait/io/file/innodb/innodb_temp_file	140464740763328	8	27240097632	6358176	3405012072	14856384048	0	0	0	0	0	0	3	68635776	11637120	22878504	39346032	114688	5	27171461856	6358176	5434292160	14856384048
/var/lib/mysql/#innodb_temp/temp_4.ibt	wait/io/file/innodb/innodb_temp_file	140464740764032	8	29705067216	4951584	3713133336	17870148912	0	0	0	0	0	0	3	66100320	11195184	22033440	40908912	114688	5	29638966896	4951584	5927793168	17870148912
/var/lib/mysql/#innodb_temp/temp_5.ibt	wait/io/file/innodb/innodb_temp_file	140464740764736	8	27154740096	6459552	3394342512	14313115872	0	0	0	0	0	0	3	70895616	14034240	23631696	39678144	114688	5	27083844480	6459552	5416768896	14313115872
/var/lib/mysql/#innodb_temp/temp_6.ibt	wait/io/file/innodb/innodb_temp_file	140464740765440	8	30018061920	5776320	3752257608	18110257968	0	0	0	0	0	0	3	67977360	10885248	22659120	40963824	114688	5	29950084560	5776320	5990016912	18110257968
/var/lib/mysql/#innodb_temp/temp_7.ibt	wait/io/file/innodb/innodb_temp_file	140464740766144	8	27202367808	11707344	3400295976	14738730336	0	0	0	0	0	0	3	70426224	11707344	23475408	40522944	114688	5	27131941584	15868512	5426388264	14738730336
/var/lib/mysql/#innodb_temp/temp_8.ibt	wait/io/file/innodb/innodb_temp_file	140464740766848	8	25996976016	8789616	3249621936	14238940848	0	0	0	0	0	0	3	92138640	21328560	30712704	42884688	114688	5	25904837376	8789616	5180967264	14238940848
/var/lib/mysql/#innodb_temp/temp_9.ibt	wait/io/file/innodb/innodb_temp_file	140464740767552	104	909767039280	4246176	8747759856	430788258912	0	0	0	0	0	0	78	489033659136	4246176	6269662080	430788258912	2719744	26	420733380144	9003984	16182052920	36554696640
/var/lib/mysql/#innodb_temp/temp_10.ibt	wait/io/file/innodb/innodb_temp_file	140464740768256	281	1106170482384	3501696	3936549672	356247124464	0	0	0	0	0	0	241	455656877808	3501696	1890692232	356247124464	6307840	40	650513604576	8857728	16262840088	34506066144
/var/lib/mysql/mysql.ibd	wait/io/file/innodb/innodb_data_file	140464740768960	1153	985807413888	545424	854993304	27565621248	465	94058418432	2458896	202276008	1996693248	7667712	517	8720336592	3419856	16866960	600471168	8470528	171	883028658864	545424	5163910224	27565621248
/var/lib/mysql/sys/sys_config.ibd	wait/io/file/innodb/innodb_data_file	140464740769664	9	862241952	2486352	95804544	241067376	4	598992768	28341456	149748192	228378480	114688	0	0	0	0	0	0	5	263249184	2486352	52649784	241067376
/var/lib/mysql/sakila/actor.ibd	wait/io/file/innodb/innodb_data_file	140464740770368	10	1775142864	874896	177514128	1104939792	5	1724980224	42629664	344995992	1104939792	131072	0	0	0	0	0	0	5	50162640	874896	10032528	26049936
/var/lib/mysql/sakila/address.ibd	wait/io/file/innodb/innodb_data_file	140464740771072	14	1998402384	838464	142742952	379229664	9	1979887008	27672480	219987240	379229664	196608	0	0	0	0	0	0	5	18515376	838464	3702864	6718800
/var/lib/mysql/sakila/category.ibd	wait/io/file/innodb/innodb_data_file	140464740771776	9	968622864	843216	107624616	319377696	4	927070320	51463632	231767448	319377696	114688	0	0	0	0	0	0	5	41552544	843216	8310456	18128352
/var/lib/mysql/sakila/city.ibd	wait/io/file/innodb/innodb_data_file	140464740772480	12	1467757104	811008	122313048	284603616	7	1448011488	22567776	206858784	284603616	163840	0	0	0	0	0	0	5	19745616	811008	3948912	7598448
/var/lib/mysql/sakila/country.ibd	wait/io/file/innodb/innodb_data_file	140464740773184	9	860509584	856944	95612088	283804224	4	822335184	18464160	205583664	283804224	114688	0	0	0	0	0	0	5	38174400	856944	7634880	18939888

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!