programming-study icon indicating copy to clipboard operation
programming-study copied to clipboard

Published 20 hours ago • verified publisher icon heowc

[db] MySQL Troubleshooting

Open heowc opened this issue 5 years ago • 1 comments

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

heowc avatar Apr 13 '19 04:04 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

heowc avatar Apr 13 '19 04:04 heowc