{"id":20560,"date":"2021-04-15T16:30:31","date_gmt":"2021-04-15T09:30:31","guid":{"rendered":"https:\/\/www.rumahweb.com\/journal\/?p=20560"},"modified":"2021-05-27T13:27:36","modified_gmt":"2021-05-27T06:27:36","slug":"slow-query","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/slow-query\/","title":{"rendered":"Slow Query: Pengertian, Cara Aktivasi dan Perbaikannya"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Pada database, Query merupakan syntax atau perintah yang digunakan untuk mengolah sebuah isi database. Seperti melakukan perintah select, insert, update, dan delete. Dengan Query Anda bisa mengolah data pada sebuah database misalnya untuk menampilkan data sesuai yang diinginkan pada sebuah website dengan menggunakan php. <\/p>\n\n\n\n<!--more-->\n\n\n\n\n\n<p class=\"wp-block-paragraph\">Penggunaan Query yang benar dan optimal akan membuat kinerja server tidak berat dan informasi yang ditampilan dari hasil query juga akan cepat tersedia, tetapi sebaliknya jika query tidak benar dan tidak optimal tentu akan membuat kinerja server menjadi berat dan informasi yang ditampilkan dari hasil query menjadi lebih lama. Untuk mengetahui query apa yang membuat kinerja server menjadi berat dan prosesnya lama, Anda bisa mengaktifkan Slow Query Log.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Pengertian Slow Query Log<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Slow Query Log adalah catatan yang berisi Query SQL yang memerlukan waktu lama dari long_query_time ketika dijalankan. long_query_time adalah parameter yang digunakan sebagai batas penentu apakah query dianggap slow atau tidak. Default nilai long_query_time adalah 10 detik, sehingga query dengan waktu eksekusi lebih dari nilai long_query_time akan dicatat pada Slow Query Log. Slow Query Log akan menampilkan query-query lambat yang nantinya bisa dilakukan optimasi.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Cara Aktivasi Slow Query Log<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Aktivasi Slow Query Log hanya bisa dilakukan dari user root, sehingga jika Anda tidak memiliki akses root maka tidak bisa melakukan Aktivasi Slow Query Log. Jika Anda tidak memiliki akses root, bisa minta bantuan ke admin atau support dari server\/hosting yang digunakan.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1. Login <a href=\"https:\/\/www.rumahweb.com\/journal\/melakukan-koneksi-ssh-menggunakan-putty\/\">SSH ke server<\/a> dengan user root<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2. Edit file my.cnf misalnya dengan editor nano. Perintahnya : <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><span class=\"has-inline-color has-gridlove-acc-color\">nano \/etc\/my.cnf<\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3. Masukan kode berikut :<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><span class=\"has-inline-color has-gridlove-acc-color\">slow_query_log = 1<br \/>slow-query_log_file = \/var\/log\/mysql-slow.log<br \/>long_query_time = 2<\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4. Buat file \/var\/log\/mysql-slow.log dengan user permission mysql. Perintahnya :<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><span class=\"has-inline-color has-gridlove-acc-color\">touch \/var\/log\/mysql-slow.log<br \/>chown mysql:mysql \/var\/log\/mysql-slow.log<\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5. Restart MySQL atau MariaDB<br \/>Jika menggunakan cPanel silahkan gunakan perintah :<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><span class=\"has-inline-color has-gridlove-acc-color\">\/usr\/local\/cpanel\/scripts\/restartsrv_mysql<\/span><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Jika tanpa panel dan menggunakan MySQL :<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><span class=\"has-inline-color has-gridlove-acc-color\">service mysql restart<\/span><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Jika tanpa panel dan menggunakan MariaDB :<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><span class=\"has-inline-color has-gridlove-acc-color\">service mariadb restart<\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">6. Melakukan monitoring Slow Query Log untuk melihat query yang lambat dengan perintah :<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><span class=\"has-inline-color has-gridlove-acc-color\">mysqldumpslow -a \/var\/log\/mysql-slow.log<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Perbaikan<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Dari hasil monitoring Slow Query Log, Anda dapat dengan mudah melakukan optimasi karena bisa melihat query apa saja yang lambat diproses. Optimasi dilakukan dengan banyak cara, misalnya melakukan audit langsung pada query atau menggunakan aplikasi seperti EverSQL, ApexSQL Plan, SQL Azure Query Performance Insights, sql-tuning.com, dll<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Demikian panduan mengenai Slow Query Log, cara aktivasi dan perbaikannya. Semoga bermanfaat.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pada database, Query merupakan syntax atau perintah yang digunakan untuk mengolah sebuah isi database. Seperti melakukan perintah select, insert, update, dan delete. Dengan Query Anda bisa mengolah data pada sebuah database misalnya untuk menampilkan data sesuai yang diinginkan pada sebuah website dengan menggunakan php.<\/p>\n","protected":false},"author":324,"featured_media":20584,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[177],"tags":[321],"class_list":["post-20560","post","type-post","status-publish","format-standard","has-post-thumbnail","category-vps","tag-vps"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Slow Query Log adalah catatan yang berisi Query SQL yang memerlukan waktu lama dari long_query_time ketika dijalankan. long_query_time adalah parameter yang\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Triyadi\"\/>\n\t<meta name=\"google-site-verification\" content=\"wPstUwU5246IbK_1PqwGrc1LoSDnB-9rPbcT8_vSNgQ\" \/>\n\t<meta name=\"keywords\" content=\"slow query log,slow query,mysql get slow query log,how to check mysql slow query log,mysql slow query log,vps\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.rumahweb.com\/journal\/slow-query\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"id_Id\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Rumahweb Journal \u2013 News, Article, and Tutorial of Web Dev\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Slow Query: Pengertian, Cara Aktivasi dan Perbaikannya\" \/>\n\t\t<meta property=\"og:description\" content=\"Slow Query Log adalah catatan yang berisi Query SQL yang memerlukan waktu lama dari long_query_time ketika dijalankan. long_query_time adalah parameter yang\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.rumahweb.com\/journal\/slow-query\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/04\/Slow-Query-Log.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/04\/Slow-Query-Log.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t\t<meta property=\"og:image:height\" content=\"631\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2021-04-15T09:30:31+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2021-05-27T06:27:36+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RumahwebIndonesia\/\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@rumahwebtweet\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Slow Query: Pengertian, Cara Aktivasi dan Perbaikannya\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Slow Query Log adalah catatan yang berisi Query SQL yang memerlukan waktu lama dari long_query_time ketika dijalankan. long_query_time adalah parameter yang\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@rumahwebtweet\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/04\/Slow-Query-Log.png\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Slow Query: Pengertian, Cara Aktivasi dan Perbaikannya","description":"Slow Query Log adalah catatan yang berisi Query SQL yang memerlukan waktu lama dari long_query_time ketika dijalankan. long_query_time adalah parameter yang","canonical_url":"https:\/\/www.rumahweb.com\/journal\/slow-query\/","robots":"max-image-preview:large","keywords":"slow query log,slow query,mysql get slow query log,how to check mysql slow query log,mysql slow query log,vps","webmasterTools":{"google-site-verification":"wPstUwU5246IbK_1PqwGrc1LoSDnB-9rPbcT8_vSNgQ","miscellaneous":""},"schema":null,"og:locale":"id_Id","og:site_name":"Rumahweb Journal \u2013 News, Article, and Tutorial of Web Dev","og:type":"article","og:title":"Slow Query: Pengertian, Cara Aktivasi dan Perbaikannya","og:description":"Slow Query Log adalah catatan yang berisi Query SQL yang memerlukan waktu lama dari long_query_time ketika dijalankan. long_query_time adalah parameter yang","og:url":"https:\/\/www.rumahweb.com\/journal\/slow-query\/","og:image":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/04\/Slow-Query-Log.png","og:image:secure_url":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/04\/Slow-Query-Log.png","og:image:width":1200,"og:image:height":631,"article:published_time":"2021-04-15T09:30:31+00:00","article:modified_time":"2021-05-27T06:27:36+00:00","article:publisher":"https:\/\/www.facebook.com\/RumahwebIndonesia\/","twitter:card":"summary_large_image","twitter:site":"@rumahwebtweet","twitter:title":"Slow Query: Pengertian, Cara Aktivasi dan Perbaikannya","twitter:description":"Slow Query Log adalah catatan yang berisi Query SQL yang memerlukan waktu lama dari long_query_time ketika dijalankan. long_query_time adalah parameter yang","twitter:creator":"@rumahwebtweet","twitter:image":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/04\/Slow-Query-Log.png"},"aioseo_meta_data":{"post_id":"20560","title":null,"description":"Slow Query Log adalah catatan yang berisi Query SQL yang memerlukan waktu lama dari long_query_time ketika dijalankan. long_query_time adalah parameter yang","keywords":[{"label":"slow query log","value":"slow query log"},{"label":" slow query","value":" slow query"},{"label":"mysql get slow query log","value":"mysql get slow query log"},{"label":" how to check mysql slow query log","value":" how to check mysql slow query log"},{"label":" mysql slow query log","value":" mysql slow query log"}],"keyphrases":{"focus":{"keyphrase":"slow query","score":88,"analysis":{"keyphraseInTitle":{"title":"Focus Keyphrase in SEO title","description":"Focus Keyphrase found in SEO title.","score":9,"maxScore":9,"error":0},"keyphraseInDescription":{"title":"Focus keyphrase in meta description","description":"Focus keyphrase found in meta description.","score":9,"maxScore":9,"error":0},"keyphraseInURL":{"title":"Focus Keyphrase in URL","description":"Focus Keyphrase used in the URL.","score":5,"maxScore":5,"error":0},"keyphraseInIntroduction":{"title":"Focus keyphrase in introduction","description":"Your Focus keyphrase does not appear in the first paragraph. Make sure the topic is clear immediately.","score":3,"maxScore":9,"error":1},"keyphraseInSubHeadings":{"title":"Focus Keyphrase in Subheadings","description":"Your H2 and H3 subheadings reflects the topic of your copy. Good job!","score":9,"maxScore":9,"error":0},"keyphraseLength":{"title":"Focus keyphrase length","description":"Good job!","score":9,"maxScore":9,"error":0,"length":2},"keyphraseInImageAlt":[]}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"Article","defaultPostTypeGraph":""},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"}}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","location":null,"local_seo":{"businessInfo":{"name":"","urls":{"website":"","aboutPage":"","contactPage":""},"address":{"line1":"","line2":"","zip":"","city":"","state":"","country":""},"contact":{"email":"","phone":"","fax":""},"ids":{"vatID":"","taxID":"","chamberID":""},"payment":{"priceIndication":"","currenciesAccepted":"","methodsAccepted":""},"areaServed":""},"openingHours":{"show":false,"closedLabel":"","open24h":false,"open24hLabel":"","open247":false,"use24hFormat":false,"twoSets":false,"timezone":"","hours":[]}},"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-04-14 03:10:44","updated":"2026-04-19 04:04:18","seo_analyzer_scan_date":null},"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/20560","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/users\/324"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/comments?post=20560"}],"version-history":[{"count":0,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/20560\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/20584"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=20560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=20560"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=20560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}