I am testing my website on "https://developers.google.com/speed/pagespeed/insights/" and have only low ratings (9-12/100).
Virtual Server (CentOS) with 16 GB RAM, 6 cores (Intel Xeon), SSD Storage Magento 2.1.7 Apache 2.4.6
I made sure to have 14GB RAM in my php.ini (memory_limit = 14000M).
.user.ini in magento root directory and pub directory (all have 14 GB RAM).
My configuration file for MariaDB (/etc/my.cnf) looks like this:
[client] port = 3306 socket = /var/lib/mysql/mysql.sock
[mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-external-locking key_buffer_size = 384M max_allowed_packet = 10M
table_open_cache = 4096 sort_buffer_size = 16M
read_buffer_size = 4M read_rnd_buffer_size = 14M
myisam_sort_buffer_size = 64M thread_cache_size = 256
query_cache_type = 1 query_cache_limit = 4M
query_cache_size = 512M thread_concurrency = 8
log-bin=mysql-bin server-id = 1 innodb_buffer_pool_size = 3000M
innodb_additional_mem_pool_size = 80M
[mysqldump] quick max_allowed_packet = 512M
[myisamchk] key_buffer_size = 256M
sort_buffer_size = 256M read_buffer = 4M
write_buffer = 4M
I don't know why my website is still so slow (server response is always 1-2.5 seconds according to google pagespeed), even though my hardware is good enough (enough RAM).
PS: My magento mode is developer and all css js minify and merge options are off.