[db] MySQL Troubleshooting

[heowc]

https://smartstore.naver.com/dasodabook/products/3954489452?NaPm=ct%3Dju4v6woo%7Cci%3De451577a47bc5022eea6eeca3c0b886466e3650d%7Ctr%3Dslsl%7Csn%3D438051%7Cic%3D%7Chk%3Da5e0dbd0834d2761058bcab0d5237cede319f510

[heowc]

query log 확인하기

query log 활성화

SET GLOBAL general_log='on'
-- SET GLOBAL log_output='file'
-- SET GLOBAL log_output='table'

query log 비활성화

SET GLOBAL general_log='on'
SET GLOBAL log_output='none'

참고

• https://docs.aws.amazon.com/ko_kr/AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.MySQL.html