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 (104 total, Query took 0.0012 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	140274181980928	5	1238071296	2888160	247614048	347550192	3	949217280	267934128	316405584	347550192	303507	0	0	0	0	0	0	2	288854016	2888160	144427008	285965856
/usr/share/mysql-8.0/charsets/Index.xml	wait/io/file/mysys/charset	140274181981632	3	239282736	2487408	79760736	223778544	1	223778544	223778544	223778544	223778544	19495	0	0	0	0	0	0	2	15504192	2487408	7752096	13016784
/var/lib/mysql/ibdata1	wait/io/file/innodb/innodb_data_file	140274181984448	143	1015789506336	1549152	7103422920	55822399248	20	7669554816	1549152	383477688	3256464288	2441216	61	8481858000	5552976	139046688	1448592816	10403840	62	999638093520	2251392	16123194912	55822399248
/var/lib/mysql/ib_logfile0	wait/io/file/innodb/innodb_log_file	140274181985152	67	409794711744	224400	6116338800	23286653808	6	564097248	224400	94016208	562254528	4608	29	2017599408	8370912	69572184	1036921248	14848	32	407213015088	962016	12725406672	23286653808
/var/lib/mysql/ib_logfile1	wait/io/file/innodb/innodb_log_file	140274181985856	541	3228419211600	721776	5967502992	123603409776	2	792372240	2155296	396186120	790216944	66048	328	124721319888	721776	380247912	68036343408	274432	211	3102905519472	750288	14705713176	123603409776
/var/lib/mysql/undo_001	wait/io/file/innodb/innodb_data_file	140274181986560	690	319668787152	410784	463288056	28771730592	388	34067856240	4078800	87803496	4174087104	6406144	274	5430933552	3674880	19820856	148779840	4489216	28	280169997360	410784	10006071240	28771730592
/var/lib/mysql/undo_002	wait/io/file/innodb/innodb_data_file	140274181987264	668	294315818544	291984	440592504	33054011760	384	26117413872	2153712	68014056	1558254192	6340608	259	7466214096	3596736	28826952	597643200	4243456	25	260732190576	291984	10429287528	33054011760
/var/lib/mysql/ibtmp1	wait/io/file/innodb/innodb_data_file	140274181987968	147	259483694976	7746816	1765195080	244455231504	0	0	0	0	0	0	143	14975116464	7746816	104720880	2272485072	14729216	4	244508578512	9466512	61127144496	244455231504
/var/lib/mysql/#innodb_temp/temp_1.ibt	wait/io/file/innodb/innodb_temp_file	140274181988672	8	36957034224	9690384	4619629080	20095582320	0	0	0	0	0	0	3	85214976	14043744	28404816	36085104	114688	5	36871819248	9690384	7374363744	20095582320
/var/lib/mysql/#innodb_temp/temp_2.ibt	wait/io/file/innodb/innodb_temp_file	140274181989376	8	44389668048	11114928	5548708440	30865811856	0	0	0	0	0	0	3	83035392	14156208	27678288	40815984	114688	5	44306632656	11114928	8861326320	30865811856
/var/lib/mysql/#innodb_temp/temp_3.ibt	wait/io/file/innodb/innodb_temp_file	140274181990080	8	38433250944	9190368	4804156368	21532823664	0	0	0	0	0	0	3	124077888	18881808	41359296	76916400	114688	5	38309173056	9190368	7661834400	21532823664
/var/lib/mysql/#innodb_temp/temp_4.ibt	wait/io/file/innodb/innodb_temp_file	140274181990784	8	27047039184	9422688	3380879832	14978244336	0	0	0	0	0	0	3	111450240	20481648	37150080	62282880	114688	5	26935588944	9422688	5387117736	14978244336
/var/lib/mysql/#innodb_temp/temp_5.ibt	wait/io/file/innodb/innodb_temp_file	140274181991488	8	26764067616	8239968	3345508320	14666801952	0	0	0	0	0	0	3	90962256	14081760	30320664	52320576	114688	5	26673105360	8239968	5334621072	14666801952
/var/lib/mysql/#innodb_temp/temp_6.ibt	wait/io/file/innodb/innodb_temp_file	140274181992192	8	26864747184	8873040	3358093200	14690540304	0	0	0	0	0	0	3	99993696	19009584	33331056	41087376	114688	5	26764753488	8873040	5352950592	14690540304
/var/lib/mysql/#innodb_temp/temp_7.ibt	wait/io/file/innodb/innodb_temp_file	140274181992896	8	31904039376	8689824	3988004856	19691456928	0	0	0	0	0	0	3	347852736	17560752	115950912	258647664	114688	5	31556186640	8689824	6311237328	19691456928
/var/lib/mysql/#innodb_temp/temp_8.ibt	wait/io/file/innodb/innodb_temp_file	140274181993600	109	172047444096	5850240	1578416664	30054451152	0	0	0	0	0	0	98	3373827600	5850240	34426656	175350384	2064384	11	168673616496	9751632	15333965064	30054451152
/var/lib/mysql/#innodb_temp/temp_9.ibt	wait/io/file/innodb/innodb_temp_file	140274181994304	11	44014986576	8557824	4001362200	17273758128	0	0	0	0	0	0	5	224496096	14267088	44899008	73680816	212992	6	43790490480	8557824	7298414904	17273758128
/var/lib/mysql/#innodb_temp/temp_10.ibt	wait/io/file/innodb/innodb_temp_file	140274181995008	16	90263858256	6730944	5641490976	24946937136	0	0	0	0	0	0	8	372262176	6730944	46532640	108189312	393216	8	89891596080	8792784	11236449312	24946937136
/var/lib/mysql/mysql.ibd	wait/io/file/innodb/innodb_data_file	140274181995712	430	220238985120	312576	512183496	13688436960	352	100664513664	1987392	285978528	8954456544	5816320	46	1510771680	4619472	32842656	634691904	753664	32	118063699776	312576	3689490552	13688436960
/var/lib/mysql/sys/sys_config.ibd	wait/io/file/innodb/innodb_data_file	140274181996416	9	3387226128	2226576	376358400	1992027840	4	2836240176	76753248	709059912	1992027840	114688	0	0	0	0	0	0	5	550985952	2226576	110197032	501819120
/var/lib/mysql/sakila/actor.ibd	wait/io/file/innodb/innodb_data_file	140274181997120	10	1477175040	1177968	147717504	429948816	5	1015611696	21691824	203122128	355592160	131072	0	0	0	0	0	0	5	461563344	1177968	92312616	429948816
/var/lib/mysql/sakila/address.ibd	wait/io/file/innodb/innodb_data_file	140274181997824	13	1918147968	828432	147549600	477043248	8	1867706544	28753296	233463120	477043248	180224	0	0	0	0	0	0	5	50441424	828432	10088232	26763792
/var/lib/mysql/sakila/category.ibd	wait/io/file/innodb/innodb_data_file	140274181998528	9	773467200	1709664	85940712	277566960	4	738149280	21451584	184537320	277566960	114688	0	0	0	0	0	0	5	35317920	1709664	7063584	18052320
/var/lib/mysql/sakila/city.ibd	wait/io/file/innodb/innodb_data_file	140274181999232	11	1449280272	1769328	131752632	344776080	6	1414013040	47869536	235668840	344776080	147456	0	0	0	0	0	0	5	35267232	1769328	7053288	15794592
/var/lib/mysql/sakila/country.ibd	wait/io/file/innodb/innodb_data_file	140274181999936	9	982908960	1623072	109212048	313715424	4	933718896	33848496	233429592	313715424	114688	0	0	0	0	0	0	5	49190064	1623072	9837960	23775840

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.