| Oracle/MySQL 관련 게시판 |
|---|
| 2008/06/17(16:47) from 211.109.178.9 | |
| 작성자 : 강줄기 (jkkang65@hanmail.net) | 조회수 : 3355 , 줄수 : 37 |
| Re: [MySQL] mysqladmin 명령어 |
|---|
|
1. mysql 이 살아있는지 확인 # mysqladmin -u root -p ping Enter password: mysqld is alive 2. mysql 쓰레드 목록보기 # mysqladmin -u root -p proc processlist Enter password: +-----+-------+-----------+-------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+-------+-----------+-------+---------+------+-------+------------------+ | 134 | human | localhost | human | Sleep | 14 | | | | 149 | root | localhost | | Query | 0 | | show processlist | +-----+-------+-----------+-------+---------+------+-------+------------------+ +-----+-------+-----------+-------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+-------+-----------+-------+---------+------+-------+------------------+ | 134 | human | localhost | human | Sleep | 14 | | | | 149 | root | localhost | | Query | 0 | | show processlist | +-----+-------+-----------+-------+---------+------+-------+------------------+ 3. mysql 서버환경설정 확인 # mysqladmin -u root -p variables mysqladmin -u root -p extended-status 4. 배치파일로 보기 |
|
|