{"id":316463,"date":"2026-06-21T15:30:13","date_gmt":"2026-06-21T12:30:13","guid":{"rendered":"https:\/\/www.freeextra.com\/uncategorized\/veltistopoiisi-diakomisti-mariadb-mysql\/"},"modified":"2026-09-09T12:00:13","modified_gmt":"2026-09-09T09:00:13","slug":"veltistopoiisi-diakomisti-mariadb-mysql","status":"publish","type":"post","link":"https:\/\/www.freeextra.com\/en\/uncategorized\/veltistopoiisi-diakomisti-mariadb-mysql\/","title":{"rendered":"\u0392\u03b5\u03bb\u03c4\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03b4\u03b9\u03b1\u03ba\u03bf\u03bc\u03b9\u03c3\u03c4\u03ae MariaDB, mySQL"},"content":{"rendered":"<p>\u0394\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 tmp \u03c6\u03b1\u03ba\u03ad\u03bb\u03bf\u03c5 \u03bc\u03ad\u03c3\u03b1 \u03c3\u03c4\u03bf \u03c6\u03ac\u03ba\u03b5\u03bb\u03bf \/var\/lib\/mysql\/ \u03c3\u03b5 \u03c0\u03b5\u03c1\u03af\u03c0\u03c4\u03c9\u03c3\u03b7 \u03c0\u03bf\u03c5 \u03b5\u03af\u03bd\u03b1\u03b9 \u03bc\u03cc\u03bd\u03bf \u03b1\u03c5\u03c4\u03cc\u03c2 \u03bf\u03c1\u03b9\u03c3\u03bc\u03ad\u03bd\u03bf\u03c2 \u03c3\u03b5 ssd \u03b4\u03af\u03c3\u03ba\u03bf.<\/p>\n<p>\u039f\u03c1\u03b9\u03c3\u03bc\u03cc\u03c2 \u03b4\u03b9\u03ba\u03b1\u03b9\u03c9\u03bc\u03ac\u03c4\u03c9\u03bd:<\/p>\n<p><!-- Urvanov Syntax Highlighter v2.9.1 --><\/p>\n<div id=\"urvanov-syntax-highlighter-6aa12012293c7381699057\" class=\"urvanov-syntax-highlighter-syntax crayon-theme-classic urvanov-syntax-highlighter-font-monaco urvanov-syntax-highlighter-os-pc print-yes notranslate\" data-settings=\" no-popup minimize scroll-mouseover disable-anim wrap\" style=\" margin-top: 12px; margin-bottom: 12px; font-size: 12px !important; line-height: 15px !important;\">\n<div class=\"crayon-toolbar\" data-settings=\" show\" style=\"font-size: 12px !important;height: 18px !important; line-height: 18px !important;\"><span class=\"crayon-title\"><\/span><\/p>\n<div class=\"crayon-tools\" style=\"font-size: 12px !important;height: 18px !important; line-height: 18px !important;\">\n<div class=\"crayon-button urvanov-syntax-highlighter-nums-button\" title=\"Toggle Line Numbers\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button urvanov-syntax-highlighter-plain-button\" title=\"Toggle Plain Code\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button urvanov-syntax-highlighter-wrap-button\" title=\"Toggle Line Wrap\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button urvanov-syntax-highlighter-copy-button\" title=\"Copy\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"crayon-info\" style=\"min-height: 16.8px !important; line-height: 16.8px !important;\"><\/div>\n<div class=\"urvanov-syntax-highlighter-plain-wrap\"><textarea  class=\"urvanov-syntax-highlighter-plain print-no\" data-settings=\"dblclick\" readonly style=\"-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 12px !important; line-height: 15px !important;\"><br \/>\nchown mysql:mysql \/var\/lib\/mysql\/tmp<br \/>\nchmod 750 \/var\/lib\/mysql\/tmp<\/textarea><\/div>\n<div class=\"urvanov-syntax-highlighter-main\" style=\"\">\n<table class=\"crayon-table\">\n<tr class=\"urvanov-syntax-highlighter-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"urvanov-syntax-highlighter-nums-content\" style=\"font-size: 12px !important; line-height: 15px !important;\">\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293c7381699057-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293c7381699057-2\">2<\/div>\n<\/div>\n<\/td>\n<td class=\"urvanov-syntax-highlighter-code\">\n<div class=\"crayon-pre\" style=\"font-size: 12px !important; line-height: 15px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;\">\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293c7381699057-1\"><span class=\"crayon-e\">chown <\/span><span class=\"crayon-v\">mysql<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-v\">mysql<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-t\">var<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">lib<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">mysql<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-e\">tmp<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293c7381699057-2\"><span class=\"crayon-i\">chmod<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">750<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-t\">var<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">lib<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">mysql<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">tmp<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/table><\/div>\n<\/p><\/div>\n<p><!-- [Format Time: 0.0001 seconds] --><\/p>\n<p>\u0394\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 mysql-slow.log \u03b1\u03c1\u03c7\u03b5\u03af\u03bf\u03c5 \u03bc\u03ad\u03c3\u03b1 \u03c3\u03c4\u03bf \u03c6\u03ac\u03ba\u03b5\u03bb\u03bf \/var\/log\/ \u03b3\u03b9\u03b1 \u03ba\u03b1\u03c4\u03b1\u03b3\u03c1\u03b1\u03c6\u03ae \u03b1\u03c1\u03b3\u03ce\u03bd \u03b5\u03c1\u03c9\u03c4\u03b7\u03bc\u03ac\u03c4\u03c9\u03bd.<\/p>\n<p>\u039f\u03c1\u03b9\u03c3\u03bc\u03cc\u03c2 \u03b4\u03b9\u03ba\u03b1\u03b9\u03c9\u03bc\u03ac\u03c4\u03c9\u03bd:<\/p>\n<p><!-- Urvanov Syntax Highlighter v2.9.1 --><\/p>\n<div id=\"urvanov-syntax-highlighter-6aa12012293ce974174913\" class=\"urvanov-syntax-highlighter-syntax crayon-theme-classic urvanov-syntax-highlighter-font-monaco urvanov-syntax-highlighter-os-pc print-yes notranslate\" data-settings=\" no-popup minimize scroll-mouseover disable-anim wrap\" style=\" margin-top: 12px; margin-bottom: 12px; font-size: 12px !important; line-height: 15px !important;\">\n<div class=\"crayon-toolbar\" data-settings=\" show\" style=\"font-size: 12px !important;height: 18px !important; line-height: 18px !important;\"><span class=\"crayon-title\"><\/span><\/p>\n<div class=\"crayon-tools\" style=\"font-size: 12px !important;height: 18px !important; line-height: 18px !important;\">\n<div class=\"crayon-button urvanov-syntax-highlighter-nums-button\" title=\"Toggle Line Numbers\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button urvanov-syntax-highlighter-plain-button\" title=\"Toggle Plain Code\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button urvanov-syntax-highlighter-wrap-button\" title=\"Toggle Line Wrap\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button urvanov-syntax-highlighter-copy-button\" title=\"Copy\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"crayon-info\" style=\"min-height: 16.8px !important; line-height: 16.8px !important;\"><\/div>\n<div class=\"urvanov-syntax-highlighter-plain-wrap\"><textarea  class=\"urvanov-syntax-highlighter-plain print-no\" data-settings=\"dblclick\" readonly style=\"-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 12px !important; line-height: 15px !important;\"><br \/>\nchown mysql:mysql \/var\/log\/mysql-slow.log<br \/>\nchmod 640 \/var\/log\/mysql-slow.log<\/textarea><\/div>\n<div class=\"urvanov-syntax-highlighter-main\" style=\"\">\n<table class=\"crayon-table\">\n<tr class=\"urvanov-syntax-highlighter-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"urvanov-syntax-highlighter-nums-content\" style=\"font-size: 12px !important; line-height: 15px !important;\">\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293ce974174913-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293ce974174913-2\">2<\/div>\n<\/div>\n<\/td>\n<td class=\"urvanov-syntax-highlighter-code\">\n<div class=\"crayon-pre\" style=\"font-size: 12px !important; line-height: 15px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;\">\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293ce974174913-1\"><span class=\"crayon-e\">chown <\/span><span class=\"crayon-v\">mysql<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-v\">mysql<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-t\">var<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">log<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">mysql<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">slow<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">log<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293ce974174913-2\"><span class=\"crayon-i\">chmod<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">640<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-t\">var<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">log<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">mysql<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">slow<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">log<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/table><\/div>\n<\/p><\/div>\n<p><!-- [Format Time: 0.0001 seconds] --><\/p>\n<p>\u0392\u03b5\u03bb\u03c4\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03b9\u03b7\u03bc\u03ad\u03bd\u03bf my.cnf:<\/p>\n<p><!-- Urvanov Syntax Highlighter v2.9.1 --><\/p>\n<div id=\"urvanov-syntax-highlighter-6aa12012293d0146247387\" class=\"urvanov-syntax-highlighter-syntax crayon-theme-classic urvanov-syntax-highlighter-font-monaco urvanov-syntax-highlighter-os-pc print-yes notranslate\" data-settings=\" no-popup minimize scroll-mouseover disable-anim wrap\" style=\" margin-top: 12px; margin-bottom: 12px; font-size: 12px !important; line-height: 15px !important;\">\n<div class=\"crayon-toolbar\" data-settings=\" show\" style=\"font-size: 12px !important;height: 18px !important; line-height: 18px !important;\"><span class=\"crayon-title\"><\/span><\/p>\n<div class=\"crayon-tools\" style=\"font-size: 12px !important;height: 18px !important; line-height: 18px !important;\">\n<div class=\"crayon-button urvanov-syntax-highlighter-nums-button\" title=\"Toggle Line Numbers\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button urvanov-syntax-highlighter-plain-button\" title=\"Toggle Plain Code\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button urvanov-syntax-highlighter-wrap-button\" title=\"Toggle Line Wrap\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button urvanov-syntax-highlighter-copy-button\" title=\"Copy\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"crayon-info\" style=\"min-height: 16.8px !important; line-height: 16.8px !important;\"><\/div>\n<div class=\"urvanov-syntax-highlighter-plain-wrap\"><textarea  class=\"urvanov-syntax-highlighter-plain print-no\" data-settings=\"dblclick\" readonly style=\"-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 12px !important; line-height: 15px !important;\"><br \/>\n[mysqld]<\/p>\n<p># ======================<br \/>\n# BASIC<br \/>\n# ======================<br \/>\ntmpdir = \/var\/lib\/mysql\/tmp<br \/>\nmax_allowed_packet = 64M<br \/>\nlocal_infile = 0<br \/>\nskip_name_resolve = 1<br \/>\nskip_host_cache<br \/>\nmax_connect_errors = 1000000<\/p>\n<p># ======================<br \/>\n# INNODB<br \/>\n# ======================<br \/>\ninnodb_buffer_pool_size = 36G<\/p>\n<p>innodb_log_file_size = 1G<br \/>\ninnodb_log_buffer_size = 64M<\/p>\n<p>innodb_flush_method = O_DIRECT<br \/>\ninnodb_flush_log_at_trx_commit = 1<\/p>\n<p>innodb_io_capacity = 2000<br \/>\ninnodb_io_capacity_max = 4000<br \/>\ninnodb_flush_neighbors = 0<\/p>\n<p>innodb_read_io_threads = 4<br \/>\ninnodb_write_io_threads = 4<br \/>\ninnodb_purge_threads = 4<\/p>\n<p>innodb_file_per_table = 1<br \/>\ninnodb_lock_wait_timeout = 50<br \/>\ninnodb_max_dirty_pages_pct = 75<br \/>\ninnodb_max_dirty_pages_pct_lwm = 10<\/p>\n<p># ======================<br \/>\n# CONNECTIONS<br \/>\n# ======================<\/p>\n<p># Slightly more conservative without DB Governor.<br \/>\nmax_connections = 150<br \/>\nthread_cache_size = 128<br \/>\nback_log = 256<\/p>\n<p>wait_timeout = 300<br \/>\ninteractive_timeout = 600<\/p>\n<p># ======================<br \/>\n# TEMP TABLES<br \/>\n# ======================<br \/>\ntmp_table_size = 64M<br \/>\nmax_heap_table_size = 64M<\/p>\n<p># ======================<br \/>\n# PER-CONNECTION BUFFERS<br \/>\n# ======================<br \/>\nsort_buffer_size = 2M<br \/>\njoin_buffer_size = 2M<br \/>\nread_buffer_size = 1M<br \/>\nread_rnd_buffer_size = 1M<\/p>\n<p># ======================<br \/>\n# MYISAM<br \/>\n# ======================<br \/>\nkey_buffer_size = 1G<br \/>\nconcurrent_insert = 2<br \/>\nmyisam_recover_options = BACKUP,FORCE<\/p>\n<p># ======================<br \/>\n# TABLE CACHE<br \/>\n# ======================<br \/>\ntable_open_cache = 8000<br \/>\ntable_definition_cache = 8000<br \/>\ntable_open_cache_instances = 16<br \/>\nopen_files_limit = 80000<\/p>\n<p># ======================<br \/>\n# QUERY CACHE<br \/>\n# ======================<br \/>\nquery_cache_type = 0<br \/>\nquery_cache_size = 0<\/p>\n<p># ======================<br \/>\n# LOGGING<br \/>\n# ======================<br \/>\nslow_query_log = 1<br \/>\nslow_query_log_file = \/var\/log\/mysql-slow.log<br \/>\nlong_query_time = 3<br \/>\nmin_examined_row_limit = 100<br \/>\nlog_queries_not_using_indexes = 0<\/p>\n<p># ======================<br \/>\n# DURABILITY<br \/>\n# ======================<br \/>\nsync_binlog = 1<\/p>\n<p># ======================<br \/>\n# MONITORING<br \/>\n# ======================<br \/>\nperformance_schema = ON<\/textarea><\/div>\n<div class=\"urvanov-syntax-highlighter-main\" style=\"\">\n<table class=\"crayon-table\">\n<tr class=\"urvanov-syntax-highlighter-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"urvanov-syntax-highlighter-nums-content\" style=\"font-size: 12px !important; line-height: 15px !important;\">\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-13\">13<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-15\">15<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-16\">16<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-17\">17<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-18\">18<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-19\">19<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-20\">20<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-21\">21<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-22\">22<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-23\">23<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-24\">24<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-25\">25<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-26\">26<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-27\">27<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-28\">28<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-29\">29<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-30\">30<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-31\">31<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-32\">32<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-33\">33<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-34\">34<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-35\">35<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-36\">36<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-37\">37<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-38\">38<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-39\">39<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-40\">40<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-41\">41<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-42\">42<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-43\">43<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-44\">44<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-45\">45<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-46\">46<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-47\">47<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-48\">48<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-49\">49<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-50\">50<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-51\">51<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-52\">52<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-53\">53<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-54\">54<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-55\">55<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-56\">56<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-57\">57<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-58\">58<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-59\">59<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-60\">60<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-61\">61<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-62\">62<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-63\">63<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-64\">64<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-65\">65<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-66\">66<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-67\">67<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-68\">68<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-69\">69<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-70\">70<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-71\">71<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-72\">72<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-73\">73<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-74\">74<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-75\">75<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-76\">76<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-77\">77<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-78\">78<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-79\">79<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-80\">80<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-81\">81<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-82\">82<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-83\">83<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-84\">84<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-85\">85<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-86\">86<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-87\">87<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-88\">88<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-89\">89<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-90\">90<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-91\">91<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-92\">92<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-93\">93<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-94\">94<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-95\">95<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-96\">96<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-97\">97<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-98\">98<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-99\">99<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-100\">100<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6aa12012293d0146247387-101\">101<\/div>\n<\/div>\n<\/td>\n<td class=\"urvanov-syntax-highlighter-code\">\n<div class=\"crayon-pre\" style=\"font-size: 12px !important; line-height: 15px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;\">\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-1\"><span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">mysqld<\/span><span class=\"crayon-sy\">]<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-2\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-3\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-4\"><span class=\"crayon-p\"># BASIC<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-5\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-6\"><span class=\"crayon-v\">tmpdir<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-t\">var<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">lib<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">mysql<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-e\">tmp<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-7\"><span class=\"crayon-v\">max_allowed_packet<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">64M<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-8\"><span class=\"crayon-v\">local_infile<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">0<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-9\"><span class=\"crayon-v\">skip_name_resolve<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">1<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-10\"><span class=\"crayon-e\">skip_host_cache<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-11\"><span class=\"crayon-v\">max_connect_errors<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">1000000<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-12\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-13\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-14\"><span class=\"crayon-p\"># INNODB<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-15\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-16\"><span class=\"crayon-v\">innodb_buffer_pool_size<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">36G<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-17\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-18\"><span class=\"crayon-v\">innodb_log_file_size<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">1G<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-19\"><span class=\"crayon-v\">innodb_log_buffer_size<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">64M<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-20\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-21\"><span class=\"crayon-v\">innodb_flush_method<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">O_DIRECT<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-22\"><span class=\"crayon-v\">innodb_flush_log_at_trx_commit<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">1<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-23\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-24\"><span class=\"crayon-v\">innodb_io_capacity<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">2000<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-25\"><span class=\"crayon-v\">innodb_io_capacity_max<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">4000<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-26\"><span class=\"crayon-v\">innodb_flush_neighbors<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">0<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-27\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-28\"><span class=\"crayon-v\">innodb_read_io_threads<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">4<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-29\"><span class=\"crayon-v\">innodb_write_io_threads<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">4<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-30\"><span class=\"crayon-v\">innodb_purge_threads<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">4<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-31\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-32\"><span class=\"crayon-v\">innodb_file_per_table<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">1<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-33\"><span class=\"crayon-v\">innodb_lock_wait_timeout<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">50<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-34\"><span class=\"crayon-v\">innodb_max_dirty_pages_pct<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">75<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-35\"><span class=\"crayon-v\">innodb_max_dirty_pages_pct_lwm<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">10<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-36\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-37\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-38\"><span class=\"crayon-p\"># CONNECTIONS<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-39\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-40\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-41\"><span class=\"crayon-p\"># Slightly more conservative without DB Governor.<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-42\"><span class=\"crayon-v\">max_connections<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">150<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-43\"><span class=\"crayon-v\">thread_cache_size<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">128<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-44\"><span class=\"crayon-v\">back_log<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">256<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-45\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-46\"><span class=\"crayon-v\">wait_timeout<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">300<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-47\"><span class=\"crayon-v\">interactive_timeout<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">600<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-48\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-49\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-50\"><span class=\"crayon-p\"># TEMP TABLES<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-51\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-52\"><span class=\"crayon-v\">tmp_table_size<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">64M<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-53\"><span class=\"crayon-v\">max_heap_table_size<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">64M<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-54\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-55\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-56\"><span class=\"crayon-p\"># PER-CONNECTION BUFFERS<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-57\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-58\"><span class=\"crayon-v\">sort_buffer_size<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">2M<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-59\"><span class=\"crayon-v\">join_buffer_size<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">2M<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-60\"><span class=\"crayon-v\">read_buffer_size<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">1M<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-61\"><span class=\"crayon-v\">read_rnd_buffer_size<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">1M<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-62\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-63\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-64\"><span class=\"crayon-p\"># MYISAM<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-65\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-66\"><span class=\"crayon-v\">key_buffer_size<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">1G<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-67\"><span class=\"crayon-v\">concurrent_insert<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">2<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-68\"><span class=\"crayon-v\">myisam_recover_options<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">BACKUP<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-i\">FORCE<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-69\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-70\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-71\"><span class=\"crayon-p\"># TABLE CACHE<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-72\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-73\"><span class=\"crayon-v\">table_open_cache<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">8000<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-74\"><span class=\"crayon-v\">table_definition_cache<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">8000<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-75\"><span class=\"crayon-v\">table_open_cache_instances<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">16<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-76\"><span class=\"crayon-v\">open_files_limit<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">80000<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-77\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-78\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-79\"><span class=\"crayon-p\"># QUERY CACHE<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-80\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-81\"><span class=\"crayon-v\">query_cache_type<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">0<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-82\"><span class=\"crayon-v\">query_cache_size<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">0<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-83\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-84\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-85\"><span class=\"crayon-p\"># LOGGING<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-86\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-87\"><span class=\"crayon-v\">slow_query_log<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">1<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-88\"><span class=\"crayon-v\">slow_query_log_file<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-t\">var<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">log<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">mysql<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">slow<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">log<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-89\"><span class=\"crayon-v\">long_query_time<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">3<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-90\"><span class=\"crayon-v\">min_examined_row_limit<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">100<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-91\"><span class=\"crayon-v\">log_queries_not_using_indexes<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">0<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-92\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-93\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-94\"><span class=\"crayon-p\"># DURABILITY<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-95\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-96\"><span class=\"crayon-v\">sync_binlog<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">1<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-97\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-98\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-99\"><span class=\"crayon-p\"># MONITORING<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-100\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6aa12012293d0146247387-101\"><span class=\"crayon-v\">performance_schema<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">ON<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/table><\/div>\n<\/p><\/div>\n<p><!-- [Format Time: 0.0007 seconds] --><\/p>\n<p>\u039c\u03b5\u03c4\u03ac \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03c0\u03b1\u03bd\u03b5\u03ba\u03ba\u03af\u03bd\u03b7\u03c3\u03b7 \u03c4\u03b7\u03c2 mysql.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0394\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 tmp \u03c6\u03b1\u03ba\u03ad\u03bb\u03bf\u03c5 \u03bc\u03ad\u03c3\u03b1 \u03c3\u03c4\u03bf \u03c6\u03ac\u03ba\u03b5\u03bb\u03bf \/var\/lib\/mysql\/ \u03c3\u03b5 \u03c0\u03b5\u03c1\u03af\u03c0\u03c4\u03c9\u03c3\u03b7 \u03c0\u03bf\u03c5 \u03b5\u03af\u03bd\u03b1\u03b9 \u03bc\u03cc\u03bd\u03bf \u03b1\u03c5\u03c4\u03cc\u03c2 \u03bf\u03c1\u03b9\u03c3\u03bc\u03ad\u03bd\u03bf\u03c2 \u03c3\u03b5 ssd \u03b4\u03af\u03c3\u03ba\u03bf. \u039f\u03c1\u03b9\u03c3\u03bc\u03cc\u03c2 \u03b4\u03b9\u03ba\u03b1\u03b9\u03c9\u03bc\u03ac\u03c4\u03c9\u03bd: chown mysql:mysql \/var\/lib\/mysql\/tmp chmod 750 \/var\/lib\/mysql\/tmp 1 2 chown mysql:mysql \/var\/lib\/mysql\/tmp chmod 750 \/var\/lib\/mysql\/tmp \u0394\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 mysql-slow.log \u03b1\u03c1\u03c7\u03b5\u03af\u03bf\u03c5 \u03bc\u03ad\u03c3\u03b1 \u03c3\u03c4\u03bf \u03c6\u03ac\u03ba\u03b5\u03bb\u03bf \/var\/log\/ \u03b3\u03b9\u03b1 \u03ba\u03b1\u03c4\u03b1\u03b3\u03c1\u03b1\u03c6\u03ae \u03b1\u03c1\u03b3\u03ce\u03bd \u03b5\u03c1\u03c9\u03c4\u03b7\u03bc\u03ac\u03c4\u03c9\u03bd. \u039f\u03c1\u03b9\u03c3\u03bc\u03cc\u03c2 \u03b4\u03b9\u03ba\u03b1\u03b9\u03c9\u03bc\u03ac\u03c4\u03c9\u03bd: chown mysql:mysql \/var\/log\/mysql-slow.log chmod 640 \/var\/log\/mysql-slow.log 1 2 chown [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ocean_front_end_style_editor":"no","ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"on","ocean_gallery_id":[],"footnotes":""},"categories":[1],"tags":[],"class_list":["post-316463","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"yoast_head":"<title>\u0392\u03b5\u03bb\u03c4\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03b4\u03b9\u03b1\u03ba\u03bf\u03bc\u03b9\u03c3\u03c4\u03ae MariaDB, mySQL - FREEextra.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.freeextra.com\/en\/uncategorized\/veltistopoiisi-diakomisti-mariadb-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0392\u03b5\u03bb\u03c4\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03b4\u03b9\u03b1\u03ba\u03bf\u03bc\u03b9\u03c3\u03c4\u03ae MariaDB, mySQL - FREEextra.com\" \/>\n<meta property=\"og:description\" content=\"\u0394\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 tmp \u03c6\u03b1\u03ba\u03ad\u03bb\u03bf\u03c5 \u03bc\u03ad\u03c3\u03b1 \u03c3\u03c4\u03bf \u03c6\u03ac\u03ba\u03b5\u03bb\u03bf \/var\/lib\/mysql\/ \u03c3\u03b5 \u03c0\u03b5\u03c1\u03af\u03c0\u03c4\u03c9\u03c3\u03b7 \u03c0\u03bf\u03c5 \u03b5\u03af\u03bd\u03b1\u03b9 \u03bc\u03cc\u03bd\u03bf \u03b1\u03c5\u03c4\u03cc\u03c2 \u03bf\u03c1\u03b9\u03c3\u03bc\u03ad\u03bd\u03bf\u03c2 \u03c3\u03b5 ssd \u03b4\u03af\u03c3\u03ba\u03bf. \u039f\u03c1\u03b9\u03c3\u03bc\u03cc\u03c2 \u03b4\u03b9\u03ba\u03b1\u03b9\u03c9\u03bc\u03ac\u03c4\u03c9\u03bd: chown mysql:mysql \/var\/lib\/mysql\/tmp chmod 750 \/var\/lib\/mysql\/tmp 1 2 chown mysql:mysql \/var\/lib\/mysql\/tmp chmod 750 \/var\/lib\/mysql\/tmp \u0394\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 mysql-slow.log \u03b1\u03c1\u03c7\u03b5\u03af\u03bf\u03c5 \u03bc\u03ad\u03c3\u03b1 \u03c3\u03c4\u03bf \u03c6\u03ac\u03ba\u03b5\u03bb\u03bf \/var\/log\/ \u03b3\u03b9\u03b1 \u03ba\u03b1\u03c4\u03b1\u03b3\u03c1\u03b1\u03c6\u03ae \u03b1\u03c1\u03b3\u03ce\u03bd \u03b5\u03c1\u03c9\u03c4\u03b7\u03bc\u03ac\u03c4\u03c9\u03bd. \u039f\u03c1\u03b9\u03c3\u03bc\u03cc\u03c2 \u03b4\u03b9\u03ba\u03b1\u03b9\u03c9\u03bc\u03ac\u03c4\u03c9\u03bd: chown mysql:mysql \/var\/log\/mysql-slow.log chmod 640 \/var\/log\/mysql-slow.log 1 2 chown [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.freeextra.com\/en\/uncategorized\/veltistopoiisi-diakomisti-mariadb-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"FREEextra.com\" \/>\n<meta property=\"article:published_time\" content=\"2026-06-21T12:30:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-09T09:00:13+00:00\" \/>\n<meta name=\"author\" content=\"sbz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/uncategorized\\\/veltistopoiisi-diakomisti-mariadb-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/uncategorized\\\/veltistopoiisi-diakomisti-mariadb-mysql\\\/\"},\"author\":{\"name\":\"sbz\",\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#\\\/schema\\\/person\\\/a1710b2720bd36473bd450e8427b27d6\"},\"headline\":\"\u0392\u03b5\u03bb\u03c4\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03b4\u03b9\u03b1\u03ba\u03bf\u03bc\u03b9\u03c3\u03c4\u03ae MariaDB, mySQL\",\"datePublished\":\"2026-06-21T12:30:13+00:00\",\"dateModified\":\"2026-09-09T09:00:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/uncategorized\\\/veltistopoiisi-diakomisti-mariadb-mysql\\\/\"},\"wordCount\":492,\"publisher\":{\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/uncategorized\\\/veltistopoiisi-diakomisti-mariadb-mysql\\\/\",\"url\":\"https:\\\/\\\/www.freeextra.com\\\/uncategorized\\\/veltistopoiisi-diakomisti-mariadb-mysql\\\/\",\"name\":\"\u0392\u03b5\u03bb\u03c4\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03b4\u03b9\u03b1\u03ba\u03bf\u03bc\u03b9\u03c3\u03c4\u03ae MariaDB, mySQL - FREEextra.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#website\"},\"datePublished\":\"2026-06-21T12:30:13+00:00\",\"dateModified\":\"2026-09-09T09:00:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/uncategorized\\\/veltistopoiisi-diakomisti-mariadb-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.freeextra.com\\\/uncategorized\\\/veltistopoiisi-diakomisti-mariadb-mysql\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/uncategorized\\\/veltistopoiisi-diakomisti-mariadb-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.freeextra.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0392\u03b5\u03bb\u03c4\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03b4\u03b9\u03b1\u03ba\u03bf\u03bc\u03b9\u03c3\u03c4\u03ae MariaDB, mySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/\",\"name\":\"FREEextra.com\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#organization\",\"name\":\"FREEextra.com\",\"url\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.freeextra.com\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/freeextra-logo-var1-2024.png\",\"contentUrl\":\"https:\\\/\\\/www.freeextra.com\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/freeextra-logo-var1-2024.png\",\"width\":1860,\"height\":434,\"caption\":\"FREEextra.com\"},\"image\":{\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#\\\/schema\\\/person\\\/a1710b2720bd36473bd450e8427b27d6\",\"name\":\"sbz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ec2c1491a20faf6ff6fa88155d53ae766f53b1be15a28a8b563e5d5429743ed0?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ec2c1491a20faf6ff6fa88155d53ae766f53b1be15a28a8b563e5d5429743ed0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ec2c1491a20faf6ff6fa88155d53ae766f53b1be15a28a8b563e5d5429743ed0?s=96&d=mm&r=g\",\"caption\":\"sbz\"},\"sameAs\":[\"https:\\\/\\\/freeextra.com\\\/cms\"]}]}<\/script>","yoast_head_json":{"title":"\u0392\u03b5\u03bb\u03c4\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03b4\u03b9\u03b1\u03ba\u03bf\u03bc\u03b9\u03c3\u03c4\u03ae MariaDB, mySQL - FREEextra.com","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:\/\/www.freeextra.com\/en\/uncategorized\/veltistopoiisi-diakomisti-mariadb-mysql\/","og_locale":"en_US","og_type":"article","og_title":"\u0392\u03b5\u03bb\u03c4\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03b4\u03b9\u03b1\u03ba\u03bf\u03bc\u03b9\u03c3\u03c4\u03ae MariaDB, mySQL - FREEextra.com","og_description":"\u0394\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 tmp \u03c6\u03b1\u03ba\u03ad\u03bb\u03bf\u03c5 \u03bc\u03ad\u03c3\u03b1 \u03c3\u03c4\u03bf \u03c6\u03ac\u03ba\u03b5\u03bb\u03bf \/var\/lib\/mysql\/ \u03c3\u03b5 \u03c0\u03b5\u03c1\u03af\u03c0\u03c4\u03c9\u03c3\u03b7 \u03c0\u03bf\u03c5 \u03b5\u03af\u03bd\u03b1\u03b9 \u03bc\u03cc\u03bd\u03bf \u03b1\u03c5\u03c4\u03cc\u03c2 \u03bf\u03c1\u03b9\u03c3\u03bc\u03ad\u03bd\u03bf\u03c2 \u03c3\u03b5 ssd \u03b4\u03af\u03c3\u03ba\u03bf. \u039f\u03c1\u03b9\u03c3\u03bc\u03cc\u03c2 \u03b4\u03b9\u03ba\u03b1\u03b9\u03c9\u03bc\u03ac\u03c4\u03c9\u03bd: chown mysql:mysql \/var\/lib\/mysql\/tmp chmod 750 \/var\/lib\/mysql\/tmp 1 2 chown mysql:mysql \/var\/lib\/mysql\/tmp chmod 750 \/var\/lib\/mysql\/tmp \u0394\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 mysql-slow.log \u03b1\u03c1\u03c7\u03b5\u03af\u03bf\u03c5 \u03bc\u03ad\u03c3\u03b1 \u03c3\u03c4\u03bf \u03c6\u03ac\u03ba\u03b5\u03bb\u03bf \/var\/log\/ \u03b3\u03b9\u03b1 \u03ba\u03b1\u03c4\u03b1\u03b3\u03c1\u03b1\u03c6\u03ae \u03b1\u03c1\u03b3\u03ce\u03bd \u03b5\u03c1\u03c9\u03c4\u03b7\u03bc\u03ac\u03c4\u03c9\u03bd. \u039f\u03c1\u03b9\u03c3\u03bc\u03cc\u03c2 \u03b4\u03b9\u03ba\u03b1\u03b9\u03c9\u03bc\u03ac\u03c4\u03c9\u03bd: chown mysql:mysql \/var\/log\/mysql-slow.log chmod 640 \/var\/log\/mysql-slow.log 1 2 chown [&hellip;]","og_url":"https:\/\/www.freeextra.com\/en\/uncategorized\/veltistopoiisi-diakomisti-mariadb-mysql\/","og_site_name":"FREEextra.com","article_published_time":"2026-06-21T12:30:13+00:00","article_modified_time":"2026-09-09T09:00:13+00:00","author":"sbz","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.freeextra.com\/uncategorized\/veltistopoiisi-diakomisti-mariadb-mysql\/#article","isPartOf":{"@id":"https:\/\/www.freeextra.com\/uncategorized\/veltistopoiisi-diakomisti-mariadb-mysql\/"},"author":{"name":"sbz","@id":"https:\/\/www.freeextra.com\/en\/#\/schema\/person\/a1710b2720bd36473bd450e8427b27d6"},"headline":"\u0392\u03b5\u03bb\u03c4\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03b4\u03b9\u03b1\u03ba\u03bf\u03bc\u03b9\u03c3\u03c4\u03ae MariaDB, mySQL","datePublished":"2026-06-21T12:30:13+00:00","dateModified":"2026-09-09T09:00:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.freeextra.com\/uncategorized\/veltistopoiisi-diakomisti-mariadb-mysql\/"},"wordCount":492,"publisher":{"@id":"https:\/\/www.freeextra.com\/en\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.freeextra.com\/uncategorized\/veltistopoiisi-diakomisti-mariadb-mysql\/","url":"https:\/\/www.freeextra.com\/uncategorized\/veltistopoiisi-diakomisti-mariadb-mysql\/","name":"\u0392\u03b5\u03bb\u03c4\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03b4\u03b9\u03b1\u03ba\u03bf\u03bc\u03b9\u03c3\u03c4\u03ae MariaDB, mySQL - FREEextra.com","isPartOf":{"@id":"https:\/\/www.freeextra.com\/en\/#website"},"datePublished":"2026-06-21T12:30:13+00:00","dateModified":"2026-09-09T09:00:13+00:00","breadcrumb":{"@id":"https:\/\/www.freeextra.com\/uncategorized\/veltistopoiisi-diakomisti-mariadb-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.freeextra.com\/uncategorized\/veltistopoiisi-diakomisti-mariadb-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.freeextra.com\/uncategorized\/veltistopoiisi-diakomisti-mariadb-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.freeextra.com\/"},{"@type":"ListItem","position":2,"name":"\u0392\u03b5\u03bb\u03c4\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03b4\u03b9\u03b1\u03ba\u03bf\u03bc\u03b9\u03c3\u03c4\u03ae MariaDB, mySQL"}]},{"@type":"WebSite","@id":"https:\/\/www.freeextra.com\/en\/#website","url":"https:\/\/www.freeextra.com\/en\/","name":"FREEextra.com","description":"","publisher":{"@id":"https:\/\/www.freeextra.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.freeextra.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.freeextra.com\/en\/#organization","name":"FREEextra.com","url":"https:\/\/www.freeextra.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.freeextra.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.freeextra.com\/wp-content\/uploads\/2024\/12\/freeextra-logo-var1-2024.png","contentUrl":"https:\/\/www.freeextra.com\/wp-content\/uploads\/2024\/12\/freeextra-logo-var1-2024.png","width":1860,"height":434,"caption":"FREEextra.com"},"image":{"@id":"https:\/\/www.freeextra.com\/en\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.freeextra.com\/en\/#\/schema\/person\/a1710b2720bd36473bd450e8427b27d6","name":"sbz","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ec2c1491a20faf6ff6fa88155d53ae766f53b1be15a28a8b563e5d5429743ed0?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ec2c1491a20faf6ff6fa88155d53ae766f53b1be15a28a8b563e5d5429743ed0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec2c1491a20faf6ff6fa88155d53ae766f53b1be15a28a8b563e5d5429743ed0?s=96&d=mm&r=g","caption":"sbz"},"sameAs":["https:\/\/freeextra.com\/cms"]}]}},"_links":{"self":[{"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/posts\/316463","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/comments?post=316463"}],"version-history":[{"count":158,"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/posts\/316463\/revisions"}],"predecessor-version":[{"id":370101,"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/posts\/316463\/revisions\/370101"}],"wp:attachment":[{"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/media?parent=316463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/categories?post=316463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/tags?post=316463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}