Gecko [ smanegeri1koba.sch.id ]

Name	Size	Permission
alternatives	[ DIR ]	drwxr-xr-x
bash_completion.d	[ DIR ]	drwxr-xr-x
cl.nodejs	[ DIR ]	drwxr-xr-x
cl.php.d	[ DIR ]	drwxr-xr-x
cl.python	[ DIR ]	drwxr-xr-x
cl.selector	[ DIR ]	drwxr-xr-x
cl.selector.conf.d	[ DIR ]	drwxr-xr-x
crypto-policies	[ DIR ]	drwxr-xr-x
default	[ DIR ]	drwxr-xr-x
environment-modules	[ DIR ]	drwxr-xr-x
fonts	[ DIR ]	drwxr-xr-x
gcrypt	[ DIR ]	drwxr-xr-x
ld.so.conf.d	[ DIR ]	drwxr-xr-x
mail	[ DIR ]	drwxr-xr-x
mc	[ DIR ]	drwxr-xr-x
modulefiles	[ DIR ]	drwxr-xr-x
motd.d	[ DIR ]	drwxr-xr-x
my.cnf.d	[ DIR ]	drwxr-xr-x
openldap	[ DIR ]	drwxr-xr-x
pam.d	[ DIR ]	drwxr-xr-x
php.d	[ DIR ]	drwxr-xr-x
pki	[ DIR ]	drwxr-xr-x
profile.d	[ DIR ]	drwxr-xr-x
sasl2	[ DIR ]	drwxr-xr-x
scl	[ DIR ]	drwxr-xr-x
security	[ DIR ]	drwxr-xr-x
skel	[ DIR ]	drwxr-xr-x
ssh	[ DIR ]	drwxr-xr-x
ssl	[ DIR ]	drwxr-xr-x
subversion	[ DIR ]	drwxr-xr-x
sysconfig	[ DIR ]	drwxr-xr-x
.etc.version	3 B	-rw-------
DIR_COLORS	4.56 KB	-rw-r--r--
aliases	1.49 KB	-rw-r--r--
bashrc	2.6 KB	-rw-r--r--
environment	36 B	-rw-r--r--
group	403 B	-rw-r--r--
host.conf	9 B	-rw-r--r--
hosts	1.77 KB	-rw-r--r--
inputrc	943 B	-rw-r--r--
ld.so.cache	44.54 KB	-rw-r--r--
ld.so.conf	28 B	-rw-r--r--
localtime	114 B	-rw-r--r--
my.cnf	2.91 KB	-rw-r--r--
nsswitch.conf	2.07 KB	-rw-r--r--
odbc.ini	0 B	-rw-r--r--
odbcinst.ini	230 B	-rw-r--r--
passwd	976 B	-rw-r--r--
php.ini	60.67 KB	-rw-r--r--
profile	1.85 KB	-rw-r--r--
protocols	6.41 KB	-rw-r--r--
resolv.conf	124 B	-rw-r--r--
rpc	1.6 KB	-rw-r--r--
rsyncd.conf	458 B	-rw-r--r--
screenrc	6.56 KB	-rw-r--r--
services	676.58 KB	-rw-r--r--
shadow	740 B	----------
trusted-key.key	375 B	-rw-r--r--
vimrc	3.92 KB	-rw-r--r--
virc	1.16 KB	-rw-r--r--
wgetrc	4.81 KB	-rw-r--r--

Code Editor : my.cnf

# Ansible managed

[mysqld]
plugin_load_add = ha_rocksdb
plugin_load_add = cgroup
basedir = /srv/mariadb1186/usr
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 = 107803679130
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

[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/mariadb1186/usr/share/mysql

${this.title}

Code Editor : my.cnf