I am using Magento 2.3.4, and the server temp folder gets full because of SQL queries. I am looking for someone who can optimize SQL server and queries from Magento 2. The below error appears when the site crashes.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
SQLSTATE[HY000]: General error: 1021 Disk full (/dev/shm/#sql_2e1b28_7.MAI); waiting for someone to free some space... (errno: 28 "No space left on device"), query was: SELECT main_table.* FROM eav_attribute AS main_table
INNER JOIN eav_entity_type AS entity_type ON main_table.entity_type_id = entity_type.entity_type_id
LEFT JOIN eav_entity_attribute ON main_table.attribute_id = eav_entity_attribute.attribute_id
INNER JOIN catalog_eav_attribute AS additional_table ON main_table.attribute_id = additional_table.attribute_id WHERE (entity_type_code = 'catalog_product') AND ((additional_table.is_used_in_grid = 1)) GROUP BY main_table.attribute_id
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Can someone help me
