{"id":54,"date":"2016-10-19T08:29:03","date_gmt":"2016-10-19T08:29:03","guid":{"rendered":"https:\/\/galaxydata.ru\/community\/?p=54"},"modified":"2025-07-23T00:33:57","modified_gmt":"2025-07-22T21:33:57","slug":"izmenenie-timeout-v-mysql-mariadb-percona","status":"publish","type":"post","link":"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54","title":{"rendered":"\u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 Timeout \u0432 MySQL, MariaDB, Percona"},"content":{"rendered":"<h3 id=\"\u041f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c_\u0432\u0441\u0435_\u0442\u0435\u043a\u0443\u0449\u0438\u0435_\u043b\u0438\u043c\u0438\u0442\u044b_\u043c\u043e\u0436\u043d\u043e_\u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439:\" >Section 1. \u041f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u0432\u0441\u0435 \u0442\u0435\u043a\u0443\u0449\u0438\u0435 \u043b\u0438\u043c\u0438\u0442\u044b \u043c\u043e\u0436\u043d\u043e \u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439:<\/h3>\n<pre class=\"lang:mysql decode:true \">show variables like '%timeout%';<\/pre>\n<p>\u0412\u044b\u0432\u043e\u0434 \u0431\u0443\u0434\u0435\u0442 \u043f\u0440\u0438\u043c\u0435\u0440\u043d\u043e \u0442\u0430\u043a\u043e\u0439:<\/p>\n<pre class=\"lang:default decode:true \">mysql&gt; show variables like '%timeout%';\r\n+-----------------------------+----------+\r\n| Variable_name               | Value    |\r\n+-----------------------------+----------+\r\n| connect_timeout             | 360      |\r\n| delayed_insert_timeout      | 300      |\r\n| have_statement_timeout      | YES      |\r\n| innodb_flush_log_at_timeout | 1        |\r\n| innodb_lock_wait_timeout    | 50       |\r\n| innodb_rollback_on_timeout  | OFF      |\r\n| interactive_timeout         | 28800    |\r\n| lock_wait_timeout           | 31536000 |\r\n| net_read_timeout            | 300      |\r\n| net_write_timeout           | 60       |\r\n| rpl_stop_slave_timeout      | 31536000 |\r\n| slave_net_timeout           | 3600     |\r\n| thread_pool_idle_timeout    | 60       |\r\n| wait_timeout                | 28800    |\r\n+-----------------------------+----------+\r\n14 rows in set (0.01 sec)\r\n<\/pre>\n<p>&nbsp;<\/p>\n<h3 id=\"1._Start_the_DB_server_as_&#8216;root&#8217;_user_with_\u00a0the_comandline_option_and_check_the_values_of_&#8216;net_read_timeout&#8217;_and_&#8216;wait_timeout&#8217;\" >Section 2. 1. Start the DB server as &#8216;root&#8217; user with \u00a0the comandline option and check the values of &#8216;net_read_timeout&#8217; and &#8216;wait_timeout&#8217;<\/h3>\n<div>\n<div><\/div>\n<div>The result may be like this :<\/div>\n<div><\/div>\n<div>mysql&gt; SHOW SESSION VARIABLES LIKE &#8216;net_read_timeout&#8217;;<\/div>\n<div>+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+<\/div>\n<div>| Variable_name \u00a0 \u00a0| Value |<\/div>\n<div>+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+<\/div>\n<div>| net_read_timeout | 30 \u00a0 \u00a0|<\/div>\n<div>+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+<\/div>\n<div>1 row in set (0.00 sec)<\/div>\n<div><\/div>\n<div><\/div>\n<div>\n<div>mysql&gt; SHOW SESSION VARIABLES LIKE &#8216;wait_timeout&#8217;;<\/div>\n<div>+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+<\/div>\n<div>| Variable_name \u00a0 \u00a0| Value |<\/div>\n<div>+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+<\/div>\n<div>|\u00a0wait_timeout\u00a0| 30 \u00a0 \u00a0|<\/div>\n<div>+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+<\/div>\n<div>1 row in set (0.00 sec)<\/div>\n<\/div>\n<h3 id=\"2._Change_the_values_as_you_need\" >Section 3. 2. Change the values as you need<\/h3>\n<h4 id=\"Here_i_am_setting\u00a028800_instead_of_30\" >1) Here i am setting\u00a028800 instead of 30<\/h4>\n<\/div>\n<div><\/div>\n<div>\n<div>mysql&gt;\u00a0SET SESSION net_read_timeout=28800;<\/div>\n<div>Query OK, 0 rows affected (0.00 sec)<\/div>\n<\/div>\n<div><\/div>\n<div>\n<div>\n<div>mysql&gt;\u00a0SET SESSION\u00a0wait_timeout=28800;<\/div>\n<div>Query OK, 0 rows affected (0.00 sec)<\/div>\n<\/div>\n<\/div>\n<div><\/div>\n<h3 id=\"3._Now_you_can_check_the_variable_values_updated_or_not..\" >Section 4. 3. Now you can check the variable values updated or not..<\/h3>\n<div>\n<div>mysql&gt; SHOW SESSION VARIABLES LIKE &#8216;net_read_timeout&#8217;;<\/div>\n<div>+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+<\/div>\n<div>| Variable_name \u00a0 \u00a0| Value |<\/div>\n<div>+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+<\/div>\n<div>|\u00a0net_read_timeout\u00a0| 28800 |<\/div>\n<div>+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+<\/div>\n<div>1 row in set (0.00 sec)<\/div>\n<\/div>\n<div><\/div>\n<div>\n<div>\n<div>mysql&gt; SHOW SESSION VARIABLES LIKE &#8216;wait_timeout&#8217;;<\/div>\n<div>+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+<\/div>\n<div>| Variable_name \u00a0 \u00a0| Value |<\/div>\n<div>+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+<\/div>\n<div>|\u00a0wait_timeout\u00a0| 28800 |<\/div>\n<div>+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+<\/div>\n<div>1 row in set (0.00 sec)<\/div>\n<\/div>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div>SET\u00a0GLOBAL\u00a0connect_timeout=60;<\/div>\n<div><\/div>\n<h3 id=\"4._Now_restart_your_mysql_server\" >Section 5. 4. Now restart your mysql server<\/h3>\n<div>\n<h4 id=\"If_you_are_using_mysql_on\u00a0RedHat_Linux_(Fedora_Core\/Cent_OS)\u00a0then_use_following_command:\" >1) If you are using mysql on\u00a0RedHat Linux (Fedora Core\/Cent OS)\u00a0then use following command:<\/h4>\n<\/div>\n<div>\n<pre>\/etc\/init.d\/mysqld restart<\/pre>\n<\/div>\n<div>\n<h4 id=\"If_you_are_using_mysql_on\u00a0Debian_\/_Ubuntu\u00a0Linux_then_use_following_command:\" >2) If you are using mysql on\u00a0Debian \/ Ubuntu\u00a0Linux then use following command:<\/h4>\n<\/div>\n<div>\n<pre>\/etc\/init.d\/mysql restart<\/pre>\n<\/div>\n<div>Thats it \u00a0!<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u041f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u0432\u0441\u0435 \u0442\u0435\u043a\u0443\u0449\u0438\u0435 \u043b\u0438\u043c\u0438\u0442\u044b \u043c\u043e\u0436\u043d\u043e \u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439: show variables like &#8216;%timeout%&#8217;; \u0412\u044b\u0432\u043e\u0434 \u0431\u0443\u0434\u0435\u0442 \u043f\u0440\u0438\u043c\u0435\u0440\u043d\u043e \u0442\u0430\u043a\u043e\u0439: mysql&gt; show variables like &#8216;%timeout%&#8217;; +&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;-+ | Variable_name | Value | +&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;-+ | connect_timeout | 360&hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[23,22,21],"class_list":["post-54","post","type-post","status-publish","format-standard","hentry","category-database","tag-mariadb","tag-mysql","tag-percona"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.4 (Yoast SEO v25.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 Timeout \u0432 MySQL, MariaDB, Percona - GalaxyData Community<\/title>\n<meta name=\"description\" content=\"\u041f\u0440\u0430\u043a\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0435 \u0440\u0443\u043a\u043e\u0432\u043e\u0434\u0441\u0442\u0432\u043e \u043f\u043e \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430 timeout \u0432 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u044b\u0445 \u0421\u0423\u0411\u0414 \u0441\u0435\u043c\u0435\u0439\u0441\u0442\u0432\u0430 MySQL: \u043a\u0430\u043a \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u0438\u043b\u0438 \u0443\u043c\u0435\u043d\u044c\u0448\u0438\u0442\u044c \u0438\u043d\u0442\u0435\u0440\u0432\u0430\u043b \u043e\u0436\u0438\u0434\u0430\u043d\u0438\u044f \u043d\u0435\u0430\u043a\u0442\u0438\u0432\u043d\u044b\u0445 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0439, \u043f\u043e\u0432\u044b\u0448\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0438 \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e\u0441\u0442\u044c \u0440\u0430\u0431\u043e\u0442\u044b \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54\" \/>\n<meta property=\"og:locale\" content=\"ru_RU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 Timeout \u0432 MySQL, MariaDB, Percona\" \/>\n<meta property=\"og:description\" content=\"\u041f\u0440\u0430\u043a\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0435 \u0440\u0443\u043a\u043e\u0432\u043e\u0434\u0441\u0442\u0432\u043e \u043f\u043e \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430 timeout \u0432 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u044b\u0445 \u0421\u0423\u0411\u0414 \u0441\u0435\u043c\u0435\u0439\u0441\u0442\u0432\u0430 MySQL: \u043a\u0430\u043a \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u0438\u043b\u0438 \u0443\u043c\u0435\u043d\u044c\u0448\u0438\u0442\u044c \u0438\u043d\u0442\u0435\u0440\u0432\u0430\u043b \u043e\u0436\u0438\u0434\u0430\u043d\u0438\u044f \u043d\u0435\u0430\u043a\u0442\u0438\u0432\u043d\u044b\u0445 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0439, \u043f\u043e\u0432\u044b\u0448\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0438 \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e\u0441\u0442\u044c \u0440\u0430\u0431\u043e\u0442\u044b \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54\" \/>\n<meta property=\"og:site_name\" content=\"GalaxyData Community\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/vk.com\/galaxydata\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-19T08:29:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-22T21:33:57+00:00\" \/>\n<meta name=\"author\" content=\"Eduard Yamaltdinov\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0430\u0432\u0442\u043e\u0440\u043e\u043c\" \/>\n\t<meta name=\"twitter:data1\" content=\"Eduard Yamaltdinov\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u043c\u0438\u043d\u0443\u0442\u044b\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54#article\",\"isPartOf\":{\"@id\":\"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54\"},\"author\":{\"name\":\"Eduard Yamaltdinov\",\"@id\":\"https:\/\/galaxydata.ru\/community\/#\/schema\/person\/674f493b626af18d90fe784aa69dfd7b\"},\"headline\":\"\u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 Timeout \u0432 MySQL, MariaDB, Percona\",\"datePublished\":\"2016-10-19T08:29:03+00:00\",\"dateModified\":\"2025-07-22T21:33:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54\"},\"wordCount\":226,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/galaxydata.ru\/community\/#organization\"},\"keywords\":[\"mariadb\",\"mysql\",\"percona\"],\"articleSection\":[\"Database\"],\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54\",\"url\":\"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54\",\"name\":\"\u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 Timeout \u0432 MySQL, MariaDB, Percona - GalaxyData Community\",\"isPartOf\":{\"@id\":\"https:\/\/galaxydata.ru\/community\/#website\"},\"datePublished\":\"2016-10-19T08:29:03+00:00\",\"dateModified\":\"2025-07-22T21:33:57+00:00\",\"description\":\"\u041f\u0440\u0430\u043a\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0435 \u0440\u0443\u043a\u043e\u0432\u043e\u0434\u0441\u0442\u0432\u043e \u043f\u043e \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430 timeout \u0432 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u044b\u0445 \u0421\u0423\u0411\u0414 \u0441\u0435\u043c\u0435\u0439\u0441\u0442\u0432\u0430 MySQL: \u043a\u0430\u043a \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u0438\u043b\u0438 \u0443\u043c\u0435\u043d\u044c\u0448\u0438\u0442\u044c \u0438\u043d\u0442\u0435\u0440\u0432\u0430\u043b \u043e\u0436\u0438\u0434\u0430\u043d\u0438\u044f \u043d\u0435\u0430\u043a\u0442\u0438\u0432\u043d\u044b\u0445 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0439, \u043f\u043e\u0432\u044b\u0448\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0438 \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e\u0441\u0442\u044c \u0440\u0430\u0431\u043e\u0442\u044b \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.\",\"breadcrumb\":{\"@id\":\"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54#breadcrumb\"},\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\",\"item\":\"https:\/\/galaxydata.ru\/community\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 Timeout \u0432 MySQL, MariaDB, Percona\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/galaxydata.ru\/community\/#website\",\"url\":\"https:\/\/galaxydata.ru\/community\/\",\"name\":\"GalaxyData Community\",\"description\":\"Tutorial for Cloud VDS\",\"publisher\":{\"@id\":\"https:\/\/galaxydata.ru\/community\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/galaxydata.ru\/community\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ru-RU\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/galaxydata.ru\/community\/#organization\",\"name\":\"GalaxyData Community\",\"url\":\"https:\/\/galaxydata.ru\/community\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\/\/galaxydata.ru\/community\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/galaxydata.ru\/community\/wp-content\/uploads\/2025\/07\/favicon_from_logo_32x32_gd.png\",\"contentUrl\":\"https:\/\/galaxydata.ru\/community\/wp-content\/uploads\/2025\/07\/favicon_from_logo_32x32_gd.png\",\"width\":32,\"height\":32,\"caption\":\"GalaxyData Community\"},\"image\":{\"@id\":\"https:\/\/galaxydata.ru\/community\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/vk.com\/galaxydata\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/galaxydata.ru\/community\/#\/schema\/person\/674f493b626af18d90fe784aa69dfd7b\",\"name\":\"Eduard Yamaltdinov\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\/\/galaxydata.ru\/community\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/galaxydata.ru\/community\/wp-content\/uploads\/2016\/10\/cloud-server-150x150.png\",\"contentUrl\":\"https:\/\/galaxydata.ru\/community\/wp-content\/uploads\/2016\/10\/cloud-server-150x150.png\",\"caption\":\"Eduard Yamaltdinov\"},\"description\":\"Eduard Yamaltdinov \u2014 \u0430\u0432\u0442\u043e\u0440 \u0438 \u044d\u043a\u0441\u043f\u0435\u0440\u0442 \u0432 \u043e\u0431\u043b\u0430\u0441\u0442\u0438 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0439 \u0438 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f. \u0415\u0441\u043b\u0438 \u0432\u0430\u043c \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e \u0443\u0437\u043d\u0430\u0442\u044c \u0431\u043e\u043b\u044c\u0448\u0435 \u043e \u0435\u0433\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0445, \u043e\u043f\u044b\u0442\u0435 \u0438\u043b\u0438 \u043f\u0440\u043e\u0435\u043a\u0442\u0430\u0445, \u0441\u043e\u043e\u0431\u0449\u0438\u0442\u0435 \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u0435\u0435, \u043a\u0430\u043a\u0443\u044e \u0438\u043c\u0435\u043d\u043d\u043e \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u0445\u043e\u0442\u0438\u0442\u0435 \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c.\",\"url\":\"https:\/\/galaxydata.ru\/community\/author\/galaxydata\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 Timeout \u0432 MySQL, MariaDB, Percona - GalaxyData Community","description":"\u041f\u0440\u0430\u043a\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0435 \u0440\u0443\u043a\u043e\u0432\u043e\u0434\u0441\u0442\u0432\u043e \u043f\u043e \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430 timeout \u0432 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u044b\u0445 \u0421\u0423\u0411\u0414 \u0441\u0435\u043c\u0435\u0439\u0441\u0442\u0432\u0430 MySQL: \u043a\u0430\u043a \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u0438\u043b\u0438 \u0443\u043c\u0435\u043d\u044c\u0448\u0438\u0442\u044c \u0438\u043d\u0442\u0435\u0440\u0432\u0430\u043b \u043e\u0436\u0438\u0434\u0430\u043d\u0438\u044f \u043d\u0435\u0430\u043a\u0442\u0438\u0432\u043d\u044b\u0445 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0439, \u043f\u043e\u0432\u044b\u0448\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0438 \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e\u0441\u0442\u044c \u0440\u0430\u0431\u043e\u0442\u044b \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54","og_locale":"ru_RU","og_type":"article","og_title":"\u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 Timeout \u0432 MySQL, MariaDB, Percona","og_description":"\u041f\u0440\u0430\u043a\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0435 \u0440\u0443\u043a\u043e\u0432\u043e\u0434\u0441\u0442\u0432\u043e \u043f\u043e \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430 timeout \u0432 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u044b\u0445 \u0421\u0423\u0411\u0414 \u0441\u0435\u043c\u0435\u0439\u0441\u0442\u0432\u0430 MySQL: \u043a\u0430\u043a \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u0438\u043b\u0438 \u0443\u043c\u0435\u043d\u044c\u0448\u0438\u0442\u044c \u0438\u043d\u0442\u0435\u0440\u0432\u0430\u043b \u043e\u0436\u0438\u0434\u0430\u043d\u0438\u044f \u043d\u0435\u0430\u043a\u0442\u0438\u0432\u043d\u044b\u0445 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0439, \u043f\u043e\u0432\u044b\u0448\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0438 \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e\u0441\u0442\u044c \u0440\u0430\u0431\u043e\u0442\u044b \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.","og_url":"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54","og_site_name":"GalaxyData Community","article_publisher":"https:\/\/vk.com\/galaxydata","article_published_time":"2016-10-19T08:29:03+00:00","article_modified_time":"2025-07-22T21:33:57+00:00","author":"Eduard Yamaltdinov","twitter_card":"summary_large_image","twitter_misc":{"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0430\u0432\u0442\u043e\u0440\u043e\u043c":"Eduard Yamaltdinov","\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f":"2 \u043c\u0438\u043d\u0443\u0442\u044b"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54#article","isPartOf":{"@id":"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54"},"author":{"name":"Eduard Yamaltdinov","@id":"https:\/\/galaxydata.ru\/community\/#\/schema\/person\/674f493b626af18d90fe784aa69dfd7b"},"headline":"\u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 Timeout \u0432 MySQL, MariaDB, Percona","datePublished":"2016-10-19T08:29:03+00:00","dateModified":"2025-07-22T21:33:57+00:00","mainEntityOfPage":{"@id":"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54"},"wordCount":226,"commentCount":0,"publisher":{"@id":"https:\/\/galaxydata.ru\/community\/#organization"},"keywords":["mariadb","mysql","percona"],"articleSection":["Database"],"inLanguage":"ru-RU","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54#respond"]}]},{"@type":"WebPage","@id":"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54","url":"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54","name":"\u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 Timeout \u0432 MySQL, MariaDB, Percona - GalaxyData Community","isPartOf":{"@id":"https:\/\/galaxydata.ru\/community\/#website"},"datePublished":"2016-10-19T08:29:03+00:00","dateModified":"2025-07-22T21:33:57+00:00","description":"\u041f\u0440\u0430\u043a\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0435 \u0440\u0443\u043a\u043e\u0432\u043e\u0434\u0441\u0442\u0432\u043e \u043f\u043e \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430 timeout \u0432 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u044b\u0445 \u0421\u0423\u0411\u0414 \u0441\u0435\u043c\u0435\u0439\u0441\u0442\u0432\u0430 MySQL: \u043a\u0430\u043a \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u0438\u043b\u0438 \u0443\u043c\u0435\u043d\u044c\u0448\u0438\u0442\u044c \u0438\u043d\u0442\u0435\u0440\u0432\u0430\u043b \u043e\u0436\u0438\u0434\u0430\u043d\u0438\u044f \u043d\u0435\u0430\u043a\u0442\u0438\u0432\u043d\u044b\u0445 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0439, \u043f\u043e\u0432\u044b\u0448\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0438 \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e\u0441\u0442\u044c \u0440\u0430\u0431\u043e\u0442\u044b \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.","breadcrumb":{"@id":"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54#breadcrumb"},"inLanguage":"ru-RU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/galaxydata.ru\/community\/izmenenie-timeout-v-mysql-mariadb-percona-54#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/galaxydata.ru\/community"},{"@type":"ListItem","position":2,"name":"\u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 Timeout \u0432 MySQL, MariaDB, Percona"}]},{"@type":"WebSite","@id":"https:\/\/galaxydata.ru\/community\/#website","url":"https:\/\/galaxydata.ru\/community\/","name":"GalaxyData Community","description":"Tutorial for Cloud VDS","publisher":{"@id":"https:\/\/galaxydata.ru\/community\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/galaxydata.ru\/community\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ru-RU"},{"@type":"Organization","@id":"https:\/\/galaxydata.ru\/community\/#organization","name":"GalaxyData Community","url":"https:\/\/galaxydata.ru\/community\/","logo":{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/galaxydata.ru\/community\/#\/schema\/logo\/image\/","url":"https:\/\/galaxydata.ru\/community\/wp-content\/uploads\/2025\/07\/favicon_from_logo_32x32_gd.png","contentUrl":"https:\/\/galaxydata.ru\/community\/wp-content\/uploads\/2025\/07\/favicon_from_logo_32x32_gd.png","width":32,"height":32,"caption":"GalaxyData Community"},"image":{"@id":"https:\/\/galaxydata.ru\/community\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/vk.com\/galaxydata"]},{"@type":"Person","@id":"https:\/\/galaxydata.ru\/community\/#\/schema\/person\/674f493b626af18d90fe784aa69dfd7b","name":"Eduard Yamaltdinov","image":{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/galaxydata.ru\/community\/#\/schema\/person\/image\/","url":"https:\/\/galaxydata.ru\/community\/wp-content\/uploads\/2016\/10\/cloud-server-150x150.png","contentUrl":"https:\/\/galaxydata.ru\/community\/wp-content\/uploads\/2016\/10\/cloud-server-150x150.png","caption":"Eduard Yamaltdinov"},"description":"Eduard Yamaltdinov \u2014 \u0430\u0432\u0442\u043e\u0440 \u0438 \u044d\u043a\u0441\u043f\u0435\u0440\u0442 \u0432 \u043e\u0431\u043b\u0430\u0441\u0442\u0438 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0439 \u0438 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f. \u0415\u0441\u043b\u0438 \u0432\u0430\u043c \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e \u0443\u0437\u043d\u0430\u0442\u044c \u0431\u043e\u043b\u044c\u0448\u0435 \u043e \u0435\u0433\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0445, \u043e\u043f\u044b\u0442\u0435 \u0438\u043b\u0438 \u043f\u0440\u043e\u0435\u043a\u0442\u0430\u0445, \u0441\u043e\u043e\u0431\u0449\u0438\u0442\u0435 \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u0435\u0435, \u043a\u0430\u043a\u0443\u044e \u0438\u043c\u0435\u043d\u043d\u043e \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u0445\u043e\u0442\u0438\u0442\u0435 \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c.","url":"https:\/\/galaxydata.ru\/community\/author\/galaxydata"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/posts\/54","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/comments?post=54"}],"version-history":[{"count":1,"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/posts\/54\/revisions"}],"predecessor-version":[{"id":2051,"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/posts\/54\/revisions\/2051"}],"wp:attachment":[{"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/media?parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/categories?post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/tags?post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}