2.6.1.2.1.8. Terminate processes using phpMyAdmin

You can quickly terminate all database queries at once in the control panel.

Important points:

  • The "Status" section is displayed only when no database is selected in the left-hand menu. If a database has been selected, simply click on the server name at the very top of the page, which appears as Server: example.mysql.ukraine.com.ua.
  • When you open the page displaying current processes, at least one process with the query SHOW PROCESSLIST will always be shown. This query cannot be closed because it is executed to display the page with current processes.
  • If you see the error message "phpMyAdmin was unable to close thread ID XXXXXX. It may have already been closed", refresh the page by clicking "Refresh".
  • We strongly advise against enabling auto-updates with short intervals on a long-term basis, as this may place an additional load on the database server and consume CPU minutes/resources included in your plan.
  • When using the SQL query SHOW PROCESSLIST, errors may occur when terminating processes due to a lack of required privileges. In such cases, you should terminate the processes by following the instructions provided here.

Each database connection runs in a separate process (thread). If necessary, these processes can be forcefully terminated.

  1. Log in to phpMyAdmin.
  2. Go to the "Status → Processes" section and click "Kill" next to the desired process:
  3. Confirm the operation by clicking "OK".
Content
    (1)

    Comments

    novatorstroy
    2023-10-03 - 04:27 pm
    Информация не актуальна! Прошу актуализировать справочную информацию под версию 5.2.1
    karlov
    2023-10-04 - 09:31 am
    В версии 5.2.1 порядок действий тот же, что описан в статье. Убедитесь, что у вас слева не выбрана никакая база данных, иначе раздел «Состояние» не будет отображаться.