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 (101 total, Query took 0.0004 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	139871511270144	5	1105294080	4087248	221058816	435268416	3	877536528	207228912	292512000	435268416	303507	0	0	0	0	0	0	2	227757552	4087248	113878776	223670304
/usr/share/mysql-8.0/charsets/Index.xml	wait/io/file/mysys/charset	139871511270848	3	280126176	2661120	93375216	262162560	1	262162560	262162560	262162560	262162560	19495	0	0	0	0	0	0	2	17963616	2661120	8981808	15302496
/var/lib/mysql/ibdata1	wait/io/file/innodb/innodb_data_file	139871511273664	91	584963466384	1392336	6428169792	41692686288	20	10190039376	1392336	509501784	5414854368	2441216	33	2354310816	4819584	71342568	524568528	3506176	38	572419116192	2391312	15063660744	41692686288
/var/lib/mysql/ib_logfile0	wait/io/file/innodb/innodb_log_file	139871511274368	41	237359867184	231264	5789264976	25029799344	6	697756224	231264	116292528	695736096	4608	16	1038779280	4471632	64923672	482776272	8192	19	235623331680	436656	12401227872	25029799344
/var/lib/mysql/ib_logfile1	wait/io/file/innodb/innodb_log_file	139871511275072	254	1389161125968	281424	5469138048	28735768512	2	945997008	6943728	472998504	939053280	66048	151	26688254736	465168	176743248	7550419008	162816	101	1361526874224	281424	13480464096	28735768512
/var/lib/mysql/undo_001	wait/io/file/innodb/innodb_data_file	139871511275776	469	204968593104	1907664	437032992	17468254848	387	65512871424	3759360	169283664	2492013744	6389760	65	1878052176	4633200	28892952	201244560	1064960	17	137577669504	1907664	8092803840	17468254848
/var/lib/mysql/undo_002	wait/io/file/innodb/innodb_data_file	139871511276480	454	223975934688	1431408	493338912	24845475600	382	30311039088	3659568	79348104	2593351728	6307840	50	1460041440	4539744	29200776	173953824	819200	22	192204854160	1431408	8736584208	24845475600
/var/lib/mysql/ibtmp1	wait/io/file/innodb/innodb_data_file	139871511277184	147	246274892160	7258416	1675339248	235994260128	0	0	0	0	0	0	143	10224172992	7258416	71497536	1074735024	14729216	4	236050719168	13103376	59012679792	235994260128
/var/lib/mysql/#innodb_temp/temp_1.ibt	wait/io/file/innodb/innodb_temp_file	139871511277888	8	36058011792	10290720	4507251408	18334445184	0	0	0	0	0	0	3	174138624	36113616	58046208	76064208	114688	5	35883873168	10290720	7176774528	18334445184
/var/lib/mysql/#innodb_temp/temp_2.ibt	wait/io/file/innodb/innodb_temp_file	139871511278592	8	34753773120	15979920	4344221640	19511635968	0	0	0	0	0	0	3	360036336	64024752	120012024	216419280	114688	5	34393736784	15979920	6878747304	19511635968
/var/lib/mysql/#innodb_temp/temp_3.ibt	wait/io/file/innodb/innodb_temp_file	139871511279296	8	33738324048	30868992	4217290440	17772037536	0	0	0	0	0	0	3	584896224	66634128	194965320	436578384	114688	5	33153427824	30868992	6630685512	17772037536
/var/lib/mysql/#innodb_temp/temp_4.ibt	wait/io/file/innodb/innodb_temp_file	139871511280000	8	37377558240	18947280	4672194648	22386406944	0	0	0	0	0	0	3	320988624	41973888	106996032	208083744	114688	5	37056569616	18947280	7411313712	22386406944
/var/lib/mysql/#innodb_temp/temp_5.ibt	wait/io/file/innodb/innodb_temp_file	139871511280704	8	34054259712	19927248	4256782464	18718453248	0	0	0	0	0	0	3	467994912	74113248	155998128	271242048	114688	5	33586264800	19927248	6717252960	18718453248
/var/lib/mysql/#innodb_temp/temp_6.ibt	wait/io/file/innodb/innodb_temp_file	139871511281408	8	37991497104	41085792	4748937072	19335616080	0	0	0	0	0	0	3	478394928	46447632	159464976	357021984	114688	5	37513102176	41085792	7502620224	19335616080
/var/lib/mysql/#innodb_temp/temp_7.ibt	wait/io/file/innodb/innodb_temp_file	139871511282112	8	34430221056	19077696	4303777632	18270651696	0	0	0	0	0	0	3	472967088	43841424	157655520	352889856	114688	5	33957253968	19077696	6791450688	18270651696
/var/lib/mysql/#innodb_temp/temp_8.ibt	wait/io/file/innodb/innodb_temp_file	139871511282816	8	45152284848	19079808	5644035408	26108858160	0	0	0	0	0	0	3	293316144	44010384	97771872	176474496	114688	5	44858968704	19079808	8971793688	26108858160
/var/lib/mysql/#innodb_temp/temp_9.ibt	wait/io/file/innodb/innodb_temp_file	139871511283520	8	54163836144	19172208	6770479320	31551244560	0	0	0	0	0	0	3	412712256	44269632	137570664	298888656	114688	5	53751123888	19172208	10750224672	31551244560
/var/lib/mysql/#innodb_temp/temp_10.ibt	wait/io/file/innodb/innodb_temp_file	139871511284224	11	59986770096	17896560	5453342664	22439745504	0	0	0	0	0	0	5	465549216	18834288	93109632	295917600	212992	6	59521220880	17896560	9920203392	22439745504
/var/lib/mysql/mysql.ibd	wait/io/file/innodb/innodb_data_file	139871511284928	396	198472308672	1734480	501192648	29804900400	314	85527931632	3892944	272381736	5962074096	5193728	60	1906913184	4463712	31781640	190875168	983040	22	111037463856	1734480	5047157280	29804900400
/var/lib/mysql/sys/sys_config.ibd	wait/io/file/innodb/innodb_data_file	139871511285632	9	940869072	2094048	104540832	407732688	4	892892352	8533008	223223088	407732688	114688	0	0	0	0	0	0	5	47976720	2094048	9595344	20684400
/var/lib/mysql/sakila/actor.ibd	wait/io/file/innodb/innodb_data_file	139871511286336	3	464487936	1273008	154829136	458298192	1	458298192	458298192	458298192	458298192	65536	0	0	0	0	0	0	2	6189744	1273008	3094872	4916736
/var/lib/mysql/sakila/address.ibd	wait/io/file/innodb/innodb_data_file	139871511287040	9	2099751456	1071312	233305512	788976144	4	2010250704	121603680	502562544	788976144	114688	0	0	0	0	0	0	5	89500752	1071312	17899992	40388304
/var/lib/mysql/sakila/category.ibd	wait/io/file/innodb/innodb_data_file	139871511287744	3	305463312	861696	101821104	300072960	1	300072960	300072960	300072960	300072960	65536	0	0	0	0	0	0	2	5390352	861696	2695176	4528656
/var/lib/mysql/sakila/city.ibd	wait/io/file/innodb/innodb_data_file	139871511288448	3	326287632	859584	108762456	321706176	1	321706176	321706176	321706176	321706176	65536	0	0	0	0	0	0	2	4581456	859584	2290728	3721872
/var/lib/mysql/sakila/country.ibd	wait/io/file/innodb/innodb_data_file	139871511289152	9	1206869136	798336	134096424	347996880	4	840468816	26053104	210117072	330454608	114688	0	0	0	0	0	0	5	366400320	798336	73280064	347996880

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Currently running Git revision RELEASE_5_2_1-4907-g5b04607256 from the master branch.