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 (88 total, Query took 0.0004 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	140464740754176	5	1232995632	3235584	246598968	369688176	3	965560464	244980912	321853488	369688176	303507	0	0	0	0	0	0	2	267435168	3235584	133717584	264199584
/usr/share/mysql-8.0/charsets/Index.xml	wait/io/file/mysys/charset	140464740754880	3	304270560	2156880	101423520	262034784	1	262034784	262034784	262034784	262034784	19495	0	0	0	0	0	0	2	42235776	2156880	21117888	40078896
/var/lib/mysql/ibdata1	wait/io/file/innodb/innodb_data_file	140464740757696	111	734729898144	1429824	6619188048	37188531600	20	12274171536	1429824	613708392	5361241248	2441216	43	2738031120	5450544	63674952	601154400	6225920	48	719717695488	1867536	14994118656	37188531600
/var/lib/mysql/ib_logfile0	wait/io/file/innodb/innodb_log_file	140464740758400	49	255161373984	238128	5207374920	29816092944	6	544128816	238128	90687960	542310912	4608	20	1384066992	9419520	69203112	636892608	10240	23	253233178176	369600	11010137952	29816092944
/var/lib/mysql/ib_logfile1	wait/io/file/innodb/innodb_log_file	140464740759104	337	1754260498320	307296	5205520584	41371796928	2	811211808	2426688	405605904	808785120	66048	199	44429645568	484176	223264536	9668767152	252416	136	1709019640944	307296	12566320800	41371796928
/var/lib/mysql/undo_001	wait/io/file/innodb/innodb_data_file	140464740759808	561	258717819888	402336	461172360	42988670736	388	36356221440	3867072	93701520	4488255552	6406144	148	2694199728	4266768	18203856	228906480	2424832	25	219667398720	402336	8786695896	42988670736
/var/lib/mysql/undo_002	wait/io/file/innodb/innodb_data_file	140464740760512	555	228031185888	269808	410866896	21122401344	384	30103661808	2159520	78394800	2437422768	6340608	145	5844223440	4753584	40304880	3905727936	2375680	26	192083300640	269808	7387819032	21122401344
/var/lib/mysql/ibtmp1	wait/io/file/innodb/innodb_data_file	140464740761216	147	210212583504	4731408	1430017512	198498515952	0	0	0	0	0	0	143	11624158656	4731408	81287712	1803055056	14729216	4	198588424848	19435152	49647106080	198498515952
/var/lib/mysql/#innodb_temp/temp_1.ibt	wait/io/file/innodb/innodb_temp_file	140464740761920	8	42757886688	7874064	5344735704	27617799264	0	0	0	0	0	0	3	94640304	15201648	31546680	45525216	114688	5	42663246384	7874064	8532649224	27617799264
/var/lib/mysql/#innodb_temp/temp_2.ibt	wait/io/file/innodb/innodb_temp_file	140464740762624	8	26891173056	4621584	3361396632	15209469792	0	0	0	0	0	0	3	77761200	11598576	25920312	43441728	114688	5	26813411856	4621584	5362682160	15209469792
/var/lib/mysql/#innodb_temp/temp_3.ibt	wait/io/file/innodb/innodb_temp_file	140464740763328	8	27240097632	6358176	3405012072	14856384048	0	0	0	0	0	0	3	68635776	11637120	22878504	39346032	114688	5	27171461856	6358176	5434292160	14856384048
/var/lib/mysql/#innodb_temp/temp_4.ibt	wait/io/file/innodb/innodb_temp_file	140464740764032	8	29705067216	4951584	3713133336	17870148912	0	0	0	0	0	0	3	66100320	11195184	22033440	40908912	114688	5	29638966896	4951584	5927793168	17870148912
/var/lib/mysql/#innodb_temp/temp_5.ibt	wait/io/file/innodb/innodb_temp_file	140464740764736	8	27154740096	6459552	3394342512	14313115872	0	0	0	0	0	0	3	70895616	14034240	23631696	39678144	114688	5	27083844480	6459552	5416768896	14313115872
/var/lib/mysql/#innodb_temp/temp_6.ibt	wait/io/file/innodb/innodb_temp_file	140464740765440	8	30018061920	5776320	3752257608	18110257968	0	0	0	0	0	0	3	67977360	10885248	22659120	40963824	114688	5	29950084560	5776320	5990016912	18110257968
/var/lib/mysql/#innodb_temp/temp_7.ibt	wait/io/file/innodb/innodb_temp_file	140464740766144	8	27202367808	11707344	3400295976	14738730336	0	0	0	0	0	0	3	70426224	11707344	23475408	40522944	114688	5	27131941584	15868512	5426388264	14738730336
/var/lib/mysql/#innodb_temp/temp_8.ibt	wait/io/file/innodb/innodb_temp_file	140464740766848	8	25996976016	8789616	3249621936	14238940848	0	0	0	0	0	0	3	92138640	21328560	30712704	42884688	114688	5	25904837376	8789616	5180967264	14238940848
/var/lib/mysql/#innodb_temp/temp_9.ibt	wait/io/file/innodb/innodb_temp_file	140464740767552	8	51551901984	9003984	6443987616	36554696640	0	0	0	0	0	0	3	86955792	16804656	28985088	47442384	114688	5	51464946192	9003984	10292989080	36554696640
/var/lib/mysql/#innodb_temp/temp_10.ibt	wait/io/file/innodb/innodb_temp_file	140464740768256	38	190176594432	5901456	5004647208	25364975856	0	0	0	0	0	0	24	908026944	5901456	37834368	124567872	1048576	14	189268567488	8857728	13519183392	25364975856
/var/lib/mysql/mysql.ibd	wait/io/file/innodb/innodb_data_file	140464740768960	487	198712660608	545424	408034176	17443505904	411	74629534848	2458896	181580256	1996693248	6782976	49	970751232	4759920	19811088	271764768	802816	27	123112374528	545424	4559717448	17443505904
/var/lib/mysql/sys/sys_config.ibd	wait/io/file/innodb/innodb_data_file	140464740769664	9	862241952	2486352	95804544	241067376	4	598992768	28341456	149748192	228378480	114688	0	0	0	0	0	0	5	263249184	2486352	52649784	241067376
/var/lib/mysql/sakila/actor.ibd	wait/io/file/innodb/innodb_data_file	140464740770368	3	220603152	874896	73534296	214906032	1	214906032	214906032	214906032	214906032	65536	0	0	0	0	0	0	2	5697120	874896	2848560	4822224
/var/lib/mysql/sakila/address.ibd	wait/io/file/innodb/innodb_data_file	140464740771072	9	828673824	838464	92074752	302311680	4	810158448	27672480	202539480	302311680	114688	0	0	0	0	0	0	5	18515376	838464	3702864	6718800
/var/lib/mysql/sakila/category.ibd	wait/io/file/innodb/innodb_data_file	140464740771776	3	291726864	843216	97242288	286271568	1	286271568	286271568	286271568	286271568	65536	0	0	0	0	0	0	2	5455296	843216	2727648	4612080
/var/lib/mysql/sakila/city.ibd	wait/io/file/innodb/innodb_data_file	140464740772480	9	799578912	811008	88842072	284603616	4	779833296	22567776	194958192	284603616	114688	0	0	0	0	0	0	5	19745616	811008	3948912	7598448
/var/lib/mysql/sakila/country.ibd	wait/io/file/innodb/innodb_data_file	140464740773184	9	860509584	856944	95612088	283804224	4	822335184	18464160	205583664	283804224	114688	0	0	0	0	0	0	5	38174400	856944	7634880	18939888

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!