How to manage data in the amasty_xsearch_users_search table efficiently?
In order to maintain optimal database performance and manage data effectively in the Advanced Search module, you may need to truncate the amasty_xsearch_users_search table. Here’s how you can manually delete records or set up an automatic clean-up function.
Manually Deleting Records
To manually clear the amasty_xsearch_users_search table, the following SQL commands can be used:
To delete all records:
DELETE FROM amasty_xsearch_users_search;
To delete records older than 1 year:
DELETE FROM amasty_xsearch_users_search WHERE created_at < CURRENT_TIMESTAMP - INTERVAL 1 YEAR;"YEAR" can be replaced with "MONTH", "WEEK", or "DAY" to adjust the time interval as needed.
Automatic Clean-up Setup
To ensure that the process of clearing old search requests is automated, it should be confirmed that the Advanced Search module is updated and configured correctly:
Step 1. Module Version Verification: It should be checked that version 1.19.0 or higher of the Advanced Search module is being used, as the feature for records auto-cleaning was added in this release. Assistance with the updating process can be sought by referring to this article.
Step 2. Enabling Auto-Cleaning: The Old Search Requests Auto-Cleaning setting should be enabled by navigating to Stores > Configurations > Amasty Extensions > Advanced Search > General tab:
Thus, the records older than the period specified in the Auto-Cleaning Period in Days field will be automatically deleted.
It should be outlined that deleting records from the amasty_xsearch_users_search table will not disrupt the extension's functionality. However, the analytics data based on the remaining records will be affected, as deleted records will no longer be available for historical analysis.
Related Articles
Advanced Search API
We have created a public API collection for Advanced Search module with all available queries and sample data that you can both test via our demo endpoints and copy to run local tests in your Magento environment. More details about using public ...I face some issues with the Elastic Search extension. What should I check?
If the extension doesn't work as expected (e.g. search results are not relevant or do not display at all), we'd recommend checking the module configurations following the instructions below. 1. A compatible version of the Elasticsearch Engine should ...How to configure search synonyms in Amasty Elastic Search?
Besides other features like Search Relevance Rules, Stop Words, etc., the Amasty Elastic Search extension supports Search Synonyms. Default Magento synonyms aren't used in Amasty Elastic Search, the module manages synonyms separately. Step 1. To ...Why should I use your module instead of Magento Elastic Search?
Starting from version 2.4, Magento works with the Elastic Search that greatly impacts the overall performance of the website. Using Elastic Search as a search engine provides faster page loading and more relevant search results. Within the default ...How to add more product data to rich snippets?
Utilizing our Rich Snippets module, you can enhance your product data by incorporating additional information into rich data sets. This is accomplished by populating the "Custom Properties" field. To add custom properties: 1. Navigate to: Amasty > ...
Announcements
⚡ Have you enlarged the functionality of the Amasty extension with your own code? Share your improvements with us!
At Amasty, we understand that some of our clients require customized features to perfectly align the extension with their business needs. If you have developed new functionality within an Amasty module and would like to share it, please submit a ticket