demo.phpmyadmin.net / phpMyAdmin demo - MySQL

Derekqorlardy sharlaýyn tarmaq retinde kórsetý Sharlaý taqtasynda derekqor tarmaǵyn tańdaýshymen aýystyrady
Negizgi taqtamen baılanystyrý Aǵymdyq derekqordy nemese kesteni bólekteý arqyly basty taqtamen baılanystyrý.
Logotıpty beıneleý Sharlaý taqtasynda logotıp kórsetý.
Logotıp siltemesiniń URL-y Sharlaý taqtasyndaǵyi logotıp meńzeıtin URL.
Logotıp siltemesiniń maqsaty Open the linked page in the main window (`main`) or in a new one (`new`).
Bólekteýdi qosý Tintýir kórsetkisi astynda serverdi bólekteý.
Birinshi deńgeıdegi eń kóp elementter Sharlaý tarmaǵynyń birinshi deńgeıindegi árbir bette beınelenetin element sany.
Súzgi uıasynda beınelenetin elementtiń eń az sany Súzgi uıasynda beınelenetin elementtiń (keste, kórinis, rásim jáne oqıǵa) eń az sanyn anyqtaıdy.
Jýyqtaǵy paıdalanylǵan kesteler Jaqynda paıdalanylǵan kestelerdiń eń kóp sany; óshirý úshin 0 ornatyńyz.
Tańdaýly kesteler Tańdaýly kestelerdiń eń kóp sany; óshirý úshin 0 ornatyńyz.
Sharlaý taqtasynyń eni Sharlaý taqtasyn tasalaý úshin 0 mánine ornatý.

Tarmaqtaǵy elementtiń eń kóp sany Sharlaý tarmaǵynyń árbir bette beınelenetin element sany.
Tarmaqtaǵy elementterdi toptastyrý Sharlaý tarmaǵyndaǵy elementterdi toptastyrý (derekqor men kesteler qoıyndylarynda kórsetilgen bólgishpen anyqtalady).
Sharlaý tarmaǵyn keńeıtýdi qosý Sharlaý taqtasynda tarmaq keńeıtý yqtımaldyǵy usynylsyn ba.
Tarmaqtaǵy kestelerdi kórsetý Sharlaý tarmaǵy ishindegi derekqordyń astynda kesteler kórsetilsin be
Tarmaqtaǵy kórinisterdi kórsetý Sharlaý tarmaǵy ishindegi derekqor astynda kórinister kórsetilsin be
Tarmaqtaǵy funksıalardy kórsetý Sharlaý tarmaǵy ishindegi derekqor astynda fýnksıalar kórsetilsin be
Tarmaqtaǵy rásimderdi kórsetý Sharlaý tarmaǵy ishindegi derekqor astynda rásimder kórsetilsin be
Tarmaqtaǵy oqıǵalardy kórsetý Sharlaý tarmaǵy ishindegi derekqor astynda oqıǵalar kórsetilsin be
Jalǵyz derekqordy keńeıtý Sharlaý tarmaǵy ishindegi jalǵyz derekqor avtomatty keńeıtilsin be.

Serverler bólekteýdi beıneleý Sharlaý taqtasynyń joǵarǵy jaǵynda server tańdaýyn beıneleý.
Serverlerdi tizim retinde beıneleý Server tizbesin ashylmaly tizimniń ornyna tizim retinde kórsetý.

Derekqordyń súzgi uıasynda beınelenetin derekqordyń eń az sany
Derekqor tarmaǵynyń bólgishi Derekqorlardy ártúrli tarmaq deńgeılerine bóletin jol.

Jyldam qatynaý beligishesi úshin maqsat
Ekinshi jyldam qatynaý beligishesi úshin maqsat
Keste tarmaǵynyń bólgishi Kestelerdi ártúrli tarmaq deńgeılerine bóletin jol.
Keste tarmǵynyń eń kóp terendigi

Árqashan saýal habarlaryn keńeıtý

Saýal tarıhyn basynda kórsetý

Aǵymdyq sholýdaǵy saýaldy kórsetý

Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.

Kúńgirt taqyrypqa aýystyrý

Aınymaly	Mán	Sıpattamasy
Aborted clients	0 0	Klıent qosylymdy durys jabylmastan quraǵandyqtan úzilgen qosylymnyń sany.
Aborted connects	0 0	MySQL serverine qosylý sátsiz áreketiniń sany.
Acl cache items count	0 0
Binlog cache disk use	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	28 28	Ýaqytsha ekilik jurnal keshin paıdalanatyn tranzaksıa sany.
Binlog stmt cache disk use	0 0
Binlog stmt cache use	5 5
Bytes received	1,8 M 1771522
Bytes sent	6 M 5967602
Caching sha2 password rsa public key	-----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAx1vvT1kkedc7d0ezgTYY 3NhVHYM+zYotl6z32Viw9b/F9rPOc0v5Z6RrjQlAiEeCVi0fako5M0lTpUSEN9hu gqeZFx3gujyxUEYLp+9XoFUdOfQJaB+1L8DwXw0yabdvrHWRiAPHsFLTDeZ+V+0n Lq2BtzLq87yjd0dS8I68crLBBejJhgu0ClcBPHcrONBbLYZYViO97urugdKyj7yJ vaTgWuldVld30Jlv95gIp/M+NY0ZYwjC4uLVkLD5T5gO6grtO3tWPb/quOJ0qKyT j0264kS0jtMwxxIgFRFlggBhSSBbXurdespV6Cqop2r8SrAyjX5oUOJ88YGrqfzg 4QIDAQAB -----END PUBLIC KEY----- -----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAx1vvT1kkedc7d0ezgTYY 3NhVHYM+zYotl6z32Viw9b/F9rPOc0v5Z6RrjQlAiEeCVi0fako5M0lTpUSEN9hu gqeZFx3gujyxUEYLp+9XoFUdOfQJaB+1L8DwXw0yabdvrHWRiAPHsFLTDeZ+V+0n Lq2BtzLq87yjd0dS8I68crLBBejJhgu0ClcBPHcrONBbLYZYViO97urugdKyj7yJ vaTgWuldVld30Jlv95gIp/M+NY0ZYwjC4uLVkLD5T5gO6grtO3tWPb/quOJ0qKyT j0264kS0jtMwxxIgFRFlggBhSSBbXurdespV6Cqop2r8SrAyjX5oUOJ88YGrqfzg 4QIDAQAB -----END PUBLIC KEY-----
Com admin commands	0 0
Com assign to keycache	0 0
Com alter db	0 0
Com alter event	0 0
Com alter function	0 0
Com alter instance	0 0
Com alter procedure	0 0
Com alter resource group	0 0
Com alter server	0 0
Com alter table	0 0
Com alter tablespace	0 0
Com alter user	0 0
Com alter user default role	0 0
Com analyze	0 0
Com begin	0 0
Com binlog	0 0
Com call procedure	0 0
Com change db	1,2 k 1222
Com change master	0 0
Com change repl filter	0 0
Com check	0 0
Com checksum	0 0
Com clone	0 0
Com commit	0 0
Com create db	2 2
Com create event	0 0
Com create function	0 0
Com create index	0 0
Com create procedure	0 0
Com create role	0 0
Com create server	0 0
Com create table	34 34
Com create resource group	0 0
Com create trigger	0 0
Com create udf	0 0
Com create user	0 0
Com create view	0 0
Com create spatial reference system	0 0
Com delete	0 0
Com delete multi	0 0
Com do	0 0
Com drop db	27 27
Com drop event	0 0
Com drop function	0 0
Com drop index	0 0
Com drop procedure	0 0
Com drop resource group	0 0
Com drop role	0 0
Com drop server	0 0
Com drop spatial reference system	0 0
Com drop table	0 0
Com drop trigger	0 0
Com drop user	0 0
Com drop view	0 0
Com empty query	0 0
Com explain other	0 0
Com flush	2 2
Com get diagnostics	0 0
Com grant	0 0
Com grant roles	0 0
Com ha close	0 0
Com ha open	0 0
Com ha read	0 0
Com help	0 0
Com import	0 0
Com insert	0 0
Com insert select	0 0
Com install component	0 0
Com install plugin	0 0
Com kill	0 0
Com load	0 0
Com lock instance	0 0
Com lock tables	0 0
Com optimize	0 0
Com preload keys	0 0
Com purge	0 0
Com purge before date	0 0
Com release savepoint	0 0
Com rename table	0 0
Com rename user	0 0
Com repair	0 0
Com replace	0 0
Com replace select	0 0
Com reset	0 0
Com resignal	0 0
Com restart	0 0
Com revoke	0 0
Com revoke all	0 0
Com revoke roles	0 0
Com rollback	0 0
Com rollback to savepoint	0 0
Com savepoint	0 0
Com select	7,5 k 7538
Com set option	1,9 k 1872
Com set password	0 0
Com set resource group	0 0
Com set role	0 0
Com signal	0 0
Com show binlog events	0 0
Com show binlogs	156 156
Com show charsets	0 0
Com show collations	0 0
Com show create db	0 0
Com show create event	0 0
Com show create func	3 3
Com show create proc	3 3
Com show create table	76 76
Com show create trigger	0 0
Com show databases	0 0
Com show engine logs	0 0
Com show engine mutex	0 0
Com show engine status	1 1
Com show events	0 0
Com show errors	0 0
Com show fields	135 135
Com show function code	0 0
Com show function status	0 0
Com show grants	410 410
Com show keys	103 103
Com show master status	22 22
Com show open tables	0 0
Com show plugins	0 0
Com show privileges	0 0
Com show procedure code	0 0
Com show procedure status	0 0
Com show processlist	0 0
Com show profile	0 0
Com show profiles	0 0
Com show relaylog events	0 0
Com show slave hosts	1 1
Com show slave status	22 22
Com show status	8 8
Com show storage engines	9 9
Com show table status	31 31
Com show tables	1,1 k 1081
Com show triggers	0 0
Com show variables	308 308
Com show warnings	55 55
Com show create user	0 0
Com shutdown	0 0
Com slave start	0 0
Com slave stop	0 0
Com group replication start	0 0
Com group replication stop	0 0
Com stmt execute	9 9
Com stmt close	9 9
Com stmt fetch	0 0
Com stmt prepare	9 9
Com stmt reset	0 0
Com stmt send long data	0 0
Com truncate	0 0
Com uninstall component	0 0
Com uninstall plugin	0 0
Com unlock instance	0 0
Com unlock tables	0 0
Com update	0 0
Com update multi	0 0
Com xa commit	0 0
Com xa end	0 0
Com xa prepare	0 0
Com xa recover	0 0
Com xa rollback	0 0
Com xa start	0 0
Com stmt reprepare	0 0
Connection errors accept	0 0
Connection errors internal	0 0
Connection errors max connections	0 0
Connection errors peer address	0 0
Connection errors select	0 0
Connection errors tcpwrap	0 0
Connections	1,4 k 1367	MySQL serverine qosylý áreketiniń (sátti nemese joq) sany.
Created tmp disk tables	3 3	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	6 6	mysqld arqyly qansha ýaqytsha faıl jasaldy.
Created tmp tables	11,9 k 11851	Nusqaýlardy oryndaý kezinde server arqyly avtomatty jasalatyn jadtaǵy ýaqytsha kesteniń sany.
Current tls ca	ca.pem ca.pem
Current tls capath
Current tls cert	server-cert.pem server-cert.pem
Current tls cipher
Current tls ciphersuites
Current tls crl
Current tls crlpath
Current tls key	server-key.pem server-key.pem
Current tls version	TLSv1,TLSv1.1,TLSv1.2 TLSv1,TLSv1.1,TLSv1.2
Delayed errors	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	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	0 0	INSERT DELAYED jazylǵan joldyń sany.
Flush commands	3 3	Oryndalǵan FLUSH nusqaýnyń sany.
Handler commit	11,5 k 11491	Ishki COMMIT nusqaýnyń sany.
Handler delete	1,6 k 1552	Kesteden jol joıylǵan ret sany.
Handler discover	0 0	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	71,1 k 71133
Handler mrr init	0 0
Handler prepare	112 112
Handler read first	8,1 k 8146	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	143,8 k 143849	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	0 0
Handler read next	96,3 k 96295	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	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 rnd	6,1 k 6051	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 next	866,7 k 866692	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	0 0	Ishki ROLLBACK nusqaýnyń sany.
Handler savepoint	0 0
Handler savepoint rollback	0 0
Handler update	1,8 k 1755	Kestede joldy jańartý saýaldyń sany.
Handler write	756,6 k 756612	Kestege joldy kiristirý saýaldyń sany.
Innodb buffer pool dump status	Dumping of buffer pool not started Dumping of buffer pool not started
Innodb buffer pool load status	Buffer pool(s) load completed at 240919 19:16:02 Buffer pool(s) load completed at 240919 19:16:02
Innodb buffer pool resize status
Innodb buffer pool pages data	1,4 k 1391	Derekter bar bettiń sany (bos emes nemese taza).
Innodb buffer pool bytes data	22,8 M 22790144
Innodb buffer pool pages dirty	0 0	Aǵymda bos emes bet sany.
Innodb buffer pool bytes dirty	0 0
Innodb buffer pool pages flushed	1,1 k 1113	Tazartý saýaly jiberilgen býfer pýly betiniń sany.
Innodb buffer pool pages free	6,8 k 6779	Bos bet sany.
Innodb buffer pool pages misc	22 22	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	8,2 k 8192	Býfer pýlynyń qorytyndy ólshemi, betpen alǵanda.
Innodb buffer pool read ahead rnd	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	0 0
Innodb buffer pool read ahead evicted	0 0
Innodb buffer pool read requests	492,3 k 492269	InnoDB oryndaǵan logıkalyq oqý saýalynyń sany.
Innodb buffer pool reads	1,2 k 1236	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	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	29,1 k 29138	InnoDB býferlik pýlyna jazý jasalǵan sany.
Innodb data fsyncs	646 646	Osyi ýaqytqa deıin fsync() áreketiniń sany.
Innodb data pending fsyncs	0 0	Bógelis fsync() áreketiniń aǵymdaǵy sany.
Innodb data pending reads	0 0	Bógelis oqylymdardyń aǵymdyq sany.
Innodb data pending writes	0 0	Bógelis jazylymdardyń aǵymdyq sany.
Innodb data read	20,5 M 20452352	Ázirshe oqylǵan derekterdiń kólemi, baıttar.
Innodb data reads	1,4 k 1367	Derekter oqylymdarynyń qorytyndy sany.
Innodb data writes	2,4 k 2395	Derekter jazylymdarynyń qorytyndy sany.
Innodb data written	36,7 M 36659200	Ázirshe jazylǵan derekter kólemi, baıttar.
Innodb dblwr pages written	979 979	Qos jazý áreketteri úshin jazylǵan bet sany.
Innodb dblwr writes	28 28	Oryndalǵan qos jazý áreket sany.
Innodb log waits	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	19,2 k 19228	Jurnalǵa jazý saýal sany.
Innodb log writes	1,2 k 1187	Jýrnal faılyna fızıkalyq jazylym sany.
Innodb os log fsyncs	518 518	Jýrnal faılyna jasalǵan fsync () jazylymnyń sany.
Innodb os log pending fsyncs	0 0	Jurnal faılynyń bógelis fsync() sany.
Innodb os log pending writes	0 0	Jurnal faılynyń bógelis jazylymdar.
Innodb os log written	1,5 M 1490944	Jurnal faılyna jazylǵan baıt sany.
Innodb page size	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	164 164	Jasalǵan bet sany.
Innodb pages read	1,2 k 1236	Oqylǵan bet sany.
Innodb pages written	1,1 k 1123	Jazylǵan bet sany.
Innodb row lock current waits	0 0	Aǵymda kútip jatqan jol qulpynyń sany.
Innodb row lock time	0 0	Joldy qulyptap alýdyń jumsalǵan qorytyndy ýaqyty, mıllısekýntpen.
Innodb row lock time avg	0 0	Joldy qulyptap alýdyń ortasha ýaqyty, mıllısekýntpen.
Innodb row lock time max	0 0	Joldy qulyptap alýdyń eń uzaq ýaqyty, mıllısekýntpen.
Innodb row lock waits	0 0	Joldy qulyptaýdyń kútip jatqan retiniń sany.
Innodb rows deleted	1,6 k 1552	InnoDB kestelerinen joıylǵan joldyń sany.
Innodb rows inserted	166 166	InnoDB kestelerine kiristirilgen joldyń sany.
Innodb rows read	230,8 k 230760	InnoDB kestelerinen oqylǵan joldyń sany.
Innodb rows updated	1,8 k 1776	InnoDB kestelerinde jańartylǵan joldyń sany.
Innodb num open files	17 17
Innodb truncated status writes	0 0
Innodb undo tablespaces total	2 2
Innodb undo tablespaces implicit	2 2
Innodb undo tablespaces explicit	0 0
Innodb undo tablespaces active	2 2
Key blocks not flushed	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	6,7 k 6698	Kilt keshindegi paıdalanylmaǵan bloktyń sany. Bul mándi kilt keshiniń qansha paıdalanylýyn anyqtaý úshin paıdalana alasyz.
Key blocks used	0 0	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 read requests	0 0	Keshten kilt blogyn oqý úshin saýal sany.
Key reads	0 0	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	0 0	Keshke kiltti blokty jazý saýalynyń sany.
Key writes	0 0	Dıskige kilttik bloktyń fızıkalyq jazýynyń sany.
Locked connects	0 0
Max execution time exceeded	0 0
Max execution time set	0 0
Max execution time set failed	0 0
Max used connections	10 10	Server iske qosylǵan keıin bir ýaqytta paıdalanylǵan qosylymnyń eń kóp sany.
Max used connections time	2024-09-19 19:16:04 2024-09-19 19:16:04
Mysqlx aborted clients	0 0
Mysqlx address	:: ::
Mysqlx bytes received	0 0
Mysqlx bytes sent	0 0
Mysqlx connection accept errors	0 0
Mysqlx connection errors	0 0
Mysqlx connections accepted	0 0
Mysqlx connections closed	0 0
Mysqlx connections rejected	0 0
Mysqlx crud create view	0 0
Mysqlx crud delete	0 0
Mysqlx crud drop view	0 0
Mysqlx crud find	0 0
Mysqlx crud insert	0 0
Mysqlx crud modify view	0 0
Mysqlx crud update	0 0
Mysqlx cursor close	0 0
Mysqlx cursor fetch	0 0
Mysqlx cursor open	0 0
Mysqlx errors sent	0 0
Mysqlx errors unknown message type	0 0
Mysqlx expect close	0 0
Mysqlx expect open	0 0
Mysqlx init error	0 0
Mysqlx notice global sent	0 0
Mysqlx notice other sent	0 0
Mysqlx notice warning sent	0 0
Mysqlx notified by group replication	0 0
Mysqlx port	33,1 k 33060
Mysqlx prep deallocate	0 0
Mysqlx prep execute	0 0
Mysqlx prep prepare	0 0
Mysqlx rows sent	0 0
Mysqlx sessions	0 0
Mysqlx sessions accepted	0 0
Mysqlx sessions closed	0 0
Mysqlx sessions fatal error	0 0
Mysqlx sessions killed	0 0
Mysqlx sessions rejected	0 0
Mysqlx socket	/var/run/mysqld/mysqlx.sock /var/run/mysqld/mysqlx.sock
Mysqlx ssl accepts	0 0
Mysqlx ssl active
Mysqlx ssl cipher
Mysqlx ssl cipher list
Mysqlx ssl ctx verify depth	18,4 E 18446744073709551615
Mysqlx ssl ctx verify mode	5 5
Mysqlx ssl finished accepts	0 0
Mysqlx ssl server not after	Oct 27 14:09:28 2029 GMT Oct 27 14:09:28 2029 GMT
Mysqlx ssl server not before	Oct 30 14:09:28 2019 GMT Oct 30 14:09:28 2019 GMT
Mysqlx ssl verify depth
Mysqlx ssl verify mode
Mysqlx ssl version
Mysqlx stmt create collection	0 0
Mysqlx stmt create collection index	0 0
Mysqlx stmt disable notices	0 0
Mysqlx stmt drop collection	0 0
Mysqlx stmt drop collection index	0 0
Mysqlx stmt enable notices	0 0
Mysqlx stmt ensure collection	0 0
Mysqlx stmt execute mysqlx	0 0
Mysqlx stmt execute sql	0 0
Mysqlx stmt execute xplugin	0 0
Mysqlx stmt kill client	0 0
Mysqlx stmt list clients	0 0
Mysqlx stmt list notices	0 0
Mysqlx stmt list objects	0 0
Mysqlx stmt ping	0 0
Mysqlx worker threads	2 2
Mysqlx worker threads active	0 0
Not flushed delayed rows	0 0	INSERT DELAYED kezegine jazylýdy kútip jatqan joldyń sany.
Ongoing anonymous transaction count	0 0
Open files	6 6	Ashyq faıl sany.
Open streams	0 0	Ashyq aǵyn sany (jurnalǵa jazý úshin basymdy paıdalanylady).
Open table definitions	175 175
Open tables	656 656	Ashyq keste sany.
Opened files	208 208
Opened table definitions	272 272
Opened tables	760 760	The number of tables that have been opened. If opened tables is big, your table_open_cache value is probably too small.
Performance schema accounts lost	0 0
Performance schema cond classes lost	0 0
Performance schema cond instances lost	0 0
Performance schema digest lost	0 0
Performance schema file classes lost	0 0
Performance schema file handles lost	0 0
Performance schema file instances lost	0 0
Performance schema hosts lost	0 0
Performance schema index stat lost	0 0
Performance schema locker lost	0 0
Performance schema memory classes lost	0 0
Performance schema metadata lock lost	0 0
Performance schema mutex classes lost	0 0
Performance schema mutex instances lost	0 0
Performance schema nested statement lost	0 0
Performance schema prepared statements lost	0 0
Performance schema program lost	0 0
Performance schema rwlock classes lost	0 0
Performance schema rwlock instances lost	0 0
Performance schema session connect attrs longest seen	48 48
Performance schema session connect attrs lost	0 0
Performance schema socket classes lost	0 0
Performance schema socket instances lost	0 0
Performance schema stage classes lost	0 0
Performance schema statement classes lost	0 0
Performance schema table handles lost	0 0
Performance schema table instances lost	0 0
Performance schema table lock stat lost	0 0
Performance schema thread classes lost	0 0
Performance schema thread instances lost	0 0
Performance schema users lost	0 0
Prepared stmt count	0 0
Queries	14,5 k 14469
Questions	14,5 k 14450
Rsa public key	-----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAx1vvT1kkedc7d0ezgTYY 3NhVHYM+zYotl6z32Viw9b/F9rPOc0v5Z6RrjQlAiEeCVi0fako5M0lTpUSEN9hu gqeZFx3gujyxUEYLp+9XoFUdOfQJaB+1L8DwXw0yabdvrHWRiAPHsFLTDeZ+V+0n Lq2BtzLq87yjd0dS8I68crLBBejJhgu0ClcBPHcrONBbLYZYViO97urugdKyj7yJ vaTgWuldVld30Jlv95gIp/M+NY0ZYwjC4uLVkLD5T5gO6grtO3tWPb/quOJ0qKyT j0264kS0jtMwxxIgFRFlggBhSSBbXurdespV6Cqop2r8SrAyjX5oUOJ88YGrqfzg 4QIDAQAB -----END PUBLIC KEY----- -----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAx1vvT1kkedc7d0ezgTYY 3NhVHYM+zYotl6z32Viw9b/F9rPOc0v5Z6RrjQlAiEeCVi0fako5M0lTpUSEN9hu gqeZFx3gujyxUEYLp+9XoFUdOfQJaB+1L8DwXw0yabdvrHWRiAPHsFLTDeZ+V+0n Lq2BtzLq87yjd0dS8I68crLBBejJhgu0ClcBPHcrONBbLYZYViO97urugdKyj7yJ vaTgWuldVld30Jlv95gIp/M+NY0ZYwjC4uLVkLD5T5gO6grtO3tWPb/quOJ0qKyT j0264kS0jtMwxxIgFRFlggBhSSBbXurdespV6Cqop2r8SrAyjX5oUOJ88YGrqfzg 4QIDAQAB -----END PUBLIC KEY-----
Secondary engine execution count	0 0
Select full join	3,8 k 3815	Indeksterdi paıdalanbaıtyn jalǵasý sany. Eger bul mán 0 bolmasa, kestelerińizdiń ındeksterin muqıat tekserińiz.
Select full range join	0 0	Anyqtamalyq kestede aýqymdy izdeýdi qoldanatyn jalǵasý sany.
Select range	0 0	Birinshi kestede aýqymdardy paıdalanatyn jalǵasý sany. (Bul úlken bolsa da, ádette mańyzdy emes.)
Select range check	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	13,9 k 13900	Birinshi kesteni tolyq skanerleýdi istegen jalǵasý sany.
Slave open temp tables	0 0	The number of temporary tables currently open by the replica SQL thread.
Slow launch threads	0 0	Jasaý úshin slow_launch_time sekýntten kóbirek ýaqytty alǵan tizbek sany.
Slow queries	0 0	long_query_time parametrindegi sekýntterden kóbirek ýaqyt jumsaǵan saýal sany.
Sort merge passes	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 range	0 0	Aýqymdarmen daıyndalǵan suryptaý sany.
Sort rows	29,6 k 29631	Suryptalǵan jol sany.
Sort scan	1,8 k 1758	Kesteni skanerleý arqyly istelgen suryptaý sany.
Ssl accept renegotiates	0 0
Ssl accepts	0 0
Ssl callback cache hits	0 0
Ssl cipher
Ssl cipher list
Ssl client connects	0 0
Ssl connect renegotiates	0 0
Ssl ctx verify depth	18,4 E 18446744073709551615
Ssl ctx verify mode	5 5
Ssl default timeout	0 0
Ssl finished accepts	0 0
Ssl finished connects	0 0
Ssl server not after	Oct 27 14:09:28 2029 GMT Oct 27 14:09:28 2029 GMT
Ssl server not before	Oct 30 14:09:28 2019 GMT Oct 30 14:09:28 2019 GMT
Ssl session cache hits	0 0
Ssl session cache misses	0 0
Ssl session cache mode	SERVER SERVER
Ssl session cache overflows	0 0
Ssl session cache size	128 128
Ssl session cache timeouts	0 0
Ssl sessions reused	0 0
Ssl used session cache entries	0 0
Ssl verify depth	0 0
Ssl verify mode	0 0
Ssl version
Table locks immediate	421 421	Keste qulpynyń birden alynǵan retiniń sany.
Table locks waited	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 hits	35,2 k 35155
Table open cache misses	760 760
Table open cache overflows	0 0
Tc log max pages used	0 0
Tc log page size	0 0
Tc log page waits	0 0
Threads cached	7 7	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	2 2	Aǵymda ashyq qosylym sany.
Threads created	10 10	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	2 2	Belsendi tizbek sany.
Uptime	0 kún, 0 saǵat, 1 mınýt jáne 30 sekýnt 90
Uptime since flush status	0 kún, 0 saǵat, 1 mınýt jáne 30 sekýnt 90
Key buffer fraction %	18,24 % 18.2373046875	Qoldanylǵan kilt keshiniń paıyzdyǵy (eseptelgen mán)
Threads cache hitrate %	99,27 % 99.268471104609	Tizbek keshiniń sáıkestik jıiligi (eseptelgen máni)

Aınymaly

Mán

Sıpattamasy

Aborted clients

Klıent qosylymdy durys jabylmastan quraǵandyqtan úzilgen qosylymnyń sany.

Aborted connects

MySQL serverine qosylý sátsiz áreketiniń sany.

Acl cache items count

Binlog cache disk use

Ý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

Ýaqytsha ekilik jurnal keshin paıdalanatyn tranzaksıa sany.

Binlog stmt cache disk use

Binlog stmt cache use

Bytes received

1,8 M

Bytes sent

6 M

Caching sha2 password rsa public key

Com admin commands

Com assign to keycache

Com alter db

Com alter event

Com alter function

Com alter instance

Com alter procedure

Com alter resource group

Com alter server

Com alter table

Com alter tablespace

Com alter user

Com alter user default role

Com analyze

Com begin

Com binlog

Com call procedure

Com change db

1,2 k

Com change master

Com change repl filter

Com check

Com checksum

Com clone

Com commit

Com create db

Com create event

Com create function

Com create index

Com create procedure

Com create role

Com create server

Com create table

Com create resource group

Com create trigger

Com create udf

Com create user

Com create view

Com create spatial reference system

Com delete

Com delete multi

Com do

Com drop db

Com drop event

Com drop function

Com drop index

Com drop procedure

Com drop resource group

Com drop role

Com drop server

Com drop spatial reference system

Com drop table

Com drop trigger

Com drop user

Com drop view

Com empty query

Com explain other

Com flush

Com get diagnostics

Com grant

Com grant roles

Com ha close

Com ha open

Com ha read

Com help

Com import

Com insert

Com insert select

Com install component

Com install plugin

Com kill

Com load

Com lock instance

Com lock tables

Com optimize

Com preload keys

Com purge

Com purge before date

Com release savepoint

Com rename table

Com rename user

Com repair

Com replace

Com replace select

Com reset

Com resignal

Com restart

Com revoke

Com revoke all

Com revoke roles

Com rollback

Com rollback to savepoint

Com savepoint

Com select

7,5 k

Com set option

1,9 k

Com set password

Com set resource group

Com set role

Com signal

Com show binlog events

Com show binlogs

156

Com show charsets

Com show collations

Com show create db

Com show create event

Com show create func

Com show create proc

Com show create table

Com show create trigger

Com show databases

Com show engine logs

Com show engine mutex

Com show engine status

Com show events

Com show errors

Com show fields

135

Com show function code

Com show function status

Com show grants

410

Com show keys

103

Com show master status

Com show open tables

Com show plugins

Com show privileges

Com show procedure code

Com show procedure status

Com show processlist

Com show profile

Com show profiles

Com show relaylog events

Com show slave hosts

Com show slave status

Com show status

Com show storage engines

Com show table status

Com show tables

1,1 k

Com show triggers

Com show variables

308

Com show warnings

Com show create user

Com shutdown

Com slave start

Com slave stop

Com group replication start

Com group replication stop

Com stmt execute

Com stmt close

Com stmt fetch

Com stmt prepare

Com stmt reset

Com stmt send long data

Com truncate

Com uninstall component

Com uninstall plugin

Com unlock instance

Com unlock tables

Com update

Com update multi

Com xa commit

Com xa end

Com xa prepare

Com xa recover

Com xa rollback

Com xa start

Com stmt reprepare

Connection errors accept

Connection errors internal

Connection errors max connections

Connection errors peer address

Connection errors select

Connection errors tcpwrap

Connections

1,4 k

MySQL serverine qosylý áreketiniń (sátti nemese joq) sany.

Created tmp disk tables

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

mysqld arqyly qansha ýaqytsha faıl jasaldy.

Created tmp tables

11,9 k

Nusqaýlardy oryndaý kezinde server arqyly avtomatty jasalatyn jadtaǵy ýaqytsha kesteniń sany.

Current tls ca

ca.pem

Current tls capath

Current tls cert

server-cert.pem

Current tls cipher

Current tls ciphersuites

Current tls crl

Current tls crlpath

Current tls key

server-key.pem

Current tls version

TLSv1,TLSv1.1,TLSv1.2

Delayed errors

INSERT DELAYED nusqaýmen jazylǵan, olarda keıbir qateler (múmkin qaıtalanatyn kiltten) oryn alǵan úshin, joldyń sany.

Delayed insert threads

Qoldanylatyn INSERT DELAYED óńdeýish tizbeginiń sany. Onda bireýi INSERT DELAYED paıdalanatyn árbir ártúrli keste óz tizbegin alady.

Delayed writes

INSERT DELAYED jazylǵan joldyń sany.

Flush commands

Oryndalǵan FLUSH nusqaýnyń sany.

Handler commit

11,5 k

Ishki COMMIT nusqaýnyń sany.

Handler delete

1,6 k

Kesteden jol joıylǵan ret sany.

Handler discover

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

71,1 k

Handler mrr init

Handler prepare

112

Handler read first

8,1 k

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

143,8 k

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

Handler read next

96,3 k

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

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 rnd

6,1 k

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 next

866,7 k

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

Ishki ROLLBACK nusqaýnyń sany.

Handler savepoint

Handler savepoint rollback

Handler update

1,8 k

Kestede joldy jańartý saýaldyń sany.

Handler write

756,6 k

Kestege joldy kiristirý saýaldyń sany.

Innodb buffer pool dump status

Dumping of buffer pool not started

Innodb buffer pool load status

Buffer pool(s) load completed at 240919 19:16:02

Innodb buffer pool resize status

Innodb buffer pool pages data

1,4 k

Derekter bar bettiń sany (bos emes nemese taza).

Innodb buffer pool bytes data

22,8 M

Innodb buffer pool pages dirty

Aǵymda bos emes bet sany.

Innodb buffer pool bytes dirty

Innodb buffer pool pages flushed

1,1 k

Tazartý saýaly jiberilgen býfer pýly betiniń sany.

Innodb buffer pool pages free

6,8 k

Bos bet sany.

Innodb buffer pool pages misc

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

8,2 k

Býfer pýlynyń qorytyndy ólshemi, betpen alǵanda.

Innodb buffer pool read ahead rnd

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

Innodb buffer pool read ahead evicted

Innodb buffer pool read requests

492,3 k

InnoDB oryndaǵan logıkalyq oqý saýalynyń sany.

Innodb buffer pool reads

1,2 k

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

Á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

29,1 k

InnoDB býferlik pýlyna jazý jasalǵan sany.

Innodb data fsyncs

646

Osyi ýaqytqa deıin fsync() áreketiniń sany.

Innodb data pending fsyncs

Bógelis fsync() áreketiniń aǵymdaǵy sany.

Innodb data pending reads

Bógelis oqylymdardyń aǵymdyq sany.

Innodb data pending writes

Bógelis jazylymdardyń aǵymdyq sany.

Innodb data read

20,5 M

Ázirshe oqylǵan derekterdiń kólemi, baıttar.

Innodb data reads

1,4 k

Derekter oqylymdarynyń qorytyndy sany.

Innodb data writes

2,4 k

Derekter jazylymdarynyń qorytyndy sany.

Innodb data written

36,7 M

Ázirshe jazylǵan derekter kólemi, baıttar.

Innodb dblwr pages written

979

Qos jazý áreketteri úshin jazylǵan bet sany.

Innodb dblwr writes

Oryndalǵan qos jazý áreket sany.

Innodb log waits

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

19,2 k

Jurnalǵa jazý saýal sany.

Innodb log writes

1,2 k

Jýrnal faılyna fızıkalyq jazylym sany.

Innodb os log fsyncs

518

Jýrnal faılyna jasalǵan fsync () jazylymnyń sany.

Innodb os log pending fsyncs

Jurnal faılynyń bógelis fsync() sany.

Innodb os log pending writes

Jurnal faılynyń bógelis jazylymdar.

Innodb os log written

1,5 M

Jurnal faılyna jazylǵan baıt sany.

Innodb page size

16,4 k

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

164

Jasalǵan bet sany.

Innodb pages read

1,2 k

Oqylǵan bet sany.

Innodb pages written

1,1 k

Jazylǵan bet sany.

Innodb row lock current waits

Aǵymda kútip jatqan jol qulpynyń sany.

Innodb row lock time

Joldy qulyptap alýdyń jumsalǵan qorytyndy ýaqyty, mıllısekýntpen.

Innodb row lock time avg

Joldy qulyptap alýdyń ortasha ýaqyty, mıllısekýntpen.

Innodb row lock time max

Joldy qulyptap alýdyń eń uzaq ýaqyty, mıllısekýntpen.

Innodb row lock waits

Joldy qulyptaýdyń kútip jatqan retiniń sany.

Innodb rows deleted

1,6 k

InnoDB kestelerinen joıylǵan joldyń sany.

Innodb rows inserted

166

InnoDB kestelerine kiristirilgen joldyń sany.

Innodb rows read

230,8 k

InnoDB kestelerinen oqylǵan joldyń sany.

Innodb rows updated

1,8 k

InnoDB kestelerinde jańartylǵan joldyń sany.

Innodb num open files

Innodb truncated status writes

Innodb undo tablespaces total

Innodb undo tablespaces implicit

Innodb undo tablespaces explicit

Innodb undo tablespaces active

Key blocks not flushed

Ózgertilgen, biraq dıskige áli tazartylmaǵan kilt keshindegi kilt blogynyń sany. Ol ádette Not_flushed_key_blocks dep atalady.

Key blocks unused

6,7 k

Kilt keshindegi paıdalanylmaǵan bloktyń sany. Bul mándi kilt keshiniń qansha paıdalanylýyn anyqtaý úshin paıdalana alasyz.

Key blocks used

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 read requests

Keshten kilt blogyn oqý úshin saýal sany.

Key reads

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

Keshke kiltti blokty jazý saýalynyń sany.

Key writes

Dıskige kilttik bloktyń fızıkalyq jazýynyń sany.

Locked connects

Max execution time exceeded

Max execution time set

Max execution time set failed

Max used connections

Server iske qosylǵan keıin bir ýaqytta paıdalanylǵan qosylymnyń eń kóp sany.

Max used connections time

2024-09-19 19:16:04

Mysqlx aborted clients

Mysqlx address

Mysqlx bytes received

Mysqlx bytes sent

Mysqlx connection accept errors

Mysqlx connection errors

Mysqlx connections accepted

Mysqlx connections closed

Mysqlx connections rejected

Mysqlx crud create view

Mysqlx crud delete

Mysqlx crud drop view

Mysqlx crud find

Mysqlx crud insert

Mysqlx crud modify view

Mysqlx crud update

Mysqlx cursor close

Mysqlx cursor fetch

Mysqlx cursor open

Mysqlx errors sent

Mysqlx errors unknown message type

Mysqlx expect close

Mysqlx expect open

Mysqlx init error

Mysqlx notice global sent

Mysqlx notice other sent

Mysqlx notice warning sent

Mysqlx notified by group replication

Mysqlx port

33,1 k

Mysqlx prep deallocate

Mysqlx prep execute

Mysqlx prep prepare

Mysqlx rows sent

Mysqlx sessions

Mysqlx sessions accepted

Mysqlx sessions closed

Mysqlx sessions fatal error

Mysqlx sessions killed

Mysqlx sessions rejected

Mysqlx socket

/var/run/mysqld/mysqlx.sock

Mysqlx ssl accepts

Mysqlx ssl active

Mysqlx ssl cipher

Mysqlx ssl cipher list

Mysqlx ssl ctx verify depth

18,4 E

Mysqlx ssl ctx verify mode

Mysqlx ssl finished accepts

Mysqlx ssl server not after

Oct 27 14:09:28 2029 GMT

Mysqlx ssl server not before

Oct 30 14:09:28 2019 GMT

Mysqlx ssl verify depth

Mysqlx ssl verify mode

Mysqlx ssl version

Mysqlx stmt create collection

Mysqlx stmt create collection index

Mysqlx stmt disable notices

Mysqlx stmt drop collection

Mysqlx stmt drop collection index

Mysqlx stmt enable notices

Mysqlx stmt ensure collection

Mysqlx stmt execute mysqlx

Mysqlx stmt execute sql

Mysqlx stmt execute xplugin

Mysqlx stmt kill client

Mysqlx stmt list clients

Mysqlx stmt list notices

Mysqlx stmt list objects

Mysqlx stmt ping

Mysqlx worker threads

Mysqlx worker threads active

Not flushed delayed rows

INSERT DELAYED kezegine jazylýdy kútip jatqan joldyń sany.

Ongoing anonymous transaction count

Open files

Ashyq faıl sany.

Open streams

Ashyq aǵyn sany (jurnalǵa jazý úshin basymdy paıdalanylady).

Open table definitions

175

Open tables

656

Ashyq keste sany.

Opened files

208

Opened table definitions

272

Opened tables

760

The number of tables that have been opened. If opened tables is big, your table_open_cache value is probably too small.

Performance schema accounts lost

Performance schema cond classes lost

Performance schema cond instances lost

Performance schema digest lost

Performance schema file classes lost

Performance schema file handles lost

Performance schema file instances lost

Performance schema hosts lost

Performance schema index stat lost

Performance schema locker lost

Performance schema memory classes lost

Performance schema metadata lock lost

Performance schema mutex classes lost

Performance schema mutex instances lost

Performance schema nested statement lost

Performance schema prepared statements lost

Performance schema program lost

Performance schema rwlock classes lost

Performance schema rwlock instances lost

Performance schema session connect attrs longest seen

Performance schema session connect attrs lost

Performance schema socket classes lost

Performance schema socket instances lost

Performance schema stage classes lost

Performance schema statement classes lost

Performance schema table handles lost

Performance schema table instances lost

Performance schema table lock stat lost

Performance schema thread classes lost

Performance schema thread instances lost

Performance schema users lost

Prepared stmt count

Queries

14,5 k

Questions

14,5 k

Rsa public key

Secondary engine execution count

Select full join

3,8 k

Indeksterdi paıdalanbaıtyn jalǵasý sany. Eger bul mán 0 bolmasa, kestelerińizdiń ındeksterin muqıat tekserińiz.

Select full range join

Anyqtamalyq kestede aýqymdy izdeýdi qoldanatyn jalǵasý sany.

Select range

Birinshi kestede aýqymdardy paıdalanatyn jalǵasý sany. (Bul úlken bolsa da, ádette mańyzdy emes.)

Select range check

Á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

13,9 k

Birinshi kesteni tolyq skanerleýdi istegen jalǵasý sany.

Slave open temp tables

The number of temporary tables currently open by the replica SQL thread.

Slow launch threads

Jasaý úshin slow_launch_time sekýntten kóbirek ýaqytty alǵan tizbek sany.

Slow queries

long_query_time parametrindegi sekýntterden kóbirek ýaqyt jumsaǵan saýal sany.

Sort merge passes

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 range

Aýqymdarmen daıyndalǵan suryptaý sany.

Sort rows

29,6 k

Suryptalǵan jol sany.

Sort scan

1,8 k

Kesteni skanerleý arqyly istelgen suryptaý sany.

Ssl accept renegotiates

Ssl accepts

Ssl callback cache hits

Ssl cipher

Ssl cipher list

Ssl client connects

Ssl connect renegotiates

Ssl ctx verify depth

18,4 E

Ssl ctx verify mode

Ssl default timeout

Ssl finished accepts

Ssl finished connects

Ssl server not after

Oct 27 14:09:28 2029 GMT

Ssl server not before

Oct 30 14:09:28 2019 GMT

Ssl session cache hits

Ssl session cache misses

Ssl session cache mode

SERVER

Ssl session cache overflows

Ssl session cache size

128

Ssl session cache timeouts

Ssl sessions reused

Ssl used session cache entries

Ssl verify depth

Ssl verify mode

Ssl version

Table locks immediate

421

Keste qulpynyń birden alynǵan retiniń sany.

Table locks waited

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 hits

35,2 k

Table open cache misses

760

Table open cache overflows

Tc log max pages used

Tc log page size

Tc log page waits

Threads cached

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

Aǵymda ashyq qosylym sany.

Threads created

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

Belsendi tizbek sany.

Uptime

0 kún, 0 saǵat, 1 mınýt jáne 30 sekýnt

Uptime since flush status

0 kún, 0 saǵat, 1 mınýt jáne 30 sekýnt

Key buffer fraction %

18,24 %

Qoldanylǵan kilt keshiniń paıyzdyǵy (eseptelgen mán)

Threads cache hitrate %

99,27 %

Tizbek keshiniń sáıkestik jıiligi (eseptelgen máni)

Sharlaý tarmaǵy kórinisin teńsheý.

Sharlaý tarmaǵyn teńsheý.

Serverlerdi beıneleý opsıalary.

Derekqorlardy beıneleý opsıalary.

Kestelerdi beıneleý opsıalary.

SQL júktep salý ( 0 ) x -

Sharlaý taqtasy

Sharlaý tarmaǵy kórinisin teńsheý.

Sharlaý tarmaǵy

Sharlaý tarmaǵyn teńsheý.

Serverler

Serverlerdi beıneleý opsıalary.

Derekqorlar

Derekqorlardy beıneleý opsıalary.

Kesteler

Kestelerdi beıneleý opsıalary.

SQL júktep salý ( 0 ) x -