www.bloggerafif.com / localhost / performance_schema / file_summary_by_instance

There are no favorite tables.

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 (60 total, Query took 0.0015 seconds.)

SELECT * FROM `file_summary_by_instance`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

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
C:\Program Files\Ampps\mysql\share\english\errmsg....	wait/io/file/sql/ERRMSG	2844377780352	5	2120817780	40603988	424163556	1668512568	3	411701224	51045164	137233595	300971376	388982	0	0	0	0	0	0	2	1709116556	40603988	854558278	1668512568
C:\Program Files\Ampps\mysql\share\charsets\Index....	wait/io/file/mysys/charset	2844377781056	3	186436276	29923996	62145279	84607592	1	71904688	71904688	71904688	71904688	19525	0	0	0	0	0	0	2	114531588	29923996	57265794	84607592
C:\Program Files\Ampps\mysql\data\auto.cnf	wait/io/file/mysys/cnf	2844377783872	5	178743240	349444	35748648	107934296	3	45582248	349444	15193790	40024508	56	0	0	0	0	0	0	2	133160992	25226696	66580496	107934296
C:\Program Files\Ampps\mysql\data\mysql.ibd	wait/io/file/innodb/innodb_data_file	2844377784576	1358	12113391620800	33867972	8920023001	2252919776690	395	323785176106	33867972	819709141	150950643436	6520832	497	5288028306474	49868644	10639895935	2252919776690	8142848	466	6501578138220	34628320	13951884023	2009105099678
C:\Program Files\Ampps\mysql\data\sys\sys_config.i...	wait/io/file/innodb/innodb_data_file	2844377785280	12	7495735352	25166992	624644320	2407993142	5	3266663094	306453608	653332531	1322108204	131072	0	0	0	0	0	0	7	4229072258	25166992	604153117	2407993142
C:\Program Files\Ampps\mysql\data\undo_001	wait/io/file/innodb/innodb_data_file	2844377785984	4401	15919195992989	33237568	3617176937	2278654811862	284	235910357336	200905716	830670093	11311640126	4702208	2912	3603811075833	33237568	1237572169	2278654811862	47710208	1205	12079474559820	36756592	10024460079	1814982333168
C:\Program Files\Ampps\mysql\data\undo_002	wait/io/file/innodb/innodb_data_file	2844377786688	4434	11045639583507	27944984	2491122621	1933278267148	278	224809904745	195928334	808668291	4856612222	4603904	2900	5001823668737	31392012	1724766467	1933278267148	47513600	1256	5819006010025	27944984	4632966306	1310098310668
C:\Program Files\Ampps\mysql\data\ibdata1	wait/io/file/innodb/innodb_data_file	2844377787392	1503	10406512278601	27052936	6923826785	1919984132435	534	159618857354	174045940	298911588	2834373648	8798208	482	2967214183609	52780970	6156045637	1121739129941	7897088	487	7279679237638	27052936	14948006631	1919984132435
C:\Program Files\Ampps\mysql\data\#ib_16384_0.dblw...	wait/io/file/innodb/innodb_dblwr_file	2844377788096	1984	26447965536996	126916656	13330627466	2426477281778	1	653790408	653790408	653790408	653790408	196608	1980	26446605478120	188532940	13356871325	2426477281778	111263744	3	706268468	126916656	235422530	436178108
C:\Program Files\Ampps\mysql\data\#ib_16384_1.dblw...	wait/io/file/innodb/innodb_dblwr_file	2844377788800	4	8015031086	113765972	2003757552	5742829424	1	5742829424	5742829424	5742829424	5742829424	8585216	0	0	0	0	0	0	3	2272201662	113765972	757400554	1698203016
C:\Program Files\Ampps\mysql\data\#innodb_redo\#ib...	wait/io/file/innodb/innodb_log_file	2844377789504	4051	38221897550784	4332052	9435175892	6732622053246	6	3756969902	4332052	626161504	3599979990	68096	1699	159567905697	6300528	93918343	1344158296	1353216	2346	38058572675185	20095664	16222750247	6732622053246
C:\Program Files\Ampps\mysql\data\#innodb_redo\#ib...	wait/io/file/innodb/innodb_log_file	2844377790208	6070	66100074219972	5503743	10889632938	5029429457192	0	0	0	0	0	0	2538	1032817152179	5503743	406941147	771222177504	4873216	3532	65067257067793	36778981	18422213121	5029429457192
C:\Program Files\Ampps\mysql\data\#innodb_redo\#ib...	wait/io/file/innodb/innodb_log_file	2844377790912	7	6502410930	118760036	928915659	2041297320	0	0	0	0	0	0	4	4090531760	454730248	1022632940	2041297320	3276800	3	2411879170	118760036	803959577	1417222822
C:\Program Files\Ampps\mysql\data\#innodb_redo\#ib...	wait/io/file/innodb/innodb_log_file	2844377791616	7	7084495078	171497984	1012070600	2394281416	0	0	0	0	0	0	4	4912206304	615934560	1228051576	2394281416	3276800	3	2172288774	171497984	724096258	1449659654
C:\Program Files\Ampps\mysql\data\#innodb_redo\#ib...	wait/io/file/innodb/innodb_log_file	2844377792320	7	6666591662	159652008	952370112	2081073354	0	0	0	0	0	0	4	4246512850	467833520	1061627993	2081073354	3276800	3	2420078812	159652008	806692791	1475802982
C:\Program Files\Ampps\mysql\data\#innodb_redo\#ib...	wait/io/file/innodb/innodb_log_file	2844377793024	7	6375193998	106374968	910741937	2056973132	0	0	0	0	0	0	4	4405103356	489005612	1101275839	2056973132	3276800	3	1970090642	106374968	656696588	1287311308
C:\Program Files\Ampps\mysql\data\#innodb_redo\#ib...	wait/io/file/innodb/innodb_log_file	2844377793728	7	7800408376	127885090	1114343991	2408177522	0	0	0	0	0	0	4	5549519286	899288866	1387379602	2408177522	3276800	3	2250889090	127885090	750296217	1304352410
C:\Program Files\Ampps\mysql\data\#innodb_redo\#ib...	wait/io/file/innodb/innodb_log_file	2844377794432	7	7685086149	102801508	1097869199	3295263066	0	0	0	0	0	0	4	5317783478	409195412	1329445650	3295263066	3276800	3	2367302671	102801508	789100744	1180153164
C:\Program Files\Ampps\mysql\data\#innodb_redo\#ib...	wait/io/file/innodb/innodb_log_file	2844377795136	7	6256157392	119718812	893736394	1997632624	0	0	0	0	0	0	4	4201825284	441300360	1050456321	1997632624	3276800	3	2054332108	119718812	684777223	1234724376
C:\Program Files\Ampps\mysql\data\#innodb_redo\#ib...	wait/io/file/innodb/innodb_log_file	2844377795840	7	6352780414	85568124	907539871	2353573824	0	0	0	0	0	0	4	4542340902	395886688	1135585006	2353573824	3276800	3	1810439512	85568124	603479691	1228694272
C:\Program Files\Ampps\mysql\data\#innodb_redo\#ib...	wait/io/file/innodb/innodb_log_file	2844377796544	7	7094793140	129853566	1013541689	2106063868	0	0	0	0	0	0	4	4696902266	569731566	1174225347	2106063868	3276800	3	2397890874	129853566	799296958	1416776798
C:\Program Files\Ampps\mysql\data\#innodb_redo\#ib...	wait/io/file/innodb/innodb_log_file	2844377797248	7	6827751196	133623698	975393028	1961916462	0	0	0	0	0	0	4	4341558984	555199788	1085389746	1961916462	3276800	3	2486192212	133623698	828730591	1433945210
C:\Program Files\Ampps\mysql\data\#innodb_redo\#ib...	wait/io/file/innodb/innodb_log_file	2844377797952	7	6914760996	157438570	987822874	2315832994	0	0	0	0	0	0	4	4471913888	393721540	1117978472	2315832994	3276800	3	2442847108	157438570	814282223	1190814718
C:\Program Files\Ampps\mysql\data\#innodb_redo\#ib...	wait/io/file/innodb/innodb_log_file	2844377798656	7	11692860702	156832750	1670408609	4829001756	0	0	0	0	0	0	4	8818872572	771681224	2204718143	4829001756	3276800	3	2873988130	156832750	957995897	1804316340
C:\Program Files\Ampps\mysql\data\#innodb_redo\#ib...	wait/io/file/innodb/innodb_log_file	2844377799360	7	9081686068	117702046	1297383724	3156301128	0	0	0	0	0	0	4	6339911568	499848034	1584977892	3156301128	3276800	3	2741774500	117702046	913924687	1345267210

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view