Aǵymdyq server:
(Serverler) ...
phpMyAdmin demo - MariaDB (root)
phpMyAdmin demo - MySQL (root)
Jýyktaǵy
`sys`.`host_summary`
Tańdaýlylar
Munda tańdaýly kesteler joq.
Jańa
Company
company
COMPENY_BD
Employee
information_schema
maintenance_db
mysql
performance_schema
sys
US_ACADEMY
Vidsoal
web_app
Sharlaý taqtasy
Sharlaý tarmaǵy
Serverler
Derekqorlar
Kesteler
Sharlaý taqtasy
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
).
main
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ǵy
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.
Serverler
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ý.
Derekqorlar
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.
Kesteler
Kestelerdi beıneleý opsıalary.
Kesteler
Jyldam qatynaý beligishesi úshin maqsat
Qurylym
SQL
Izdeý
Kiristirý
Sharlaý
Ekinshi jyldam qatynaý beligishesi úshin maqsat
Qurylym
SQL
Izdeý
Kiristirý
Sharlaý
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
-
Sharlaý tarmaǵynyń jasyryn elementterin kórsetý.
Kórinis jasaý
Sholǵyshyńyzda osy domen úshin phpMyAdmin konfıgýrasıasy bar. Ony aǵymdyq seansqa ımporttaýdy qalaısyz ba?
Ia
/
Joq
/
Parametrlerdi joıý
Osy sátten bastap Javascript qosýly bolýy qajet!
Server: phpMyAdmin demo - MySQL
Derekqor: information_schema
Qurylym
SQL
Izdeý
Saýal
(current)
Eksport
root@192.168.30.%
phpMyAdmin qujattamasy
MySQL documentation
Parametrler
Shyǵý
Konsól
Tazalaý
Tarıh
Opsıalar
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:
Opsıalar
Restore default values
Á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:
Loading
ENUM/SET óńdegishi
Kórinis jasaý
Saýal terezesi
*
CHARACTER_SET_NAME
DEFAULT_COLLATE_NAME
DESCRIPTION
MAXLEN
*
CONSTRAINT_CATALOG
CONSTRAINT_SCHEMA
CONSTRAINT_NAME
CHECK_CLAUSE
*
COLLATION_NAME
CHARACTER_SET_NAME
ID
IS_DEFAULT
IS_COMPILED
SORTLEN
PAD_ATTRIBUTE
*
COLLATION_NAME
CHARACTER_SET_NAME
*
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
ORDINAL_POSITION
COLUMN_DEFAULT
IS_NULLABLE
DATA_TYPE
CHARACTER_MAXIMUM_LENGTH
CHARACTER_OCTET_LENGTH
NUMERIC_PRECISION
NUMERIC_SCALE
DATETIME_PRECISION
CHARACTER_SET_NAME
COLLATION_NAME
COLUMN_TYPE
COLUMN_KEY
EXTRA
PRIVILEGES
COLUMN_COMMENT
GENERATION_EXPRESSION
SRS_ID
*
GRANTEE
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
PRIVILEGE_TYPE
IS_GRANTABLE
*
SCHEMA_NAME
TABLE_NAME
COLUMN_NAME
HISTOGRAM
*
ENGINE
SUPPORT
COMMENT
TRANSACTIONS
XA
SAVEPOINTS
*
EVENT_CATALOG
EVENT_SCHEMA
EVENT_NAME
DEFINER
TIME_ZONE
EVENT_BODY
EVENT_DEFINITION
EVENT_TYPE
EXECUTE_AT
INTERVAL_VALUE
INTERVAL_FIELD
SQL_MODE
STARTS
ENDS
STATUS
ON_COMPLETION
CREATED
LAST_ALTERED
LAST_EXECUTED
EVENT_COMMENT
ORIGINATOR
CHARACTER_SET_CLIENT
COLLATION_CONNECTION
DATABASE_COLLATION
*
FILE_ID
FILE_NAME
FILE_TYPE
TABLESPACE_NAME
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
LOGFILE_GROUP_NAME
LOGFILE_GROUP_NUMBER
ENGINE
FULLTEXT_KEYS
DELETED_ROWS
UPDATE_COUNT
FREE_EXTENTS
TOTAL_EXTENTS
EXTENT_SIZE
INITIAL_SIZE
MAXIMUM_SIZE
AUTOEXTEND_SIZE
CREATION_TIME
LAST_UPDATE_TIME
LAST_ACCESS_TIME
RECOVER_TIME
TRANSACTION_COUNTER
VERSION
ROW_FORMAT
TABLE_ROWS
AVG_ROW_LENGTH
DATA_LENGTH
MAX_DATA_LENGTH
INDEX_LENGTH
DATA_FREE
CREATE_TIME
UPDATE_TIME
CHECK_TIME
CHECKSUM
STATUS
EXTRA
*
POOL_ID
BLOCK_ID
SPACE
PAGE_NUMBER
PAGE_TYPE
FLUSH_TYPE
FIX_COUNT
IS_HASHED
NEWEST_MODIFICATION
OLDEST_MODIFICATION
ACCESS_TIME
TABLE_NAME
INDEX_NAME
NUMBER_RECORDS
DATA_SIZE
COMPRESSED_SIZE
PAGE_STATE
IO_FIX
IS_OLD
FREE_PAGE_CLOCK
*
POOL_ID
LRU_POSITION
SPACE
PAGE_NUMBER
PAGE_TYPE
FLUSH_TYPE
FIX_COUNT
IS_HASHED
NEWEST_MODIFICATION
OLDEST_MODIFICATION
ACCESS_TIME
TABLE_NAME
INDEX_NAME
NUMBER_RECORDS
DATA_SIZE
COMPRESSED_SIZE
COMPRESSED
IO_FIX
IS_OLD
FREE_PAGE_CLOCK
*
POOL_ID
POOL_SIZE
FREE_BUFFERS
DATABASE_PAGES
OLD_DATABASE_PAGES
MODIFIED_DATABASE_PAGES
PENDING_DECOMPRESS
PENDING_READS
PENDING_FLUSH_LRU
PENDING_FLUSH_LIST
PAGES_MADE_YOUNG
PAGES_NOT_MADE_YOUNG
PAGES_MADE_YOUNG_RATE
PAGES_MADE_NOT_YOUNG_RATE
NUMBER_PAGES_READ
NUMBER_PAGES_CREATED
NUMBER_PAGES_WRITTEN
PAGES_READ_RATE
PAGES_CREATE_RATE
PAGES_WRITTEN_RATE
NUMBER_PAGES_GET
HIT_RATE
YOUNG_MAKE_PER_THOUSAND_GETS
NOT_YOUNG_MAKE_PER_THOUSAND_GETS
NUMBER_PAGES_READ_AHEAD
NUMBER_READ_AHEAD_EVICTED
READ_AHEAD_RATE
READ_AHEAD_EVICTED_RATE
LRU_IO_TOTAL
LRU_IO_CURRENT
UNCOMPRESS_TOTAL
UNCOMPRESS_CURRENT
*
SPACE_ID
INDEX_ID
N_CACHED_PAGES
*
page_size
compress_ops
compress_ops_ok
compress_time
uncompress_ops
uncompress_time
*
page_size
buffer_pool_instance
pages_used
pages_free
relocation_ops
relocation_time
*
page_size
buffer_pool_instance
pages_used
pages_free
relocation_ops
relocation_time
*
database_name
table_name
index_name
compress_ops
compress_ops_ok
compress_time
uncompress_ops
uncompress_time
*
database_name
table_name
index_name
compress_ops
compress_ops_ok
compress_time
uncompress_ops
uncompress_time
*
page_size
compress_ops
compress_ops_ok
compress_time
uncompress_ops
uncompress_time
*
TABLE_ID
NAME
POS
MTYPE
PRTYPE
LEN
HAS_DEFAULT
DEFAULT_VALUE
*
SPACE
PATH
*
INDEX_ID
NAME
POS
*
ID
FOR_NAME
REF_NAME
N_COLS
TYPE
*
ID
FOR_COL_NAME
REF_COL_NAME
POS
*
DOC_ID
*
KEY
VALUE
*
value
*
DOC_ID
*
WORD
FIRST_DOC_ID
LAST_DOC_ID
DOC_COUNT
DOC_ID
POSITION
*
WORD
FIRST_DOC_ID
LAST_DOC_ID
DOC_COUNT
DOC_ID
POSITION
*
INDEX_ID
NAME
TABLE_ID
TYPE
N_FIELDS
PAGE_NO
SPACE
MERGE_THRESHOLD
*
NAME
SUBSYSTEM
COUNT
MAX_COUNT
MIN_COUNT
AVG_COUNT
COUNT_RESET
MAX_COUNT_RESET
MIN_COUNT_RESET
AVG_COUNT_RESET
TIME_ENABLED
TIME_DISABLED
TIME_ELAPSED
TIME_RESET
STATUS
TYPE
COMMENT
*
ID
SPACE
PATH
SIZE
STATE
PURPOSE
*
TABLE_ID
NAME
FLAG
N_COLS
SPACE
ROW_FORMAT
ZIP_PAGE_SIZE
SPACE_TYPE
INSTANT_COLS
*
SPACE
NAME
FLAG
ROW_FORMAT
PAGE_SIZE
ZIP_PAGE_SIZE
SPACE_TYPE
FS_BLOCK_SIZE
FILE_SIZE
ALLOCATED_SIZE
SERVER_VERSION
SPACE_VERSION
ENCRYPTION
STATE
*
SPACE
NAME
PATH
FLAG
SPACE_TYPE
*
TABLE_ID
NAME
STATS_INITIALIZED
NUM_ROWS