{"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-07-01T12:00:13","modified_gmt":"2026-07-01T09: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-6a44d712595f6983153561\" 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-6a44d712595f6983153561-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595f6983153561-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-6a44d712595f6983153561-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-6a44d712595f6983153561-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-6a44d712595fc073494574\" 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-6a44d712595fc073494574-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595fc073494574-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-6a44d712595fc073494574-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-6a44d712595fc073494574-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-6a44d712595ff734826217\" 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-6a44d712595ff734826217-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-13\">13<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-15\">15<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-16\">16<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-17\">17<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-18\">18<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-19\">19<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-20\">20<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-21\">21<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-22\">22<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-23\">23<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-24\">24<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-25\">25<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-26\">26<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-27\">27<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-28\">28<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-29\">29<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-30\">30<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-31\">31<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-32\">32<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-33\">33<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-34\">34<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-35\">35<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-36\">36<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-37\">37<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-38\">38<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-39\">39<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-40\">40<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-41\">41<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-42\">42<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-43\">43<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-44\">44<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-45\">45<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-46\">46<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-47\">47<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-48\">48<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-49\">49<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-50\">50<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-51\">51<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-52\">52<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-53\">53<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-54\">54<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-55\">55<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-56\">56<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-57\">57<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-58\">58<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-59\">59<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-60\">60<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-61\">61<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-62\">62<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-63\">63<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-64\">64<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-65\">65<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-66\">66<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-67\">67<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-68\">68<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-69\">69<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-70\">70<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-71\">71<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-72\">72<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-73\">73<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-74\">74<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-75\">75<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-76\">76<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-77\">77<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-78\">78<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-79\">79<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-80\">80<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-81\">81<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-82\">82<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-83\">83<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-84\">84<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-85\">85<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-86\">86<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-87\">87<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-88\">88<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-89\">89<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-90\">90<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-91\">91<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-92\">92<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-93\">93<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-94\">94<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-95\">95<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-96\">96<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-97\">97<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-98\">98<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-99\">99<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-100\">100<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-2\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-3\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-4\"><span class=\"crayon-p\"># BASIC<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-5\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-10\"><span class=\"crayon-e\">skip_host_cache<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-12\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-13\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-14\"><span class=\"crayon-p\"># INNODB<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-15\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-17\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-20\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-23\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-27\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-31\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-36\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-37\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-38\"><span class=\"crayon-p\"># CONNECTIONS<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-39\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-40\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-45\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-48\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-49\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-50\"><span class=\"crayon-p\"># TEMP TABLES<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-51\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-54\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-55\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-56\"><span class=\"crayon-p\"># PER-CONNECTION BUFFERS<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-57\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-62\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-63\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-64\"><span class=\"crayon-p\"># MYISAM<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-65\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-69\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-70\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-71\"><span class=\"crayon-p\"># TABLE CACHE<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-72\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-77\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-78\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-79\"><span class=\"crayon-p\"># QUERY CACHE<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-80\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-83\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-84\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-85\"><span class=\"crayon-p\"># LOGGING<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-86\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-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-6a44d712595ff734826217-92\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-93\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-94\"><span class=\"crayon-p\"># DURABILITY<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-95\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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-6a44d712595ff734826217-97\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-98\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-99\"><span class=\"crayon-p\"># MONITORING<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-100\"><span class=\"crayon-p\"># ======================<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a44d712595ff734826217-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.0010 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_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-07-01T09: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-07-01T09: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-07-01T09: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-07-01T09: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-07-01T09: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-07-01T09: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":19,"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/posts\/316463\/revisions"}],"predecessor-version":[{"id":322919,"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/posts\/316463\/revisions\/322919"}],"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}]}}