# 데이터베이스 어드민 쿼리를 화면으로 만들기 (show processlist)

**URL:** <https://ask.selectfromuser.com/t/show-processlist/200>\
**Category:** 사용 팁\
**Created:** [6월 19, 2024, 7:14오전 UTC](https://ask.selectfromuser.com/t/show-processlist/200 "2024-06-19T07:14:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jhlee](https://yyz2.discourse-cdn.com/flex032/user_avatar/ask.selectfromuser.com/jhlee/32/20_2.png) [@jhlee](https://ask.selectfromuser.com/u/jhlee)\
**Post date:** [6월 19, 2024, 7:14오전 UTC](https://ask.selectfromuser.com/t/show-processlist/200/1 "2024-06-19T07:14:46Z")

</div>

테스트 할때 트랜잭션, 스키마 변경 (DDL) 여러번하다가 종종 lock으로 process kill이 필요한 경우

하나씩 해결하면 어려워서 간단하게 만들었습니다.

## 기존 방법

`show processlist;`  
`kill 47000`

하나씩 호출해야합니다.

## 셀렉트 사용

 ![스크린샷 2024-06-19 오후 4.07.17](https://canada1.discourse-cdn.com/flex032/uploads/selectfromuser/original/1X/4d5bbf6cd860ad8d95277de935053faed0b0e5ac.png)

- 프로세스 리스트를 테이블로 보여주기
- 체크박스 켜기
- 액션 (forEach) 반복으로 쿼리 실행하기

> 로컬 CLI에서도 가능합니다.

---

<div class="post-metadata">

**Author:** ![jhlee](https://yyz2.discourse-cdn.com/flex032/user_avatar/ask.selectfromuser.com/jhlee/32/20_2.png) [@jhlee](https://ask.selectfromuser.com/u/jhlee)\
**Post date:** [6월 19, 2024, 7:25오전 UTC](https://ask.selectfromuser.com/t/show-processlist/200/2 "2024-06-19T07:25:59Z")

</div>

```yml
menus:
- path: pages/eiJj3F
  name: 새로운 메뉴
pages:
- path: pages/eiJj3F
  title: processlist
  subtitle: 내용
  blocks:
  - type: query
    resource: tm_root
    sqlType: select
    sql: >
      show processlist;
    selectOptions: 
      enabled: true
    searchOptions: 
      enabled: true
    actions:
      - type: query
        resource: tm_root
        sql: >
          CALL mysql.rds_kill(:id);
        sqlType: update
        # sqlConfirm: true
        params:
          - key: id
            valueFromSelectedRows: Id
        button:
          type: primary
        forEach: true
        reloadAfterSubmit: true
        toast: 완료

```