MariaDB 메모리 설정값 변경
2024.05.11 15:05
68
0
https://eond.com/462414
object(HotopayModel)#785 (23) { ["error"]=> int(0) ["message"]=> string(7) "success" ["variables"]=> array(0) { } ["httpStatusCode"]=> int(200) ["module"]=> string(7) "hotopay" ["module_info"]=> NULL ["origin_module_info"]=> NULL ["module_config"]=> NULL ["module_path"]=> string(52) "/home/eond/web/eond.com/public_html/modules/hotopay/" ["xml_info"]=> NULL ["module_srl"]=> NULL ["mid"]=> NULL ["act"]=> NULL ["template_path"]=> NULL ["template_file"]=> NULL ["layout_path"]=> NULL ["layout_file"]=> NULL ["edited_layout_file"]=> NULL ["stop_proc"]=> bool(false) ["user"]=> object(Rhymix\Framework\Helpers\SessionHelper)#784 (20) { ["member_srl"]=> int(0) ["user_id"]=> NULL ["user_name"]=> NULL ["nick_name"]=> NULL ["email_address"]=> NULL ["phone_number"]=> NULL ["homepage"]=> NULL ["blog"]=> NULL ["birthday"]=> NULL ["denied"]=> NULL ["status"]=> NULL ["is_admin"]=> string(1) "N" ["is_site_admin"]=> NULL ["profile_image"]=> NULL ["image_name"]=> NULL ["image_mark"]=> NULL ["signature"]=> NULL ["description"]=> NULL ["group_list"]=> array(0) { } ["menu_list"]=> array(0) { } } ["request"]=> object(Rhymix\Framework\Request)#10 (13) { ["method"]=> string(3) "GET" ["compat_method"]=> string(3) "GET" ["url"]=> string(23) "talk/462414/page/465436" ["hostname"]=> string(8) "eond.com" ["domain"]=> NULL ["protocol"]=> string(5) "https" ["callback_function"]=> string(0) "" ["_route_status":protected]=> int(200) ["_route_options":protected]=> object(stdClass)#11 (5) { ["cache_control"]=> bool(true) ["check_csrf"]=> bool(true) ["is_forwarded"]=> bool(false) ["is_indexable"]=> bool(true) ["enable_session"]=> bool(true) } ["module"]=> string(5) "board" ["mid"]=> string(4) "talk" ["act"]=> string(16) "dispBoardContent" ["args"]=> array(4) { ["document_srl"]=> string(6) "462414" ["page"]=> int(465436) ["mid"]=> string(4) "talk" ["act"]=> string(16) "dispBoardContent" } } ["ajaxRequestMethod"]=> array(2) { [0]=> string(6) "XMLRPC" [1]=> string(4) "JSON" } ["gzhandler_enable"]=> bool(true) }

key_buffer_size = 512M

max_allowed_packet = 128M

table_open_cache = 512

sort_buffer_size = 64M

read_buffer_size = 64M

read_rnd_buffer_size = 128M

myisam_sort_buffer_size = 2048M

thread_cache_size = 64

query_cache_size= 2048M


#innodb_use_native_aio = 0

default_storage_engine = InnoDB

innodb_buffer_pool_size = 64G

innodb_file_per_table = 1

innodb_log_file_size = 256M

innodb_buffer_pool_instances = 8

innodb_flush_log_at_trx_commit = 0

innodb_flush_method = O_DSYNC

innodb_io_capacity = 20000


max_connections=5000

max_user_connections=1500

wait_timeout=120

interactive_timeout=120

long_query_time=60


변경 후

[client]

port=3306

socket=/run/mysqld/mysqld.sock

default-character-set=utf8mb4


[mysql]

default-character-set=utf8mb4


[mysqld_safe]

socket=/run/mysqld/mysqld.sock


[mysqld]

user=mysql

pid-file=/run/mysqld/mysqld.pid

socket=/run/mysqld/mysqld.sock

port=3306

basedir=/usr

datadir=/var/lib/mysql

tmpdir=/tmp

lc-messages-dir=/usr/share/mysql

log_error=/var/log/mysql/error.log

collation-server = utf8mb4_unicode_520_ci

init-connect='SET NAMES utf8mb4'

character-set-server = utf8mb4


symbolic-links=0

local-infile=0


skip-external-locking

key_buffer_size = 512M

max_allowed_packet = 128M

table_open_cache = 512

sort_buffer_size = 64M

read_buffer_size = 64M

read_rnd_buffer_size = 128M

myisam_sort_buffer_size = 512M

thread_cache_size = 64

query_cache_size= 128


#innodb_use_native_aio = 0

default_storage_engine = InnoDB

innodb_buffer_pool_size = 58G

innodb_file_per_table = 1

innodb_log_file_size = 256M

innodb_buffer_pool_instances = 16

innodb_flush_log_at_trx_commit = 0

innodb_flush_method = O_DSYNC

innodb_io_capacity = 20000


max_connections=5000

max_user_connections=1500

wait_timeout=120

interactive_timeout=120

long_query_time=60


!includedir /etc/mysql/conf.d/

!includedir /etc/mysql/mariadb.conf.d/


라이믹스는 이온디와 함께

talk
-
+
  • 제목
  • 등록일
닫기

마이페이지

로그인을 해주세요

네이버로 로그인