{"id":1134575,"date":"2020-09-23T15:13:58","date_gmt":"2020-09-23T11:43:58","guid":{"rendered":"https:\/\/iranamir.com\/news\/?p=1134575"},"modified":"2020-09-23T15:13:58","modified_gmt":"2020-09-23T11:43:58","slug":"best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more","status":"publish","type":"post","link":"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/","title":{"rendered":"Best Optimized my.cnf 2021 server configuration with 32GB ram and more"},"content":{"rendered":"<p dir=\"ltr\" style=\"text-align: left;\"><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">The best MySQL and MariaDb \/ mysql and mariadb settings for an 8-core server with 32GB of RAM are listed below.<\/span><\/span><\/p>\n<p dir=\"ltr\" style=\"text-align: left;\"><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">Of course note, that these settings also work for up to 128GB of RAM and a 10- to 20-core CPU.<\/span> <span class=\"\" title=\"\">And it is very suitable for visits of more than 1000 people online &#8230;<\/span><\/span><\/p>\n<p style=\"text-align: left;\"><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">If you use the following command<\/span><\/span><\/p>\n<p style=\"text-align: left;\">perl mysqltuner.pl<\/p>\n<p style=\"text-align: left;\"><span class=\"tlid-translation translation\" lang=\"en\"><span title=\"\">Your data after 48 is suggested to you to modify.<\/span> <span class=\"\" title=\"\">It is better to ignore!<\/span> <span class=\"\" title=\"\">Of course for 32G RAM!<\/span><\/span><\/p>\n<p dir=\"ltr\" style=\"text-align: left;\"><span class=\"tlid-translation translation\" lang=\"en\"><span title=\"\">If you have any questions, ask at the bottom to be answered.<\/span> <span class=\"\" title=\"\">Of course, note that any changes in these codes may have CP loaded, so it is recommended to ask before any changes.<\/span><\/span><\/p>\n<figure id=\"attachment_1134573\" aria-describedby=\"caption-attachment-1134573\" style=\"width: 403px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-1134573\" src=\"https:\/\/iranamir.com\/news\/wp-content\/uploads\/2020\/09\/mycnf32gbram.png\" alt=\"\u06a9\u0627\u0646\u0641\u06cc\u06af my.cnf \u062d\u0631\u0641\u0647 \u0627\u06cc\u06cc\" width=\"403\" height=\"339\" srcset=\"https:\/\/iranamir.com\/news\/wp-content\/uploads\/2020\/09\/mycnf32gbram.png 1206w, https:\/\/iranamir.com\/news\/wp-content\/uploads\/2020\/09\/mycnf32gbram-300x252.png 300w\" sizes=\"auto, (max-width: 403px) 100vw, 403px\" \/><figcaption id=\"caption-attachment-1134573\" class=\"wp-caption-text\">\u062a\u0646\u0638\u06cc\u0645\u0627\u062a \u0628\u0647\u06cc\u0646\u0647 \u0633\u0627\u0632\u06cc \u0634\u062f\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 my.cnf \u062c\u062f\u06cc\u062f \u0628\u0631\u0627\u06cc \u0647\u0627\u06cc \u0644\u0648\u062f \u0633\u0631\u0648\u0631<\/figcaption><\/figure>\n<p style=\"text-align: left;\">[mysql]<br \/>\nport = 3306<\/p>\n<p style=\"text-align: left;\">[mysqld]<br \/>\nsql-mode = &#8220;&#8221;<br \/>\nperformance-schema = 0<br \/>\nsocket = \/var\/lib\/mysql\/mysql.sock<br \/>\nsymbolic-links = 0<br \/>\nlog-error = \/var\/log\/mysqld.log<br \/>\nbind_address = 127.0.0.1 # Change to 0.0.0.0 to allow remote connections<br \/>\nmax_allowed_packet=256M<br \/>\nmax_connect_errors = 100<br \/>\nport = 3306<br \/>\nskip_external_locking<br \/>\nskip_name_resolve=1<br \/>\n#max_connections = 256<br \/>\n#max_user_connections = 200<br \/>\ninteractive_timeout = 300<br \/>\nwait_timeout = 300<br \/>\nconnect_timeout =10<br \/>\nthread_stack = 256K<br \/>\njoin_buffer_size =256M<br \/>\nread_buffer_size = 32M<br \/>\nread_rnd_buffer_size =32M<br \/>\nsort_buffer_size = 32M<br \/>\nthread_cache_size = 256<br \/>\ntable_cache = 2048<br \/>\ntable_open_cache =2048<br \/>\ntable_definition_cache = 2048<br \/>\nquery_cache_type = 0<br \/>\nquery_cache_size = 0<br \/>\nquery_cache_limit =16M<br \/>\nopen_files_limit = 131072<br \/>\nquery_cache_min_res_unit=512<br \/>\nperformance_schema=ON<\/p>\n<p style=\"text-align: left;\"># Enable for b\/c with databases created in older MySQL\/MariaDB versions (e.g. when using null dates)<br \/>\n#sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES<\/p>\n<p style=\"text-align: left;\">tmpdir = \/tmp<br \/>\nuser = mysql<\/p>\n<p style=\"text-align: left;\"># InnoDB Settings<br \/>\ndefault_storage_engine = InnoDB<br \/>\ninnodb_buffer_pool_instances =10 # Use 1 instance per 1GB of InnoDB pool size<br \/>\ninnodb_buffer_pool_size = 10G # Use up to 70-80% of RAM<br \/>\ninnodb_file_per_table = 1<br \/>\ninnodb_flush_log_at_trx_commit = 0<br \/>\ninnodb_flush_method = O_DIRECT<br \/>\ninnodb_log_buffer_size = 512M<br \/>\ninnodb_log_file_size = 1G<br \/>\ninnodb_stats_on_metadata = 0<\/p>\n<p style=\"text-align: left;\">#innodb_temp_data_file_path = ibtmp1:64M:autoextend:max:20G # Control the maximum size for the ibtmp1 file<br \/>\n#innodb_thread_concurrency = 6 # Optional: Set to the number of CPUs on your system (minus 1 or 2) to better<br \/>\n# contain CPU usage. E.g. if your system has 8 CPUs, try 6 or 7 and check<br \/>\n# the overall load produced by MySQL\/MariaDB.<br \/>\ninnodb_read_io_threads = 64<br \/>\ninnodb_write_io_threads = 64<\/p>\n<p style=\"text-align: left;\"># MyISAM Settings<\/p>\n<p style=\"text-align: left;\">key_buffer_size = 256M<\/p>\n<p style=\"text-align: left;\">low_priority_updates = 1<br \/>\nconcurrent_insert = 2<br \/>\nback_log = 512<br \/>\n# Table Settings<\/p>\n<p style=\"text-align: left;\">max_heap_table_size =1024M<br \/>\ntmp_table_size =1024M<\/p>\n<p style=\"text-align: left;\"># Search Settings<br \/>\nft_min_word_len = 3 # Minimum length of words to be indexed for search results<\/p>\n<p style=\"text-align: left;\"># Logging<br \/>\nlog_error = \/var\/lib\/mysql\/mysql_error.log<br \/>\nlog_queries_not_using_indexes = 1<br \/>\nlong_query_time = 5<br \/>\nslow_query_log = 0 # Disabled for production<br \/>\nslow_query_log_file = \/var\/lib\/mysql\/mysql_slow.log<\/p>\n<p style=\"text-align: left;\">[mysqldump]<br \/>\nquick<br \/>\nquote_names<br \/>\nmax_allowed_packet =256M<\/p>\n<p style=\"text-align: left;\">\n<p dir=\"ltr\" style=\"text-align: left;\"><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">If you have a problem with your server configuration, leave a message through the comments section to be resolved for you.<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The best MySQL and MariaDb \/ mysql and mariadb settings for an 8-core server with 32GB of RAM are listed below.<\/p>\n","protected":false},"author":1,"featured_media":1134583,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[26339,26335,26340],"class_list":["post-1134575","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-9","tag-config-my-cnf","tag-my-cnf","tag-set-my-cnf"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631 - Best Optimized my.cnf 2021 server configuration with 32GB ram and more<\/title>\n<meta name=\"description\" content=\"The best MySQL and MariaDb \/ mysql and mariadb settings for an 8-core server with 32GB of RAM are listed below.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/\u0627\u062e\u0628\u0627\u0631-\u0631\u0648\u0632\/\" \/>\n<meta property=\"og:locale\" content=\"fa_IR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631 - Best Optimized my.cnf 2021 server configuration with 32GB ram and more\" \/>\n<meta property=\"og:description\" content=\"The best MySQL and MariaDb \/ mysql and mariadb settings for an 8-core server with 32GB of RAM are listed below.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/\u0627\u062e\u0628\u0627\u0631-\u0631\u0648\u0632\/\" \/>\n<meta property=\"og:site_name\" content=\"\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/iranamirco-100742161421876\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-23T11:43:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/iranamir.com\/news\/wp-content\/uploads\/2020\/09\/mycnf32gbram-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1206\" \/>\n\t<meta property=\"og:image:height\" content=\"1014\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0646\u0648\u0634\u062a\u0647\u200c\u0634\u062f\u0647 \u0628\u062f\u0633\u062a\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u0632\u0645\u0627\u0646 \u062a\u0642\u0631\u06cc\u0628\u06cc \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u062f\u0642\u06cc\u0642\u0647\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/\",\"url\":\"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/\",\"name\":\"\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631 - Best Optimized my.cnf 2021 server configuration with 32GB ram and more\",\"isPartOf\":{\"@id\":\"https:\/\/iranamir.com\/news\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/iranamir.com\/news\/wp-content\/uploads\/2020\/09\/mycnf32gbram-1.png\",\"datePublished\":\"2020-09-23T11:43:58+00:00\",\"author\":{\"@id\":\"https:\/\/iranamir.com\/news\/#\/schema\/person\/cb033af2672956685c09d06ce7f9cb28\"},\"description\":\"The best MySQL and MariaDb \/ mysql and mariadb settings for an 8-core server with 32GB of RAM are listed below.\",\"breadcrumb\":{\"@id\":\"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/#breadcrumb\"},\"inLanguage\":\"fa-IR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/#primaryimage\",\"url\":\"https:\/\/iranamir.com\/news\/wp-content\/uploads\/2020\/09\/mycnf32gbram-1.png\",\"contentUrl\":\"https:\/\/iranamir.com\/news\/wp-content\/uploads\/2020\/09\/mycnf32gbram-1.png\",\"width\":1206,\"height\":1014,\"caption\":\"config my.cnf optimized\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u062e\u0627\u0646\u0647\",\"item\":\"https:\/\/iranamir.com\/news\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0627\u062e\u0628\u0627\u0631 \u0631\u0648\u0632\",\"item\":\"https:\/\/iranamir.com\/news\/category\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Best Optimized my.cnf 2021 server configuration with 32GB ram and more\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/iranamir.com\/news\/#website\",\"url\":\"https:\/\/iranamir.com\/news\/\",\"name\":\"\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631\",\"description\":\"\u0627\u0631\u0627\u0626\u0647 \u062e\u0628\u0631\u0647\u0627\u06cc \u067e\u0631\u0628\u0627\u0632\u062f\u06cc\u062f \u0648 \u0645\u0647\u0645 \u0631\u0648\u0632 \u062c\u0647\u0627\u0646\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/iranamir.com\/news\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fa-IR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/iranamir.com\/news\/#\/schema\/person\/cb033af2672956685c09d06ce7f9cb28\",\"name\":\"\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\/\/iranamir.com\/news\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/56fceb509d7f10ddfbe134e79d39711334e5dee8bb693d0e94918a5f021ccf49?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/56fceb509d7f10ddfbe134e79d39711334e5dee8bb693d0e94918a5f021ccf49?s=96&d=mm&r=g\",\"caption\":\"\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631\"},\"sameAs\":[\"https:\/\/iranamir.com\/news\"],\"url\":\"https:\/\/iranamir.com\/news\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631 - Best Optimized my.cnf 2021 server configuration with 32GB ram and more","description":"The best MySQL and MariaDb \/ mysql and mariadb settings for an 8-core server with 32GB of RAM are listed below.","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:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/\u0627\u062e\u0628\u0627\u0631-\u0631\u0648\u0632\/","og_locale":"fa_IR","og_type":"article","og_title":"\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631 - Best Optimized my.cnf 2021 server configuration with 32GB ram and more","og_description":"The best MySQL and MariaDb \/ mysql and mariadb settings for an 8-core server with 32GB of RAM are listed below.","og_url":"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/\u0627\u062e\u0628\u0627\u0631-\u0631\u0648\u0632\/","og_site_name":"\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631","article_publisher":"https:\/\/www.facebook.com\/iranamirco-100742161421876\/","article_published_time":"2020-09-23T11:43:58+00:00","og_image":[{"width":1206,"height":1014,"url":"https:\/\/iranamir.com\/news\/wp-content\/uploads\/2020\/09\/mycnf32gbram-1.png","type":"image\/png"}],"author":"\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631","twitter_card":"summary_large_image","twitter_misc":{"\u0646\u0648\u0634\u062a\u0647\u200c\u0634\u062f\u0647 \u0628\u062f\u0633\u062a":"\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631","\u0632\u0645\u0627\u0646 \u062a\u0642\u0631\u06cc\u0628\u06cc \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646":"2 \u062f\u0642\u06cc\u0642\u0647"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/","url":"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/","name":"\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631 - Best Optimized my.cnf 2021 server configuration with 32GB ram and more","isPartOf":{"@id":"https:\/\/iranamir.com\/news\/#website"},"primaryImageOfPage":{"@id":"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/#primaryimage"},"image":{"@id":"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/#primaryimage"},"thumbnailUrl":"https:\/\/iranamir.com\/news\/wp-content\/uploads\/2020\/09\/mycnf32gbram-1.png","datePublished":"2020-09-23T11:43:58+00:00","author":{"@id":"https:\/\/iranamir.com\/news\/#\/schema\/person\/cb033af2672956685c09d06ce7f9cb28"},"description":"The best MySQL and MariaDb \/ mysql and mariadb settings for an 8-core server with 32GB of RAM are listed below.","breadcrumb":{"@id":"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/#breadcrumb"},"inLanguage":"fa-IR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/"]}]},{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/#primaryimage","url":"https:\/\/iranamir.com\/news\/wp-content\/uploads\/2020\/09\/mycnf32gbram-1.png","contentUrl":"https:\/\/iranamir.com\/news\/wp-content\/uploads\/2020\/09\/mycnf32gbram-1.png","width":1206,"height":1014,"caption":"config my.cnf optimized"},{"@type":"BreadcrumbList","@id":"https:\/\/iranamir.com\/news\/best-optimized-my-cnf-2021-server-configuration-with-32gb-ram-and-more\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u062e\u0627\u0646\u0647","item":"https:\/\/iranamir.com\/news\/"},{"@type":"ListItem","position":2,"name":"\u0627\u062e\u0628\u0627\u0631 \u0631\u0648\u0632","item":"https:\/\/iranamir.com\/news\/category\/%d8%a7%d8%ae%d8%a8%d8%a7%d8%b1-%d8%b1%d9%88%d8%b2\/"},{"@type":"ListItem","position":3,"name":"Best Optimized my.cnf 2021 server configuration with 32GB ram and more"}]},{"@type":"WebSite","@id":"https:\/\/iranamir.com\/news\/#website","url":"https:\/\/iranamir.com\/news\/","name":"\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631","description":"\u0627\u0631\u0627\u0626\u0647 \u062e\u0628\u0631\u0647\u0627\u06cc \u067e\u0631\u0628\u0627\u0632\u062f\u06cc\u062f \u0648 \u0645\u0647\u0645 \u0631\u0648\u0632 \u062c\u0647\u0627\u0646","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/iranamir.com\/news\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fa-IR"},{"@type":"Person","@id":"https:\/\/iranamir.com\/news\/#\/schema\/person\/cb033af2672956685c09d06ce7f9cb28","name":"\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631","image":{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/iranamir.com\/news\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/56fceb509d7f10ddfbe134e79d39711334e5dee8bb693d0e94918a5f021ccf49?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/56fceb509d7f10ddfbe134e79d39711334e5dee8bb693d0e94918a5f021ccf49?s=96&d=mm&r=g","caption":"\u062e\u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0627\u06cc\u0631\u0627\u0646 \u0627\u0645\u06cc\u0631"},"sameAs":["https:\/\/iranamir.com\/news"],"url":"https:\/\/iranamir.com\/news\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/iranamir.com\/news\/wp-json\/wp\/v2\/posts\/1134575","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iranamir.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iranamir.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iranamir.com\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/iranamir.com\/news\/wp-json\/wp\/v2\/comments?post=1134575"}],"version-history":[{"count":0,"href":"https:\/\/iranamir.com\/news\/wp-json\/wp\/v2\/posts\/1134575\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/iranamir.com\/news\/wp-json\/wp\/v2\/media\/1134583"}],"wp:attachment":[{"href":"https:\/\/iranamir.com\/news\/wp-json\/wp\/v2\/media?parent=1134575"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iranamir.com\/news\/wp-json\/wp\/v2\/categories?post=1134575"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iranamir.com\/news\/wp-json\/wp\/v2\/tags?post=1134575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}