Faıldardy osynda aparyńyz

SQL júktep salý ( 0 ) x -

Saýaldy oryndaý úshin Ctrl+Enter basyńyz Saýaldy oryndaý úshin «Enter» basyńyz
ósýmen
kemýmen
Reti:
SQL kúıin keltirý
Sany
Oryndaý reti
Alǵan ýaqyt
Reti boıynsha:
Saýaldardy toptastyrý
Saýaldardy toptastyrylmaý
Jıý Jaıý Qadaǵalaýdy kórsetý Qadaǵalaýdy jasyrý Count: Alynǵan ýaqyt:
Betbelgiler
Jańalaý
Ústeý
Betbelgiler joq
Betbelgi ústeý
Opsıalar
Restore default values
Jıý Jaıý Jańǵyrtý Óńdeý Explain áreketi Profaıldaý Betbelgi Saýal sátsiz aıaqtaldy Derekqor: Saýaldyq ýaqyt:
Súzgiler
Aınymaly Mán Sıpattamasy
Aborted clients Qujattama 6 6 Klıent qosylymdy durys jabylmastan quraǵandyqtan úzilgen qosylymnyń sany.
Aborted connects Qujattama 38 38 MySQL serverine qosylý sátsiz áreketiniń sany.
Aborted connects preauth Qujattama 1 1
Access denied errors Qujattama 37 37
Acl column grants Qujattama 29 29
Acl database grants Qujattama 1 1
Acl function grants Qujattama 0 0
Acl procedure grants Qujattama 0 0
Acl package spec grants Qujattama 0 0
Acl package body grants Qujattama 0 0
Acl proxy users Qujattama 2 2
Acl role grants Qujattama 0 0
Acl roles Qujattama 0 0
Acl table grants Qujattama 4 4
Acl users Qujattama 7 7
Aria pagecache blocks not flushed Qujattama 0 0
Aria pagecache blocks unused Qujattama 15,7 k 15706
Aria pagecache blocks used Qujattama 311 311
Aria pagecache read requests Qujattama 5,2 M 5225838
Aria pagecache reads Qujattama 390,1 k 390124
Aria pagecache write requests Qujattama 782,7 k 782689
Aria pagecache writes Qujattama 782,7 k 782689
Aria transaction log syncs Qujattama 348 348
Binlog commits Qujattama 20,6 k 20555
Binlog group commits Qujattama 20,6 k 20555
Binlog group commit trigger count Qujattama 0 0
Binlog group commit trigger lock wait Qujattama 0 0
Binlog group commit trigger timeout Qujattama 0 0
Binlog snapshot file Qujattama mariadb-bin.000057 mariadb-bin.000057
Binlog snapshot position Qujattama 15,9 M 15905963
Binlog bytes written Qujattama 15,9 M 15905787
Binlog cache disk use Qujattama 0 0 Ýaqytsha ekilik jurnal keshin paıdalanatyn, biraq binlog_cache_size máninen asatyn tranzaksıanyń sany, jáne tranzaksıadan nusqaýlardy saqtaý úshin ýaqytsha faıl paıdalanatyn.
Binlog cache use Qujattama 20,6 k 20555 Ýaqytsha ekilik jurnal keshin paıdalanatyn tranzaksıa sany.
Binlog stmt cache disk use Qujattama 0 0
Binlog stmt cache use Qujattama 0 0
Busy time Qujattama 0 0.000000
Bytes received Qujattama 900,4 M 900373957
Bytes sent Qujattama 2,3 G 2318511499
Column compressions Qujattama 0 0
Column decompressions Qujattama 0 0
Com admin commands Qujattama 0 0
Com alter db Qujattama 0 0
Com alter db upgrade Qujattama 0 0
Com alter event Qujattama 0 0
Com alter function Qujattama 0 0
Com alter procedure Qujattama 0 0
Com alter server Qujattama 0 0
Com alter sequence Qujattama 0 0
Com alter table Qujattama 0 0
Com alter tablespace Qujattama 0 0
Com alter user Qujattama 0 0
Com analyze Qujattama 0 0
Com assign to keycache Qujattama 0 0
Com backup Qujattama 0 0
Com backup lock Qujattama 0 0
Com begin Qujattama 0 0
Com binlog Qujattama 0 0
Com call procedure Qujattama 0 0
Com change db Qujattama 263 k 262985
Com change master Qujattama 0 0
Com check Qujattama 0 0
Com checksum Qujattama 0 0
Com commit Qujattama 0 0
Com compound sql Qujattama 0 0
Com create db Qujattama 0 0
Com create event Qujattama 0 0
Com create function Qujattama 0 0
Com create index Qujattama 0 0
Com create package Qujattama 0 0
Com create package body Qujattama 0 0
Com create procedure Qujattama 0 0
Com create role Qujattama 0 0
Com create sequence Qujattama 0 0
Com create server Qujattama 0 0
Com create table Qujattama 4 4
Com create temporary table Qujattama 0 0
Com create trigger Qujattama 0 0
Com create udf Qujattama 0 0
Com create user Qujattama 0 0
Com create view Qujattama 0 0
Com delete Qujattama 0 0
Com delete multi Qujattama 0 0
Com do Qujattama 0 0
Com drop db Qujattama 0 0
Com drop event Qujattama 0 0
Com drop function Qujattama 0 0
Com drop index Qujattama 0 0
Com drop procedure Qujattama 0 0
Com drop package Qujattama 0 0
Com drop package body Qujattama 0 0
Com drop role Qujattama 0 0
Com drop server Qujattama 0 0
Com drop sequence Qujattama 0 0
Com drop table Qujattama 0 0
Com drop temporary table Qujattama 0 0
Com drop trigger Qujattama 0 0
Com drop user Qujattama 0 0
Com drop view Qujattama 0 0
Com empty query Qujattama 0 0
Com execute immediate Qujattama 0 0
Com flush Qujattama 0 0
Com get diagnostics Qujattama 0 0
Com grant Qujattama 0 0
Com grant role Qujattama 0 0
Com ha close Qujattama 0 0
Com ha open Qujattama 0 0
Com ha read Qujattama 0 0
Com help Qujattama 0 0
Com insert Qujattama 5 5
Com insert select Qujattama 0 0
Com install plugin Qujattama 0 0
Com kill Qujattama 0 0
Com load Qujattama 0 0
Com lock tables Qujattama 0 0
Com multi Qujattama 0 0
Com optimize Qujattama 0 0
Com preload keys Qujattama 0 0
Com purge Qujattama 0 0
Com purge before date Qujattama 0 0
Com release savepoint Qujattama 0 0
Com rename table Qujattama 0 0
Com rename user Qujattama 0 0
Com repair Qujattama 0 0
Com replace Qujattama 19,8 k 19785
Com replace select Qujattama 0 0
Com reset Qujattama 0 0
Com resignal Qujattama 0 0
Com revoke Qujattama 0 0
Com revoke all Qujattama 0 0
Com revoke role Qujattama 0 0
Com rollback Qujattama 0 0
Com rollback to savepoint Qujattama 0 0
Com savepoint Qujattama 0 0
Com select Qujattama 6,4 M 6423101
Com set option Qujattama 390,5 k 390494
Com show authors Qujattama 0 0
Com show binlog events Qujattama 0 0
Com show binlogs Qujattama 2 k 1998
Com show charsets Qujattama 0 0
Com show collations Qujattama 0 0
Com show contributors Qujattama 0 0
Com show create db Qujattama 0 0
Com show create event Qujattama 0 0
Com show create func Qujattama 0 0
Com show create package Qujattama 0 0
Com show create package body Qujattama 0 0
Com show create proc Qujattama 0 0
Com show create table Qujattama 125,8 k 125846
Com show create trigger Qujattama 0 0
Com show create user Qujattama 0 0
Com show databases Qujattama 46 46
Com show engine logs Qujattama 0 0
Com show engine mutex Qujattama 0 0
Com show engine status Qujattama 1 1
Com show errors Qujattama 0 0
Com show events Qujattama 0 0
Com show explain Qujattama 0 0
Com show fields Qujattama 385,2 k 385213
Com show function status Qujattama 0 0
Com show generic Qujattama 0 0
Com show grants Qujattama 129,6 k 129556
Com show keys Qujattama 501,2 k 501247
Com show master status Qujattama 109 109
Com show open tables Qujattama 0 0
Com show package status Qujattama 0 0
Com show package body status Qujattama 0 0
Com show plugins Qujattama 0 0
Com show privileges Qujattama 0 0
Com show procedure status Qujattama 0 0
Com show processlist Qujattama 4 4
Com show profile Qujattama 0 0
Com show profiles Qujattama 0 0
Com show relaylog events Qujattama 0 0
Com show slave hosts Qujattama 0 0
Com show slave status Qujattama 109 109
Com show status Qujattama 55 55
Com show storage engines Qujattama 197 197
Com show table status Qujattama 1,8 k 1838
Com show tables Qujattama 267,4 k 267382
Com show triggers Qujattama 0 0
Com show variables Qujattama 252,7 k 252680
Com show warnings Qujattama 125,4 k 125413
Com shutdown Qujattama 0 0
Com signal Qujattama 0 0
Com start all slaves Qujattama 0 0
Com start slave Qujattama 0 0
Com stmt close Qujattama 200 200
Com stmt execute Qujattama 200 200
Com stmt fetch Qujattama 0 0
Com stmt prepare Qujattama 263 263
Com stmt reprepare Qujattama 0 0
Com stmt reset Qujattama 0 0
Com stmt send long data Qujattama 0 0
Com stop all slaves Qujattama 0 0
Com stop slave Qujattama 0 0
Com truncate Qujattama 0 0
Com uninstall plugin Qujattama 0 0
Com unlock tables Qujattama 0 0
Com update Qujattama 765 765
Com update multi Qujattama 0 0
Com xa commit Qujattama 0 0
Com xa end Qujattama 0 0
Com xa prepare Qujattama 0 0
Com xa recover Qujattama 0 0
Com xa rollback Qujattama 0 0
Com xa start Qujattama 0 0
Compression Qujattama OFF OFF
Connection errors accept Qujattama 0 0
Connection errors internal Qujattama 0 0
Connection errors max connections Qujattama 0 0
Connection errors peer address Qujattama 0 0
Connection errors select Qujattama 0 0
Connection errors tcpwrap Qujattama 0 0
Connections Qujattama 265,6 k 265588 MySQL serverine qosylý áreketiniń (sátti nemese joq) sany.
Cpu time Qujattama 0 0.000000
Created tmp disk tables Qujattama 402,3 k 402268 Nusqaýlardy oryndaý kezinde server arqyly avtomatty jasalatyn ýaqytsha kesteniń sany. Eger created_tmp_disk_tables úlken bolsa, ýaqytsha kesteler dıski-negizdi ornyna jad-negizdi týdyrý úshin tmp_table_size mánin arttyrǵyńyz múmkin.
Created tmp files Qujattama 5 5 mysqld arqyly qansha ýaqytsha faıl jasaldy.
Created tmp tables Qujattama 6,2 M 6203997 Nusqaýlardy oryndaý kezinde server arqyly avtomatty jasalatyn jadtaǵy ýaqytsha kesteniń sany.
Delayed errors Qujattama 0 0 INSERT DELAYED nusqaýmen jazylǵan, olarda keıbir qateler (múmkin qaıtalanatyn kiltten) oryn alǵan úshin, joldyń sany.
Delayed insert threads Qujattama 0 0 Qoldanylatyn INSERT DELAYED óńdeýish tizbeginiń sany. Onda bireýi INSERT DELAYED paıdalanatyn árbir ártúrli keste óz tizbegin alady.
Delayed writes Qujattama 0 0 INSERT DELAYED jazylǵan joldyń sany.
Delete scan Qujattama 0 0
Empty queries Qujattama 4,6 M 4632531
Executed events Qujattama 0 0
Executed triggers Qujattama 0 0
Feature application time periods Qujattama 0 0
Feature check constraint Qujattama 0 0
Feature custom aggregate functions Qujattama 0 0
Feature delay key write Qujattama 0 0
Feature dynamic columns Qujattama 0 0
Feature fulltext Qujattama 0 0
Feature gis Qujattama 5 5
Feature invisible columns Qujattama 0 0
Feature json Qujattama 0 0
Feature locale Qujattama 125,1 k 125121
Feature subquery Qujattama 174 174
Feature system versioning Qujattama 0 0
Feature timezone Qujattama 0 0
Feature trigger Qujattama 79 79
Feature window functions Qujattama 0 0
Feature xml Qujattama 0 0
Flush commands Qujattama 1 1 Oryndalǵan FLUSH nusqaýnyń sany.
Handler commit Qujattama 84 k 84043 Ishki COMMIT nusqaýnyń sany.
Handler delete Qujattama 0 0 Kesteden jol joıylǵan ret sany.
Handler discover Qujattama 52 52 MySQL serveri, NDB Cluster saqtaýysh mehanızmynen, eger ol berilgen atymen keste týraly bilse, ony suraı alady. Bul ashyp kórsetý dep atalady. Handler_discover ashyp kórsetilgen ýaqytsha kesteniń sanyn anyqtaıdy.
Handler external lock Qujattama 0 0
Handler icp attempts Qujattama 0 0
Handler icp match Qujattama 0 0
Handler mrr init Qujattama 0 0
Handler mrr key refills Qujattama 0 0
Handler mrr rowid refills Qujattama 0 0
Handler prepare Qujattama 41,1 k 41050
Handler read first Qujattama 133,3 k 133309 Birinshi jazba ındeksten oqylǵan ret sany. Eger bul joǵary bolsa, ol server tolyq ındekstik skanerleýdi kóp jasaıdy dep boljaıdy; mysaly, SELECT col1 FROM foo, sonda col1 ındekstelgen dep boljanǵan.
Handler read key Qujattama 793,1 k 793085 Kiltke negizdelgen joldy oqýǵa arnalǵan saýal sany. Eger bul joǵary bolsa, bul saýaldar men kesteler durys ındekstelgenin jaqsy kórsetedi.
Handler read last Qujattama 0 0
Handler read next Qujattama 804,3 k 804317 Kilt retindegi kelesi joldy oqýǵa arnalǵan saýal sany. Eger aýqym shekteýleri bar ındekstik baǵanǵa saýal jasasańyz nemese eger ındekstik skanerleýdi isteseńiz, bul arttyrylady.
Handler read prev Qujattama 0 0 Kilt retimen aldyńǵy joldy oqý úshin saýal sany. Bul oqý ádisi ORDER BY … DESC ońtaılandyrý úshin basymdy paıdalanylady.
Handler read retry Qujattama 0 0
Handler read rnd Qujattama 2,2 M 2163718 Turaqty jaıǵasymǵa negizdelgen joldy oqýǵa arnalǵan saýal sany. Nátıjeni suryptaýdy qajet etetin kóptegen saýaldar isteseńiz, bul joǵary bolady. Múmkin búkil kestelerdi skanerleý úshin MySQL qajet etetin kóptegen saýaldaryńyz bar nemese kiltterdi durys paıdalanbaıtyn jalǵasýlaryńyz bar.
Handler read rnd deleted Qujattama 132,6 k 132614
Handler read rnd next Qujattama 89,5 M 89478658 Derekter faılyndaǵy kelesi joldy oqýǵa arnalǵan saýal sany. Kóptegen keste skanerleýlerin isteseńiz, bul joǵary bolady. Ádette bul kestelerińiz durys ındekstelmegenin nemese bar ındeksterden paıda alý úshin saýaldaryńyz jazylmaǵanyn kórsetedi.
Handler rollback Qujattama 0 0 Ishki ROLLBACK nusqaýnyń sany.
Handler savepoint Qujattama 0 0
Handler savepoint rollback Qujattama 0 0
Handler tmp delete Qujattama 0 0
Handler tmp update Qujattama 32,1 k 32056
Handler tmp write Qujattama 90,3 M 90330776
Handler update Qujattama 20,5 k 20520 Kestede joldy jańartý saýaldyń sany.
Handler write Qujattama 19,8 k 19794 Kestege joldy kiristirý saýaldyń sany.
Innodb buffer pool dump status Qujattama
Innodb buffer pool load status Qujattama Buffer pool(s) load completed at 251229 0:01:23 Buffer pool(s) load completed at 251229 0:01:23
Innodb buffer pool resize status Qujattama
Innodb buffer pool load incomplete Qujattama OFF OFF
Innodb buffer pool pages data Qujattama 868 868 Derekter bar bettiń sany (bos emes nemese taza).
Innodb buffer pool bytes data Qujattama 14,2 M 14221312
Innodb buffer pool pages dirty Qujattama 5 5 Aǵymda bos emes bet sany.
Innodb buffer pool bytes dirty Qujattama 81,9 k 81920
Innodb buffer pool pages flushed Qujattama 79,8 k 79761 Tazartý saýaly jiberilgen býfer pýly betiniń sany.
Innodb buffer pool pages free Qujattama 15,1 k 15089 Bos bet sany.
Innodb buffer pool pages misc Qujattama 427 427 Bos emes bettiń sany, sebebi olar ákimshilik ústeme úshin bólingen, mysaly, joldyń qulyptary nemese beıimdeletin hesh ındeksi. Bul mán Innodb_buffer_pool_pages_total - Innodb_buffer_pool_pages_free - Innodb_buffer_pool_pages_data retinde eseptelýi múmkin.
Innodb buffer pool pages total Qujattama 16,4 k 16384 Býfer pýlynyń qorytyndy ólshemi, betpen alǵanda.
Innodb buffer pool read ahead rnd Qujattama 0 0 InnoDB iske qosqan «kezdeısoq» aldymen oqý sany. Bul saýal arqyly kezdeısoq retimen kesteniń úlken bóligin skanerleý kezinde oryn alady.
Innodb buffer pool read ahead Qujattama 0 0
Innodb buffer pool read ahead evicted Qujattama 0 0
Innodb buffer pool read requests Qujattama 2,4 M 2368044 InnoDB oryndaǵan logıkalyq oqý saýalynyń sany.
Innodb buffer pool reads Qujattama 705 705 InnoDB býferlik pýldan qanaǵattandyra almaǵan jáne jalǵyz bet oqý áreketin istegen logıkalyq oqý sany.
Innodb buffer pool wait free Qujattama 0 0 Ádette, InnoDB býferiniń pýlyna jazý óńde oryn alady. Degenmen, eger betti oqý nemese jasaý qajet bolsa jáne taza better bolmasa, aldymen betterdiń tazalanýyn kútý qajet. Bul eseptegish osy kútýlerdiń danalaryn sanaıdy. Eger býfer pýlynyń ólshemi durys ornatylǵan bolsa, bul mán az bolýy kerek.
Innodb buffer pool write requests Qujattama 162,5 k 162523 InnoDB býferlik pýlyna jazý jasalǵan sany.
Innodb data fsyncs Qujattama 65,3 k 65338 Osyi ýaqytqa deıin fsync() áreketiniń sany.
Innodb data pending fsyncs Qujattama 0 0 Bógelis fsync() áreketiniń aǵymdaǵy sany.
Innodb data pending reads Qujattama 0 0 Bógelis oqylymdardyń aǵymdyq sany.
Innodb data pending writes Qujattama 0 0 Bógelis jazylymdardyń aǵymdyq sany.
Innodb data read Qujattama 13,4 M 13437440 Ázirshe oqylǵan derekterdiń kólemi, baıttar.
Innodb data reads Qujattama 863 863 Derekter oqylymdarynyń qorytyndy sany.
Innodb data writes Qujattama 130,5 k 130534 Derekter jazylymdarynyń qorytyndy sany.
Innodb data written Qujattama 2,7 G 2682051584 Ázirshe jazylǵan derekter kólemi, baıttar.
Innodb dblwr pages written Qujattama 79,6 k 79630 Qos jazý áreketteri úshin jazylǵan bet sany.
Innodb dblwr writes Qujattama 7,8 k 7798 Oryndalǵan qos jazý áreket sany.
Innodb log waits Qujattama 0 0 Kútip jatqan sany, sebebi jurnaldyń býferi tym az boldy jáne jalǵastyrmas buryn ony tazalaýdy kútýge týra keldi.
Innodb log write requests Qujattama 116 k 115962 Jurnalǵa jazý saýal sany.
Innodb log writes Qujattama 35,4 k 35406 Jýrnal faılyna fızıkalyq jazylym sany.
Innodb os log fsyncs Qujattama 42,9 k 42941 Jýrnal faılyna jasalǵan fsync () jazylymnyń sany.
Innodb os log pending fsyncs Qujattama 0 0 Jurnal faılynyń bógelis fsync() sany.
Innodb os log pending writes Qujattama 0 0 Jurnal faılynyń bógelis jazylymdar.
Innodb os log written Qujattama 66,7 M 66731520 Jurnal faılyna jazylǵan baıt sany.
Innodb page size Qujattama 16,4 k 16384 Qurastyrylǵan InnoDB bet ólshemi (ádepki 16KB). Kóptegen mánder betterde esepteledi; bet ólshemi olardy baıtqa ońaı túrlendirýge ruqsat etedi.
Innodb pages created Qujattama 164 164 Jasalǵan bet sany.
Innodb pages read Qujattama 704 704 Oqylǵan bet sany.
Innodb pages written Qujattama 79,8 k 79761 Jazylǵan bet sany.
Innodb row lock current waits Qujattama 0 0 Aǵymda kútip jatqan jol qulpynyń sany.
Innodb row lock time Qujattama 6,5 k 6507 Joldy qulyptap alýdyń jumsalǵan qorytyndy ýaqyty, mıllısekýntpen.
Innodb row lock time avg Qujattama 5 5 Joldy qulyptap alýdyń ortasha ýaqyty, mıllısekýntpen.
Innodb row lock time max Qujattama 31 31 Joldy qulyptap alýdyń eń uzaq ýaqyty, mıllısekýntpen.
Innodb row lock waits Qujattama 1,3 k 1266 Joldy qulyptaýdyń kútip jatqan retiniń sany.
Innodb rows deleted Qujattama 0 0 InnoDB kestelerinen joıylǵan joldyń sany.
Innodb rows inserted Qujattama 1 1 InnoDB kestelerine kiristirilgen joldyń sany.
Innodb rows read Qujattama 972,4 k 972355 InnoDB kestelerinen oqylǵan joldyń sany.
Innodb rows updated Qujattama 18,7 k 18684 InnoDB kestelerinde jańartylǵan joldyń sany.
Innodb system rows deleted Qujattama 0 0
Innodb system rows inserted Qujattama 8 8
Innodb system rows read Qujattama 5,6 k 5581
Innodb system rows updated Qujattama 0 0
Innodb num open files Qujattama 47 47
Innodb truncated status writes Qujattama 0 0
Innodb available undo logs Qujattama 128 128
Innodb undo truncations Qujattama 0 0
Innodb page compression saved Qujattama 0 0
Innodb num index pages written Qujattama 0 0
Innodb num non index pages written Qujattama 0 0
Innodb num pages page compressed Qujattama 0 0
Innodb num page compressed trim op Qujattama 0 0
Innodb num pages page decompressed Qujattama 0 0
Innodb num pages page compression error Qujattama 0 0
Innodb num pages encrypted Qujattama 0 0
Innodb num pages decrypted Qujattama 0 0
Innodb have lz4 Qujattama OFF OFF
Innodb have lzo Qujattama OFF OFF
Innodb have lzma Qujattama OFF OFF
Innodb have bzip2 Qujattama OFF OFF
Innodb have snappy Qujattama OFF OFF
Innodb have punch hole Qujattama ON ON
Innodb defragment compression failures Qujattama 0 0
Innodb defragment failures Qujattama 0 0
Innodb defragment count Qujattama 0 0
Innodb instant alter column Qujattama 0 0
Innodb onlineddl rowlog rows Qujattama 0 0
Innodb onlineddl rowlog pct used Qujattama 0 0
Innodb onlineddl pct progress Qujattama 0 0
Innodb secondary index triggered cluster reads Qujattama 96,3 k 96345
Innodb secondary index triggered cluster reads avoided Qujattama 0 0
Innodb encryption rotation pages read from cache Qujattama 0 0
Innodb encryption rotation pages read from disk Qujattama 0 0
Innodb encryption rotation pages modified Qujattama 0 0
Innodb encryption rotation pages flushed Qujattama 0 0
Innodb encryption rotation estimated iops Qujattama 0 0
Innodb encryption key rotation list length Qujattama 0 0
Innodb encryption n merge blocks encrypted Qujattama 0 0
Innodb encryption n merge blocks decrypted Qujattama 0 0
Innodb encryption n rowlog blocks encrypted Qujattama 0 0
Innodb encryption n rowlog blocks decrypted Qujattama 0 0
Innodb encryption n temp blocks encrypted Qujattama 0 0
Innodb encryption n temp blocks decrypted Qujattama 0 0
Innodb scrub background page reorganizations Qujattama 0 0
Innodb scrub background page splits Qujattama 0 0
Innodb scrub background page split failures underflow Qujattama 0 0
Innodb scrub background page split failures out of filespace Qujattama 0 0
Innodb scrub background page split failures missing index Qujattama 0 0
Innodb scrub background page split failures unknown Qujattama 0 0
Innodb scrub log Qujattama 0 0
Innodb encryption num key requests Qujattama 0 0
Key blocks not flushed Qujattama 0 0 Ózgertilgen, biraq dıskige áli tazartylmaǵan kilt keshindegi kilt blogynyń sany. Ol ádette Not_flushed_key_blocks dep atalady.
Key blocks unused Qujattama 13,4 k 13355 Kilt keshindegi paıdalanylmaǵan bloktyń sany. Bul mándi kilt keshiniń qansha paıdalanylýyn anyqtaý úshin paıdalana alasyz.
Key blocks used Qujattama 34 34 Kilt keshindegi paıdalanylǵan bloktyń sany. Bul mán bir ýaqytta qoldanystaǵy bloktardy eń kóp sanyn kórsetetin joǵary deńgeı belgisi bolyp tabylady.
Key blocks warm Qujattama 11 11
Key read requests Qujattama 273,6 k 273638 Keshten kilt blogyn oqý úshin saýal sany.
Key reads Qujattama 34 34 Dıskidegi kilttik bloktyń fızıkalyq oqylym sany. Eger Key_reads úlken bolsa, key_buffer_size máni tym kishkentaı bolýy yqtımal. Kesh nátıjesizdiginiń araqatynasy Key_reads/Key_read_requests retinde esepteledi.
Key write requests Qujattama 0 0 Keshke kiltti blokty jazý saýalynyń sany.
Key writes Qujattama 0 0 Dıskige kilttik bloktyń fızıkalyq jazýynyń sany.
Last query cost Qujattama 0 0.000000 Saýal ońtaılandyrǵyshy arqyly eseptelgen sońǵy qurylǵan saýaldyń qorytyndy shyǵyny. Birdeı saýal úshin ártúrli saýal josparlarynyń shyǵynyn salystyrýǵa paıdaly. Ádepki 0 máni eshbir saýal áli qurastyrylmaǵanyn bildiredi.
Master gtid wait count Qujattama 0 0
Master gtid wait time Qujattama 0 0
Master gtid wait timeouts Qujattama 0 0
Max statement time exceeded Qujattama 0 0
Max used connections Qujattama 11 11 Server iske qosylǵan keıin bir ýaqytta paıdalanylǵan qosylymnyń eń kóp sany.
Memory used Qujattama 179,3 M 179321712
Memory used initial Qujattama 172 M 172015152
Not flushed delayed rows Qujattama 0 0 INSERT DELAYED kezegine jazylýdy kútip jatqan joldyń sany.
Open files Qujattama 79 79 Ashyq faıl sany.
Open streams Qujattama 0 0 Ashyq aǵyn sany (jurnalǵa jazý úshin basymdy paıdalanylady).
Open table definitions Qujattama 137 137
Open tables Qujattama 150 150 Ashyq keste sany.
Opened files Qujattama 1,6 M 1609258
Opened plugin libraries Qujattama 690 690
Opened table definitions Qujattama 133 133
Opened tables Qujattama 156 156 The number of tables that have been opened. If opened tables is big, your table_open_cache value is probably too small.
Opened views Qujattama 1,1 k 1138
Performance schema accounts lost Qujattama 0 0
Performance schema cond classes lost Qujattama 0 0
Performance schema cond instances lost Qujattama 0 0
Performance schema digest lost Qujattama 0 0
Performance schema file classes lost Qujattama 0 0
Performance schema file handles lost Qujattama 0 0
Performance schema file instances lost Qujattama 0 0
Performance schema hosts lost Qujattama 0 0
Performance schema locker lost Qujattama 0 0
Performance schema mutex classes lost Qujattama 0 0
Performance schema mutex instances lost Qujattama 0 0
Performance schema rwlock classes lost Qujattama 0 0
Performance schema rwlock instances lost Qujattama 0 0
Performance schema session connect attrs lost Qujattama 0 0
Performance schema socket classes lost Qujattama 0 0
Performance schema socket instances lost Qujattama 0 0
Performance schema stage classes lost Qujattama 0 0
Performance schema statement classes lost Qujattama 0 0
Performance schema table handles lost Qujattama 0 0
Performance schema table instances lost Qujattama 0 0
Performance schema thread classes lost Qujattama 0 0
Performance schema thread instances lost Qujattama 0 0
Performance schema users lost Qujattama 0 0
Prepared stmt count Qujattama 0 0
Qcache free blocks Qujattama 26 26 Saýal keshindegi bos jad bloktyń sany. Úlken sandar FLUSH QUERY CACHE nusqaýynyń shyǵarylýy arqyly sheshilýi múmkin bólshekteý máselelerin kórsete alady.
Qcache free memory Qujattama 12,4 M 12447848 Saýal keshi úshin bos jad mólsheri.
Qcache hits Qujattama 4,2 M 4226753 Keshke ushyrasý sany.
Qcache inserts Qujattama 39,9 k 39875 Keshke ústelgen saýal sany.
Qcache lowmem prunes Qujattama 0 0 Jańa saýaldardy keshke qoıýǵa jadty bosatý úshin keshten alastalǵan saýal sany. Bul aqparat saýal keshiniń ólshemin teńsheýge kómektesedi. Qaısy saýaldar keshten alastalatynyn sheshý úshin saýal keshi jýyqta az paıdalanylǵandardy (LRU) yǵystyryp shyǵarý strategıasyn paıdalanady.
Qcache not cached Qujattama 2,2 M 2154109 Keshtelmegen saýaldyń sany (keshtelýi múmkin emes, nemese query_cache_type parametrine baılanysty keshtelmegen).
Qcache queries in cache Qujattama 3,7 k 3717 Keshte tirkelgen saýal sany.
Qcache total blocks Qujattama 7,5 k 7511 Saýal keshindegi bloktyń qorytyndy sany.
Queries Qujattama 9,2 M 9155424
Questions Qujattama 9,2 M 9154961
Rows read Qujattama 2,1 M 2053025
Rows sent Qujattama 12,5 M 12482541
Rows tmp read Qujattama 85,9 M 85861848
Rpl semi sync master clients Qujattama 0 0
Rpl semi sync master get ack Qujattama 0 0
Rpl semi sync master net avg wait time Qujattama 0 0
Rpl semi sync master net wait time Qujattama 0 0
Rpl semi sync master net waits Qujattama 0 0
Rpl semi sync master no times Qujattama 0 0
Rpl semi sync master no tx Qujattama 0 0
Rpl semi sync master request ack Qujattama 0 0
Rpl semi sync master status Qujattama OFF OFF
Rpl semi sync master timefunc failures Qujattama 0 0
Rpl semi sync master tx avg wait time Qujattama 0 0
Rpl semi sync master tx wait time Qujattama 0 0
Rpl semi sync master tx waits Qujattama 0 0
Rpl semi sync master wait pos backtraverse Qujattama 0 0
Rpl semi sync master wait sessions Qujattama 0 0
Rpl semi sync master yes tx Qujattama 0 0
Rpl semi sync slave send ack Qujattama 0 0
Rpl semi sync slave status Qujattama OFF OFF
Rpl status Qujattama AUTH_MASTER AUTH_MASTER Buzylýǵa turaqtylyq replıkalaý mártebesi (áli endirilmegen).
Rpl transactions multi engine Qujattama 0 0
Select full join Qujattama 131,7 k 131742 Indeksterdi paıdalanbaıtyn jalǵasý sany. Eger bul mán 0 bolmasa, kestelerińizdiń ındeksterin muqıat tekserińiz.
Select full range join Qujattama 0 0 Anyqtamalyq kestede aýqymdy izdeýdi qoldanatyn jalǵasý sany.
Select range Qujattama 200 200 Birinshi kestede aýqymdardy paıdalanatyn jalǵasý sany. (Bul úlken bolsa da, ádette mańyzdy emes.)
Select range check Qujattama 0 0 Ár joldan keıin kilt paıdalanýdy tekseretin kilttersiz jalǵasý sany. (Eger bul 0 bolmasa, kestelerdiń ındeksterin muqıat tekserýińiz qajet.)
Select scan Qujattama 4,5 M 4492366 Birinshi kesteni tolyq skanerleýdi istegen jalǵasý sany.
Slave connections Qujattama 0 0
Slave heartbeat period Qujattama 0 0.000
Slave open temp tables Qujattama 0 0 The number of temporary tables currently open by the replica SQL thread.
Slave received heartbeats Qujattama 0 0
Slave retried transactions Qujattama 0 0 Total (since startup) number of times the replication replica SQL thread has retried transactions.
Slave running Qujattama OFF OFF This is ON if this server is a replica that is connected to a primary.
Slave skipped errors Qujattama 0 0
Slaves connected Qujattama 0 0
Slaves running Qujattama 0 0
Slow launch threads Qujattama 0 0 Jasaý úshin slow_launch_time sekýntten kóbirek ýaqytty alǵan tizbek sany.
Slow queries Qujattama 0 0 long_query_time parametrindegi sekýntterden kóbirek ýaqyt jumsaǵan saýal sany. Qujattama
Sort merge passes Qujattama 0 0 Suryptaý algorıtmine isteý kerek bolǵan biriktirý ótýdiń sany. Eger bul mán úlken bolsa, sort_buffer_size júıe aınymaly mánin joǵarylatýdy qarastyrýyńyz kerek.
Sort priority queue sorts Qujattama 1 1
Sort range Qujattama 101 101 Aýqymdarmen daıyndalǵan suryptaý sany.
Sort rows Qujattama 2,2 M 2165496 Suryptalǵan jol sany.
Sort scan Qujattama 267,8 k 267847 Kesteni skanerleý arqyly istelgen suryptaý sany.
Ssl accept renegotiates Qujattama 0 0
Ssl accepts Qujattama 0 0
Ssl callback cache hits Qujattama 0 0
Ssl cipher Qujattama
Ssl cipher list Qujattama
Ssl client connects Qujattama 0 0
Ssl connect renegotiates Qujattama 0 0
Ssl ctx verify depth Qujattama 0 0
Ssl ctx verify mode Qujattama 0 0
Ssl default timeout Qujattama 0 0
Ssl finished accepts Qujattama 0 0
Ssl finished connects Qujattama 0 0
Ssl server not after Qujattama
Ssl server not before Qujattama
Ssl session cache hits Qujattama 0 0
Ssl session cache misses Qujattama 0 0
Ssl session cache mode Qujattama NONE NONE
Ssl session cache overflows Qujattama 0 0
Ssl session cache size Qujattama 0 0
Ssl session cache timeouts Qujattama 0 0
Ssl sessions reused Qujattama 0 0
Ssl used session cache entries Qujattama 0 0
Ssl verify depth Qujattama 0 0
Ssl verify mode Qujattama 0 0
Ssl version Qujattama
Subquery cache hit Qujattama 0 0
Subquery cache miss Qujattama 2 2
Syncs Qujattama 711 711
Table locks immediate Qujattama 271,9 k 271903 Keste qulpynyń birden alynǵan retiniń sany.
Table locks waited Qujattama 0 0 Keste qulpyna birden qoljetkizý múmkin bolmaı kútý qajet bolǵan ret sany. Eger bul joǵary bolsa jáne ónimdilik máseleler bolsa, aldymen saýaldaryńyzdy ońtaılandyryp, kesteńizdi nemese kestelerińizdi bólińiz nemese replıkalaýdy paıdalanyńyz.
Table open cache active instances Qujattama 1 1
Table open cache hits Qujattama 544 k 543968
Table open cache misses Qujattama 4,4 k 4390
Table open cache overflows Qujattama 0 0
Tc log max pages used Qujattama 0 0
Tc log page size Qujattama 0 0
Tc log page waits Qujattama 0 0
Threadpool idle threads Qujattama 0 0
Threadpool threads Qujattama 0 0
Threads cached Qujattama 4 4 Tizbek keshindegi tizbektiń sany. Keshtiń ushyrasýlar jıiligin Thread_created/Connections órnegi retinde esepteýge bolady. Eger bul mán qyzyl tústi bolsa, thread_cache_size mánin joǵarylatýyńyz qajet.
Threads connected Qujattama 4 4 Aǵymda ashyq qosylym sany.
Threads created Qujattama 86 86 Qosylymdardy óńdeý úshin jasalǵan tizbektyń sany. Eger ttizbekhreads_created úlken bolsa, thread_cache_size mánin ulǵaıtqyńyz kelýi múmkin. (Ádette, eger tizbek endirýi jaqsy bolsa, bul ónimdiliktiń aıtarlyqtaı jaqsarýyna ákelmeıdi.)
Threads running Qujattama 6 6 Belsendi tizbek sany.
Transactions gtid foreign engine Qujattama 0 0
Transactions multi engine Qujattama 0 0
Update scan Qujattama 0 0
Uptime Qujattama 0 kún, 5 saǵat, 53 mınýt jáne 26 sekýnt 21206
Uptime since flush status Qujattama 0 kún, 5 saǵat, 53 mınýt jáne 26 sekýnt 21206
wsrep Qujattama 232,7 G 232736829746
wsrep applier thread count Qujattama 0 0
wsrep cluster capabilities Qujattama
wsrep cluster conf id Qujattama 18,4 E 18446744073709551615
wsrep cluster size Qujattama 0 0
wsrep cluster state uuid Qujattama
wsrep cluster status Qujattama Disconnected Disconnected
wsrep connected Qujattama OFF OFF
wsrep local bf aborts Qujattama 0 0
wsrep local index Qujattama 18,4 E 18446744073709551615
wsrep provider capabilities Qujattama
wsrep provider name Qujattama
wsrep provider vendor Qujattama
wsrep provider version Qujattama
wsrep ready Qujattama OFF OFF
wsrep rollbacker thread count Qujattama 0 0
wsrep thread count Qujattama 0 0
Key buffer fraction % 18,49 % 18.487548828125 Qoldanylǵan kilt keshiniń paıyzdyǵy (eseptelgen mán)
Key read ratio % <0.01 % 0.012425174866064 Oqý saýaldarymen salystyrǵanda fızıkalyq oqýlardyń araqatynasy retinde eseptelgen kilt keshiniń nátıjesizdigi (eseptelgen mán)
Threads cache hitrate % 99,97 % 99.967619018932 Tizbek keshiniń sáıkestik jıiligi (eseptelgen máni)