Enhance Worldpress Speed up

mero

xyzulu hi thanks for the quick response. I dont think the database is the issue. Its more a setting problem as i think. I use Cloudfare proxy yes

Steamon

mero

Hey I migrated a woocommerce webshop with 18k products that was 20-25 seconds loading on directadmin with duplicator and can now get it under 3 seconds or even faster some pages.

Without editing the my.cnf only some php.ini rules

Would for sure check a few things settings wise and I use litespeed cache wordpress plugin with redis. 8 cpu 16 gb ram server.

ss88us

Install the Query Monitor plugin. This should help you take a peek at Environment Variables easily, but also check what potential queries or database slowness is happening. It will also let you know if those API calls are the problem.

You can also install the Index WP MySQL For Speed plugin. It converts indexes and speeds up the database queries. I've installed this onto a website with 6m+ rows in the post_meta table and it made a difference.

JohnB

ss88us Query Monitor plugin.

Amazing how such a good plugin is free.

pratik_asabe

Enable thread caching, query caching, set ample amount of buffer pool size etc. on db to see how it performs, disable swap if possible and let server use RAM as much as it needs, use redis via litespeed plugin instead of separate redis plugin (if using object caching pro then stick to it)

You need to dig into the root cause so you can better address it..

ss88us Index WP MySQL For Speed plugin

We're using it for few of our clients for past couple of years and its really good! mero

mero

Thanks guys, ive installed the litespeed cache plugin on WP and it helped alot. The Query Monitor was a amazing help. You can excactly where the problems are

rdbf

mero

Don't forget to turn on Redis, and configure it as object cache in the litespeed cache plugin as well if you haven't yet

cristianuibar

rdbf

I want to drop in and give my 2 cents. The Redis implementation inside LS Cache plugin is buggy. Use the dedicated Redis cache plugin instead. Especially with Woocommerce.

The problem I had with the LS Cache Redis implementation is related to cache invalidation when updating products and plugins. They would not reflect immediately and I feel like LS Cache is a bit too aggressive with the cache. So make sure to use it cautiously to not have problems with stock and price updates on the frontend especially in large Woo stores.

mero

pratik_asabe thanks, how i can use thread caching/query caching and set it up ?

bluelinq-computers

mero In addition to my fellow enhance peers & their recommendations, I highly recommend Redis Object Cache or Object Cache Pro (contact me directly if you are interested in OCP). In total, these are the performance related plugins that I recommend on most if not all WordPress installations:

Redis Object Cache or Object Cache Pro (https://wordpress.org/plugins/redis-cache/ OR https://objectcache.pro/)
Index WP MySQL For Speed (https://wordpress.org/plugins/index-wp-mysql-for-speed/)
Index WP Users For Speed* (https://wordpress.org/plugins/index-wp-users-for-speed/)
Query Monitor (https://wordpress.org/plugins/query-monitor/)
LiteSpeed Cache (https://wordpress.org/plugins/litespeed-cache/)
Perfmatters (https://perfmatters.io/ feel free to message me if you'd like to use this)
ShortPixel Image Optimizer (https://wordpress.org/plugins/shortpixel-image-optimiser/)

*not necessary if your site does not have a lot of users.

Do let me know if you need any assistance in configuring LiteSpeed Cache/Perfmatters to work together.

mero

ive added this in my my.cnf file and is really really skyrocking now. Chatgpt helped me lol

[mysqld]
skip-log-bin

ssl-ca=/etc/certs/mysql/ca.pem

#ssl-cert=/etc/mysql/ssl/cert.pem
#ssl-key=/etc/mysql/ssl/key.pem

skip-name-resolve
max_connections = 300
thread_cache_size = 100
table_open_cache = 10000
table_definition_cache = 10000
open_files_limit = 65535

CACHING (Query cache is deprecated in newer MySQL versions)

query_cache_type = 0
query_cache_size = 0

INNODB SETTINGS

innodb_buffer_pool_size = 48G # 75% of RAM
innodb_buffer_pool_instances = 12 # 1 instance per 4GB
innodb_log_file_size = 2G
innodb_log_buffer_size = 256M
innodb_file_per_table = 1
innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 2 # Safer = 1, Faster = 2
innodb_io_capacity = 2000
innodb_io_capacity_max = 4000
innodb_read_io_threads = 8
innodb_write_io_threads = 8

PERFORMANCE SCHEMA

performance_schema = OFF

TEMP TABLES

tmp_table_size = 512M
max_heap_table_size = 512M

LOGGING

slow_query_log = 1
slow_query_log_file = /var/log/mysql-slow.log
long_query_time = 2
log_error = /var/log/mysql-error.log

default_authentication_plugin = mysql_native_password
skip-host-cache

bluelinq-computers

cristianuibar This. Redis Cache/Object Cache Pro is the way to go. I don't let LS Cache handle any object caching.