{"id":10104,"date":"2026-07-18T13:20:23","date_gmt":"2026-07-18T06:20:23","guid":{"rendered":"https:\/\/www.jetorbit.com\/panduan\/?p=10104"},"modified":"2026-07-18T13:20:23","modified_gmt":"2026-07-18T06:20:23","slug":"cara-melihat-query-yang-sedang-berjalan-di-mysql","status":"publish","type":"post","link":"https:\/\/www.jetorbit.com\/panduan\/cara-melihat-query-yang-sedang-berjalan-di-mysql\/","title":{"rendered":"Cara Melihat Query yang Sedang Berjalan di MySQL"},"content":{"rendered":"\n<p>Pernahkah kalian merasakan database MySQL tiba-tiba terasa berat tanpa alasan yang jelas? bisa jadi salah satu penyebabnya adalah query yang berjalan di background. Misalnya terdapat query yang berat dan tidak dioptimalkan dengan baik.<\/p>\n\n\n\n<p>Oleh karena itu, penting bagi kita untuk mengetahui cara melihat query yang berjalan di MySQL. Dengan begitu kita bisa memantau aktivitas database, menemukan query berat yang menyebabkan performa lambat, sekaligus melakukan troubleshooting lebih cepat.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Mengapa perlu melihat query yang sedang berjalan<\/strong><\/h3>\n\n\n\n<p>Melihat query yang sedang berjalan sangat penting untuk monitoring performa. Tidak semua query berjalan berjalan lancar, adakalanya query terasa lambar, stuck, bahkan error. Dengan memantau query yang sedang berjalan, seorang administrator dapat<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Mengetahui aktifitas yang berjalan pada database.<\/li>\n\n\n\n<li>Mengidentifikasi query yang bermasalah.<\/li>\n\n\n\n<li>Menghentikan query yang membuat server lambat.<\/li>\n\n\n\n<li>Troubleshooting lebih cepat dan tepat.\u00a0<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Cara melihat query yang berjalan<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>show full processlist<\/li>\n<\/ol>\n\n\n\n<p>Perintah ini akan menampilkan seluruh koneksi(thread) yang sedang aktif, lengkap dengan query yang dijalankan dikolom info.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"209\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-27-1024x209.png\" alt=\"\" class=\"wp-image-10105\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-27-1024x209.png 1024w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-27-300x61.png 300w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-27-768x157.png 768w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-27.png 1423w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>SELECT * FROM information_schema.processlist<\/li>\n<\/ol>\n\n\n\n<p>Perintah ini menghasilkan output yang mirip dengan SHOW FULL PROCESSLIST tapi lebih fleksibel karena hasilnya ditampilkan dalam bentuk tabel&nbsp;<\/p>\n\n\n\n<p>Keunggulannya kita bisa melakukan filter, disortir, atau diproses lebih lanjut saat memasukkan perintah.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"252\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-32-1024x252.png\" alt=\"\" class=\"wp-image-10110\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-32-1024x252.png 1024w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-32-300x74.png 300w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-32-768x189.png 768w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-32-1536x379.png 1536w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-32.png 1919w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>ID : ID threads<\/li>\n\n\n\n<li>USER : User yang menjalankan query<\/li>\n\n\n\n<li>HOST : Dari host mana koneksi datang<\/li>\n\n\n\n<li>DB : Database yang digunakan<\/li>\n\n\n\n<li>COMMAND : Status koneksi<\/li>\n\n\n\n<li>TIME : Lama koneksi berjalan<\/li>\n\n\n\n<li>STATE : Status progress query<\/li>\n\n\n\n<li>INFO : Query yang dijalankan<\/li>\n<\/ul>\n\n\n\n<p>Contoh lainnya disini saya memasukkan perintah untuk menampilkan seluruh query yang bukan dari system_user dengan perintah<\/p>\n\n\n\n<p>SELECT * FROM information_schema.processlist WHERE USER != \u2018system_user\u2019;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"351\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-33-1024x351.png\" alt=\"\" class=\"wp-image-10111\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-33-1024x351.png 1024w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-33-300x103.png 300w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-33-768x263.png 768w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-33-1536x526.png 1536w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-33.png 1919w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Mengurutkan query berdasarkan lama waktu berjalan<\/p>\n\n\n\n<p>SELECT * FROM information_scheme.processlist ORDER BY TIME DESC;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"240\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-34-1024x240.png\" alt=\"\" class=\"wp-image-10112\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-34-1024x240.png 1024w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-34-300x70.png 300w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-34-768x180.png 768w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-34-1536x360.png 1536w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-34.png 1919w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Menghentikan query yang bermasalah<\/li>\n<\/ol>\n\n\n\n<p>Apabila terdapat proses yang berat maupun lambat kalian bisa menghentikan proses tersebut menggunakan perintah kill &lt;id&gt;. Untuk mengetahui id bisa dilihat pada tabel processlist.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"511\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-31-1024x511.png\" alt=\"\" class=\"wp-image-10108\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-31-1024x511.png 1024w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-31-300x150.png 300w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-31-768x383.png 768w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-31.png 1109w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Pernahkah kalian merasakan database MySQL tiba-tiba terasa berat tanpa alasan yang jelas? bisa jadi salah satu penyebabnya adalah query yang berjalan di background. Misalnya terdapat query yang berat dan tidak dioptimalkan dengan baik. Oleh karena itu, penting bagi kita untuk mengetahui cara melihat query yang berjalan di MySQL. Dengan begitu kita bisa memantau aktivitas database, [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":2809,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-10104","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dasar"],"_links":{"self":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/10104","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/comments?post=10104"}],"version-history":[{"count":1,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/10104\/revisions"}],"predecessor-version":[{"id":10113,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/10104\/revisions\/10113"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/media\/2809"}],"wp:attachment":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/media?parent=10104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/categories?post=10104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/tags?post=10104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}