Tag: MYSQL

Posted on

How to improve category indexer performance in local development setup warden Magento 2?

If you are working with warden setup for Magento 2 local development and your category indexer taking much time to perform indexing. This article is definitely for you to improve the performance of category indexers with the warden.

I am using MariaDB for the warden and it’s taking time to perform category indexer.

You need to set a few database variable configurations in the warden-env.yml file to fix the catalog category indexer speed-up issue: Continue reading “How to improve category indexer performance in local development setup warden Magento 2?”

Posted on

How To Export Database Dump From Mysql?

You can take mysqldump DB backup from Mysql with just simple steps.

  • First You need to log in with your SSH server.
  • After Login, Just go to your server directory location where you want to keep DB backup and that path must be writable.
  • Run the given command to take DB Backup,

Continue reading “How To Export Database Dump From Mysql?”

Posted on

How to do reset columns from collection Query by magento 2?

You can reset columns from the given collection in Magento.

Many times you want to be sure of the better performance for a given query and you want to reset a specific collection by fetching a few of the columns in the result.

Magento Collection provides the reset() method to clear specific part from the sql query. Continue reading “How to do reset columns from collection Query by magento 2?”