www.cabello.ws / localhost / performance_schema / file_summary_by_instance

There are no favorite tables.

New
aaa
- aaa
- aaa_fabricas_pruebas
abanq
- abanq_23
- abanq_23 experimental
articulos
autocompleta
azulejoscabello.com
- azulejoscabello.com
- azulejoscabello.com_tienda
azulejoscabello_com
book_sc
cabecab4
cabello-enterprises
- cabello-enterprises
- cabello-enterprises_exp
contabilidad
datatablesv03
durstone
eneboo
grespania
information_schema
intermediaria_online
jplist
keraben
letodms
letodms experimental
magazine
mydms
mydms experimental
mysql
pamesa_filter
performance_schema
php_producto
- php_producto
- php_producto_prueba
sys
tutorial
wordpress
- wordpress
- wordpress_desarrollo

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 (3066 total, Query took 0.0026 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
R:\Ampps\mysql\share\english\errmsg.sys	wait/io/file/sql/ERRMSG	1401317712000	5	10753386018	42104108	2150676972	10327584400	3	368242842	42104108	122747614	267994010	389269	0	0	0	0	0	0	2	10385143176	57558776	5192571588	10327584400
R:\Ampps\mysql\share\charsets\Index.xml	wait/io/file/mysys/charset	1401317712704	3	11971902712	63111772	3990633980	11821649124	1	87141816	87141816	87141816	87141816	19525	0	0	0	0	0	0	2	11884760896	63111772	5942380448	11821649124
R:\Ampps\mysql\data\auto.cnf	wait/io/file/mysys/cnf	1401317715520	5	9212384466	431548	1842476816	9059101936	3	98514534	431548	32838178	86829156	56	0	0	0	0	0	0	2	9113869932	54767996	4556934966	9059101936
R:\Ampps\mysql\data\mysql.ibd	wait/io/file/innodb/innodb_data_file	1401317716224	82762	20436402984638	13459820	246929604	86788580452	2726	432624757808	19632732	158703128	735843380	44711936	42231	2007137599626	20429822	47527408	2550949322	691912704	37805	17996640627204	13459820	476038360	86788580452
R:\Ampps\mysql\data\tutorial\employee.ibd	wait/io/file/innodb/innodb_data_file	1401317807040	15	21116983060	10479900	1407798742	9872819272	6	1219651920	78332524	203275320	546743138	98304	0	0	0	0	0	0	9	19897331140	10479900	2210814228	9872819272
R:\Ampps\mysql\data\sys\sys_config.ibd	wait/io/file/innodb/innodb_data_file	1401317807744	16	22658446654	10350204	1416152554	11784948630	6	954467218	50319346	159077548	326919226	98304	0	0	0	0	0	0	10	21703979436	10350204	2170397712	11784948630
R:\Ampps\mysql\data\pamesa_filter\product.ibd	wait/io/file/innodb/innodb_data_file	1401317808448	103	31085062114	10460986	301796416	11276898904	95	9970753648	57204042	104954944	340689004	1556480	0	0	0	0	0	0	8	21114308466	10460986	2639288510	11276898904
R:\Ampps\mysql\data\jplist\item.ibd	wait/io/file/innodb/innodb_data_file	1401317809152	13	21410493600	10517728	1646960868	10846960910	6	713874576	55346610	118979096	163990170	98304	0	0	0	0	0	0	7	20696619024	10517728	2956659640	10846960910
R:\Ampps\mysql\data\eneboo\accionesformativas.ibd	wait/io/file/innodb/innodb_data_file	1401317809856	16	22063979248	10178434	1378998510	10828269246	6	874749726	60996878	145791428	186377784	98304	0	0	0	0	0	0	10	21189229522	10178434	2118922682	10828269246
R:\Ampps\mysql\data\eneboo\actividadeslaborales.ib...	wait/io/file/innodb/innodb_data_file	1401317810560	16	24645388988	10377610	1540336474	12791206626	6	771410964	44543242	128568494	183399794	98304	0	0	0	0	0	0	10	23873978024	10377610	2387397648	12791206626
R:\Ampps\mysql\data\eneboo\actividadesxsector.ibd	wait/io/file/innodb/innodb_data_file	1401317811264	19	22163740176	10332062	1166512458	10704336998	7	1070637778	42835964	152948254	265972142	114688	0	0	0	0	0	0	12	21093102398	10332062	1757758308	10704336998
R:\Ampps\mysql\data\eneboo\agentes.ibd	wait/io/file/innodb/innodb_data_file	1401317811968	16	19819898382	10129026	1238743480	9733106572	6	788582946	40337772	131430298	184267136	98304	0	0	0	0	0	0	10	19031315436	10129026	1903131312	9733106572
R:\Ampps\mysql\data\eneboo\agruparalbaranescli.ibd	wait/io/file/innodb/innodb_data_file	1401317812672	19	23446873656	10257178	1234045860	11952965938	7	1137868942	36407134	162552706	362521550	114688	0	0	0	0	0	0	12	22309004714	10257178	1859083694	11952965938
R:\Ampps\mysql\data\eneboo\agruparalbaranesprov.ib...	wait/io/file/innodb/innodb_data_file	1401317813376	16	20409081062	10262968	1275567494	9749536662	6	783420968	35063082	130569904	214072898	98304	0	0	0	0	0	0	10	19625660094	10262968	1962565662	9749536662
R:\Ampps\mysql\data\eneboo\agruparpedidoscli.ibd	wait/io/file/innodb/innodb_data_file	1401317814080	16	23576908950	10508464	1473556544	12674640802	6	664565778	36572342	110760770	178001198	98304	0	0	0	0	0	0	10	22912343172	10508464	2291234240	12674640802
R:\Ampps\mysql\data\eneboo\agruparpedidosprov.ibd	wait/io/file/innodb/innodb_data_file	1401317814784	16	20888860534	10357152	1305553518	10077955498	6	632546692	36165112	105424320	149303256	98304	0	0	0	0	0	0	10	20256313842	10357152	2025631114	10077955498
R:\Ampps\mysql\data\eneboo\albaranescli.ibd	wait/io/file/innodb/innodb_data_file	1401317815488	16	19858548948	10156432	1241159068	9615297442	6	643775818	38115184	107295648	157406168	98304	0	0	0	0	0	0	10	19214773130	10156432	1921477120	9615297442
R:\Ampps\mysql\data\eneboo\albaranesprov.ibd	wait/io/file/innodb/innodb_data_file	1401317816192	17	22333887046	10362556	1313757948	11133467094	7	1033547424	33983440	147649632	321399040	114688	0	0	0	0	0	0	10	21300339622	10362556	2130033692	11133467094
R:\Ampps\mysql\data\eneboo\almacenes.ibd	wait/io/file/innodb/innodb_data_file	1401317816896	16	19349130080	10228614	1209320630	9203543522	6	823538334	40870066	137256196	185958202	98304	0	0	0	0	0	0	10	18525591746	10228614	1852559136	9203543522
R:\Ampps\mysql\data\eneboo\articulos.ibd	wait/io/file/innodb/innodb_data_file	1401317817600	5	10237568042	10880182	2047513454	10019210158	1	134629080	134629080	134629080	134629080	16384	0	0	0	0	0	0	4	10102938962	10880182	2525734644	10019210158
R:\Ampps\mysql\data\eneboo\articulosagen.ibd	wait/io/file/innodb/innodb_data_file	1401317818304	16	19745970504	10228614	1234123060	9636895686	6	784931386	42042734	130821576	217005340	98304	0	0	0	0	0	0	10	18961039118	10228614	1896103796	9636895686
R:\Ampps\mysql\data\eneboo\articuloscli.ibd	wait/io/file/innodb/innodb_data_file	1401317819008	16	22222236546	11309800	1388889760	11276283234	6	826735186	40469784	137788876	215322380	98304	0	0	0	0	0	0	10	21395501360	11309800	2139550136	11276283234
R:\Ampps\mysql\data\eneboo\articulosprov.ibd	wait/io/file/innodb/innodb_data_file	1401317819712	16	20048189204	10103936	1253011584	9589621880	7	992121904	43262494	141731480	210019898	114688	0	0	0	0	0	0	9	19056067300	10103936	2117340468	9589621880
R:\Ampps\mysql\data\eneboo\articulostarifas.ibd	wait/io/file/innodb/innodb_data_file	1401317820416	16	20007996568	10269916	1250499496	9545219528	6	784770424	41583394	130794942	208016558	98304	0	0	0	0	0	0	10	19223226144	10269916	1922322460	9545219528
R:\Ampps\mysql\data\eneboo\autorizaciones.ibd	wait/io/file/innodb/innodb_data_file	1401317821120	16	22004580024	10205840	1375285962	11023348628	6	850515874	51013374	141752324	209495710	98304	0	0	0	0	0	0	10	21154064150	10205840	2115406222	11023348628

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view