[Mysql/MariaDB] DB 시스템 변수 확인(show variable)
1. DB 시스템 변수 확인 [형식] # SHOW VARIABLES SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] ----------------------------------------------- # SELECT SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES; SELECT * FROM INFORMATION_SCHEMA.SESSION_VARIABLES; MySQL Command-Line Client 접속하여 확인 # mysql -u root -p'계정 비밀번호'; mysql> SHOW VARIABLES; +----------------------+-------+ | Variable_name |..
