LiteSpeed Linux server2.poyrazhosting.com 3.10.0-962.3.2.lve1.5.77.el7.x86_64 #1 SMP Mon Dec 12 07:06:14 EST 2022 x86_64 safemode : OFF MySQL: OFF | Perl: OFF | cURL: ON | WGet: OFF > / etc / | Server Ip : 104.21.78.54 |
Filename | /etc/my.cnf |
Size | 1.4 kb |
Permission | rw-r--r-- |
Owner | |
Create time | 03-Sep-2023 12:11 |
Last modified | 06-Oct-2022 16:16 |
Last accessed | 05-Apr-2025 03:56 |
Actions | edit | rename | delete | download (gzip) |
View | text | code | image |
[client-server]
!includedir /etc/my.cnf.d
[mysqld]
bind-address = localhost
log-error = /var/lib/mysql/server6.poyraz.err
default-storage-engine = MyISAM
performance-schema = 0
ssl = 0
sql_mode = NO_ENGINE_SUBSTITUTION
local-infile = 0
loose-local-infile = 0
symbolic-links = 0
skip-networking
back_log = 100
ft_min_word_len = 4
innodb_buffer_pool_instances = 8
innodb_buffer_pool_size = 4096M
innodb_log_file_size = 512M
innodb_purge_threads = 6
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DIRECT
innodb_log_buffer_size = 16M
innodb_stats_on_metadata = 0
max_allowed_packet = 1073741824
net_buffer_length = 16384
concurrent_insert = 2
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
max_write_lock_count = 1
external-locking = FALSE
open_files_limit = 65535
general-log = 0
interactive_timeout = 50
wait_timeout = 60
connect_timeout = 50
max_connections = 1000
max_connect_errors = 10
max_user_connections = 50
long_query_time = 2.5
query_cache_type = 1
query_cache_size = 384M
query_cache_limit = 32M
query_prealloc_size = 262144
thread_cache_size = 2384
thread_handling = one-thread-per-connection
thread_stack = 192K
table_open_cache = 40960
table_definition_cache = 40960
key_buffer_size = 192M
myisam_sort_buffer_size = 2M
join_buffer_size = 8M
read_buffer_size = 8M
read_rnd_buffer_size = 8M
sort_buffer_size = 8M
bulk_insert_buffer_size = 512M
tmp_table_size = 512M
!includedir /etc/my.cnf.d
[mysqld]
bind-address = localhost
log-error = /var/lib/mysql/server6.poyraz.err
default-storage-engine = MyISAM
performance-schema = 0
ssl = 0
sql_mode = NO_ENGINE_SUBSTITUTION
local-infile = 0
loose-local-infile = 0
symbolic-links = 0
skip-networking
back_log = 100
ft_min_word_len = 4
innodb_buffer_pool_instances = 8
innodb_buffer_pool_size = 4096M
innodb_log_file_size = 512M
innodb_purge_threads = 6
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DIRECT
innodb_log_buffer_size = 16M
innodb_stats_on_metadata = 0
max_allowed_packet = 1073741824
net_buffer_length = 16384
concurrent_insert = 2
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
max_write_lock_count = 1
external-locking = FALSE
open_files_limit = 65535
general-log = 0
interactive_timeout = 50
wait_timeout = 60
connect_timeout = 50
max_connections = 1000
max_connect_errors = 10
max_user_connections = 50
long_query_time = 2.5
query_cache_type = 1
query_cache_size = 384M
query_cache_limit = 32M
query_prealloc_size = 262144
thread_cache_size = 2384
thread_handling = one-thread-per-connection
thread_stack = 192K
table_open_cache = 40960
table_definition_cache = 40960
key_buffer_size = 192M
myisam_sort_buffer_size = 2M
join_buffer_size = 8M
read_buffer_size = 8M
read_rnd_buffer_size = 8M
sort_buffer_size = 8M
bulk_insert_buffer_size = 512M
tmp_table_size = 512M