Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #Edit File
- $ vi /etc/my.cnf.d/server.cnf
- #Add Config in next line : [mysqld]
- [mysqld]
- local-infile=0
- #skip-innodb
- innodb_buffer_pool_size=256M
- #innodb_additional_mem_pool_size=4M
- innodb_log_buffer_size=2M
- innodb_flush_log_at_trx_commit = 1
- innodb_thread_concurrency=2
- #innodb_log_file_size = 256M
- innodb_file_per_table
- skip-character-set-client-handshake
- skip-name-resolve
- max_connections = 300
- key_buffer = 512M
- myisam_sort_buffer_size = 32M
- join_buffer_size = 1M
- read_buffer_size = 1M
- sort_buffer_size = 2M
- read_rnd_buffer_size = 1M
- table_cache = 1536
- thread_cache = 4
- thread_concurrency = 2
- thread_cache_size = 256
- wait_timeout = 3600
- connect_timeout = 10
- max_tmp_tables = 256
- tmp_table_size = 128M
- max_allowed_packet = 16M
- max_connect_errors = 10
- query_cache_limit = 1M
- query_cache_size = 32M
- query_cache_type = 1
- query_prealloc_size = 16384
- query_alloc_block_size = 16384
- max_heap_table_size = 128M
- #tmpdir=/var/mysqltmp
- log_warnings=0
- [mysqld_safe]
- #log-error=/var/log/mysqld.log
- #pid-file=/var/run/mysqld/mysqld.pid
- open_files_limit = 16384
- #Save.. & Restart MySQL Service
- $ systemclt restart mysqld.service
- #Finished.
- # Linux Tips : https://www.reddit.com/user/ihotvps/
- # My Web Official : https://www.ihotvps.com
Add Comment
Please, Sign In to add comment