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 (43 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	140113535140608	5	2293229664	6559872	458645880	1355194896	3	2022412128	302306928	674137200	1355194896	303507	0	0	0	0	0	0	2	270817536	6559872	135408768	264257664
/usr/share/mysql-8.0/charsets/Index.xml	wait/io/file/mysys/charset	140113535141312	3	330139920	2195424	110046552	314524848	1	314524848	314524848	314524848	314524848	19495	0	0	0	0	0	0	2	15615072	2195424	7807536	13419648
/var/lib/mysql/ibdata1	wait/io/file/innodb/innodb_data_file	140113535144128	317	2494485229632	1468896	7869038496	41633335392	20	13176236304	1468896	658811736	5679009072	2441216	149	20315651664	5053488	136346496	2162097168	22495232	148	2460993341664	2161632	16628333304	41633335392
/var/lib/mysql/ib_logfile0	wait/io/file/innodb/innodb_log_file	140113535144832	133	937675987248	240768	7050195240	29285431824	6	573651936	240768	95608656	571599072	4608	62	3190728816	7960128	51463368	639700512	31744	65	933911606496	407616	14367870792	29285431824
/var/lib/mysql/ib_logfile1	wait/io/file/innodb/innodb_log_file	140113535145536	2100	9593478419184	330000	4568323056	215641910352	2	815918928	2185920	407959464	813733008	66048	1424	373419373536	454080	262232520	18223877760	2423296	674	9219243126720	330000	13678402056	215641910352
/var/lib/mysql/undo_001	wait/io/file/innodb/innodb_data_file	140113535146240	934	760353017952	2030160	814082280	28008789072	388	80469908640	6489648	207396552	10475337840	6406144	480	19477456416	4045008	40577856	4492587264	7864320	66	660405652896	2030160	10006146216	28008789072
/var/lib/mysql/undo_002	wait/io/file/innodb/innodb_data_file	140113535146944	940	785654566224	1364352	835802616	25701798144	386	35644003824	6216144	92341920	2001924144	6373376	486	18527124528	4540272	38121600	4166315472	7962624	68	731483437872	1364352	10757109264	25701798144
/var/lib/mysql/ibtmp1	wait/io/file/innodb/innodb_data_file	140113535147648	147	251627525952	20653776	1711751712	235123012080	0	0	0	0	0	0	143	16421367072	20653776	114834720	1252664160	14729216	4	235206158880	21755712	58801539720	235123012080
/var/lib/mysql/#innodb_temp/temp_1.ibt	wait/io/file/innodb/innodb_temp_file	140113535148352	8	46995570864	11264352	5874446160	26064994032	0	0	0	0	0	0	3	201599904	28608624	67199880	137623200	114688	5	46793970960	11264352	9358794192	26064994032
/var/lib/mysql/#innodb_temp/temp_2.ibt	wait/io/file/innodb/innodb_temp_file	140113535149056	8	31191012336	8489712	3898876344	15817890528	0	0	0	0	0	0	3	106277424	19582992	35425632	55608432	114688	5	31084734912	8489712	6216946824	15817890528
/var/lib/mysql/#innodb_temp/temp_3.ibt	wait/io/file/innodb/innodb_temp_file	140113535149760	8	32591357568	6442128	4073919696	18901358784	0	0	0	0	0	0	3	91075248	15705888	30358416	55748880	114688	5	32500282320	6442128	6500056464	18901358784
/var/lib/mysql/#innodb_temp/temp_4.ibt	wait/io/file/innodb/innodb_temp_file	140113535150464	8	33201397680	9018240	4150174512	16865833248	0	0	0	0	0	0	3	77121792	13578048	25707264	32934000	114688	5	33124275888	9018240	6624855072	16865833248
/var/lib/mysql/#innodb_temp/temp_5.ibt	wait/io/file/innodb/innodb_temp_file	140113535151168	8	30712494384	17007408	3839061600	16464267600	0	0	0	0	0	0	3	130407552	19932000	43469184	62952912	114688	5	30582086832	17007408	6116417208	16464267600
/var/lib/mysql/#innodb_temp/temp_6.ibt	wait/io/file/innodb/innodb_temp_file	140113535151872	8	31957866864	16881744	3994733160	16963079232	0	0	0	0	0	0	3	232962048	50006352	77654016	118990608	114688	5	31724904816	16881744	6344980752	16963079232
/var/lib/mysql/#innodb_temp/temp_7.ibt	wait/io/file/innodb/innodb_temp_file	140113535152576	8	33864746784	17406048	4233093216	17126253936	0	0	0	0	0	0	3	220923120	39493344	73640952	111645072	114688	5	33643823664	17406048	6728764680	17126253936
/var/lib/mysql/#innodb_temp/temp_8.ibt	wait/io/file/innodb/innodb_temp_file	140113535153280	8	37127863344	18917184	4640982720	19637364384	0	0	0	0	0	0	3	238517664	39645936	79505712	125219424	114688	5	36889345680	18917184	7377869136	19637364384
/var/lib/mysql/#innodb_temp/temp_9.ibt	wait/io/file/innodb/innodb_temp_file	140113535153984	8	32488181616	19255632	4061022504	17717251200	0	0	0	0	0	0	3	243408528	40820208	81136176	125790192	114688	5	32244773088	19255632	6448954512	17717251200
/var/lib/mysql/#innodb_temp/temp_10.ibt	wait/io/file/innodb/innodb_temp_file	140113535154688	151	1043462030160	5162256	6910344408	183094726320	0	0	0	0	0	0	109	36731679072	5162256	336987816	25081717584	4276224	42	1006730351088	20616816	23969770176	183094726320
/var/lib/mysql/mysql.ibd	wait/io/file/innodb/innodb_data_file	140113535155392	822	897924905856	1279872	1092366000	66133872288	458	116922780480	3882384	255289848	4439642064	7553024	282	23696235024	3588288	84029088	8857536336	4620288	82	757305890352	1279872	9235437552	66133872288
/var/lib/mysql/sys/sys_config.ibd	wait/io/file/innodb/innodb_data_file	140113535156096	9	1164690912	2526480	129409896	390092208	4	1118903808	28932816	279725952	390092208	114688	0	0	0	0	0	0	5	45787104	2526480	9157368	18498480
/var/lib/mysql/binlog.000007	wait/io/file/sql/binlog	140113535196928	2241	20052277872	82896	8947752	1991371536	561	9150841392	1069200	16311504	1991371536	2987	1	4076160	4076160	4076160	4076160	1	1679	10897360320	82896	6490176	807860064
/var/lib/mysql/auto.cnf	wait/io/file/mysys/cnf	140113535197632	5	1193823840	244464	238764768	1153372704	3	1154687952	244464	384895896	1153372704	56	0	0	0	0	0	0	2	39135888	15531120	19567944	23604768
/var/lib/mysql/binlog.000008	wait/io/file/sql/binlog	140113535198336	76	644397911520	2740848	8478919680	72268128768	0	0	0	0	0	0	37	3777668400	7870368	102099096	1412617008	7554	39	640620243120	2740848	16426159992	72268128768
/var/lib/mysql/binlog.index	wait/io/file/sql/binlog_index	140113535199744	13	19074506880	412368	1467269760	19013576736	3	31487280	3091440	10495584	24627504	96	0	0	0	0	0	0	10	19043019600	412368	1904301960	19013576736
/run/mysqld/mysqld.pid	wait/io/file/sql/pid	140113535200448	3	60770688	2981088	20256720	39264192	0	0	0	0	0	0	1	18525408	18525408	18525408	18525408	4	2	42245280	2981088	21122640	39264192

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.