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.0004 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	83800	20646298027464	13459820	246375694	86788580452	3175	499759748750	19632732	157404624	735843380	52068352	42544	2021492540888	20429822	47515056	2550949322	697040896	38081	18125045737826	13459820	475960002	86788580452
R:\Ampps\mysql\data\tutorial\employee.ibd	wait/io/file/innodb/innodb_data_file	1401317807040	16	21168078266	10479900	1323004578	9872819272	6	1219651920	78332524	203275320	546743138	98304	0	0	0	0	0	0	10	19948426346	10479900	1994842596	9872819272
R:\Ampps\mysql\data\sys\sys_config.ibd	wait/io/file/innodb/innodb_data_file	1401317807744	20	23274764362	10350204	1163737890	11784948630	8	1285527066	50319346	160690642	326919226	131072	0	0	0	0	0	0	12	21989237296	10350204	1832436184	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	14	21465513268	10517728	1533250672	10846960910	6	713874576	55346610	118979096	163990170	98304	0	0	0	0	0	0	8	20751638692	10517728	2593954740	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	21	25794448842	10377610	1228306812	12791206626	9	1636243192	44543242	181804456	391180506	147456	0	0	0	0	0	0	12	24158205650	10377610	2013183772	12791206626
R:\Ampps\mysql\data\eneboo\actividadesxsector.ibd	wait/io/file/innodb/innodb_data_file	1401317811264	23	22999583418	10332062	999981636	10704336998	9	1593081444	42835964	177008792	311104806	147456	0	0	0	0	0	0	14	21406501974	10332062	1529035552	10704336998
R:\Ampps\mysql\data\eneboo\agentes.ibd	wait/io/file/innodb/innodb_data_file	1401317811968	20	20566738902	10129026	1028336810	9733106572	8	1251367996	40337772	156420710	324233052	131072	0	0	0	0	0	0	12	19315370906	10129026	1609614210	9733106572
R:\Ampps\mysql\data\eneboo\agruparalbaranescli.ibd	wait/io/file/innodb/innodb_data_file	1401317812672	23	24177826416	10257178	1051209626	11952965938	9	1623904316	36407134	180433770	362521550	147456	0	0	0	0	0	0	14	22553922100	10257178	1610994160	11952965938
R:\Ampps\mysql\data\eneboo\agruparalbaranesprov.ib...	wait/io/file/innodb/innodb_data_file	1401317813376	25	21911980554	10262968	876479006	9749536662	11	1808018596	35063082	164364976	315504434	180224	0	0	0	0	0	0	14	20103961958	10262968	1435997200	9749536662
R:\Ampps\mysql\data\eneboo\agruparpedidoscli.ibd	wait/io/file/innodb/innodb_data_file	1401317814080	20	24270885998	10508464	1213544242	12674640802	8	1136628338	36572342	142078494	355948356	131072	0	0	0	0	0	0	12	23134257660	10508464	1927854612	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	21	23051691488	10362556	1097699466	11133467094	9	1459714970	33983440	162190252	321399040	147456	0	0	0	0	0	0	12	21591976518	10362556	1799331280	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	19	23268038312	10880182	1224633250	11247967046	10	1515057334	45595478	151505386	370265096	163840	0	0	0	0	0	0	9	21752980978	10880182	2416997672	11247967046
R:\Ampps\mysql\data\eneboo\articulosagen.ibd	wait/io/file/innodb/innodb_data_file	1401317818304	21	20527661806	10228614	977507558	9636895686	9	1359640610	42042734	151071136	289946216	147456	0	0	0	0	0	0	12	19168021196	10228614	1597334778	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	20	20768889032	10103936	1038444220	9589621880	9	1494207158	43262494	166022846	298147944	147456	0	0	0	0	0	0	11	19274681874	10103936	1752243526	9589621880
R:\Ampps\mysql\data\eneboo\articulostarifas.ibd	wait/io/file/innodb/innodb_data_file	1401317820416	21	20797272384	10269916	990346304	9545219528	9	1438991788	41583394	159887762	269622930	147456	0	0	0	0	0	0	12	19358280596	10269916	1613189728	9545219528
R:\Ampps\mysql\data\eneboo\autorizaciones.ibd	wait/io/file/innodb/innodb_data_file	1401317821120	21	22811708726	10205840	1086271550	11023348628	9	1467152418	51013374	163016678	307254456	147456	0	0	0	0	0	0	12	21344556308	10205840	1778712704	11023348628

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view