demo.phpmyadmin.net / phpMyAdmin demo - MySQL / performance_schema

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

Sharlaý taqtasy

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ý.

Sharlaý tarmaǵyn teńsheý.

Sharlaý tarmaǵy

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.

Serverlerdi beıneleý opsıalary.

Serverler

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ý.

Derekqorlardy beıneleý opsıalary.

Derekqorlar

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.

Kestelerdi beıneleý opsıalary.

Kesteler

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

Faıldardy osynda aparyńyz

SQL júktep salý ( 0 ) x -

Bettiń joǵarǵy jaǵyna jyljý úshin jolaqty basyńyz

Saýaldy oryndaý úshin Ctrl+Enter basyńyz

Jıý Jaıý Qadaǵalaýdy kórsetý Qadaǵalaýdy jasyrý Alynǵan ýaqyt:

Á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ý

Jıý Jaıý Jańǵyrtý Óńdeý Explain áreketi Profaıldaý Saýal sátsiz aıaqtaldy Derekqor: Saýaldyq ýaqyt:

Derekqor qurylymy

Derekqor qurylymynda (kesteler tizimi) kórsetiletin egjeılerdi tańdańyz.

Derekqor qurylymy

Kesteniń tańbalar jıynyn kórsetý Barlyq kesteler úshin tańbalar jıynyn beıneleıtin baǵandy kórsetý nemese jasyrý.
Keste túsiniktemelerin kórsetý Barlyq kesteler úshin túsiniktemelerdi beıneleıtin baǵandy kórsetý nemese jasyrý.
Jasaýdyń ýaqyt belgisin kórsetý Barlyq kesteler úshin jasaý ýaqyty belgisin beıneleıtin baǵandy kórsetý nemese jasyrý.
Sońǵy jańartýdyń ýaqyt belgisin kórsetý Barlyq kesteler úshin sońǵy jańartý ýaqyty belgisin beıneleıtin baǵandy kórsetý nemese jasyrý.
Sońǵy tekserýdiń ýaqyt belgisin kórsetý Barlyq kesteler úshin sońǵy tekserý ýaqyty belgisin beıneleıtin baǵandy kórsetý nemese jasyrý.

Súzgiler

Ishindegi bar sóz:

Keste	Áreket				Joldar Shamamen bolýy múmkin. Naqty sandy alý úshin nómirdi basyńyz. FAQ 3.11 qarańyz.	Túri	Kolasıa
accounts		Sharlaý	Qurylym	Izdeý	128	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
cond_instances		Sharlaý	Qurylym	Izdeý	256	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
data_locks		Sharlaý	Qurylym	Izdeý	99 999	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
data_lock_waits		Sharlaý	Qurylym	Izdeý	99 999	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_errors_summary_by_account_by_error		Sharlaý	Qurylym	Izdeý	587 904	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_errors_summary_by_host_by_error		Sharlaý	Qurylym	Izdeý	587 904	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_errors_summary_by_thread_by_error		Sharlaý	Qurylym	Izdeý	1 175 808	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_errors_summary_by_user_by_error		Sharlaý	Qurylym	Izdeý	587 904	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_errors_summary_global_by_error		Sharlaý	Qurylym	Izdeý	4 593	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_stages_current		Sharlaý	Qurylym	Izdeý	256	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_stages_history		Sharlaý	Qurylym	Izdeý	2 560	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_stages_history_long		Sharlaý	Qurylym	Izdeý	10 000	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_stages_summary_by_account_by_event_name		Sharlaý	Qurylym	Izdeý	22 400	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_stages_summary_by_host_by_event_name		Sharlaý	Qurylym	Izdeý	22 400	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_stages_summary_by_thread_by_event_name		Sharlaý	Qurylym	Izdeý	44 800	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_stages_summary_by_user_by_event_name		Sharlaý	Qurylym	Izdeý	22 400	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_stages_summary_global_by_event_name		Sharlaý	Qurylym	Izdeý	175	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_statements_current		Sharlaý	Qurylym	Izdeý	2 560	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_statements_histogram_by_digest		Sharlaý	Qurylym	Izdeý	10 000	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_statements_histogram_global		Sharlaý	Qurylym	Izdeý	450	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_statements_history		Sharlaý	Qurylym	Izdeý	2 560	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_statements_history_long		Sharlaý	Qurylym	Izdeý	10 000	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_statements_summary_by_account_by_event_name		Sharlaý	Qurylym	Izdeý	27 904	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_statements_summary_by_digest		Sharlaý	Qurylym	Izdeý	10 000	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_statements_summary_by_host_by_event_name		Sharlaý	Qurylym	Izdeý	27 904	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_statements_summary_by_program		Sharlaý	Qurylym	Izdeý	1 024	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_statements_summary_by_thread_by_event_name		Sharlaý	Qurylym	Izdeý	55 808	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_statements_summary_by_user_by_event_name		Sharlaý	Qurylym	Izdeý	27 904	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_statements_summary_global_by_event_name		Sharlaý	Qurylym	Izdeý	218	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_transactions_current		Sharlaý	Qurylym	Izdeý	256	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_transactions_history		Sharlaý	Qurylym	Izdeý	2 560	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_transactions_history_long		Sharlaý	Qurylym	Izdeý	10 000	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_transactions_summary_by_account_by_event_name		Sharlaý	Qurylym	Izdeý	128	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_transactions_summary_by_host_by_event_name		Sharlaý	Qurylym	Izdeý	128	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_transactions_summary_by_thread_by_event_name		Sharlaý	Qurylym	Izdeý	256	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_transactions_summary_by_user_by_event_name		Sharlaý	Qurylym	Izdeý	128	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_transactions_summary_global_by_event_name		Sharlaý	Qurylym	Izdeý	1	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_waits_current		Sharlaý	Qurylym	Izdeý	1 536	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_waits_history		Sharlaý	Qurylym	Izdeý	2 560	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_waits_history_long		Sharlaý	Qurylym	Izdeý	10 000	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_waits_summary_by_account_by_event_name		Sharlaý	Qurylym	Izdeý	70 912	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_waits_summary_by_host_by_event_name		Sharlaý	Qurylym	Izdeý	70 912	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_waits_summary_by_instance		Sharlaý	Qurylym	Izdeý	10 752	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_waits_summary_by_thread_by_event_name		Sharlaý	Qurylym	Izdeý	141 824	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_waits_summary_by_user_by_event_name		Sharlaý	Qurylym	Izdeý	70 912	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
events_waits_summary_global_by_event_name		Sharlaý	Qurylym	Izdeý	554	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
file_instances		Sharlaý	Qurylym	Izdeý	4 096	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
file_summary_by_event_name		Sharlaý	Qurylym	Izdeý	80	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
file_summary_by_instance		Sharlaý	Qurylym	Izdeý	4 096	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
global_status		Sharlaý	Qurylym	Izdeý	242	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
global_variables		Sharlaý	Qurylym	Izdeý	591	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
hosts		Sharlaý	Qurylym	Izdeý	128	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
host_cache		Sharlaý	Qurylym	Izdeý	279	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
keyring_keys		Sharlaý	Qurylym	Izdeý	96	PERFORMANCE_SCHEMA	utf8mb4_bin
log_status		Sharlaý	Qurylym	Izdeý	1	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
memory_summary_by_account_by_event_name		Sharlaý	Qurylym	Izdeý	57 600	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
memory_summary_by_host_by_event_name		Sharlaý	Qurylym	Izdeý	57 600	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
memory_summary_by_thread_by_event_name		Sharlaý	Qurylym	Izdeý	115 200	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
memory_summary_by_user_by_event_name		Sharlaý	Qurylym	Izdeý	57 600	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
memory_summary_global_by_event_name		Sharlaý	Qurylym	Izdeý	450	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
metadata_locks		Sharlaý	Qurylym	Izdeý	1 024	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
mutex_instances		Sharlaý	Qurylym	Izdeý	3 072	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
objects_summary_global_by_type		Sharlaý	Qurylym	Izdeý	5 120	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
performance_timers		Sharlaý	Qurylym	Izdeý	4	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
persisted_variables		Sharlaý	Qurylym	Izdeý	0	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
prepared_statements_instances		Sharlaý	Qurylym	Izdeý	1 024	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
replication_applier_configuration		Sharlaý	Qurylym	Izdeý	256	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
replication_applier_filters		Sharlaý	Qurylym	Izdeý	0	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
replication_applier_global_filters		Sharlaý	Qurylym	Izdeý	0	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
replication_applier_status		Sharlaý	Qurylym	Izdeý	256	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
replication_applier_status_by_coordinator		Sharlaý	Qurylym	Izdeý	256	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
replication_applier_status_by_worker		Sharlaý	Qurylym	Izdeý	8 192	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
replication_connection_configuration		Sharlaý	Qurylym	Izdeý	256	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
replication_connection_status		Sharlaý	Qurylym	Izdeý	256	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
replication_group_members		Sharlaý	Qurylym	Izdeý	0	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
replication_group_member_stats		Sharlaý	Qurylym	Izdeý	0	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
rwlock_instances		Sharlaý	Qurylym	Izdeý	3 072	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
session_account_connect_attrs		Sharlaý	Qurylym	Izdeý	131 072	PERFORMANCE_SCHEMA	utf8mb4_bin
session_connect_attrs		Sharlaý	Qurylym	Izdeý	131 072	PERFORMANCE_SCHEMA	utf8mb4_bin
session_status		Sharlaý	Qurylym	Izdeý	242	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
session_variables		Sharlaý	Qurylym	Izdeý	591	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
setup_actors		Sharlaý	Qurylym	Izdeý	128	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
setup_consumers		Sharlaý	Qurylym	Izdeý	15	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
setup_instruments		Sharlaý	Qurylym	Izdeý	1 399	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
setup_objects		Sharlaý	Qurylym	Izdeý	128	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
setup_threads		Sharlaý	Qurylym	Izdeý	100	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
socket_instances		Sharlaý	Qurylym	Izdeý	256	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
socket_summary_by_event_name		Sharlaý	Qurylym	Izdeý	10	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
socket_summary_by_instance		Sharlaý	Qurylym	Izdeý	256	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
status_by_account		Sharlaý	Qurylym	Izdeý	30 976	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
status_by_host		Sharlaý	Qurylym	Izdeý	30 976	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
status_by_thread		Sharlaý	Qurylym	Izdeý	61 952	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
status_by_user		Sharlaý	Qurylym	Izdeý	30 976	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
table_handles		Sharlaý	Qurylym	Izdeý	1 024	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
table_io_waits_summary_by_index_usage		Sharlaý	Qurylym	Izdeý	8 192	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
table_io_waits_summary_by_table		Sharlaý	Qurylym	Izdeý	4 096	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
table_lock_waits_summary_by_table		Sharlaý	Qurylym	Izdeý	4 096	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
threads		Sharlaý	Qurylym	Izdeý	256	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
users		Sharlaý	Qurylym	Izdeý	128	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
user_defined_functions		Sharlaý	Qurylym	Izdeý	5	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
user_variables_by_thread		Sharlaý	Qurylym	Izdeý	2 560	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
variables_by_thread		Sharlaý	Qurylym	Izdeý	151 296	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
variables_info		Sharlaý	Qurylym	Izdeý	591	PERFORMANCE_SCHEMA	utf8mb4_0900_ai_ci
103 keste	Somasy				4 752 477	InnoDB	utf8mb4_0900_ai_ci

Barlyǵyn belgileý

Derekter sózdigi

phpMyAdmin demo-serveri: Aǵymda master tarmaǵynan RELEASE_5_2_1-4907-g5b04607256 Git túzetýi iske qosylǵan.