Serveri aktual:
(Serverat) ...
localhost:3306 (root)
localhost (root)
Të fundit
`sys`.`sys_config`
`performance_schema`.`file_instances`
`performance_schema`.`setup_objects`
`performance_schema`.`setup_consumers`
`sys`.`x$innodb_buffer_stats_by_table`
`performance_schema`.`file_summary_by_instance`
`sys`.`innodb_buffer_stats_by_schema`
`performance_schema`.`setup_instruments`
`performance_schema`.`cond_instances`
`performance_schema`.`mutex_instances`
Preferencat
Nuk ka tabela të preferuara.
E re
hostpanel
information_schema
mysql
performance_schema
phpmyadmin
roundcube
sys
Paneli i navigimit
Pema e navigimit
Serverat
Databazat
Tabela
Paneli i navigimit
Përshtat shfaqjen e panelit të navigimit.
Paneli i navigimit
Shfaq navigimin e databazës si pemë
Në panelin e navigimit, zëvendëso pemën e databazës me një përzgjedhës
Lidh me panelin kryesor
Lidhja me panelin kryesor, duke theksuar databazën aktuale ose tabelën.
Shfaq logo
Shfaq logon në panelin e navigimit.
URL e lidhjes së logos
URL ku logo në panelin e navigimit do të tregojë.
Objektivi i lidhjes së logos
Hap faqen e lidhur në dritaren kryesore (
kryesore
) ose në një të re (
e re
).
main
new
Aftëso theksimin
Thekso serverin nën kursorin e miut.
Maksimumi i njësive në nivelin e parë
Numri i njësive që mund të shfaqet në çdo faqe të nivelit të parë të pemës së navigimit.
Numri minimal i njësive që shfaq kutia e filtrit
Përcakton numrin minimal të njësive (tabela, pamje, rutinat dhe ngjarjet) për të shfaqur një kuti filtri.
Tabelat e përdorura së fundi
Numri maksimal i tabelave të përdorura së fundi; vendos 0 për ta pasivizuar.
Tabelat e preferuara
Numri maksimal i tabelave të preferuara; vëndos 0 për ta pasivizuar.
Navigation panel width
Set to 0 to collapse navigation panel.
Pema e navigimit
Përshtat pemën e navigimit.
Pema e navigimit
Njësitë maksimale në degë
Numri i njësive që mund të shfaqet në çdo faqe të pemës së navigimit.
Njësitë e grupit në pemë
Njësitë e grupit në pemën e navigacionit (të përcaktuar nga ndarës të vendosur në tabelorët e Databazave dhe Tabelave më lart).
Aftëso zgjerimin e navigimit të pemës
Nëse ofron mundësinë e zgjerimit të pemës në panelin e navigimit.
Shfaq tabelën në pemë
Nëse shfaq tabelat nën databazë në pemën e navigimit
Shfaq pamjet në pemë
Nëse shfaq pamjet nën databazë në pemën e navigimit
Shfaq funksionet në pemë
Nëse shfaq funksionet nën databazë në pemën e navigimit
Shfaq procedurat në pemë
Nëse shfaq procedurat nën databazë në pemën e navigimit
Shfaq ngjarjet në pemë
Nëse shfaq ngjarjet nën databazë në pemën e navigimit
Expand single database
Whether to expand single database in the navigation tree automatically.
Serverat
Opsionet e shfaqjes së serverit.
Serverat
Shfaq zgjedhjen e serverave
Shfaq zgjedhjen e serverit në krye të panelit të navigimit.
Shfaq serverat si një listë
Shfaq listën e serverit, si listë në vend të lësho-poshtë.
Databazat
Opsionet e shfaqjes së databazave.
Databazat
Numri minimal i databazave që shfaq kutia e filtrit të databazës
Ndarësi pemë i databazës
Vargu që ndan databazat në nivele të ndryshme të pemës.
Tabela
Opsionet e shfaqjes së tabelës.
Tabela
Objektivi për ikonën e hyrjes së shpejtë
Struktura
SQL
Kërko
Fut
Shfleto
Objektivi për ikonën e dytë të hyrjes së shpejtë
Struktura
SQL
Kërko
Fut
Shfleto
Ndarësi i pemës së tabelës
Vargu që ndan tabelat në nivele të ndryshme të pemës.
Thellësia maksimale e pemës së tabelës
Lësho filet këtu
SQL upload (
0
)
x
-
Shfaq njësitë e fshehta të pemës së navigimit.
Krijo pamje
Javascript duhet të aftësohet për të kaluar këtë pikë!
Serveri: localhost:3306
Databaza: sys
Tabela: sys_config
Shfleto
Struktura
(current)
SQL
Kërko
Eksporti
Konsole
Pastro
Historia
Opsionet
Faqeruajtësit
Debug (rregullo) SQL
Shtyp Ctrl+Enter për të ekzekutuar pyetsorin
Shtyp Enter për të ekzekutuar pyetsorin
ngritëse
zbritëse
Renditja:
Debug (rregullo) SQL
Numri
Ekzekutimi i renditjes
Koha që ka marrë
Renditur sipas:
Grupo pyetsorët
Mos-grupo pyetsorët
Ngushto
Zgjero
Shfaq gjurmën
Fsheh gjurmën
Numri :
Koha që ka marrë :
Faqeruajtësit
Rifresko
Shto
Jo faqeruajtës
Shto faqeruajtës
Etiketë:
Databaza e objektivit:
Ndan këtë faqeruajtës
OK
Opsionet
E paracaktuar
Zgjero gjithmonë mesazhet e pyetsorit
Shfaq historinë e pyetsorit në fillim
Trego pyetjen aktuale të shfletimit
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Kalo tek modeli i errët
Ngushto
Zgjero
Requery (kërkesë)
Redakto
Sqaro
Profilon
Faqeruajtës
Pyetsori dështoi
Databaza :
Koha e pyetsorit :
Loading
Editori ENUM/SET (num/vendos)
Krijo pamje
Struktura e tabelës
Pamje e relacionit
Detyrimet e çelësit të huaj
Veprime
Vetitë e detyrimit
Kolona
Krijimi i një çelës të jashtëm mbi një kolonë të pa indeksuar do të krijonte automatikisht një indeks në të. Përndryshe, mund të përcaktoni një indeks më poshtë, para se të krijohet kyç i huaj.
Kufizo çelësin e huaj (INNODB)
Databaza
Tabela
Kolona
ON DELETE
CASCADE
SET NULL
NO ACTION
RESTRICT
ON UPDATE
CASCADE
SET NULL
NO ACTION
RESTRICT
set_by
set_time
value
variable
+ Shto kolonë
hostpanel
information_schema
mysql
performance_schema
phpmyadmin
roundcube
sys
sys_config
+ Shto detyrim
Marrëdhëniet e brendshme
Marrëdhëniet e brendshme
Kolona
Relacion i brendshëm
Një relacion i brendshëm nuk është i nevojshëm kur ekziston një relacion korrespondues FOREIGN KEY (çelës i huaj).
variable
hostpanel
information_schema
mysql
performance_schema
phpmyadmin
roundcube
sys
host_summary
host_summary_by_file_io
host_summary_by_file_io_type
host_summary_by_stages
host_summary_by_statement_latency
host_summary_by_statement_type
innodb_buffer_stats_by_schema
innodb_buffer_stats_by_table
innodb_lock_waits
io_by_thread_by_latency
io_global_by_file_by_bytes
io_global_by_file_by_latency
io_global_by_wait_by_bytes
io_global_by_wait_by_latency
latest_file_io
memory_by_host_by_current_bytes
memory_by_thread_by_current_bytes
memory_by_user_by_current_bytes
memory_global_by_current_bytes
memory_global_total
metrics
processlist
ps_check_lost_instrumentation
schema_auto_increment_columns
schema_index_statistics
schema_object_overview
schema_redundant_indexes
schema_tables_with_full_table_scans
schema_table_lock_waits
schema_table_statistics
schema_table_statistics_with_buffer
schema_unused_indexes
session
session_ssl_status
statements_with_errors_or_warnings
statements_with_full_table_scans
statements_with_runtimes_in_95th_percentile
statements_with_sorting
statements_with_temp_tables
statement_analysis
sys_config
user_summary
user_summary_by_file_io
user_summary_by_file_io_type
user_summary_by_stages
user_summary_by_statement_latency
user_summary_by_statement_type
version
waits_by_host_by_latency
waits_by_user_by_latency
waits_global_by_latency
wait_classes_global_by_avg_latency
wait_classes_global_by_latency
x$host_summary
x$host_summary_by_file_io
x$host_summary_by_file_io_type
x$host_summary_by_stages
x$host_summary_by_statement_latency
x$host_summary_by_statement_type
x$innodb_buffer_stats_by_schema
x$innodb_buffer_stats_by_table
x$innodb_lock_waits
x$io_by_thread_by_latency
x$io_global_by_file_by_bytes
x$io_global_by_file_by_latency
x$io_global_by_wait_by_bytes
x$io_global_by_wait_by_latency
x$latest_file_io
x$memory_by_host_by_current_bytes
x$memory_by_thread_by_current_bytes
x$memory_by_user_by_current_bytes
x$memory_global_by_current_bytes
x$memory_global_total
x$processlist
x$ps_digest_95th_percentile_by_avg_us
x$ps_digest_avg_latency_distribution
x$ps_schema_table_statistics_io
x$schema_flattened_keys
x$schema_index_statistics
x$schema_tables_with_full_table_scans
x$schema_table_lock_waits
x$schema_table_statistics
x$schema_table_statistics_with_buffer
x$session
x$statements_with_errors_or_warnings
x$statements_with_full_table_scans
x$statements_with_runtimes_in_95th_percentile
x$statements_with_sorting
x$statements_with_temp_tables
x$statement_analysis
x$user_summary
x$user_summary_by_file_io
x$user_summary_by_file_io_type
x$user_summary_by_stages
x$user_summary_by_statement_latency
x$user_summary_by_statement_type
x$waits_by_host_by_latency
x$waits_by_user_by_latency
x$waits_global_by_latency
x$wait_classes_global_by_avg_latency
x$wait_classes_global_by_latency
value
hostpanel
information_schema
mysql
performance_schema
phpmyadmin
roundcube
sys
host_summary
host_summary_by_file_io
host_summary_by_file_io_type
host_summary_by_stages
host_summary_by_statement_latency
host_summary_by_statement_type
innodb_buffer_stats_by_schema
innodb_buffer_stats_by_table
innodb_lock_waits
io_by_thread_by_latency
io_global_by_file_by_bytes
io_global_by_file_by_latency
io_global_by_wait_by_bytes
io_global_by_wait_by_latency
latest_file_io
memory_by_host_by_current_bytes
memory_by_thread_by_current_bytes
memory_by_user_by_current_bytes
memory_global_by_current_bytes
memory_global_total
metrics
processlist
ps_check_lost_instrumentation
schema_auto_increment_columns
schema_index_statistics
schema_object_overview
schema_redundant_indexes
schema_tables_with_full_table_scans
schema_table_lock_waits
schema_table_statistics
schema_table_statistics_with_buffer
schema_unused_indexes
session
session_ssl_status
statements_with_errors_or_warnings
statements_with_full_table_scans
statements_with_runtimes_in_95th_percentile
statements_with_sorting
statements_with_temp_tables
statement_analysis
sys_config
user_summary
user_summary_by_file_io
user_summary_by_file_io_type
user_summary_by_stages
user_summary_by_statement_latency
user_summary_by_statement_type
version
waits_by_host_by_latency
waits_by_user_by_latency
waits_global_by_latency
wait_classes_global_by_avg_latency
wait_classes_global_by_latency
x$host_summary
x$host_summary_by_file_io
x$host_summary_by_file_io_type
x$host_summary_by_stages
x$host_summary_by_statement_latency
x$host_summary_by_statement_type
x$innodb_buffer_stats_by_schema
x$innodb_buffer_stats_by_table
x$innodb_lock_waits
x$io_by_thread_by_latency
x$io_global_by_file_by_bytes
x$io_global_by_file_by_latency
x$io_global_by_wait_by_bytes
x$io_global_by_wait_by_latency
x$latest_file_io
x$memory_by_host_by_current_bytes
x$memory_by_thread_by_current_bytes
x$memory_by_user_by_current_bytes
x$memory_global_by_current_bytes
x$memory_global_total
x$processlist
x$ps_digest_95th_percentile_by_avg_us
x$ps_digest_avg_latency_distribution
x$ps_schema_table_statistics_io
x$schema_flattened_keys
x$schema_index_statistics
x$schema_tables_with_full_table_scans
x$schema_table_lock_waits
x$schema_table_statistics
x$schema_table_statistics_with_buffer
x$session
x$statements_with_errors_or_warnings
x$statements_with_full_table_scans
x$statements_with_runtimes_in_95th_percentile
x$statements_with_sorting
x$statements_with_temp_tables
x$statement_analysis
x$user_summary
x$user_summary_by_file_io
x$user_summary_by_file_io_type
x$user_summary_by_stages
x$user_summary_by_statement_latency
x$user_summary_by_statement_type
x$waits_by_host_by_latency
x$waits_by_user_by_latency
x$waits_global_by_latency
x$wait_classes_global_by_avg_latency
x$wait_classes_global_by_latency
set_time
hostpanel
information_schema
mysql
performance_schema
phpmyadmin
roundcube
sys
host_summary
host_summary_by_file_io
host_summary_by_file_io_type
host_summary_by_stages
host_summary_by_statement_latency
host_summary_by_statement_type
innodb_buffer_stats_by_schema
innodb_buffer_stats_by_table
innodb_lock_waits
io_by_thread_by_latency
io_global_by_file_by_bytes
io_global_by_file_by_latency
io_global_by_wait_by_bytes
io_global_by_wait_by_latency
latest_file_io
memory_by_host_by_current_bytes
memory_by_thread_by_current_bytes
memory_by_user_by_current_bytes
memory_global_by_current_bytes
memory_global_total
metrics
processlist
ps_check_lost_instrumentation
schema_auto_increment_columns
schema_index_statistics
schema_object_overview
schema_redundant_indexes
schema_tables_with_full_table_scans
schema_table_lock_waits
schema_table_statistics
schema_table_statistics_with_buffer
schema_unused_indexes
session
session_ssl_status
statements_with_errors_or_warnings
statements_with_full_table_scans
statements_with_runtimes_in_95th_percentile
statements_with_sorting
statements_with_temp_tables
statement_analysis
sys_config
user_summary
user_summary_by_file_io
user_summary_by_file_io_type
user_summary_by_stages
user_summary_by_statement_latency
user_summary_by_statement_type
version
waits_by_host_by_latency
waits_by_user_by_latency
waits_global_by_latency
wait_classes_global_by_avg_latency
wait_classes_global_by_latency
x$host_summary
x$host_summary_by_file_io
x$host_summary_by_file_io_type
x$host_summary_by_stages
x$host_summary_by_statement_latency
x$host_summary_by_statement_type
x$innodb_buffer_stats_by_schema
x$innodb_buffer_stats_by_table
x$innodb_lock_waits
x$io_by_thread_by_latency
x$io_global_by_file_by_bytes
x$io_global_by_file_by_latency
x$io_global_by_wait_by_bytes
x$io_global_by_wait_by_latency
x$latest_file_io
x$memory_by_host_by_current_bytes
x$memory_by_thread_by_current_bytes
x$memory_by_user_by_current_bytes
x$memory_global_by_current_bytes
x$memory_global_total
x$processlist
x$ps_digest_95th_percentile_by_avg_us
x$ps_digest_avg_latency_distribution
x$ps_schema_table_statistics_io
x$schema_flattened_keys
x$schema_index_statistics
x$schema_tables_with_full_table_scans
x$schema_table_lock_waits
x$schema_table_statistics
x$schema_table_statistics_with_buffer
x$session
x$statements_with_errors_or_warnings
x$statements_with_full_table_scans
x$statements_with_runtimes_in_95th_percentile
x$statements_with_sorting
x$statements_with_temp_tables
x$statement_analysis
x$user_summary
x$user_summary_by_file_io
x$user_summary_by_file_io_type
x$user_summary_by_stages
x$user_summary_by_statement_latency
x$user_summary_by_statement_type
x$waits_by_host_by_latency
x$waits_by_user_by_latency
x$waits_global_by_latency
x$wait_classes_global_by_avg_latency
x$wait_classes_global_by_latency
set_by
hostpanel
information_schema
mysql
performance_schema
phpmyadmin
roundcube
sys
host_summary
host_summary_by_file_io
host_summary_by_file_io_type
host_summary_by_stages
host_summary_by_statement_latency
host_summary_by_statement_type
innodb_buffer_stats_by_schema
innodb_buffer_stats_by_table
innodb_lock_waits
io_by_thread_by_latency
io_global_by_file_by_bytes
io_global_by_file_by_latency
io_global_by_wait_by_bytes
io_global_by_wait_by_latency
latest_file_io
memory_by_host_by_current_bytes
memory_by_thread_by_current_bytes
memory_by_user_by_current_bytes
memory_global_by_current_bytes
memory_global_total
metrics
processlist
ps_check_lost_instrumentation
schema_auto_increment_columns
schema_index_statistics
schema_object_overview
schema_redundant_indexes
schema_tables_with_full_table_scans
schema_table_lock_waits
schema_table_statistics
schema_table_statistics_with_buffer
schema_unused_indexes
session
session_ssl_status
statements_with_errors_or_warnings
statements_with_full_table_scans
statements_with_runtimes_in_95th_percentile
statements_with_sorting
statements_with_temp_tables
statement_analysis
sys_config
user_summary
user_summary_by_file_io
user_summary_by_file_io_type
user_summary_by_stages
user_summary_by_statement_latency
user_summary_by_statement_type
version
waits_by_host_by_latency
waits_by_user_by_latency
waits_global_by_latency
wait_classes_global_by_avg_latency
wait_classes_global_by_latency
x$host_summary
x$host_summary_by_file_io
x$host_summary_by_file_io_type
x$host_summary_by_stages
x$host_summary_by_statement_latency
x$host_summary_by_statement_type
x$innodb_buffer_stats_by_schema
x$innodb_buffer_stats_by_table
x$innodb_lock_waits
x$io_by_thread_by_latency
x$io_global_by_file_by_bytes
x$io_global_by_file_by_latency
x$io_global_by_wait_by_bytes
x$io_global_by_wait_by_latency
x$latest_file_io
x$memory_by_host_by_current_bytes
x$memory_by_thread_by_current_bytes
x$memory_by_user_by_current_bytes
x$memory_global_by_current_bytes
x$memory_global_total
x$processlist
x$ps_digest_95th_percentile_by_avg_us
x$ps_digest_avg_latency_distribution
x$ps_schema_table_statistics_io
x$schema_flattened_keys
x$schema_index_statistics
x$schema_tables_with_full_table_scans
x$schema_table_lock_waits
x$schema_table_statistics
x$schema_table_statistics_with_buffer
x$session
x$statements_with_errors_or_warnings
x$statements_with_full_table_scans
x$statements_with_runtimes_in_95th_percentile
x$statements_with_sorting
x$statements_with_temp_tables
x$statement_analysis
x$user_summary
x$user_summary_by_file_io
x$user_summary_by_file_io_type
x$user_summary_by_stages
x$user_summary_by_statement_latency
x$user_summary_by_statement_type
x$waits_by_host_by_latency
x$waits_by_user_by_latency
x$waits_global_by_latency
x$wait_classes_global_by_avg_latency
x$wait_classes_global_by_latency
Zgjedh kolonën për të shfaqur:
---
variable
value
set_time
set_by
Loading