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