{"id":1726,"date":"2020-06-08T14:01:36","date_gmt":"2020-06-08T07:01:36","guid":{"rendered":"https:\/\/www.domosquare.com\/tutorial\/?p=1726"},"modified":"2020-06-08T14:05:18","modified_gmt":"2020-06-08T07:05:18","slug":"mysql-error-too-many-connections-dan-solusinya","status":"publish","type":"post","link":"https:\/\/www.domosquare.com\/tutorial\/hosting\/mysql-error-too-many-connections-dan-solusinya.html","title":{"rendered":"MySQL Error \u201cToo many connections\u201d Dan Solusinya"},"content":{"rendered":"\n<p class=\"has-text-color has-background has-very-light-gray-color has-vivid-red-background-color\">Menaikan maksimal pemakaian koneksi ke MySQL dapat menyebabkan server overload, apabila RAM dan CPU tidak memadai.<\/p>\n\n\n\n<p>Solusi berikut ini adalah apabila Anda menggunakan VPS atau Dedicated Server. Jika Anda menggunakan cPanel Akses ke WHM Anda kemudian pilih Terminal.<\/p>\n\n\n\n<p>Jika tidak menggunakan cPanel silahkan akses SSH dengan aplikasi terminal atau Putty<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"774\" height=\"533\" src=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/06\/gambar-5.png\" alt=\"\" class=\"wp-image-1727\" srcset=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/06\/gambar-5.png 774w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/06\/gambar-5-300x207.png 300w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/06\/gambar-5-768x529.png 768w\" sizes=\"auto, (max-width: 774px) 100vw, 774px\" \/><\/figure>\n\n\n\n<p>Setelah login ke terminal menggunakan akses root ketikan:<\/p>\n\n\n\n<p>mysql<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"772\" height=\"467\" src=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/06\/gambar-6.png\" alt=\"\" class=\"wp-image-1728\" srcset=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/06\/gambar-6.png 772w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/06\/gambar-6-300x181.png 300w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/06\/gambar-6-768x465.png 768w\" sizes=\"auto, (max-width: 772px) 100vw, 772px\" \/><\/figure>\n\n\n\n<p>Kemudian ketik perintah berikut untuk mengetahui jumlah maksimalnya<\/p>\n\n\n\n<p>SHOW STATUS LIKE &#8216;max_used_connections&#8217;;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"772\" height=\"462\" src=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/06\/gambar-7.png\" alt=\"\" class=\"wp-image-1729\" srcset=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/06\/gambar-7.png 772w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/06\/gambar-7-300x180.png 300w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/06\/gambar-7-768x460.png 768w\" sizes=\"auto, (max-width: 772px) 100vw, 772px\" \/><\/figure>\n\n\n\n<p>Kemudian ketik perintah berikut untuk menaikan jumlah maksimalnya:<\/p>\n\n\n\n<p>SET GLOBAL max_connections = 400;<\/p>\n\n\n\n<p>Perintah ini hanya berlaku sementara, artinya jika MySQL direstart maka akan kembali ke posisi defaultnya.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Menaikan maksimal pemakaian koneksi ke MySQL dapat menyebabkan server overload, apabila RAM dan CPU tidak memadai. Solusi berikut ini adalah apabila Anda menggunakan VPS atau Dedicated Server. Jika Anda menggunakan cPanel Akses ke WHM Anda kemudian pilih Terminal. Jika tidak menggunakan cPanel silahkan akses SSH dengan aplikasi terminal atau Putty Setelah login ke terminal menggunakan [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"rating_form_position":"","rating_results_position":"","mr_structured_data_type":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1726","post","type-post","status-publish","format-standard","hentry","category-hosting"],"jetpack_featured_media_url":"","multi-rating":{"mr_rating_results":[{"adjusted_star_result":0,"star_result":0,"total_max_option_value":5,"adjusted_score_result":0,"score_result":0,"percentage_result":0,"adjusted_percentage_result":0,"count":0,"post_id":1726}]},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts\/1726","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/comments?post=1726"}],"version-history":[{"count":3,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts\/1726\/revisions"}],"predecessor-version":[{"id":1732,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts\/1726\/revisions\/1732"}],"wp:attachment":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/media?parent=1726"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/categories?post=1726"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/tags?post=1726"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}