{"id":38754,"date":"2013-09-29T13:38:37","date_gmt":"2013-09-29T13:38:37","guid":{"rendered":"http:\/\/harry.sufehmi.com\/archives\/2013-09-29-38754\/"},"modified":"2014-02-26T04:17:56","modified_gmt":"2014-02-25T21:17:56","slug":"mysql-notifikasi-jika-query-sudah-selesai","status":"publish","type":"post","link":"https:\/\/harry.sufehmi.com\/archives\/2013-09-29-mysql-notifikasi-jika-query-sudah-selesai\/","title":{"rendered":"MySQL : Notifikasi jika Query sudah selesai"},"content":{"rendered":"
:: kadangkala ada query yang berjalan lama & kita tidak ingin cuma duduk bengong menanti query tsb selesai. Lebih baik kita gunakan waktu tersebut untuk mengerjakan hal yang lainnya bukan ?<\/p>\n

Caranya mudah sekali :<\/p>\n

1. Pasang putty : sudo apt-get install putty<\/p>\n

2. Jalankan putty<\/p>\n

3. Pilih menu Terminal – Bell; dan lalu pastikan bahwa opsi "Make default system alert sound" sudah dipilih<\/p>\n

4. Login ke server & jalankan query<\/p>\n

5. Ketikkan perintah berikut ini :<\/p>\n

while mysqladmin -h 127.0.0.1 processlist | grep QUERY > \/dev\/null ; do sleep 10; done ; while true; do echo -e "a"; sleep 2; done<\/p>\n

6. Ganti string "QUERY" diatas dengan perintah query yang ingin Anda pantau<\/p>\n

Maka, ketika query tersebut sudah selesai, terminal Putty tersebut akan berbunyi & berkedip setiap 2 detik \ud83d\ude42<\/p>\n

Semoga bermanfaat.\u00ef\u00bb\u00bf<\/p><\/div>\n


This post has been reshared 3 times on Google+<\/a>
<\/span> View this post on Google+<\/a><\/p>\n

Post imported by Google+Blog for WordPress<\/a>.<\/i><\/p>\n","protected":false},"excerpt":{"rendered":"

:: kadangkala ada query yang berjalan lama & kita tidak ingin cuma duduk bengong menanti query tsb selesai. Lebih baik kita gunakan waktu tersebut untuk mengerjakan hal yang lainnya bukan ? Caranya mudah sekali : 1. Pasang putty : sudo apt-get install putty 2. Jalankan putty 3. Pilih menu Terminal – Bell; dan lalu pastikan … Continue reading MySQL : Notifikasi jika Query sudah selesai<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-38754","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/posts\/38754"}],"collection":[{"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/comments?post=38754"}],"version-history":[{"count":3,"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/posts\/38754\/revisions"}],"predecessor-version":[{"id":38805,"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/posts\/38754\/revisions\/38805"}],"wp:attachment":[{"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/media?parent=38754"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/categories?post=38754"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/tags?post=38754"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}