현재 서버:
(서버) ...
phpMyAdmin demo - MariaDB (root)
phpMyAdmin demo - MySQL (root)
최근
`phpmyadmin`.`pma__users`
`bd_ventas`.`Vendedor`
`Bant`.`Registration`
`phpmyadmin`.`pma__usergroups`
`buku tamu`.`Buku Tamu`
`bd_ventas`.`Producto`
`mysql`.`columns_priv`
`performance_schema`.`events_statements_summary_by_digest`
`mysql`.`table_stats`
`phpmyadmin`.`pma__bookmark`
즐겨찾기
즐겨찾기 테이블이 없습니다.
새로운
Bant
bd_ventas
buku tamu
comapany
Gimnasio
information_schema
mysql
performance_schema
phpmyadmin
내비게이션 패널
내비게이션 트리
서버
데이터베이스
테이블
내비게이션 패널
내비게이션 패널 모양 설정.
내비게이션 패널
데이터베이스 내비게이션을 트리로 보기
내비게이션 패널에서, 데이터베이스 선택 방식을 트리 형태로 바꿉니다
매인 패널에 링크
현재 데이터베이스 또는 테이블을 강조 표시하여 기본 패널과 연결하십시오.
로고 출력
탐색 패널에 로고를 보여줌.
로고 링크 URL
탐색 패널의 로고가 가리키는 URL.
로고 링크 타겟
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
강조 표시 사용
마우스 커서 아래의 서버를 강조 표시.
첫번째 단계에서 최대 아이템 갯수
탐색 트리 첫번째 단계에서 페이지 당 보여질 아이템 수.
필터 박스에 표시할 최소 아이템 개수
필터 박스에 표시할 아이템(테이블, 뷰, 루틴, 이벤트)의 최소 개수를 정의.
최근 사용한 테이블
최근 사용한 테이블 최대 개수; 0이면 이 기능 사용 안 함.
즐겨찾기 테이블
즐겨찾기 테이블 최대 개수; 0이면 이 기능 사용 안 함.
Navigation panel width
Set to 0 to collapse navigation panel.
내비게이션 트리
내비게이션 트리 사용자화.
내비게이션 트리
브렌치 당 최대 아이템 갯수
탐색 트리에서 페이지 당 보여질 아이템 수.
트리의 그룹 아이템
내비게이션 트리의 그룹 아이템 (위쪽 '데이터베이스와 테이블' 탭에서 정의한 구분자로 구분).
내비게이션 트리 확장 사용
내비게이션 패널에서 트리 확장을 가능하게 할 지 설정합니다.
트리에 테이블 표시
내비게이션 트리에 테이블 안에 있는 데이터베이스를 표시할 지 설정합니다
트리에 뷰 보기
내비게이션 트리에 데이터베이스 안의 뷰를 보일지 설정합니다
트리에 기능 보이기
내비게이션 트리에 데이터베이스에서 사용 가능한 기능을 보일지 설정합니다
트리에 프로시저 보이기
탐색 트리의 데이터베이스 아래에 프로시저를 표시할지 여부
트리에 이벤트 보이기
내비게이션 트리에서 데이터베이스의 이벤트를 보일지 설정합니다
Expand single database
Whether to expand single database in the navigation tree automatically.
서버
서버보기 옵션.
서버
서버 선택 출력
네비게이션 패널 맨 위에 서버 선택 메뉴를 표시.
서버들을 목록으로 표시
서버 목록을 목록 형태로 출력(드롭 다운 사용 안 함).
데이터베이스
데이터베이스 표시 옵션.
데이터베이스
데이터베이스 필터 박스에 표시할 최소 데이터베이스 수
데이터베이스 트리 구분자
데이터베이스를 서로 다른 트리 레벨로 구분하기 위한 문자열.
테이블
테이블보기 옵션.
테이블
빠른 접근 아이콘 대상
구조
SQL
검색
삽입
보기
두 번째 빠른 접근 아이콘 대상
구조
SQL
검색
삽입
보기
테이블 트리 구분자
테이블을 서로 다른 트리 레벨로 구분하기 위한 문자열.
테이블 트리의 최대 깊이(depth)
파일을 여기로 끌어오세요
SQL upload (
0
)
x
-
숨겨진 탐색 트리의 항목보기.
이 페이지를 넘기려면 Javascript 사용을 허용해야 합니다!
서버: phpMyAdmin demo - MariaDB
데이터베이스: performance_schema
구조
SQL
검색
질의 마법사
(현재)
내보내기
콘솔
제거
최근 기록
옵션
북마크
SQL 디버그
Ctrl+Enter를 눌러 쿼리를 실행
Enter를 눌러 쿼리를 실행
오름차순
내림차순
순서:
SQL 디버그
개수
실행 순서
소요 시간
정렬 순서:
그룹 질의
그룹 해제 질의
접기
펼치기
추적 보기
추적 숨기기
개수
소요 시간
북마크
다시 보기
추가
북마크 없음
북마크 추가
레이블:
대상 데이터베이스:
이 북마크를 공유
확인
옵션
기본값으로 초기화
항상 질의 메시지를 확장
시작할 때 질의 기록을 보여주기
현재 탐색 중인 쿼리 보기
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
어두운 테마로 변경
접기
펼치기
다시 쿼리하기
수정
설명
프로파일링
북마크
질의 실패
데이터베이스:
질의 실행 시간:
Loading
ENUM/SET 수정
뷰 생성
암호 변경
Multi-table query
Query by example
질의 창
*
USER
HOST
CURRENT_CONNECTIONS
TOTAL_CONNECTIONS
*
NAME
OBJECT_INSTANCE_BEGIN
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
NESTING_EVENT_ID
NESTING_EVENT_TYPE
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
NESTING_EVENT_ID
NESTING_EVENT_TYPE
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
NESTING_EVENT_ID
NESTING_EVENT_TYPE
*
USER
HOST
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
HOST
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
THREAD_ID
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
USER
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
LOCK_TIME
SQL_TEXT
DIGEST
DIGEST_TEXT
CURRENT_SCHEMA
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
OBJECT_INSTANCE_BEGIN
MYSQL_ERRNO
RETURNED_SQLSTATE
MESSAGE_TEXT
ERRORS
WARNINGS
ROWS_AFFECTED
ROWS_SENT
ROWS_EXAMINED
CREATED_TMP_DISK_TABLES
CREATED_TMP_TABLES
SELECT_FULL_JOIN
SELECT_FULL_RANGE_JOIN
SELECT_RANGE
SELECT_RANGE_CHECK
SELECT_SCAN
SORT_MERGE_PASSES
SORT_RANGE
SORT_ROWS
SORT_SCAN
NO_INDEX_USED
NO_GOOD_INDEX_USED
NESTING_EVENT_ID
NESTING_EVENT_TYPE
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
LOCK_TIME
SQL_TEXT
DIGEST
DIGEST_TEXT
CURRENT_SCHEMA
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
OBJECT_INSTANCE_BEGIN
MYSQL_ERRNO
RETURNED_SQLSTATE
MESSAGE_TEXT
ERRORS
WARNINGS
ROWS_AFFECTED
ROWS_SENT
ROWS_EXAMINED
CREATED_TMP_DISK_TABLES
CREATED_TMP_TABLES
SELECT_FULL_JOIN
SELECT_FULL_RANGE_JOIN
SELECT_RANGE
SELECT_RANGE_CHECK
SELECT_SCAN
SORT_MERGE_PASSES
SORT_RANGE
SORT_ROWS
SORT_SCAN
NO_INDEX_USED
NO_GOOD_INDEX_USED
NESTING_EVENT_ID
NESTING_EVENT_TYPE
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
LOCK_TIME
SQL_TEXT
DIGEST
DIGEST_TEXT
CURRENT_SCHEMA
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
OBJECT_INSTANCE_BEGIN
MYSQL_ERRNO
RETURNED_SQLSTATE
MESSAGE_TEXT
ERRORS
WARNINGS
ROWS_AFFECTED
ROWS_SENT
ROWS_EXAMINED
CREATED_TMP_DISK_TABLES
CREATED_TMP_TABLES
SELECT_FULL_JOIN
SELECT_FULL_RANGE_JOIN
SELECT_RANGE
SELECT_RANGE_CHECK
SELECT_SCAN
SORT_MERGE_PASSES
SORT_RANGE
SORT_ROWS
SORT_SCAN
NO_INDEX_USED
NO_GOOD_INDEX_USED
NESTING_EVENT_ID
NESTING_EVENT_TYPE
*
USER
HOST
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
SUM_LOCK_TIME
SUM_ERRORS
SUM_WARNINGS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_DISK_TABLES
SUM_CREATED_TMP_TABLES
SUM_SELECT_FULL_JOIN
SUM_SELECT_FULL_RANGE_JOIN
SUM_SELECT_RANGE
SUM_SELECT_RANGE_CHECK
SUM_SELECT_SCAN
SUM_SORT_MERGE_PASSES
SUM_SORT_RANGE
SUM_SORT_ROWS
SUM_SORT_SCAN
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
*
SCHEMA_NAME
DIGEST
DIGEST_TEXT
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
SUM_LOCK_TIME
SUM_ERRORS
SUM_WARNINGS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_DISK_TABLES
SUM_CREATED_TMP_TABLES
SUM_SELECT_FULL_JOIN
SUM_SELECT_FULL_RANGE_JOIN
SUM_SELECT_RANGE
SUM_SELECT_RANGE_CHECK
SUM_SELECT_SCAN
SUM_SORT_MERGE_PASSES
SUM_SORT_RANGE
SUM_SORT_ROWS
SUM_SORT_SCAN
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
FIRST_SEEN
LAST_SEEN
*
HOST
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
SUM_LOCK_TIME
SUM_ERRORS
SUM_WARNINGS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_DISK_TABLES
SUM_CREATED_TMP_TABLES
SUM_SELECT_FULL_JOIN
SUM_SELECT_FULL_RANGE_JOIN
SUM_SELECT_RANGE
SUM_SELECT_RANGE_CHECK
SUM_SELECT_SCAN
SUM_SORT_MERGE_PASSES
SUM_SORT_RANGE
SUM_SORT_ROWS
SUM_SORT_SCAN
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
*
THREAD_ID
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
SUM_LOCK_TIME
SUM_ERRORS
SUM_WARNINGS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_DISK_TABLES
SUM_CREATED_TMP_TABLES
SUM_SELECT_FULL_JOIN
SUM_SELECT_FULL_RANGE_JOIN
SUM_SELECT_RANGE
SUM_SELECT_RANGE_CHECK
SUM_SELECT_SCAN
SUM_SORT_MERGE_PASSES
SUM_SORT_RANGE
SUM_SORT_ROWS
SUM_SORT_SCAN
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
*
USER
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
SUM_LOCK_TIME
SUM_ERRORS
SUM_WARNINGS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_DISK_TABLES
SUM_CREATED_TMP_TABLES
SUM_SELECT_FULL_JOIN
SUM_SELECT_FULL_RANGE_JOIN
SUM_SELECT_RANGE
SUM_SELECT_RANGE_CHECK
SUM_SELECT_SCAN
SUM_SORT_MERGE_PASSES
SUM_SORT_RANGE
SUM_SORT_ROWS
SUM_SORT_SCAN
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
*
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
SUM_LOCK_TIME
SUM_ERRORS
SUM_WARNINGS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_DISK_TABLES
SUM_CREATED_TMP_TABLES
SUM_SELECT_FULL_JOIN
SUM_SELECT_FULL_RANGE_JOIN
SUM_SELECT_RANGE
SUM_SELECT_RANGE_CHECK
SUM_SELECT_SCAN
SUM_SORT_MERGE_PASSES
SUM_SORT_RANGE
SUM_SORT_ROWS
SUM_SORT_SCAN
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
SPINS
OBJECT_SCHEMA
OBJECT_NAME
INDEX_NAME
OBJECT_TYPE
OBJECT_INSTANCE_BEGIN
NESTING_EVENT_ID
NESTING_EVENT_TYPE
OPERATION
NUMBER_OF_BYTES
FLAGS
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
SPINS
OBJECT_SCHEMA
OBJECT_NAME
INDEX_NAME
OBJECT_TYPE
OBJECT_INSTANCE_BEGIN
NESTING_EVENT_ID
NESTING_EVENT_TYPE
OPERATION
NUMBER_OF_BYTES
FLAGS
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
SPINS
OBJECT_SCHEMA
OBJECT_NAME
INDEX_NAME
OBJECT_TYPE
OBJECT_INSTANCE_BEGIN
NESTING_EVENT_ID
NESTING_EVENT_TYPE
OPERATION
NUMBER_OF_BYTES
FLAGS
*
USER
HOST
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
HOST
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
EVENT_NAME
OBJECT_INSTANCE_BEGIN
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
THREAD_ID
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
USER
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
FILE_NAME
EVENT_NAME
OPEN_COUNT
*
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ
SUM_TIMER_READ
MIN_TIMER_READ
AVG_TIMER_READ
MAX_TIMER_READ
SUM_NUMBER_OF_BYTES_READ
COUNT_WRITE
SUM_TIMER_WRITE
MIN_TIMER_WRITE
AVG_TIMER_WRITE
MAX_TIMER_WRITE
SUM_NUMBER_OF_BYTES_WRITE
COUNT_MISC
SUM_TIMER_MISC
MIN_TIMER_MISC
AVG_TIMER_MISC
MAX_TIMER_MISC
*
FILE_NAME
EVENT_NAME
OBJECT_INSTANCE_BEGIN
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ
SUM_TIMER_READ
MIN_TIMER_READ
AVG_TIMER_READ
MAX_TIMER_READ
SUM_NUMBER_OF_BYTES_READ
COUNT_WRITE
SUM_TIMER_WRITE
MIN_TIMER_WRITE
AVG_TIMER_WRITE
MAX_TIMER_WRITE
SUM_NUMBER_OF_BYTES_WRITE
COUNT_MISC
SUM_TIMER_MISC
MIN_TIMER_MISC
AVG_TIMER_MISC
MAX_TIMER_MISC
*
HOST
CURRENT_CONNECTIONS
TOTAL_CONNECTIONS
*
IP
HOST
HOST_VALIDATED
SUM_CONNECT_ERRORS
COUNT_HOST_BLOCKED_ERRORS
COUNT_NAMEINFO_TRANSIENT_ERRORS
COUNT_NAMEINFO_PERMANENT_ERRORS
COUNT_FORMAT_ERRORS
COUNT_ADDRINFO_TRANSIENT_ERRORS
COUNT_ADDRINFO_PERMANENT_ERRORS
COUNT_FCRDNS_ERRORS
COUNT_HOST_ACL_ERRORS
COUNT_NO_AUTH_PLUGIN_ERRORS
COUNT_AUTH_PLUGIN_ERRORS
COUNT_HANDSHAKE_ERRORS
COUNT_PROXY_USER_ERRORS
COUNT_PROXY_USER_ACL_ERRORS
COUNT_AUTHENTICATION_ERRORS
COUNT_SSL_ERRORS
COUNT_MAX_USER_CONNECTIONS_ERRORS
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS
COUNT_DEFAULT_DATABASE_ERRORS
COUNT_INIT_CONNECT_ERRORS
COUNT_LOCAL_ERRORS
COUNT_UNKNOWN_ERRORS
FIRST_SEEN
LAST_SEEN
FIRST_ERROR_SEEN
LAST_ERROR_SEEN
*
NAME
OBJECT_INSTANCE_BEGIN
LOCKED_BY_THREAD_ID
*
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
TIMER_NAME
TIMER_FREQUENCY
TIMER_RESOLUTION
TIMER_OVERHEAD
*
NAME
OBJECT_INSTANCE_BEGIN
WRITE_LOCKED_BY_THREAD_ID
READ_LOCKED_BY_COUNT
*
PROCESSLIST_ID
ATTR_NAME
ATTR_VALUE
ORDINAL_POSITION
*
PROCESSLIST_ID
ATTR_NAME
ATTR_VALUE
ORDINAL_POSITION
*
HOST
USER
ROLE
*
NAME
ENABLED
*
NAME
ENABLED
TIMED
*
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
ENABLED
TIMED
*
NAME
TIMER_NAME
*
EVENT_NAME
OBJECT_INSTANCE_BEGIN
THREAD_ID
SOCKET_ID
IP
PORT
STATE
*
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ
SUM_TIMER_READ
MIN_TIMER_READ
AVG_TIMER_READ
MAX_TIMER_READ
SUM_NUMBER_OF_BYTES_READ
COUNT_WRITE
SUM_TIMER_WRITE
MIN_TIMER_WRITE
AVG_TIMER_WRITE
MAX_TIMER_WRITE
SUM_NUMBER_OF_BYTES_WRITE
COUNT_MISC
SUM_TIMER_MISC
MIN_TIMER_MISC
AVG_TIMER_MISC
MAX_TIMER_MISC
*
EVENT_NAME
OBJECT_INSTANCE_BEGIN
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ
SUM_TIMER_READ
MIN_TIMER_READ
AVG_TIMER_READ
MAX_TIMER_READ
SUM_NUMBER_OF_BYTES_READ
COUNT_WRITE
SUM_TIMER_WRITE
MIN_TIMER_WRITE
AVG_TIMER_WRITE
MAX_TIMER_WRITE
SUM_NUMBER_OF_BYTES_WRITE
COUNT_MISC
SUM_TIMER_MISC
MIN_TIMER_MISC
AVG_TIMER_MISC
MAX_TIMER_MISC
*
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
INDEX_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ
SUM_TIMER_READ
MIN_TIMER_READ
AVG_TIMER_READ
MAX_TIMER_READ
COUNT_WRITE
SUM_TIMER_WRITE
MIN_TIMER_WRITE
AVG_TIMER_WRITE
MAX_TIMER_WRITE
COUNT_FETCH
SUM_TIMER_FETCH
MIN_TIMER_FETCH
AVG_TIMER_FETCH
MAX_TIMER_FETCH
COUNT_INSERT
SUM_TIMER_INSERT
MIN_TIMER_INSERT
AVG_TIMER_INSERT
MAX_TIMER_INSERT
COUNT_UPDATE
SUM_TIMER_UPDATE
MIN_TIMER_UPDATE
AVG_TIMER_UPDATE
MAX_TIMER_UPDATE
COUNT_DELETE
SUM_TIMER_DELETE
MIN_TIMER_DELETE
AVG_TIMER_DELETE
MAX_TIMER_DELETE
*
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ
SUM_TIMER_READ
MIN_TIMER_READ
AVG_TIMER_READ
MAX_TIMER_READ
COUNT_WRITE
SUM_TIMER_WRITE
MIN_TIMER_WRITE
AVG_TIMER_WRITE
MAX_TIMER_WRITE
COUNT_FETCH
SUM_TIMER_FETCH
MIN_TIMER_FETCH
AVG_TIMER_FETCH
MAX_TIMER_FETCH
COUNT_INSERT
SUM_TIMER_INSERT
MIN_TIMER_INSERT
AVG_TIMER_INSERT
MAX_TIMER_INSERT
COUNT_UPDATE
SUM_TIMER_UPDATE
MIN_TIMER_UPDATE
AVG_TIMER_UPDATE
MAX_TIMER_UPDATE
COUNT_DELETE
SUM_TIMER_DELETE
MIN_TIMER_DELETE
AVG_TIMER_DELETE
MAX_TIMER_DELETE
*
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ
SUM_TIMER_READ
MIN_TIMER_READ
AVG_TIMER_READ
MAX_TIMER_READ
COUNT_WRITE
SUM_TIMER_WRITE
MIN_TIMER_WRITE
AVG_TIMER_WRITE
MAX_TIMER_WRITE
COUNT_READ_NORMAL
SUM_TIMER_READ_NORMAL
MIN_TIMER_READ_NORMAL
AVG_TIMER_READ_NORMAL
MAX_TIMER_READ_NORMAL
COUNT_READ_WITH_SHARED_LOCKS
SUM_TIMER_READ_WITH_SHARED_LOCKS
MIN_TIMER_READ_WITH_SHARED_LOCKS
AVG_TIMER_READ_WITH_SHARED_LOCKS
MAX_TIMER_READ_WITH_SHARED_LOCKS
COUNT_READ_HIGH_PRIORITY
SUM_TIMER_READ_HIGH_PRIORITY
MIN_TIMER_READ_HIGH_PRIORITY
AVG_TIMER_READ_HIGH_PRIORITY
MAX_TIMER_READ_HIGH_PRIORITY
COUNT_READ_NO_INSERT
SUM_TIMER_READ_NO_INSERT
MIN_TIMER_READ_NO_INSERT
AVG_TIMER_READ_NO_INSERT
MAX_TIMER_READ_NO_INSERT
COUNT_READ_EXTERNAL
SUM_TIMER_READ_EXTERNAL
MIN_TIMER_READ_EXTERNAL
AVG_TIMER_READ_EXTERNAL
MAX_TIMER_READ_EXTERNAL
COUNT_WRITE_ALLOW_WRITE
SUM_TIMER_WRITE_ALLOW_WRITE
MIN_TIMER_WRITE_ALLOW_WRITE
AVG_TIMER_WRITE_ALLOW_WRITE
MAX_TIMER_WRITE_ALLOW_WRITE
COUNT_WRITE_CONCURRENT_INSERT
SUM_TIMER_WRITE_CONCURRENT_INSERT
MIN_TIMER_WRITE_CONCURRENT_INSERT
AVG_TIMER_WRITE_CONCURRENT_INSERT
MAX_TIMER_WRITE_CONCURRENT_INSERT
COUNT_WRITE_DELAYED
SUM_TIMER_WRITE_DELAYED
MIN_TIMER_WRITE_DELAYED
AVG_TIMER_WRITE_DELAYED
MAX_TIMER_WRITE_DELAYED
COUNT_WRITE_LOW_PRIORITY
SUM_TIMER_WRITE_LOW_PRIORITY
MIN_TIMER_WRITE_LOW_PRIORITY
AVG_TIMER_WRITE_LOW_PRIORITY
MAX_TIMER_WRITE_LOW_PRIORITY
COUNT_WRITE_NORMAL
SUM_TIMER_WRITE_NORMAL
MIN_TIMER_WRITE_NORMAL
AVG_TIMER_WRITE_NORMAL
MAX_TIMER_WRITE_NORMAL
COUNT_WRITE_EXTERNAL
SUM_TIMER_WRITE_EXTERNAL
MIN_TIMER_WRITE_EXTERNAL
AVG_TIMER_WRITE_EXTERNAL
MAX_TIMER_WRITE_EXTERNAL
*
THREAD_ID
NAME
TYPE
PROCESSLIST_ID
PROCESSLIST_USER
PROCESSLIST_HOST
PROCESSLIST_DB
PROCESSLIST_COMMAND
PROCESSLIST_TIME
PROCESSLIST_STATE
PROCESSLIST_INFO
PARENT_THREAD_ID
ROLE
INSTRUMENTED
*
USER
CURRENT_CONNECTIONS
TOTAL_CONNECTIONS
select table
accounts
cond_instances
events_stages_current
events_stages_history
events_stages_history_long
events_stages_summary_by_account_by_event_name
events_stages_summary_by_host_by_event_name
events_stages_summary_by_thread_by_event_name
events_stages_summary_by_user_by_event_name
events_stages_summary_global_by_event_name
events_statements_current
events_statements_history
events_statements_history_long
events_statements_summary_by_account_by_event_name
events_statements_summary_by_digest
events_statements_summary_by_host_by_event_name
events_statements_summary_by_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_summary_global_by_event_name
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_account_by_event_name
events_waits_summary_by_host_by_event_name
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_by_user_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
hosts
host_cache
mutex_instances
objects_summary_global_by_type
performance_timers
rwlock_instances
session_account_connect_attrs
session_connect_attrs
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_timers
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
users
.
select column
보기
criteria
정렬
오름차순
내림차순
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
텍스트
Another column
select table
accounts
cond_instances
events_stages_current
events_stages_history
events_stages_history_long
events_stages_summary_by_account_by_event_name
events_stages_summary_by_host_by_event_name
events_stages_summary_by_thread_by_event_name
events_stages_summary_by_user_by_event_name
events_stages_summary_global_by_event_name
events_statements_current
events_statements_history
events_statements_history_long
events_statements_summary_by_account_by_event_name
events_statements_summary_by_digest
events_statements_summary_by_host_by_event_name
events_statements_summary_by_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_summary_global_by_event_name
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_account_by_event_name
events_waits_summary_by_host_by_event_name
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_by_user_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
hosts
host_cache
mutex_instances
objects_summary_global_by_type
performance_timers
rwlock_instances
session_account_connect_attrs
session_connect_attrs
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_timers
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
users
.
select column
select table
accounts
cond_instances
events_stages_current
events_stages_history
events_stages_history_long
events_stages_summary_by_account_by_event_name
events_stages_summary_by_host_by_event_name
events_stages_summary_by_thread_by_event_name
events_stages_summary_by_user_by_event_name
events_stages_summary_global_by_event_name
events_statements_current
events_statements_history
events_statements_history_long
events_statements_summary_by_account_by_event_name
events_statements_summary_by_digest
events_statements_summary_by_host_by_event_name
events_statements_summary_by_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_summary_global_by_event_name
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_account_by_event_name
events_waits_summary_by_host_by_event_name
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_by_user_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
hosts
host_cache
mutex_instances
objects_summary_global_by_type
performance_timers
rwlock_instances
session_account_connect_attrs
session_connect_attrs
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_timers
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
users
.
select column
보기
criteria
정렬
오름차순
내림차순
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
텍스트
Another column
select table
accounts
cond_instances
events_stages_current
events_stages_history
events_stages_history_long
events_stages_summary_by_account_by_event_name
events_stages_summary_by_host_by_event_name
events_stages_summary_by_thread_by_event_name
events_stages_summary_by_user_by_event_name
events_stages_summary_global_by_event_name
events_statements_current
events_statements_history
events_statements_history_long
events_statements_summary_by_account_by_event_name
events_statements_summary_by_digest
events_statements_summary_by_host_by_event_name
events_statements_summary_by_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_summary_global_by_event_name
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_account_by_event_name
events_waits_summary_by_host_by_event_name
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_by_user_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
hosts
host_cache
mutex_instances
objects_summary_global_by_type
performance_timers
rwlock_instances
session_account_connect_attrs
session_connect_attrs
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_timers
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
users
.
select column
select table
accounts
cond_instances
events_stages_current
events_stages_history
events_stages_history_long
events_stages_summary_by_account_by_event_name
events_stages_summary_by_host_by_event_name
events_stages_summary_by_thread_by_event_name
events_stages_summary_by_user_by_event_name
events_stages_summary_global_by_event_name
events_statements_current
events_statements_history
events_statements_history_long
events_statements_summary_by_account_by_event_name
events_statements_summary_by_digest
events_statements_summary_by_host_by_event_name
events_statements_summary_by_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_summary_global_by_event_name
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_account_by_event_name
events_waits_summary_by_host_by_event_name
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_by_user_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
hosts
host_cache
mutex_instances
objects_summary_global_by_type
performance_timers
rwlock_instances
session_account_connect_attrs
session_connect_attrs
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_timers
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
users
.
select column
보기
criteria
정렬
오름차순
내림차순
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
텍스트
Another column
select table
accounts
cond_instances
events_stages_current
events_stages_history
events_stages_history_long
events_stages_summary_by_account_by_event_name
events_stages_summary_by_host_by_event_name
events_stages_summary_by_thread_by_event_name
events_stages_summary_by_user_by_event_name
events_stages_summary_global_by_event_name
events_statements_current
events_statements_history
events_statements_history_long
events_statements_summary_by_account_by_event_name
events_statements_summary_by_digest
events_statements_summary_by_host_by_event_name
events_statements_summary_by_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_summary_global_by_event_name
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_account_by_event_name
events_waits_summary_by_host_by_event_name
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_by_user_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
hosts
host_cache
mutex_instances
objects_summary_global_by_type
performance_timers
rwlock_instances
session_account_connect_attrs
session_connect_attrs
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_timers
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
users
.
select column
select table
accounts
cond_instances
events_stages_current
events_stages_history
events_stages_history_long
events_stages_summary_by_account_by_event_name
events_stages_summary_by_host_by_event_name
events_stages_summary_by_thread_by_event_name
events_stages_summary_by_user_by_event_name
events_stages_summary_global_by_event_name
events_statements_current
events_statements_history
events_statements_history_long
events_statements_summary_by_account_by_event_name
events_statements_summary_by_digest
events_statements_summary_by_host_by_event_name
events_statements_summary_by_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_summary_global_by_event_name
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_account_by_event_name
events_waits_summary_by_host_by_event_name
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_by_user_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
hosts
host_cache
mutex_instances
objects_summary_global_by_type
performance_timers
rwlock_instances
session_account_connect_attrs
session_connect_attrs
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_timers
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
users
.
select column
보기
criteria
정렬
오름차순
내림차순
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
텍스트
Another column
select table
accounts
cond_instances
events_stages_current
events_stages_history
events_stages_history_long
events_stages_summary_by_account_by_event_name
events_stages_summary_by_host_by_event_name
events_stages_summary_by_thread_by_event_name
events_stages_summary_by_user_by_event_name
events_stages_summary_global_by_event_name
events_statements_current
events_statements_history
events_statements_history_long
events_statements_summary_by_account_by_event_name
events_statements_summary_by_digest
events_statements_summary_by_host_by_event_name
events_statements_summary_by_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_summary_global_by_event_name
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_account_by_event_name
events_waits_summary_by_host_by_event_name
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_by_user_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
hosts
host_cache
mutex_instances
objects_summary_global_by_type
performance_timers
rwlock_instances
session_account_connect_attrs
session_connect_attrs
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_timers
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
users
.
select column
확인
Loading
페이지 관련 설정
phpMyAdmin 데모 서버:
master
구분에서 현재 실행중인 Git 리버젼
RELEASE_5_2_0-676-g94206e9963
.