Magento 2 performance optimization
Topic: Indexing, SQL, MSI, cache, OpenSearch Magento only starts to slow down when the store begins to make money. I analyze real cases: long queries on catalog_category_product, problems with inventory_stock_x, blocking indexes, or poorly chosen JOINs. No generalizations — specific queries, execution plan analysis, and fixes that actually make a difference.