MySql is very slow on our site

[ad_1]

Thank you for uploading your metadata.

I think you have a lot of “orphan postmeta data”. That is, you have deleted many posts, pages, or products and their metadata — prices, vendors, etc — was not cleaned up. Try using a plugin like Advanced Database Cleaner to remove the orphan data.

Check that your persistent object cache is working correctly.

WPML isn’t fast.

It looks like you have set up your MariaDB server to use an “innodb_buffer_pool_size” of 3GiB. But you have 32GiB of physical RAM. The buffer pool is surprisingly small for a server of your size. Read this for more information. https://dba.stackexchange.com/questions/27328/how-large-should-be-mysql-innodb-buffer-pool-size

And you have a innodb_sort_buffer_size of 1MiB. Your can probably quadruple that, to 4MiB.

But these are entirely guesses on my part. I dare not give precise advice about server configuration without understanding a lot more about your setup.

It is safe to say your server needs to be examined for efficient resource allocation, and some things probably can adjusted to make it faster. And, it’s possible you don’t need such a large server.

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer