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	139772255593216	5	1200670416	4960032	240133872	492152496	3	966189840	226486128	322063104	492152496	303507	0	0	0	0	0	0	2	234480576	4960032	117240288	229520544
/usr/share/mysql-8.0/charsets/Index.xml	wait/io/file/mysys/charset	139772255593920	3	264595584	3399264	88198440	245512080	1	245512080	245512080	245512080	245512080	19495	0	0	0	0	0	0	2	19083504	3399264	9541752	15684240
/var/lib/mysql/ibdata1	wait/io/file/innodb/innodb_data_file	139772255596736	163	2485379718096	1842720	15247728144	917164068480	20	7088072640	1842720	354403632	3143606400	2441216	73	35588402784	7017648	487512168	20685591696	16121856	70	2442703242672	1887072	34895760504	917164068480
/var/lib/mysql/ib_logfile0	wait/io/file/innodb/innodb_log_file	139772255597440	53	419964748896	238128	7923863112	120248234304	6	454574208	238128	75762192	452574672	4608	22	1654130016	11039424	75187728	620288592	11264	25	417856044672	708048	16714241544	120248234304
/var/lib/mysql/ib_logfile1	wait/io/file/innodb/innodb_log_file	139772255598144	1305	6564451852992	477312	5030231184	63871403904	2	737585904	5424144	368792952	732161760	66048	855	419141152848	477312	490223448	29003361024	1402368	448	6144573114240	485760	13715564808	63871403904
/var/lib/mysql/undo_001	wait/io/file/innodb/innodb_data_file	139772255598848	809	369256080336	645744	456435144	26914261968	388	32155278144	4436784	82874352	2280311616	6406144	387	17296032864	5341776	44692560	4731202608	6340608	34	319804769328	645744	9406022472	26914261968
/var/lib/mysql/undo_002	wait/io/file/innodb/innodb_data_file	139772255599552	785	529471977408	492096	674486472	59252743440	384	30022156032	3362832	78182544	2001813792	6340608	367	16269562848	5040816	44331144	4772153232	6012928	34	483180258528	492096	14211183888	59252743440
/var/lib/mysql/ibtmp1	wait/io/file/innodb/innodb_data_file	139772255600256	147	247028610048	5077776	1680466656	238108103376	0	0	0	0	0	0	143	8860918176	5077776	61964232	962734608	14729216	4	238167691872	9973392	59541922968	238108103376
/var/lib/mysql/#innodb_temp/temp_1.ibt	wait/io/file/innodb/innodb_temp_file	139772255600960	8	40219224144	8930592	5027402952	24324905088	0	0	0	0	0	0	3	124957008	18403968	41652336	75733152	114688	5	40094267136	8930592	8018853216	24324905088
/var/lib/mysql/#innodb_temp/temp_2.ibt	wait/io/file/innodb/innodb_temp_file	139772255601664	8	32072151936	10184064	4009018992	20011222704	0	0	0	0	0	0	3	133204368	29210544	44401368	70292112	114688	5	31938947568	10184064	6387789408	20011222704
/var/lib/mysql/#innodb_temp/temp_3.ibt	wait/io/file/innodb/innodb_temp_file	139772255602368	8	29844713184	7896240	3730589016	17953575024	0	0	0	0	0	0	3	108246336	15286128	36081936	61365216	114688	5	29736466848	7896240	5947293264	17953575024
/var/lib/mysql/#innodb_temp/temp_4.ibt	wait/io/file/innodb/innodb_temp_file	139772255603072	8	32221877424	9889968	4027734480	18584054544	0	0	0	0	0	0	3	130148832	14267616	43382856	83246592	114688	5	32091728592	9889968	6418345560	18584054544
/var/lib/mysql/#innodb_temp/temp_5.ibt	wait/io/file/innodb/innodb_temp_file	139772255603776	8	27115446336	7821792	3389430792	15184094640	0	0	0	0	0	0	3	120123696	13917552	40041144	82903392	114688	5	26995322640	7821792	5399064528	15184094640
/var/lib/mysql/#innodb_temp/temp_6.ibt	wait/io/file/innodb/innodb_temp_file	139772255604480	8	28035099840	8392032	3504387480	14578893648	0	0	0	0	0	0	3	149912400	15595536	49970712	110991936	114688	5	27885187440	8392032	5577037488	14578893648
/var/lib/mysql/#innodb_temp/temp_7.ibt	wait/io/file/innodb/innodb_temp_file	139772255605184	8	28841059632	8993424	3605132256	14674748352	0	0	0	0	0	0	3	84299424	13373712	28099632	41875680	114688	5	28756760208	8993424	5751351936	14674748352
/var/lib/mysql/#innodb_temp/temp_8.ibt	wait/io/file/innodb/innodb_temp_file	139772255605888	10	65576837568	7841328	6557683704	37300926432	0	0	0	0	0	0	4	158787552	16648896	39696888	74074176	196608	6	65418050016	7841328	10903008336	37300926432
/var/lib/mysql/#innodb_temp/temp_9.ibt	wait/io/file/innodb/innodb_temp_file	139772255606592	98	370348936848	4549776	3779070768	282592760208	0	0	0	0	0	0	92	308890376784	4549776	3357503952	282592760208	1638400	6	61458560064	10024608	10243093344	27450060528
/var/lib/mysql/#innodb_temp/temp_10.ibt	wait/io/file/innodb/innodb_temp_file	139772255607296	43	244678907088	4601520	5690206896	122013239040	0	0	0	0	0	0	37	171408767904	4601520	4632669360	122013239040	737280	6	73270139184	10235808	12211689864	29778527856
/var/lib/mysql/mysql.ibd	wait/io/file/innodb/innodb_data_file	139772255608000	520	622996150656	277728	1198069488	128574697152	344	213405614928	2007984	620365152	128574697152	5685248	138	16490267376	3863376	119494584	3847212864	2260992	38	393100268352	277728	10344743904	55351894752
/var/lib/mysql/sys/sys_config.ibd	wait/io/file/innodb/innodb_data_file	139772255608704	3	284776272	3168528	94925424	267609936	1	267609936	267609936	267609936	267609936	65536	0	0	0	0	0	0	2	17166336	3168528	8583168	13997808
/var/lib/mysql/sakila/actor.ibd	wait/io/file/innodb/innodb_data_file	139772255609408	10	5143967136	1997424	514396608	2439160944	5	5041335552	23830752	1008266952	2439160944	131072	0	0	0	0	0	0	5	102631584	1997424	20526264	45354144
/var/lib/mysql/sakila/address.ibd	wait/io/file/innodb/innodb_data_file	139772255610112	10	2801525232	2546544	280152312	1855297488	5	2757359616	35922480	551471712	1855297488	131072	0	0	0	0	0	0	5	44165616	2546544	8832912	19910880
/var/lib/mysql/sakila/category.ibd	wait/io/file/innodb/innodb_data_file	139772255610816	9	4236906960	2224992	470767440	2057964480	4	4181674464	40941648	1045418616	2057964480	114688	0	0	0	0	0	0	5	55232496	2224992	11046288	22495440
/var/lib/mysql/sakila/city.ibd	wait/io/file/innodb/innodb_data_file	139772255611520	3	1098180864	3058704	366060288	1087460352	1	1087460352	1087460352	1087460352	1087460352	65536	0	0	0	0	0	0	2	10720512	3058704	5360256	7661808
/var/lib/mysql/sakila/country.ibd	wait/io/file/innodb/innodb_data_file	139772255612224	9	908144688	1541760	100904760	311009424	4	858768240	9920592	214691928	311009424	114688	0	0	0	0	0	0	5	49376448	1541760	9875184	18722352

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.