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.0003 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	140281776919296	5	1377534576	4590432	275506704	516465312	3	1112699280	270450048	370899672	516465312	303507	0	0	0	0	0	0	2	264835296	4590432	132417648	260244864
/usr/share/mysql-8.0/charsets/Index.xml	wait/io/file/mysys/charset	140281776920000	3	250019616	16318368	83339784	204451104	1	204451104	204451104	204451104	204451104	19495	0	0	0	0	0	0	2	45568512	16318368	22784256	29250144
/var/lib/mysql/ibdata1	wait/io/file/innodb/innodb_data_file	140281776922816	83	383150427792	1473120	4616270208	22718432880	20	6686132640	1473120	334306632	2653304016	2441216	29	961668048	6689232	33160776	123060432	1458176	34	375502627104	2237664	11044194744	22718432880
/var/lib/mysql/ib_logfile0	wait/io/file/innodb/innodb_log_file	140281776923520	39	181430572752	226512	4652065968	18019116720	6	889018416	226512	148169736	886457088	4608	15	998492352	10392624	66566016	280727040	7680	18	179543061984	392832	9974614320	18019116720
/var/lib/mysql/ib_logfile1	wait/io/file/innodb/innodb_log_file	140281776924224	137	709801094640	297792	5181029832	38959229232	2	752385744	7070448	376192872	745315296	66048	77	17656945680	601392	229310928	4277479536	83456	58	691391763216	297792	11920547496	38959229232
/var/lib/mysql/undo_001	wait/io/file/innodb/innodb_data_file	140281776924928	416	69099945024	960432	166105632	15111806160	387	22860966480	3562944	59072112	1301155152	6389760	19	711164784	5532912	37429656	258808704	311296	10	45527813760	960432	4552781376	15111806160
/var/lib/mysql/undo_002	wait/io/file/innodb/innodb_data_file	140281776925632	425	54165333552	562848	127447584	22694647008	386	18411103920	3560832	47697144	1216801872	6373376	27	764948448	5519184	28331424	256954368	442368	12	34989281184	562848	2915773344	22694647008
/var/lib/mysql/ibtmp1	wait/io/file/innodb/innodb_data_file	140281776926336	147	186204465216	6640656	1266696816	175740836304	0	0	0	0	0	0	143	10422734784	6640656	72886176	4495147008	14729216	4	175781730432	9946992	43945432608	175740836304
/var/lib/mysql/#innodb_temp/temp_1.ibt	wait/io/file/innodb/innodb_temp_file	140281776927040	8	49502292576	11873136	6187786440	26448012624	0	0	0	0	0	0	3	135040752	22160688	45013584	77176176	114688	5	49367251824	11873136	9873450312	26448012624
/var/lib/mysql/#innodb_temp/temp_2.ibt	wait/io/file/innodb/innodb_temp_file	140281776927744	8	38703500352	20027568	4837937544	22075266048	0	0	0	0	0	0	3	260769696	39904128	86923056	135981648	114688	5	38442730656	20027568	7688545920	22075266048
/var/lib/mysql/#innodb_temp/temp_3.ibt	wait/io/file/innodb/innodb_temp_file	140281776928448	8	37261216080	17938272	4657651944	21522502848	0	0	0	0	0	0	3	255995520	42765888	85331664	135248256	114688	5	37005220560	17938272	7401044112	21522502848
/var/lib/mysql/#innodb_temp/temp_4.ibt	wait/io/file/innodb/innodb_temp_file	140281776929152	8	33216745584	17238144	4152093000	17863425360	0	0	0	0	0	0	3	287036640	42078960	95678880	161537904	114688	5	32929708944	17238144	6585941736	17863425360
/var/lib/mysql/#innodb_temp/temp_5.ibt	wait/io/file/innodb/innodb_temp_file	140281776929856	8	36448384368	17172672	4556047848	21605306448	0	0	0	0	0	0	3	231888096	39468528	77296032	129537936	114688	5	36216496272	17172672	7243299096	21605306448
/var/lib/mysql/#innodb_temp/temp_6.ibt	wait/io/file/innodb/innodb_temp_file	140281776930560	8	29097571008	6820176	3637196376	15243752832	0	0	0	0	0	0	3	164567568	20201280	54855768	120854448	114688	5	28933003440	6820176	5786600688	15243752832
/var/lib/mysql/#innodb_temp/temp_7.ibt	wait/io/file/innodb/innodb_temp_file	140281776931264	8	31292426880	8792784	3911553360	16356047136	0	0	0	0	0	0	3	78460800	11913264	26153424	38461104	114688	5	31213966080	8792784	6242793216	16356047136
/var/lib/mysql/#innodb_temp/temp_8.ibt	wait/io/file/innodb/innodb_temp_file	140281776931968	8	34222692768	13556400	4277836464	17025571200	0	0	0	0	0	0	3	136286832	32164176	45428856	53257248	114688	5	34086405936	13556400	6817280976	17025571200
/var/lib/mysql/#innodb_temp/temp_9.ibt	wait/io/file/innodb/innodb_temp_file	140281776932672	8	49545664080	19608864	6193207944	30137064672	0	0	0	0	0	0	3	216158976	43255344	72052992	95797152	114688	5	49329505104	19608864	9865900968	30137064672
/var/lib/mysql/#innodb_temp/temp_10.ibt	wait/io/file/innodb/innodb_temp_file	140281776933376	125	177516252144	3656928	1420129920	23327987232	0	0	0	0	0	0	111	1388549184	3656928	12509376	138872448	2473984	14	176127702960	20623152	12580550136	23327987232
/var/lib/mysql/mysql.ibd	wait/io/file/innodb/innodb_data_file	140281776934080	384	134952314112	1515360	351438120	12286511424	354	95040533280	4132128	268475856	4907834976	5849088	15	399700224	5325936	26646576	230834736	245760	15	39512080608	1515360	2634138672	12286511424
/var/lib/mysql/sys/sys_config.ibd	wait/io/file/innodb/innodb_data_file	140281776934784	9	1051526256	2900304	116836104	571576896	4	982569984	11417472	245642496	571576896	114688	0	0	0	0	0	0	5	68956272	2900304	13791096	26687232
/var/lib/mysql/sakila/actor.ibd	wait/io/file/innodb/innodb_data_file	140281776935488	9	542648304	852720	60294168	290067360	4	497386032	7376688	124346376	290067360	114688	0	0	0	0	0	0	5	45262272	852720	9052296	19721856
/var/lib/mysql/sakila/address.ibd	wait/io/file/innodb/innodb_data_file	140281776936192	3	12223728	715440	4074576	6900960	1	6900960	6900960	6900960	6900960	65536	0	0	0	0	0	0	2	5322768	715440	2661384	4607328
/var/lib/mysql/sakila/category.ibd	wait/io/file/innodb/innodb_data_file	140281776936896	3	44754864	743424	14918112	39242016	1	39242016	39242016	39242016	39242016	65536	0	0	0	0	0	0	2	5512848	743424	2756424	4769424
/var/lib/mysql/sakila/city.ibd	wait/io/file/innodb/innodb_data_file	140281776937600	11	717338160	1232880	65212488	347772480	6	545836368	2016960	90972552	347772480	147456	0	0	0	0	0	0	5	171501792	1232880	34300200	146409648
/var/lib/mysql/sakila/country.ibd	wait/io/file/innodb/innodb_data_file	140281776938304	9	740890656	784080	82321008	367765728	4	703897920	8092656	175974480	367765728	114688	0	0	0	0	0	0	5	36992736	784080	7398336	14969328

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.