Slowness after server migration

Resolved vincenzolavino
(@vincenzolavino)

1 year ago

Good morning,
I moved the site from one server to a new one with many more resources via plesk.

Afterwards I noticed a great slowness especially when I do an order search.

I first deactivated and then reactivated the “high-performance” (in WP MySQL For Speed plug-in) to redo the indexes but the search in the orders (48,000) is slower, even slower than the old server

What can I do?

This is my kBqMeVed code

Viewing 4 replies - 1 through 4 (of 4 total)

Plugin Author OllieJones
(@olliejones)

1 year ago
Thanks for the question. Congratulations on a successful shop!
1. Your new MariaDB 10.6 server is misconfigured. It has an innodb_buffer_pool_size of 128MiB, which is so small it’s slamming performance. It should be set to about 40% of the total RAM on your server machine. Read this. https://mariadb.com/kb/en/innodb-system-variables/#innodb_buffer_pool_size Change the system variable and restart your database server.
2. You’re running on a single machine so you may find my SQLite Object Cache to be substantially faster than the Redis Object Cache you’re using. SQLite Object Cache – WordPress plugin | WordPress.org
3. I have a plugin specifically to improve WooCommerce Order search. With 40,000 orders I think this may help you. Fast Woo Order Lookup – WordPress plugin | WordPress.org
I know the first suggestion will help you a lot.
yoyurec
(@yoyurec)

1 year ago

The orders page itself contains a very slow query (to be fixed in Woocommerce 9.0.0) to look up meta_keys.

hi! so nowadays (Woo 9.x ++) plugin is obsolete? tnx

Plugin Author OllieJones
(@olliejones)

1 year ago

This Index WP MySQL for Speed plugin is certainly not obsolete.

And, I just checked Fast Woo Order Lookup against WooCommerce 9.7.1. It still speeds up order search by a factor of six on my 1,500-order test site.

So, in my estimation neither plugin is obsolete. By the way, nothing would make me happier than for them to be made obsolete by improvements in core or WooCommerce or both.

yoyurec
(@yoyurec)

1 year ago

Oh, cool then! Tnx again for ALL of yours plugins 💪💪💪

By the way, nothing would make me happier

yeh ))) they need to hire you with 10x rate for improving Woo )))

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Slowness after server migration’ is closed to new replies.