제 mysql 세팅값인데 괜찮은지 봐주시겠어요?
본문
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=utf8
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
datadir = /var/lib/mysql
skip-name-resolve
skip-host-cache
# skip-external-locking
key_buffer_size = 256M
max_connections = 1200
max_connect_errors = 1200
connect_timeout = 10
#max_allowed_packet = 1M
max_allowed_packet = 32M
wait_timeout = 28800
interactive_timeout = 28800
long_query_time = 3
slow_query_log = 1
slow_query_log_file=/var/log/mysql/mysql-slow.log
#sort_buffer_size = 512K
sort_buffer_size = 8M
#new
#join_buffer_size = 8M
#bulk_insert_buffer_size = 16M
tmp_table_size = 256M
#new
#max_heap_table_size = 256M
net_buffer_length = 16K
#newly added. 2021-01
myisam_sort_buffer_size = 8M
transaction-isolation = READ-COMMITTED
#REPEATABLE-READ
init-connect='SET NAMES utf8'
character-set-server = utf8
#newly added. 2021-01
table_open_cache = 1280
query-cache-type = 1
query_cache_size = 256M
query_cache_limit = 256M
# Bulk insert for MyISAM.
bulk_insert_buffer_size = 64M
thread_concurrency = 4
# Don't listen on a TCP/IP port at all.
skip-networking
# required unique id between 1 and 2^32 - 1
server-id = 1
# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000
# InnoDB tables are now used by default
#innodb_data_home_dir = /srv/mysql
#innodb_log_group_home_dir = /srv/mysql
# All the innodb_xxx values below are the default ones:
innodb_data_file_path = ibdata1:12M:autoextend
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#inno buffer pool size = 128M, log = 48M, log buffer 16M
innodb_buffer_pool_size = 4G
innodb_log_file_size = 48M
innodb_log_buffer_size = 1M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_write_io_threads = 4
innodb_read_io_threads = 4
innodb-defragment=1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
default-character-set=utf8
# This statement tells MySQL server to log any query that takes longer that 3 seconds.
#log_slow_queries=/var/log/mysql/log-slow-queries.log
# This statement tells MySQL server where to log the slow queries.
#log_queries_not_using_indexes=YES
# This is an optional statement that logs queries that don’t use an index.
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
# End /etc/mysql/my.cnf
동접 500-1000명 사이입니다.
apache 2.4.6 , php 7.2 , mariadb 10.5 쓰고 있습니다.
특정페이지에서 엄청 느리게 뜨는데 이유를 모르겠습니다.
innodb 로 대부분 테이블 쓰고 있습니다.
로그인, 글쓰기나 댓글 다 빠르게 되는데 회원가입 하다보면 register_result 페이지 뜰때 10분정도 걸려요..ㅠㅠ
!-->
답변을 작성하시기 전에 로그인 해주세요.