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 (113 total, Query took 0.0005 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	140550162457344	5	1329865152	3910368	265972872	520798608	3	1097783808	221148576	365927760	520798608	303507	0	0	0	0	0	0	2	232081344	3910368	116040672	228170976
/usr/share/mysql-8.0/charsets/Index.xml	wait/io/file/mysys/charset	140550162458048	3	633370848	2786256	211123440	614545536	1	614545536	614545536	614545536	614545536	19495	0	0	0	0	0	0	2	18825312	2786256	9412656	16039056
/var/lib/mysql/ibdata1	wait/io/file/innodb/innodb_data_file	140550162460864	309	2509932350112	1484736	8122758336	128307061344	20	14687889744	1484736	734394408	8955393216	2441216	145	14554718112	5382432	100377288	827338512	19546112	144	2480689742256	2310000	17227011912	128307061344
/var/lib/mysql/ib_logfile0	wait/io/file/innodb/innodb_log_file	140550162461568	141	976024034832	241824	6922156032	38975384448	6	502096320	241824	83682720	499984848	4608	66	6294884640	6998112	95376864	3705882576	33792	69	969227053872	1589280	14046768648	38975384448
/var/lib/mysql/ib_logfile1	wait/io/file/innodb/innodb_log_file	140550162462272	1096	7478158624464	661584	6823137288	717043621536	2	1018381584	1646832	509190792	1016734752	66048	681	285111237312	661584	418665456	104641454016	868352	413	7192029005568	1049136	17414113728	717043621536
/var/lib/mysql/undo_001	wait/io/file/innodb/innodb_data_file	140550162462976	703	657360548064	4036032	935078760	22304264400	389	98915224320	7795920	254280576	7312969488	6422528	258	19273006368	4636896	74701440	5586165552	4227072	56	539172317376	4036032	9628077096	22304264400
/var/lib/mysql/undo_002	wait/io/file/innodb/innodb_data_file	140550162463680	722	789655411248	1361184	1093705536	24583426560	384	107177498208	6288480	279107928	13537415760	6340608	277	13457095872	4909344	48581544	3772701504	4538368	61	669020817168	1361184	10967554224	24583426560
/var/lib/mysql/ibtmp1	wait/io/file/innodb/innodb_data_file	140550162464384	147	348931617408	20869200	2373684456	317501814432	0	0	0	0	0	0	143	31269644736	20869200	218668824	3561543216	14729216	4	317661972672	22779504	79415493168	317501814432
/var/lib/mysql/#innodb_temp/temp_1.ibt	wait/io/file/innodb/innodb_temp_file	140550162465088	8	67009270944	19825872	8376158736	35944301712	0	0	0	0	0	0	3	286427328	39330192	95475600	124806528	114688	5	66722843616	19825872	13344568512	35944301712
/var/lib/mysql/#innodb_temp/temp_2.ibt	wait/io/file/innodb/innodb_temp_file	140550162465792	8	77516975712	10299696	9689621832	47609234112	0	0	0	0	0	0	3	214328400	39785856	71442624	133234992	114688	5	77302647312	10299696	15460529304	47609234112
/var/lib/mysql/#innodb_temp/temp_3.ibt	wait/io/file/innodb/innodb_temp_file	140550162466496	8	72050561616	15215904	9006320136	39817588272	0	0	0	0	0	0	3	127217376	19546560	42405792	57164448	114688	5	71923344240	15215904	14384668848	39817588272
/var/lib/mysql/#innodb_temp/temp_4.ibt	wait/io/file/innodb/innodb_temp_file	140550162467200	8	48434776896	19432512	6054347112	26781224448	0	0	0	0	0	0	3	200214960	26193552	66738144	89271072	114688	5	48234561936	19432512	9646912176	26781224448
/var/lib/mysql/#innodb_temp/temp_5.ibt	wait/io/file/innodb/innodb_temp_file	140550162467904	8	49071604032	18917184	6133950504	30811539264	0	0	0	0	0	0	3	292956048	43909008	97652016	128938656	114688	5	48778647984	18917184	9755729544	30811539264
/var/lib/mysql/#innodb_temp/temp_6.ibt	wait/io/file/innodb/innodb_temp_file	140550162468608	8	67791504528	20219232	8473938000	37744578960	0	0	0	0	0	0	3	261999936	56359248	87333312	121871904	114688	5	67529504592	20219232	13505900760	37744578960
/var/lib/mysql/#innodb_temp/temp_7.ibt	wait/io/file/innodb/innodb_temp_file	140550162469312	8	75590883456	23440560	9448860432	38249342736	0	0	0	0	0	0	3	251034432	40861920	83677968	122687664	114688	5	75339849024	23440560	15067969752	38249342736
/var/lib/mysql/#innodb_temp/temp_8.ibt	wait/io/file/innodb/innodb_temp_file	140550162470016	8	64762807296	10737936	8095350912	32249738928	0	0	0	0	0	0	3	300308448	41545152	100102728	214440336	114688	5	64462498848	10737936	12892499664	32249738928
/var/lib/mysql/#innodb_temp/temp_9.ibt	wait/io/file/innodb/innodb_temp_file	140550162470720	8	51042620640	7261056	6380327448	30425303040	0	0	0	0	0	0	3	165986304	13909632	55328592	125515104	114688	5	50876634336	7261056	10175326656	30425303040
/var/lib/mysql/#innodb_temp/temp_10.ibt	wait/io/file/innodb/innodb_temp_file	140550162471424	54	264548388192	4807968	4899044040	28220916768	0	0	0	0	0	0	45	118815776112	4807968	2640350328	23669160768	1064960	9	145732612080	19450992	16192512336	28220916768
/var/lib/mysql/mysql.ibd	wait/io/file/innodb/innodb_data_file	140550162472128	922	1063898043648	1548624	1153902288	31580293536	350	229175719344	4175424	654787584	20278441392	5783552	484	11789236800	3590400	24357696	139502880	7929856	88	822933087504	1548624	9351512280	31580293536
/var/lib/mysql/sys/sys_config.ibd	wait/io/file/innodb/innodb_data_file	140550162472832	9	1404853296	2292576	156094752	568999728	4	1107790992	32058048	276947616	568999728	114688	0	0	0	0	0	0	5	297062304	2292576	59412408	261534768
/var/lib/mysql/sakila/actor.ibd	wait/io/file/innodb/innodb_data_file	140550162473536	3	406067904	3023856	135355968	388931136	1	388931136	388931136	388931136	388931136	65536	0	0	0	0	0	0	2	17136768	3023856	8568384	14112912
/var/lib/mysql/sakila/address.ibd	wait/io/file/innodb/innodb_data_file	140550162474240	10	1458505488	3027024	145850496	467359728	5	1387752432	43235280	277550328	467359728	131072	0	0	0	0	0	0	5	70753056	3027024	14150400	29045280
/var/lib/mysql/sakila/category.ibd	wait/io/file/innodb/innodb_data_file	140550162474944	3	379780368	3119952	126593280	365377584	1	365377584	365377584	365377584	365377584	65536	0	0	0	0	0	0	2	14402784	3119952	7201392	11282832
/var/lib/mysql/sakila/city.ibd	wait/io/file/innodb/innodb_data_file	140550162475648	3	414661104	2093520	138220368	402104736	1	402104736	402104736	402104736	402104736	65536	0	0	0	0	0	0	2	12556368	2093520	6278184	10462848
/var/lib/mysql/sakila/country.ibd	wait/io/file/innodb/innodb_data_file	140550162476352	3	1665616128	2997984	555205200	1654333296	1	1654333296	1654333296	1654333296	1654333296	65536	0	0	0	0	0	0	2	11282832	2997984	5641416	8284848

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.