mysql 환경설정 확인.
페이지 정보
본문
SELECT default_character_set_name FROM information_schema.SCHEMATA S
WHERE schema_name = "gstt";
SELECT @@time_zone;
SELECT @rownum:=@rownum+1 AS rownum, a.PhotoUrl, a.UserMsg FROM PhotoList a, IaState b WHERE (@rownum:=0)=0 AND a.IaState_idx = b.idx AND a.PlayStat ='r' AND b.site = 'ingak' LIMIT 3
SELECT ENGINE,table_name FROM information_schema.TABLES WHERE table_schema ='gst'
SELECT table_schema "Database Name", table_name,
SUM(data_length + index_length) / 1024 / 1024 "Size(MB)"
FROM information_schema.TABLES
GROUP BY table_schema,table_name;
SHOW VARIABLES LIKE '%max_connection%';
SHOW STATUS
SHOW PROCESSLIST
SHOW VARIABLES LIKE '%timeout'
SHOW EVENTS
WHERE schema_name = "gstt";
SELECT @@time_zone;
SELECT @rownum:=@rownum+1 AS rownum, a.PhotoUrl, a.UserMsg FROM PhotoList a, IaState b WHERE (@rownum:=0)=0 AND a.IaState_idx = b.idx AND a.PlayStat ='r' AND b.site = 'ingak' LIMIT 3
SELECT ENGINE,table_name FROM information_schema.TABLES WHERE table_schema ='gst'
SELECT table_schema "Database Name", table_name,
SUM(data_length + index_length) / 1024 / 1024 "Size(MB)"
FROM information_schema.TABLES
GROUP BY table_schema,table_name;
SHOW VARIABLES LIKE '%max_connection%';
SHOW STATUS
SHOW PROCESSLIST
SHOW VARIABLES LIKE '%timeout'
SHOW EVENTS
- 이전글node 소켓 websocket socket.io 20.02.21
- 다음글mysql 달력 쿼리 20.02.21
댓글목록
등록된 댓글이 없습니다.