Drop files here

SQL upload ( 0 ) x -

Sorğunu icra etmək üçün Ctrl+Enter düymələrinə basın Sorğunu icra etmək üçün Enter-ə basın
ascending
descending
Order:
Debug SQL
Sayı
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Genişlət Show trace Hide trace Count: Time taken:
Əlfəcinlər
Yenilə
Əlavə et
Əlfəcinlər yoxdur
Əlfəcin əlavə et
Seçimlər
Restore default values
Collapse Genişlət Sorğunu təkrarla Redaktə et İzah Et Profilləmə Əlfəcin Sorğu uğursuz oldu Verilənlər Bazası: Queried time:
Filtrlər
Dəyişən Dəyər Haqqında
Aborted clients Dokumentasiya 2 2 The number of connections that were aborted because the client died without closing the connection properly.
Aborted connects Dokumentasiya 43 43 MySQL serverinə bağlanmaq üçün uğursuz cəhdlərin sayıdır.
Aborted connects preauth Dokumentasiya 0 0
Access denied errors Dokumentasiya 43 43
Acl column grants Dokumentasiya 29 29
Acl database grants Dokumentasiya 1 1
Acl function grants Dokumentasiya 0 0
Acl procedure grants Dokumentasiya 0 0
Acl package spec grants Dokumentasiya 0 0
Acl package body grants Dokumentasiya 0 0
Acl proxy users Dokumentasiya 2 2
Acl role grants Dokumentasiya 0 0
Acl roles Dokumentasiya 0 0
Acl table grants Dokumentasiya 4 4
Acl users Dokumentasiya 7 7
Aria pagecache blocks not flushed Dokumentasiya 0 0
Aria pagecache blocks unused Dokumentasiya 15.7 k 15706
Aria pagecache blocks used Dokumentasiya 311 311
Aria pagecache read requests Dokumentasiya 1 M 1023089
Aria pagecache reads Dokumentasiya 68.8 k 68791
Aria pagecache write requests Dokumentasiya 139.9 k 139873
Aria pagecache writes Dokumentasiya 139.9 k 139873
Aria transaction log syncs Dokumentasiya 92 92
Binlog commits Dokumentasiya 5.3 k 5326
Binlog group commits Dokumentasiya 5.3 k 5326
Binlog group commit trigger count Dokumentasiya 0 0
Binlog group commit trigger lock wait Dokumentasiya 0 0
Binlog group commit trigger timeout Dokumentasiya 0 0
Binlog snapshot file Dokumentasiya mariadb-bin.000057 mariadb-bin.000057
Binlog snapshot position Dokumentasiya 3 M 2974938
Binlog bytes written Dokumentasiya 3 M 2974636
Binlog cache disk use Dokumentasiya 0 0 The number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the transaction.
Binlog cache use Dokumentasiya 5.3 k 5326 The number of transactions that used the temporary binary log cache.
Binlog stmt cache disk use Dokumentasiya 0 0
Binlog stmt cache use Dokumentasiya 0 0
Busy time Dokumentasiya 0 0.000000
Bytes received Dokumentasiya 167.3 M 167315837
Bytes sent Dokumentasiya 405.6 M 405630348
Column compressions Dokumentasiya 0 0
Column decompressions Dokumentasiya 0 0
Com admin commands Dokumentasiya 0 0
Com alter db Dokumentasiya 0 0
Com alter db upgrade Dokumentasiya 0 0
Com alter event Dokumentasiya 0 0
Com alter function Dokumentasiya 0 0
Com alter procedure Dokumentasiya 0 0
Com alter server Dokumentasiya 0 0
Com alter sequence Dokumentasiya 0 0
Com alter table Dokumentasiya 0 0
Com alter tablespace Dokumentasiya 0 0
Com alter user Dokumentasiya 0 0
Com analyze Dokumentasiya 0 0
Com assign to keycache Dokumentasiya 0 0
Com backup Dokumentasiya 0 0
Com backup lock Dokumentasiya 0 0
Com begin Dokumentasiya 0 0
Com binlog Dokumentasiya 0 0
Com call procedure Dokumentasiya 0 0
Com change db Dokumentasiya 50.4 k 50361
Com change master Dokumentasiya 0 0
Com check Dokumentasiya 0 0
Com checksum Dokumentasiya 0 0
Com commit Dokumentasiya 0 0
Com compound sql Dokumentasiya 0 0
Com create db Dokumentasiya 1 1
Com create event Dokumentasiya 0 0
Com create function Dokumentasiya 0 0
Com create index Dokumentasiya 0 0
Com create package Dokumentasiya 0 0
Com create package body Dokumentasiya 0 0
Com create procedure Dokumentasiya 0 0
Com create role Dokumentasiya 0 0
Com create sequence Dokumentasiya 0 0
Com create server Dokumentasiya 0 0
Com create table Dokumentasiya 0 0
Com create temporary table Dokumentasiya 0 0
Com create trigger Dokumentasiya 0 0
Com create udf Dokumentasiya 0 0
Com create user Dokumentasiya 0 0
Com create view Dokumentasiya 0 0
Com delete Dokumentasiya 0 0
Com delete multi Dokumentasiya 0 0
Com do Dokumentasiya 0 0
Com drop db Dokumentasiya 0 0
Com drop event Dokumentasiya 0 0
Com drop function Dokumentasiya 0 0
Com drop index Dokumentasiya 0 0
Com drop procedure Dokumentasiya 0 0
Com drop package Dokumentasiya 0 0
Com drop package body Dokumentasiya 0 0
Com drop role Dokumentasiya 0 0
Com drop server Dokumentasiya 0 0
Com drop sequence Dokumentasiya 0 0
Com drop table Dokumentasiya 0 0
Com drop temporary table Dokumentasiya 0 0
Com drop trigger Dokumentasiya 0 0
Com drop user Dokumentasiya 0 0
Com drop view Dokumentasiya 0 0
Com empty query Dokumentasiya 0 0
Com execute immediate Dokumentasiya 0 0
Com flush Dokumentasiya 0 0
Com get diagnostics Dokumentasiya 0 0
Com grant Dokumentasiya 0 0
Com grant role Dokumentasiya 0 0
Com ha close Dokumentasiya 0 0
Com ha open Dokumentasiya 0 0
Com ha read Dokumentasiya 0 0
Com help Dokumentasiya 0 0
Com insert Dokumentasiya 1 1
Com insert select Dokumentasiya 0 0
Com install plugin Dokumentasiya 0 0
Com kill Dokumentasiya 0 0
Com load Dokumentasiya 0 0
Com lock tables Dokumentasiya 0 0
Com multi Dokumentasiya 0 0
Com optimize Dokumentasiya 0 0
Com preload keys Dokumentasiya 0 0
Com purge Dokumentasiya 0 0
Com purge before date Dokumentasiya 0 0
Com release savepoint Dokumentasiya 0 0
Com rename table Dokumentasiya 0 0
Com rename user Dokumentasiya 0 0
Com repair Dokumentasiya 0 0
Com replace Dokumentasiya 2.6 k 2645
Com replace select Dokumentasiya 0 0
Com reset Dokumentasiya 0 0
Com resignal Dokumentasiya 0 0
Com revoke Dokumentasiya 0 0
Com revoke all Dokumentasiya 0 0
Com revoke role Dokumentasiya 0 0
Com rollback Dokumentasiya 0 0
Com rollback to savepoint Dokumentasiya 0 0
Com savepoint Dokumentasiya 0 0
Com select Dokumentasiya 1.3 M 1256509
Com set option Dokumentasiya 87.3 k 87305
Com show authors Dokumentasiya 0 0
Com show binlog events Dokumentasiya 0 0
Com show binlogs Dokumentasiya 3.5 k 3457
Com show charsets Dokumentasiya 0 0
Com show collations Dokumentasiya 0 0
Com show contributors Dokumentasiya 0 0
Com show create db Dokumentasiya 0 0
Com show create event Dokumentasiya 0 0
Com show create func Dokumentasiya 0 0
Com show create package Dokumentasiya 0 0
Com show create package body Dokumentasiya 0 0
Com show create proc Dokumentasiya 0 0
Com show create table Dokumentasiya 19 k 19040
Com show create trigger Dokumentasiya 0 0
Com show create user Dokumentasiya 0 0
Com show databases Dokumentasiya 18 18
Com show engine logs Dokumentasiya 0 0
Com show engine mutex Dokumentasiya 0 0
Com show engine status Dokumentasiya 0 0
Com show errors Dokumentasiya 0 0
Com show events Dokumentasiya 0 0
Com show explain Dokumentasiya 0 0
Com show fields Dokumentasiya 68.3 k 68257
Com show function status Dokumentasiya 0 0
Com show generic Dokumentasiya 0 0
Com show grants Dokumentasiya 20.7 k 20673
Com show keys Dokumentasiya 75.8 k 75793
Com show master status Dokumentasiya 21 21
Com show open tables Dokumentasiya 0 0
Com show package status Dokumentasiya 0 0
Com show package body status Dokumentasiya 0 0
Com show plugins Dokumentasiya 0 0
Com show privileges Dokumentasiya 0 0
Com show procedure status Dokumentasiya 0 0
Com show processlist Dokumentasiya 0 0
Com show profile Dokumentasiya 0 0
Com show profiles Dokumentasiya 0 0
Com show relaylog events Dokumentasiya 0 0
Com show slave hosts Dokumentasiya 0 0
Com show slave status Dokumentasiya 21 21
Com show status Dokumentasiya 11 11
Com show storage engines Dokumentasiya 64 64
Com show table status Dokumentasiya 1.5 k 1511
Com show tables Dokumentasiya 59.8 k 59754
Com show triggers Dokumentasiya 0 0
Com show variables Dokumentasiya 38.4 k 38361
Com show warnings Dokumentasiya 18.9 k 18905
Com shutdown Dokumentasiya 0 0
Com signal Dokumentasiya 0 0
Com start all slaves Dokumentasiya 0 0
Com start slave Dokumentasiya 0 0
Com stmt close Dokumentasiya 92 92
Com stmt execute Dokumentasiya 92 92
Com stmt fetch Dokumentasiya 0 0
Com stmt prepare Dokumentasiya 92 92
Com stmt reprepare Dokumentasiya 0 0
Com stmt reset Dokumentasiya 0 0
Com stmt send long data Dokumentasiya 0 0
Com stop all slaves Dokumentasiya 0 0
Com stop slave Dokumentasiya 0 0
Com truncate Dokumentasiya 0 0
Com uninstall plugin Dokumentasiya 0 0
Com unlock tables Dokumentasiya 0 0
Com update Dokumentasiya 2.7 k 2680
Com update multi Dokumentasiya 0 0
Com xa commit Dokumentasiya 0 0
Com xa end Dokumentasiya 0 0
Com xa prepare Dokumentasiya 0 0
Com xa recover Dokumentasiya 0 0
Com xa rollback Dokumentasiya 0 0
Com xa start Dokumentasiya 0 0
Compression Dokumentasiya OFF OFF
Connection errors accept Dokumentasiya 0 0
Connection errors internal Dokumentasiya 0 0
Connection errors max connections Dokumentasiya 0 0
Connection errors peer address Dokumentasiya 0 0
Connection errors select Dokumentasiya 0 0
Connection errors tcpwrap Dokumentasiya 0 0
Connections Dokumentasiya 59.3 k 59291 The number of connection attempts (successful or not) to the MySQL server.
Cpu time Dokumentasiya 0 0.000000
Created tmp disk tables Dokumentasiya 107.2 k 107173 The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based.
Created tmp files Dokumentasiya 5 5 How many temporary files mysqld has created.
Created tmp tables Dokumentasiya 1.3 M 1344388 The number of in-memory temporary tables created automatically by the server while executing statements.
Delayed errors Dokumentasiya 0 0 The number of rows written with INSERT DELAYED for which some error occurred (probably duplicate key).
Delayed insert threads Dokumentasiya 0 0 The number of INSERT DELAYED handler threads in use. Every different table on which one uses INSERT DELAYED gets its own thread.
Delayed writes Dokumentasiya 0 0 The number of INSERT DELAYED rows written.
Delete scan Dokumentasiya 0 0
Empty queries Dokumentasiya 899.9 k 899911
Executed events Dokumentasiya 0 0
Executed triggers Dokumentasiya 0 0
Feature application time periods Dokumentasiya 0 0
Feature check constraint Dokumentasiya 0 0
Feature custom aggregate functions Dokumentasiya 0 0
Feature delay key write Dokumentasiya 0 0
Feature dynamic columns Dokumentasiya 0 0
Feature fulltext Dokumentasiya 0 0
Feature gis Dokumentasiya 5 5
Feature invisible columns Dokumentasiya 0 0
Feature json Dokumentasiya 0 0
Feature locale Dokumentasiya 28.1 k 28120
Feature subquery Dokumentasiya 80 80
Feature system versioning Dokumentasiya 0 0
Feature timezone Dokumentasiya 0 0
Feature trigger Dokumentasiya 84 84
Feature window functions Dokumentasiya 0 0
Feature xml Dokumentasiya 0 0
Flush commands Dokumentasiya 1 1 The number of executed FLUSH statements.
Handler commit Dokumentasiya 25.5 k 25463 The number of internal COMMIT statements.
Handler delete Dokumentasiya 0 0 The number of times a row was deleted from a table.
Handler discover Dokumentasiya 52 52 The MySQL server can ask the NDB Cluster storage engine if it knows about a table with a given name. This is called discovery. Handler_discover indicates the number of time tables have been discovered.
Handler external lock Dokumentasiya 0 0
Handler icp attempts Dokumentasiya 0 0
Handler icp match Dokumentasiya 0 0
Handler mrr init Dokumentasiya 0 0
Handler mrr key refills Dokumentasiya 0 0
Handler mrr rowid refills Dokumentasiya 0 0
Handler prepare Dokumentasiya 10.4 k 10448
Handler read first Dokumentasiya 29.7 k 29726 The number of times the first entry was read from an index. If this is high, it suggests that the server is doing a lot of full index scans; for example, SELECT col1 FROM foo, assuming that col1 is indexed.
Handler read key Dokumentasiya 449.7 k 449672 The number of requests to read a row based on a key. If this is high, it is a good indication that your queries and tables are properly indexed.
Handler read last Dokumentasiya 0 0
Handler read next Dokumentasiya 474 k 474017 The number of requests to read the next row in key order. This is incremented if you are querying an index column with a range constraint or if you are doing an index scan.
Handler read prev Dokumentasiya 0 0 The number of requests to read the previous row in key order. This read method is mainly used to optimize ORDER BY … DESC.
Handler read retry Dokumentasiya 0 0
Handler read rnd Dokumentasiya 714.3 k 714261 The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
Handler read rnd deleted Dokumentasiya 29.5 k 29524
Handler read rnd next Dokumentasiya 15.8 M 15828430 The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.
Handler rollback Dokumentasiya 0 0 The number of internal ROLLBACK statements.
Handler savepoint Dokumentasiya 0 0
Handler savepoint rollback Dokumentasiya 0 0
Handler tmp delete Dokumentasiya 0 0
Handler tmp update Dokumentasiya 0