cancel
Showing results for 
Search instead for 
Did you mean: 

Magento Database Optimization

SOLVED

Magento Database Optimization

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?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Magento Database Optimization

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!

View solution in original post

2 REPLIES 2

Re: Magento Database Optimization

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!

View solution in original post

Re: Magento Database Optimization

@Nishu Jindal Thanks for your reply.

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

 

thanks for your help