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 (114 total, Query took 0.0008 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	140604757676800	5	1347704160	4203936	269540832	511860096	3	1105557552	240298080	368519184	511860096	303507	0	0	0	0	0	0	2	242146608	4203936	121073304	237942672
/usr/share/mysql-8.0/charsets/Index.xml	wait/io/file/mysys/charset	140604757677504	3	271845024	3682800	90614832	228881664	1	228881664	228881664	228881664	228881664	19495	0	0	0	0	0	0	2	42963360	3682800	21481680	39280560
/var/lib/mysql/ibdata1	wait/io/file/innodb/innodb_data_file	140604757680320	353	2705790697104	1541232	7665129384	81033792576	20	5697654864	1541232	284882664	3062364096	2441216	168	13544077536	5467440	80619264	1732902864	23052288	165	2686548964704	2093520	16282114728	81033792576
/var/lib/mysql/ib_logfile0	wait/io/file/innodb/innodb_log_file	140604757681024	145	999137774976	308352	6890605128	35679654912	6	548118912	308352	91352976	545962560	4608	68	3932434704	7369824	57829728	1201143504	34816	71	994657221360	829488	14009256624	35679654912
/var/lib/mysql/ib_logfile1	wait/io/file/innodb/innodb_log_file	140604757681728	1382	7545137192208	472560	5459578080	98860813920	2	783984960	2340096	391992480	781644864	66048	839	218014109280	472560	259849920	8782333296	871424	541	7326339097968	704880	13542216336	98860813920
/var/lib/mysql/undo_001	wait/io/file/innodb/innodb_data_file	140604757682432	935	691346628720	392304	739408032	24955274784	388	34115189328	3855984	87925728	2323019424	6406144	477	16936126944	4521792	35505360	3785507616	7815168	70	640295312448	392304	9147075696	24955274784
/var/lib/mysql/undo_002	wait/io/file/innodb/innodb_data_file	140604757683136	955	899915549280	297792	942319752	32873052432	386	40894739424	2119920	105944784	10715381952	6373376	492	12479538720	3836448	25364856	158147616	8060928	77	846541271136	297792	10994042400	32873052432
/var/lib/mysql/ibtmp1	wait/io/file/innodb/innodb_data_file	140604757683840	147	238647942192	5221392	1623455328	229800950544	0	0	0	0	0	0	143	8807015712	5221392	61587504	1179771648	14729216	4	229840926480	8484960	57460231488	229800950544
/var/lib/mysql/#innodb_temp/temp_1.ibt	wait/io/file/innodb/innodb_temp_file	140604757684544	8	52615789248	5929440	6576973656	35808655344	0	0	0	0	0	0	3	76901616	11326656	25633872	45837264	114688	5	52538887632	5929440	10507777368	35808655344
/var/lib/mysql/#innodb_temp/temp_2.ibt	wait/io/file/innodb/innodb_temp_file	140604757685248	8	42008757120	4830144	5251094640	29699532192	0	0	0	0	0	0	3	65759232	9430608	21919656	39439488	114688	5	41942997888	4830144	8388599472	29699532192
/var/lib/mysql/#innodb_temp/temp_3.ibt	wait/io/file/innodb/innodb_temp_file	140604757685952	8	49388324304	7023984	6173540472	30840906096	0	0	0	0	0	0	3	76495056	12468720	25498176	44153472	114688	5	49311829248	7023984	9862365744	30840906096
/var/lib/mysql/#innodb_temp/temp_4.ibt	wait/io/file/innodb/innodb_temp_file	140604757686656	8	33918499296	4543440	4239812280	20044321968	0	0	0	0	0	0	3	71178096	9353520	23725944	45925440	114688	5	33847321200	4543440	6769464240	20044321968
/var/lib/mysql/#innodb_temp/temp_5.ibt	wait/io/file/innodb/innodb_temp_file	140604757687360	8	31132555344	5414640	3891569352	18921080640	0	0	0	0	0	0	3	70752000	9713088	23583912	43914288	114688	5	31061803344	5414640	6212360616	18921080640
/var/lib/mysql/#innodb_temp/temp_6.ibt	wait/io/file/innodb/innodb_temp_file	140604757688064	8	32510945808	4095696	4063868160	16844194224	0	0	0	0	0	0	3	72160704	16135680	24053568	36203376	114688	5	32438785104	4095696	6487756968	16844194224
/var/lib/mysql/#innodb_temp/temp_7.ibt	wait/io/file/innodb/innodb_temp_file	140604757688768	8	32964998352	5979072	4120624728	17103048336	0	0	0	0	0	0	3	97633008	21486960	32544336	44901120	114688	5	32867365344	5979072	6573473016	17103048336
/var/lib/mysql/#innodb_temp/temp_8.ibt	wait/io/file/innodb/innodb_temp_file	140604757689472	8	27283635984	5085696	3410454432	15041761152	0	0	0	0	0	0	3	116011632	9352464	38670456	89700336	114688	5	27167624352	5085696	5433524712	15041761152
/var/lib/mysql/#innodb_temp/temp_9.ibt	wait/io/file/innodb/innodb_temp_file	140604757690176	8	27641313744	4315872	3455164152	15322605936	0	0	0	0	0	0	3	56009712	9246336	18669816	30761808	114688	5	27585304032	4315872	5517060648	15322605936
/var/lib/mysql/#innodb_temp/temp_10.ibt	wait/io/file/innodb/innodb_temp_file	140604757690880	38	252460621248	4561392	6643700448	26274793248	0	0	0	0	0	0	23	1227869808	8707776	53385552	137713488	1097728	15	251232751440	4561392	16748850096	26274793248
/var/lib/mysql/mysql.ibd	wait/io/file/innodb/innodb_data_file	140604757691584	766	699605433648	299904	913322784	25126829904	414	100043385552	1681152	241650552	5875269840	6832128	263	10545096144	3747216	40095264	4686940896	4308992	89	589016951952	299904	6618167952	25126829904
/var/lib/mysql/sys/sys_config.ibd	wait/io/file/innodb/innodb_data_file	140604757692288	9	1240476864	2476848	137830704	421068384	4	1173595104	35380752	293398776	421068384	114688	0	0	0	0	0	0	5	66881760	2476848	13376352	27715776
/var/lib/mysql/sakila/actor.ibd	wait/io/file/innodb/innodb_data_file	140604757692992	10	1100455488	1299936	110045496	395363232	5	1059709728	27052080	211941840	395363232	131072	0	0	0	0	0	0	5	40745760	1299936	8149152	17198544
/var/lib/mysql/sakila/address.ibd	wait/io/file/innodb/innodb_data_file	140604757693696	14	2564963280	1275120	183211512	998370912	9	2519834064	5998608	279981504	998370912	196608	0	0	0	0	0	0	5	45129216	1275120	9025632	20281536
/var/lib/mysql/sakila/category.ibd	wait/io/file/innodb/innodb_data_file	140604757694400	9	1004451888	1291488	111605736	379970976	4	961283136	29630304	240320784	379970976	114688	0	0	0	0	0	0	5	43168752	1291488	8633592	20365488
/var/lib/mysql/sakila/city.ibd	wait/io/file/innodb/innodb_data_file	140604757695104	12	1596675696	776688	133056264	375799248	7	1547144016	15030048	221020536	375799248	163840	0	0	0	0	0	0	5	49531680	776688	9906336	26486592
/var/lib/mysql/sakila/country.ibd	wait/io/file/innodb/innodb_data_file	140604757695808	9	1399656192	1323696	155517120	549449472	4	1328791200	61692048	332197800	549449472	114688	0	0	0	0	0	0	5	70864992	1323696	14172840	30862656

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.