{"id":7882,"date":"2026-04-23T10:11:13","date_gmt":"2026-04-23T08:11:13","guid":{"rendered":"https:\/\/mybox.com\/help\/?post_type=manual_kb&#038;p=7882"},"modified":"2026-04-23T10:11:14","modified_gmt":"2026-04-23T08:11:14","slug":"cum-sa-verificati-si-sa-inchideti-procesele-in-mysql","status":"publish","type":"manual_kb","link":"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-to-check-and-end-processes-in-mysql\/","title":{"rendered":"Cum s\u0103 verifica\u021bi \u0219i s\u0103 \u00eenchide\u021bi procesele \u00een MySQL"},"content":{"rendered":"<div class=\"translation-block translation-block-merged\">\n<p class=\"wp-block-paragraph\">Managing active database connections is essential for maintaining the performance of your <strong>mybox<\/strong> environment. If a website slows down or becomes unresponsive, a &#8220;stuck&#8221; or unoptimized SQL query is often the cause. By identifying and terminating these processes, you can restore stability without restarting the entire server.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-to-check-and-end-processes-in-mysql\/#What_is_the_Processlist\" >What is the Processlist?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-to-check-and-end-processes-in-mysql\/#Option_1_Using_phpMyAdmin_Visual_Interface\" >Option 1: Using phpMyAdmin (Visual Interface)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-to-check-and-end-processes-in-mysql\/#Option_2_Using_the_Console_SSH\" >Option 2: Using the Console (SSH)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-to-check-and-end-processes-in-mysql\/#When_should_you_end_a_query\" >When should you end a query?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-to-check-and-end-processes-in-mysql\/#Practical_Implications_for_mybox_Users\" >Practical Implications for mybox Users<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-to-check-and-end-processes-in-mysql\/#Summary\" >Summary<\/a><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_is_the_Processlist\"><\/span>What is the Processlist?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The <strong>Processlist<\/strong> is a real-time list of every active connection and query currently running on your MySQL server. It allows you to see:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Which user is connected.<\/li>\n\n\n\n<li>Which database is being accessed.<\/li>\n\n\n\n<li>How long a specific query has been running.<\/li>\n\n\n\n<li>Whether a query is &#8220;Locked&#8221; and preventing other actions from completing.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Option_1_Using_phpMyAdmin_Visual_Interface\"><\/span>Option 1: Using phpMyAdmin (Visual Interface)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<\/div>\n\n<div id=\"mybox-826934230\" class=\"mybox-content mybox-entity-placement\"><div class=\"early-access-banner-inpost\">\r\n  <div class=\"banner-left-inpost\">\r\n    <div class=\"icon-box-inpost\">\r\n      <img decoding=\"async\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2026\/02\/square-info-icon.svg\" alt=\"Info\">\r\n    <\/div>\r\n    <div class=\"text-box-inpost\">\r\n      <span class=\"label-inpost\"><span class=\"translation-block translation-block-banner-text\">Acces timpuriu<\/span><\/span>\r\n      <h4><span class=\"translation-block translation-block-banner-text\">Mai ave\u021bi nevoie de ajutor?<\/span><\/h4>\r\n      <p><span class=\"translation-block translation-block-banner-text\">Contacta\u021bi echipa noastr\u0103 de servicii pentru clien\u021bi.<\/span><\/p>\r\n    <\/div>\r\n  <\/div>\r\n\r\n  <div class=\"banner-right-inpost\">\r\n    <a href=\"https:\/\/panel.mybox.com\/helpdesk2\/v\/list\/\" class=\"banner-button-inpost\"><span class=\"translation-block translation-block-banner-text\">Trimite mesaj<\/span><\/a>\r\n  <\/div>\r\n<\/div><\/div>\n\n<div class=\"translation-block translation-block-merged\"><p class=\"wp-block-paragraph\">For most users, the <strong>mybox panel<\/strong> offers a straightforward way to manage database processes via phpMyAdmin.<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Log in to phpMyAdmin:<\/strong> Access this through the <strong>mybox panel<\/strong> using your database credentials.<\/li>\n\n\n\n<li><strong>Open the Status Tab:<\/strong> In the top navigation menu, click <strong>Status<\/strong>, then select <strong>Processes<\/strong>.<\/li>\n\n\n\n<li><strong>Identify the Problem:<\/strong> Look for queries with a high <strong>Time<\/strong> value (measured in seconds). Pay attention to the <strong>State<\/strong> column\u2014if it says &#8220;Locked,&#8221; it may be blocking your entire site.<\/li>\n\n\n\n<li><strong>End the Process:<\/strong> Click the <strong>Kill<\/strong> link on the left side of the specific row you wish to terminate.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Option_2_Using_the_Console_SSH\"><\/span>Option 2: Using the Console (SSH)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If you prefer using the command line or have large numbers of processes to manage, SSH is the most efficient method.<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Log in via SSH:<\/strong> Ensure SSH is enabled in your <strong>mybox panel<\/strong> and connect using your terminal or a client like PuTTY.<\/li>\n\n\n\n<li><strong>Enter the MySQL Client:<\/strong> Use the following command: <code>mysql -u your_username -p<\/code> <em>(Replace <code>your_username<\/code> with your database login. You will be prompted for your password.)<\/em><\/li>\n\n\n\n<li><strong>View All Processes:<\/strong> Run this command to see the full text of every active query: <code>SHOW FULL PROCESSLIST;<\/code><\/li>\n\n\n\n<li><strong>Identify the ID:<\/strong> Look at the <strong>Id<\/strong> column for the problematic row.<\/li>\n\n\n\n<li><strong>Terminate the Process:<\/strong> Run the kill command using that specific ID: <code>KILL 1234;<\/code> <em>(Replace <code>1234<\/code> with the actual process ID.)<\/em><\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"When_should_you_end_a_query\"><\/span>When should you end a query?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">You should consider manually terminating a process if you notice:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Long Duration:<\/strong> A query has been running for hundreds of seconds without finishing.<\/li>\n\n\n\n<li><strong>Table Locks:<\/strong> The status is &#8220;Locked&#8221; or &#8220;Waiting for table metadata lock,&#8221; which prevents other users from reading or writing to that table.<\/li>\n\n\n\n<li><strong>Excessive &#8220;Sleep&#8221; Connections:<\/strong> Too many idle connections (Status: Sleep) can eventually hit your maximum connection limit.<\/li>\n\n\n\n<li><strong>Malicious Activity:<\/strong> Unusually heavy queries coming from an unknown external source.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Practical_Implications_for_mybox_Users\"><\/span>Practical Implications for mybox Users<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Data Integrity:<\/strong> Be cautious when killing <code>UPDATE<\/code>, <code>INSERT<\/code>, or <code>DELETE<\/code> queries. Forcing them to stop mid-process can occasionally lead to inconsistent data.<\/li>\n\n\n\n<li><strong>Optimization:<\/strong> If you find yourself frequently killing the same type of query, it is a sign that your database needs better indexing or that the code in your application needs refactoring.<\/li>\n\n\n\n<li><strong>Automatic Safety:<\/strong> To prevent manual intervention, you can set a <code>max_execution_time<\/code> in your <strong>mybox panel<\/strong> PHP settings to automatically terminate queries that exceed a safe threshold.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Summary\"><\/span>Summary<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Monitoring your MySQL processes is a vital part of infrastructure literacy. Whether you use the visual interface of phpMyAdmin or the precision of the SSH console, being able to identify and &#8220;kill&#8221; problematic queries ensures that your <strong>mybox<\/strong> resources remain available for your visitors. Always aim to optimize the underlying code to prevent these bottlenecks from occurring in the future.<\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[9],"manual_kb_tag":[5601,9058,9059,9060,9061,9062,9063,9064,9065,9066],"class_list":["post-7882","manual_kb","type-manual_kb","status-publish","format-standard","hentry","manualknowledgebasecat-databases","manual_kb_tag-database-connections","manual_kb_tag-mysql-processlist","manual_kb_tag-phpmyadmin-processes","manual_kb_tag-kill-mysql-query","manual_kb_tag-terminate-processes","manual_kb_tag-long-running-queries","manual_kb_tag-table-locks","manual_kb_tag-sleep-connections","manual_kb_tag-connection-limits","manual_kb_tag-mysql-console"],"_links":{"self":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/7882","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":1,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/7882\/revisions"}],"predecessor-version":[{"id":7883,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/7882\/revisions\/7883"}],"wp:attachment":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/media?parent=7882"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manualknowledgebasecat?post=7882"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb_tag?post=7882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}