|
Server IP : 86.38.243.181 / Your IP : 216.73.216.86 Web Server : LiteSpeed System : Linux in-mum-web1336.main-hosting.eu 4.18.0-553.34.1.lve.el8.x86_64 #1 SMP Thu Jan 9 16:30:32 UTC 2025 x86_64 User : u986601745 ( 986601745) PHP Version : 7.4.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /etc/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
# Ansible managed [mysqld] plugin_load_add = ha_rocksdb plugin_load_add = cgroup basedir = /srv/mariadb1183/usr 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 #sort_buffer_size = 2M #read_buffer_size = 2M #read_rnd_buffer_size = 8M #myisam_sort_buffer_size = 64M 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 #in_predicate_conversion_threshold = 99999999 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 = 1 log_slow_filter = full_join,full_scan,not_using_index log_slow_min_examined_row_limit = 300000 innodb_log_buffer_size = 1G performance_schema = on extra_port = 3300 extra_max_connections = 100 #thread_handling = pool-of-threads 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 [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 default-character-set = utf8mb4