Magento Database Optimization

[robertbits]

Hi,

Recently Magento started taking a lot of CPU usage. I have contacted the hosting company and they told me that problem is being caused by excessive MySQL executions.

Also, they told me that the database is quite large and that I should clear the logs, sessions, and transient entries.

I have checked the database and the only two tables which are abnormally large are:

quote - which is 22.1 MB

quote_address - which is 20.1 MB

Does anyone know these two tables what are used for?

And is it safe to clear them?

And How do I optimize the database for Magento to work more efficient?

[Nishu Jindal · Accepted solution]

Hi @robertbits ,

Do not do any changes in the 

Quote and quote_address table.

I am sharing one link in which they have mention some points for database performance tunning.

https://www.google.com/amp/s/onilab.com/blog/magento-2-mysql-optimization-and-database-performance-t...

Hope this helps you! 

Problem Solved! Click Kudos & Accept as Solution!

[robertbits]

@Nishu Jindal Thanks for your reply.

I have made some changes, now we'll see how it affects the performance.

thanks for your help