/
etc
/
/etc
mkdir
upload
Name
Size
Mode
Actions
alternatives/
-
0755
rm
bash_completion.d/
-
0755
rm
cl.nodejs/
-
0755
rm
cl.php.d/
-
0755
rm
cl.python/
-
0755
rm
cl.selector/
-
0755
rm
cl.selector.conf.d/
-
0755
rm
crypto-policies/
-
0755
rm
default/
-
0755
rm
environment-modules/
-
0755
rm
fonts/
-
0755
rm
gcrypt/
-
0755
rm
ld.so.conf.d/
-
0755
rm
mail/
-
0755
rm
mc/
-
0755
rm
modulefiles/
-
0755
rm
motd.d/
-
0755
rm
my.cnf.d/
-
0755
rm
openldap/
-
0755
rm
pam.d/
-
0755
rm
php.d/
-
0755
rm
pki/
-
0755
rm
profile.d/
-
0755
rm
sasl2/
-
0755
rm
scl/
-
0755
rm
security/
-
0755
rm
skel/
-
0755
rm
ssh/
-
0755
rm
ssl/
-
0755
rm
subversion/
-
0755
rm
sysconfig/
-
0755
rm
.etc.version
4
0600
edit
dl
rm
aliases
1529
0644
edit
dl
rm
bashrc
2917
0644
edit
dl
rm
DIR_COLORS
4536
0644
edit
dl
rm
environment
36
0644
edit
dl
rm
group
381
0644
edit
dl
rm
host.conf
9
0644
edit
dl
rm
hosts
1814
0644
edit
dl
rm
inputrc
942
0644
edit
dl
rm
ld.so.cache
46255
0644
edit
dl
rm
ld.so.conf
28
0644
edit
dl
rm
localtime
127
0644
edit
dl
rm
my.cnf
3245
0644
edit
dl
rm
nsswitch.conf
2120
0644
edit
dl
rm
odbc.ini
0
0644
edit
dl
rm
odbcinst.ini
230
0644
edit
dl
rm
passwd
974
0644
edit
dl
rm
php.ini
62125
0644
edit
dl
rm
profile
2123
0644
edit
dl
rm
protocols
6568
0644
edit
dl
rm
resolv.conf
125
0644
edit
dl
rm
rpc
1634
0644
edit
dl
rm
services
692816
0644
edit
dl
rm
shadow
740
0000
edit
dl
rm
trusted-key.key
375
0644
edit
dl
rm
vimrc
1982
0644
edit
dl
rm
virc
1204
0644
edit
dl
rm
wgetrc
4925
0644
edit
dl
rm
Edit:
/etc/my.cnf
(3245B)
# Ansible managed [mysqld] strict_password_validation = OFF plugin_load_add = simple_password_check plugin_load_add = ha_rocksdb plugin_load_add = cgroup basedir = /srv/mariadb1188/usr secure-file-priv = /dev/null large-pages = on datadir = /var/lib/mysql socket = /var/lib/mysql/mysql.sock bind_address = * myisam_recover_options = backup,quick,force port = 3306 transaction-isolation = read-committed cgroup_enabled = True pid-file = /var/lib/mysql/mysql.pid local-infile = 0 tmpdir = /var/lib/mysqltmp tmp_table_size = 386M max_heap_table_size = 386M innodb_flush_method = O_DIRECT innodb_buffer_pool_size = 108018427494 max_allowed_packet = 1G query_cache_type = 0 max_connections = 2000 interactive_timeout = 20 wait_timeout = 20 connect_timeout = 20 thread_cache_size = 96 key_buffer_size = 2G max_connect_errors = 5 open_files_limit = 30000000 collation_server = utf8mb4_unicode_ci character_set_server = utf8mb4 table_definition_cache = 2M innodb_strict_mode = 0 sql_mode = NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION log_warnings = 1 innodb_purge_threads = 4 skip-character-set-client-handshake skip-name-resolve userstat = 1 tmp_disk_table_size = 1536M ssl-ca = /var/lib/mysql/ssl/tls-ca-bundle.pem ssl-cert = /var/lib/mysql/ssl/hostinger.crt ssl-key = /var/lib/mysql/ssl/hostinger.key innodb_log_file_size = 30G innodb_flush_log_at_trx_commit = 2 table_open_cache = 50K innodb_buffer_pool_dump_pct = 90 query_cache_size = 0 aria_pagecache_buffer_size = 1G join_buffer_size = 8M innodb_io_capacity = 2000 innodb_io_capacity_max = 4000 innodb_log_write_ahead_size = 4096 innodb_flush_neighbors = 0 innodb_read_io_threads = 32 innodb_write_io_threads = 32 key_cache_segments = 64 innodb_undo_tablespaces = 3 innodb_undo_log_truncate = True max_user_connections = 75 group_concat_max_len = 10485760 core_file rocksdb_allow_to_start_after_corruption = 0 rocksdb_block_cache_size = 5368709120 rocksdb_bulk_load = 0 rocksdb_flush_log_at_trx_commit = 2 rocksdb_merge_buf_size = 67108864 rocksdb_max_row_locks = 1M rocksdb_max_total_wal_size = 3G rocksdb_validate_tables = 0 max_prepared_stmt_count = 100000 slow_query_log = True log_output = TABLE log_slow_query_time = 3 log_slow_min_examined_row_limit = 300000 log_queries_not_using_indexes = False innodb_log_buffer_size = 30G performance_schema = on extra_port = 3300 extra_max_connections = 100 innodb_adaptive_flushing_lwm = 25 innodb_max_dirty_pages_pct = 70 transaction_prealloc_size = 8192 innodb_autoextend_increment = 48 thread_stack = 524288 optimizer_search_depth = 0 symbolic-links = 0 innodb_data_file_buffering = True # Try these if performance is lacking #thread_handling = pool-of-threads #myisam_sort_buffer_size = 64M #sort_buffer_size = 2M #read_buffer_size = 2M #read_rnd_buffer_size = 8M simple_password_check_digits = 0 simple_password_check_letters_same_case = 0 simple_password_check_other_characters = 0 simple_password_check_minimal_length = 1 [client] default-character-set = utf8mb4 ssl-verify-server-cert = False [safe_mysqld] pid-file = /var/lib/mysql/mysql.pid open_files_limit = 30000000 [mysqldump] quick max_allowed_packet = 1G [mysql] no-auto-rehash sandbox = true default-character-set = utf8mb4 character_sets_dir = /srv/mariadb1188/usr/share/mysql
Save
cmd:
run