Skip to content

After changing MySQL to MariaDB, updating Apache and PHP - laragon slow. How to improve? #872

Answered by ppfoong
alxndr-w asked this question in Q&A
Discussion options

You must be logged in to vote

Add these lines into my.ini. It is for computer with 8GB RAM. If you have more RAM, you can increase the values accordingly.

`
[mysqld]
#skip-name-resolve
skip-external-locking
back_log=50
max_connections=100
max_connect_errors=10
max_allowed_packet=512M
table_open_cache=1280
binlog_cache_size=2M
max_heap_table_size=384M
thread_cache_size=8
join_buffer_size=16M
sort_buffer_size=8M
key_buffer_size=256M
read_buffer_size=6M
read_rnd_buffer_size=16M
bulk_insert_buffer_size=64M
myisam_sort_buffer_size=256M
myisam_max_sort_file_size=2G
default_storage_engine=Innodb
innodb_file_per_table = 1
innodb_strict_mode=1
innodb_buffer_pool_size=1G
innodb_doublewrite=0
innodb_log_buffer_size=8M
innodb_flu…

Replies: 1 comment 2 replies

Comment options

You must be logged in to vote
2 replies
@alxndr-w
Comment options

@ppfoong
Comment options

Answer selected by alxndr-w
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
2 participants