demo.phpmyadmin.net / phpMyAdmin demo - MariaDB | phpMyAdmin 6.0.0-dev+20241219.8e721911f0

התאמת תצוגת חלונית הניווט.

חלונית ניווט

הצגת ניווט בין מסדי נתונים כעץ In the navigation panel, replaces the database tree with a selector
קישור ללוח הראשי Link with main panel by highlighting the current database or table.
Display logo הצגת לוגו בחלונית הניווט.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
כמות הפריטים המרבית ברמה הראשונה The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
טבלאות שהיו בשימוש לאחרונה Maximum number of recently used tables; set 0 to disable.
טבלאות מועדפות Maximum number of favorite tables; set 0 to disable.
רוחב לוח ניווט יש להגדיר ל־0 כדי לכווץ את לוח הניווט.

התאמת עץ הניווט.

עץ ניווט

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
הפעלת הרחבת עץ הניווט Whether to offer the possibility of tree expansion in the navigation panel.
הצגת טבלאות בעץ האם להציג טבלאות תחת מסד נתונים בעץ הניווט
הצג תצוגות בעץ האם להציג תצוגות תחת מסד נתונים בעץ הניווט
הצגת פונקציות בעץ Whether to show functions under database in the navigation tree
הצגת תהליכים בעץ Whether to show procedures under database in the navigation tree
הצגת אירועים בעץ האם להציג אירועים תחת מסד הנתונים בעץ הניווט
Expand single database Whether to expand single database in the navigation tree automatically.

אפשרויות הצגת שרתים.

שרתים

Display servers selection Display server choice at the top of the navigation panel.
הצגת שרתים כרשימה הצגת רישום השרתים כרשימה במקום תפריט נגלל.

אפשרויות תצוגת מסדי נתונים.

מסדי נתונים

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

אפשרויות הצגת טבלאות.

טבלאות

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

ניתן להשליך קבצים לכאן

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken:

אין סימניות

Label: Target database: Share this bookmark

תמיד להרחיב הודעות תשאול

הצגת היסטוריית שאילתות בהתחלה

Show current browsing query

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

החלפה לערכת עיצוב כהה

Collapse Expand Requery עריכה Explain Profiling Bookmark Query failed מסד נתונים: Queried time:

Filters

Containing the word:

Show only alert values

Show unformatted values

משתנה	ערך	תיאור
Aborted clients	6 6	The number of connections that were aborted because the client died without closing the connection properly.
Aborted connects	162 162	The number of failed attempts to connect to the MySQL server.
Aborted connects preauth	0 0
Access denied errors	162 162
Acl column grants	29 29
Acl database grants	1 1
Acl function grants	0 0
Acl procedure grants	0 0
Acl package spec grants	0 0
Acl package body grants	0 0
Acl proxy users	2 2
Acl role grants	0 0
Acl roles	0 0
Acl table grants	4 4
Acl users	7 7
Aria pagecache blocks not flushed	0 0
Aria pagecache blocks unused	15.7 k 15706
Aria pagecache blocks used	311 311
Aria pagecache read requests	5.7 M 5658277
Aria pagecache reads	348.4 k 348354
Aria pagecache write requests	718.4 k 718400
Aria pagecache writes	718.4 k 718400
Aria transaction log syncs	344 344
Binlog commits	32.2 k 32214
Binlog group commits	32.2 k 32214
Binlog group commit trigger count	0 0
Binlog group commit trigger lock wait	0 0
Binlog group commit trigger timeout	0 0
Binlog snapshot file	mariadb-bin.000057 mariadb-bin.000057
Binlog snapshot position	24.9 M 24914458
Binlog bytes written	24.9 M 24914786
Binlog cache disk use	0 0	The number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the transaction.
Binlog cache use	32.2 k 32214	The number of transactions that used the temporary binary log cache.
Binlog stmt cache disk use	0 0
Binlog stmt cache use	0 0
Busy time	0 0.000000
Bytes received	868.3 M 868253567
Bytes sent	2.2 G 2193274916
Column compressions	0 0
Column decompressions	0 0
Com admin commands	0 0
Com alter db	0 0
Com alter db upgrade	0 0
Com alter event	0 0
Com alter function	0 0
Com alter procedure	0 0
Com alter server	0 0
Com alter sequence	0 0
Com alter table	0 0
Com alter tablespace	0 0
Com alter user	0 0
Com analyze	0 0
Com assign to keycache	0 0
Com backup	0 0
Com backup lock	0 0
Com begin	0 0
Com binlog	0 0
Com call procedure	0 0
Com change db	246.7 k 246658
Com change master	0 0
Com check	0 0
Com checksum	0 0
Com commit	0 0
Com compound sql	0 0
Com create db	3 3
Com create event	0 0
Com create function	0 0
Com create index	0 0
Com create package	0 0
Com create package body	0 0
Com create procedure	0 0
Com create role	0 0
Com create sequence	0 0
Com create server	0 0
Com create table	3 3
Com create temporary table	0 0
Com create trigger	0 0
Com create udf	0 0
Com create user	0 0
Com create view	0 0
Com delete	72 72
Com delete multi	0 0
Com do	0 0
Com drop db	6 6
Com drop event	0 0
Com drop function	0 0
Com drop index	0 0
Com drop procedure	0 0
Com drop package	0 0
Com drop package body	0 0
Com drop role	0 0
Com drop server	0 0
Com drop sequence	0 0
Com drop table	0 0
Com drop temporary table	0 0
Com drop trigger	0 0
Com drop user	0 0
Com drop view	0 0
Com empty query	0 0
Com execute immediate	0 0
Com flush	4 4
Com get diagnostics	0 0
Com grant	0 0
Com grant role	0 0
Com ha close	0 0
Com ha open	0 0
Com ha read	0 0
Com help	0 0
Com insert	3 3
Com insert select	0 0
Com install plugin	0 0
Com kill	0 0
Com load	0 0
Com lock tables	0 0
Com multi	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	31.7 k 31653
Com replace select	0 0
Com reset	0 0
Com resignal	0 0
Com revoke	0 0
Com revoke all	0 0
Com revoke role	0 0
Com rollback	0 0
Com rollback to savepoint	0 0
Com savepoint	0 0
Com select	6 M 6036595
Com set option	364.3 k 364301
Com show authors	0 0
Com show binlog events	0 0
Com show binlogs	4.6 k 4625
Com show charsets	0 0
Com show collations	0 0
Com show contributors	0 0
Com show create db	0 0
Com show create event	0 0
Com show create func	0 0
Com show create package	0 0
Com show create package body	0 0
Com show create proc	0 0
Com show create table	106.1 k 106117
Com show create trigger	0 0
Com show create user	0 0
Com show databases	52 52
Com show engine logs	0 0
Com show engine mutex	0 0
Com show engine status	4 4
Com show errors	0 0
Com show events	0 0
Com show explain	0 0
Com show fields	339.3 k 339295
Com show function status	0 0
Com show generic	0 0
Com show grants	120.4 k 120389
Com show keys	415.1 k 415076
Com show master status	353 353
Com show open tables	0 0
Com show package status	0 0
Com show package body status	0 0
Com show plugins	0 0
Com show privileges	0 0
Com show procedure status	0 0
Com show processlist	3 3
Com show profile	0 0
Com show profiles	0 0
Com show relaylog events	0 0
Com show slave hosts	0 0
Com show slave status	353 353
Com show status	64 64
Com show storage engines	1.2 k 1178
Com show table status	6.9 k 6852
Com show tables	255.4 k 255405
Com show triggers	0 0
Com show variables	214.2 k 214165
Com show warnings	103.7 k 103671
Com shutdown	0 0
Com signal	0 0
Com start all slaves	0 0
Com start slave	0 0
Com stmt close	794 794
Com stmt execute	794 794
Com stmt fetch	0 0
Com stmt prepare	913 913
Com stmt reprepare	0 0
Com stmt reset	0 0
Com stmt send long data	0 0
Com stop all slaves	0 0
Com stop slave	0 0
Com truncate	0 0
Com uninstall plugin	0 0
Com unlock tables	0 0
Com update	486 486
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
Compression	OFF OFF
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	248.9 k 248897	The number of connection attempts (successful or not) to the MySQL server.
Cpu time	0 0.000000
Created tmp disk tables	375.2 k 375189	The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based.
Created tmp files	5 5	How many temporary files mysqld has created.
Created tmp tables	5.7 M 5670180	The number of in-memory temporary tables created automatically by the server while executing statements.
Delayed errors	0 0	The number of rows written with INSERT DELAYED for which some error occurred (probably duplicate key).
Delayed insert threads	0 0	The number of INSERT DELAYED handler threads in use. Every different table on which one uses INSERT DELAYED gets its own thread.
Delayed writes	0 0	The number of INSERT DELAYED rows written.
Delete scan	24 24
Empty queries	4.2 M 4177829
Executed events	0 0
Executed triggers	0 0
Feature application time periods	0 0
Feature check constraint	0 0
Feature custom aggregate functions	0 0
Feature delay key write	0 0
Feature dynamic columns	0 0
Feature fulltext	0 0
Feature gis	5 5
Feature invisible columns	0 0
Feature json	0 0
Feature locale	115.7 k 115733
Feature subquery	885 885
Feature system versioning	0 0
Feature timezone	0 0
Feature trigger	497 497
Feature window functions	0 0
Feature xml	0 0
Flush commands	1 1	The number of executed FLUSH statements.
Handler commit	130.1 k 130112	The number of internal COMMIT statements.
Handler delete	2 2	The number of times a row was deleted from a table.
Handler discover	52 52	The MySQL server can ask the NDB Cluster storage engine if it knows about a table with a given name. This is called discovery. Handler_discover indicates the number of time tables have been discovered.
Handler external lock	0 0
Handler icp attempts	27 27
Handler icp match	27 27
Handler mrr init	0 0
Handler mrr key refills	0 0
Handler mrr rowid refills	0 0
Handler prepare	64.3 k 64264
Handler read first	126.4 k 126395	The number of times the first entry was read from an index. If this is high, it suggests that the server is doing a lot of full index scans; for example, SELECT col1 FROM foo, assuming that col1 is indexed.
Handler read key	4.1 M 4133810	The number of requests to read a row based on a key. If this is high, it is a good indication that your queries and tables are properly indexed.
Handler read last	0 0
Handler read next	4 M 3977056	The number of requests to read the next row in key order. This is incremented if you are querying an index column with a range constraint or if you are doing an index scan.
Handler read prev	0 0	The number of requests to read the previous row in key order. This read method is mainly used to optimize ORDER BY … DESC.
Handler read retry	0 0
Handler read rnd	2.1 M 2138662	The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
Handler read rnd deleted	123.8 k 123790
Handler read rnd next	87.5 M 87500018	The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.
Handler rollback	0 0	The number of internal ROLLBACK statements.
Handler savepoint	0 0
Handler savepoint rollback	0 0
Handler tmp delete	0 0
Handler tmp update