MySQL Locked 확인
Written on - show open tables;
- MySQL 전체 테이블 잠금여부
- show open tables from ‘db명’
- 해당 DB의 테이블 잠금 여부
- show open tables from ‘db명’ like ‘테이블명’
- 해당 DB의 특정 테이블의 잠금 정보
What is show open tables command ?
SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the table cache
락 상태의 테이블 확인
- SHOW OPEN TABLES WHERE in_use>0;
특정 상태의 테이블 확인
- SHOW OPEN TABLES WHERE in_use>0 AND Table=’your_table_name’;
참고
영준 (=hax0r)
https://www.hax0r.info
I am a passionate back-end developer always in hunger of learning new things and sharing what i have learned. who loves challenges, newest technologies and programming at all.