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 (92 total, Query took 0.0037 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	140330947633920	5	2269216752	2835360	453843192	1334774496	3	2030595072	297228624	676864848	1334774496	303507	0	0	0	0	0	0	2	238621680	2835360	119310840	235786320
/usr/share/mysql-8.0/charsets/Index.xml	wait/io/file/mysys/charset	140330947634624	3	295128768	1919280	98376168	281382288	1	281382288	281382288	281382288	281382288	19495	0	0	0	0	0	0	2	13746480	1919280	6873240	11827200
/var/lib/mysql/ibdata1	wait/io/file/innodb/innodb_data_file	140330947637440	104	805624624992	1476816	7746390432	44389216608	20	11072865936	1476816	553643112	6019649328	2441216	41	4164149616	5801136	101564496	724570704	4603904	43	790387609440	1729728	18381107184	44389216608
/var/lib/mysql/ib_logfile0	wait/io/file/innodb/innodb_log_file	140330947638144	45	278829175680	223872	6196203816	27199773216	6	665367648	223872	110894520	663597792	4608	18	773600784	8662896	42977616	191831376	9216	21	277390207248	2444112	13209057312	27199773216
/var/lib/mysql/ib_logfile1	wait/io/file/innodb/innodb_log_file	140330947638848	351	2230126661136	571824	6353637048	125345993520	2	849939552	2517504	424969776	847422048	66048	222	135330839952	571824	609598176	63367694016	303104	127	2093945881632	2115696	16487762808	125345993520
/var/lib/mysql/undo_001	wait/io/file/innodb/innodb_data_file	140330947639552	467	268113474288	1276176	574118688	31786640688	387	69336746688	6485952	179164656	1902923616	6389760	59	2422073808	5371872	41052000	279077568	966656	21	196354653792	1276176	9350221584	31786640688
/var/lib/mysql/undo_002	wait/io/file/innodb/innodb_data_file	140330947640256	465	231383486928	688512	497598816	23019405552	382	34431386880	4860768	90134352	1592806512	6307840	62	3416338992	4850736	55102080	695285184	1015808	21	193535761056	688512	9215988408	23019405552
/var/lib/mysql/ibtmp1	wait/io/file/innodb/innodb_data_file	140330947640960	147	234694815696	24610608	1596563232	212448793920	0	0	0	0	0	0	143	22151536704	24610608	154905696	4085500848	14729216	4	212543278992	25412112	53135819616	212448793920
/var/lib/mysql/#innodb_temp/temp_1.ibt	wait/io/file/innodb/innodb_temp_file	140330947641664	8	66675370608	21866592	8334421128	43840240752	0	0	0	0	0	0	3	289906848	42257424	96635616	155139072	114688	5	66385463760	21866592	13277092752	43840240752
/var/lib/mysql/#innodb_temp/temp_2.ibt	wait/io/file/innodb/innodb_temp_file	140330947642368	8	34569011136	21601008	4321126392	18387786912	0	0	0	0	0	0	3	244963488	42640752	81654408	122711952	114688	5	34324047648	21601008	6864809424	18387786912
/var/lib/mysql/#innodb_temp/temp_3.ibt	wait/io/file/innodb/innodb_temp_file	140330947643072	8	40227063888	20291568	5028382920	21446617632	0	0	0	0	0	0	3	249233424	40449552	83077632	127199424	114688	5	39977830464	20291568	7995566040	21446617632
/var/lib/mysql/#innodb_temp/temp_4.ibt	wait/io/file/innodb/innodb_temp_file	140330947643776	8	37761589536	19491120	4720198560	19364146560	0	0	0	0	0	0	3	255180288	39999696	85060008	134253504	114688	5	37506409248	19491120	7501281744	19364146560
/var/lib/mysql/#innodb_temp/temp_5.ibt	wait/io/file/innodb/innodb_temp_file	140330947644480	8	39325408848	21528672	4915676040	20653300272	0	0	0	0	0	0	3	252193920	44441232	84064464	121261536	114688	5	39073214928	21528672	7814642880	20653300272
/var/lib/mysql/#innodb_temp/temp_6.ibt	wait/io/file/innodb/innodb_temp_file	140330947645184	8	34386328944	39029760	4298290920	18354332832	0	0	0	0	0	0	3	284440464	52541808	94813488	149583456	114688	5	34101888480	39029760	6820377696	18354332832
/var/lib/mysql/#innodb_temp/temp_7.ibt	wait/io/file/innodb/innodb_temp_file	140330947645888	8	33764477472	19862832	4220559552	18124336560	0	0	0	0	0	0	3	276271248	72884592	92090328	126221568	114688	5	33488206224	19862832	6697641192	18124336560
/var/lib/mysql/#innodb_temp/temp_8.ibt	wait/io/file/innodb/innodb_temp_file	140330947646592	8	36887023536	21661728	4610877744	21029587920	0	0	0	0	0	0	3	239552016	41703024	79850496	112070640	114688	5	36647471520	21661728	7329494304	21029587920
/var/lib/mysql/#innodb_temp/temp_9.ibt	wait/io/file/innodb/innodb_temp_file	140330947647296	8	36603416784	20315856	4575427032	18134888112	0	0	0	0	0	0	3	307483440	39440016	102494304	185137392	114688	5	36295933344	20315856	7259186616	18134888112
/var/lib/mysql/#innodb_temp/temp_10.ibt	wait/io/file/innodb/innodb_temp_file	140330947648000	23	127888656720	20240880	5560376184	25327667376	0	0	0	0	0	0	13	834698832	26244768	64207440	121384032	606208	10	127053957888	20240880	12705395736	25327667376
/var/lib/mysql/mysql.ibd	wait/io/file/innodb/innodb_data_file	140330947648704	448	369076077744	1447776	823830480	27403341504	308	115030068912	3967920	373474200	11505470592	5095424	112	3960945120	4039728	35365440	226112832	1835008	28	250085063712	1447776	8931609192	27403341504
/var/lib/mysql/sys/sys_config.ibd	wait/io/file/innodb/innodb_data_file	140330947649408	3	388153392	2200176	129384288	362999472	1	362999472	362999472	362999472	362999472	65536	0	0	0	0	0	0	2	25153920	2200176	12576960	22953744
/var/lib/mysql/sakila/actor.ibd	wait/io/file/innodb/innodb_data_file	140330947650112	3	284996448	901296	94998816	279668400	1	279668400	279668400	279668400	279668400	65536	0	0	0	0	0	0	2	5328048	901296	2664024	4426752
/var/lib/mysql/sakila/address.ibd	wait/io/file/innodb/innodb_data_file	140330947650816	3	254317008	866448	84772248	249482112	1	249482112	249482112	249482112	249482112	65536	0	0	0	0	0	0	2	4834896	866448	2417448	3968448
/var/lib/mysql/sakila/category.ibd	wait/io/file/innodb/innodb_data_file	140330947651520	3	268245648	620928	89415216	263408640	1	263408640	263408640	263408640	263408640	65536	0	0	0	0	0	0	2	4837008	620928	2418504	4216080
/var/lib/mysql/sakila/city.ibd	wait/io/file/innodb/innodb_data_file	140330947652224	3	184589328	600864	61529688	180444528	1	180444528	180444528	180444528	180444528	65536	0	0	0	0	0	0	2	4144800	600864	2072400	3543936
/var/lib/mysql/sakila/country.ibd	wait/io/file/innodb/innodb_data_file	140330947652928	3	225510912	635184	75170304	221565696	1	221565696	221565696	221565696	221565696	65536	0	0	0	0	0	0	2	3945216	635184	1972608	3310032

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!