File manager - Edit - /etc/my.cnf
Back
[client-server] !includedir /etc/my.cnf.d [mysqld] # Logging. Sesuaikan dengan hostname log-error = /var/lib/mysql/kerinci.iixcp.rumahweb.net.err # Optional performance tweaks performance-schema = 0 # Buffer pool innodb_buffer_pool_size = 12G innodb_file_per_table = 1 # Koneksi max_connections = 1024 max_allowed_packet = 256M open_files_limit=80000 unix_socket = OFF # Storage engine default default-storage-engine = InnoDB # SQL mode sql_mode = "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" # Nonaktifkan Query Cache (eliminasi locking & fragmentasi) query_cache_type = 0 query_cache_size = 0 query_cache_limit = 0 key_buffer_size = 32M # MyISAM legacy support # Timeout koneksi idle wait_timeout = 60 interactive_timeout = 60 # Table caching table_open_cache = 4096 table_definition_cache = 4096 # max execution time untuk mysql max_statement_time = 60 tmp_table_size = 128M max_heap_table_size = 128M innodb_stats_on_metadata = 0 innodb_flush_method = O_DIRECT
| ver. 1.4 |
Github
|
.
| PHP 8.3.30 | Generation time: 0.17 |
proxy
|
phpinfo
|
Settings