Langsung ke konten utama

Postingan

Menampilkan postingan dengan label database

Interrupt not responding query process database mysql

Gegara alter table, mengubah lebar kolom pada tabel mysql, karena ukuran data lumayan besar jadinya luamaaaa buangeeettt processnya. Ya sudah akhinya di interrupt saja (cancel) querynya. Caranya gimana? Berikut stepnya ya... 1. Access the MySQL Server from the shell prompt using the following command: mysql -u <user> -h <server> -p <password> Replace "<user>," "<server>" and "<password>" with the appropriate credentials. 2. Execute the command "show processlist;" (without quotes) to see the threads active for each user or those running under your own account. 3. Refer to the Time field to determine how long the thread has been active. Execute the following command to kill the long-running query: kill <#>; Replace "<#>" with the ID associated with the applicable thread. Microsoft Windows [Version 10.0.15063] (c) 2017 Microsoft Corporation. All rights r...