上上周遇到的一个 Magento 服务器问题。

问题现象

服务器负载居高不下，MySQL 数据库 CPU 占用很高，从 show processlist 的结果看，看不出什么问题。但是通过统计执行的 SQL 总量看，每秒钟几千个 SQL 查询。而且偶尔有执行长时间的大型联表查询语句。而产品表有近两百万的数据量。

经过一顿毫无头绪的排除。大概定位到是 magento 索引失效的问题，需要重建索引。

但是，重建命令，看不到进度，第一次执行，不知道为什么失败了。于是尝试，逐个手动重建索引。

重建索引前停掉 php fpm

sudo lnmp php-fpm stop

主要是为了防止请求进来，继续造成系统高负载。

重建后再启动

sudo lnmp php-fpm start

执行命令

以产品跟属性的索引为例：

php bin/magento indexer:reindex catalog_product_attribute -vvv

也可以一次性执行多个：

$ php bin/magento indexer:reindex catalogrule_product catalogrule_rule catalog_category_product customer_grid design_config_grid inventory catalog_product_category cataloginventory_stock -vvv

执行结果

Design Config Grid index has been rebuilt successfully in 00:00:00
Customer Grid index has been rebuilt successfully in 00:00:00
Category Products index has been rebuilt successfully in 00:21:15
Product Categories index has been rebuilt successfully in 00:00:00
Catalog Rule Product index has been rebuilt successfully in 00:00:00
Stock index has been rebuilt successfully in 00:01:59
Inventory index has been rebuilt successfully in 00:00:00
Catalog Product Rule index has been rebuilt successfully in 00:00:00
Product Price index has been rebuilt successfully in 00:21:29
Catalog Search index has been rebuilt successfully in 01:14:03

那个 catalog_product_attribute Product EAV 执行时间最长，执行了三四天。所以最好在 screen 中执行。

查看索引状态

$ php bin/magento indexer:status
+---------------------------+----------------------+--------+-----------+---------------------+---------------------+
| ID                        | Title                | Status | Update On | Schedule Status     | Schedule Updated    |
+---------------------------+----------------------+--------+-----------+---------------------+---------------------+
| catalogrule_product       | Catalog Product Rule | Ready  | Schedule  | idle (0 in backlog) | 2026-06-14 09:28:02 |
| catalogrule_rule          | Catalog Rule Product | Ready  | Schedule  | idle (0 in backlog) | 2026-06-14 09:28:02 |
| catalogsearch_fulltext    | Catalog Search       | Ready  | Schedule  | idle (0 in backlog) | 2026-06-14 14:02:10 |
| catalog_category_product  | Category Products    | Ready  | Schedule  | idle (0 in backlog) | 2026-06-14 09:28:02 |
| customer_grid             | Customer Grid        | Ready  | Schedule  | idle (0 in backlog) | 2026-06-14 09:28:02 |
| design_config_grid        | Design Config Grid   | Ready  | Schedule  | idle (0 in backlog) | 2026-06-14 09:28:02 |
| inventory                 | Inventory            | Ready  | Schedule  | idle (0 in backlog) | 2026-06-14 09:28:02 |
| catalog_product_category  | Product Categories   | Ready  | Schedule  | idle (0 in backlog) | 2026-06-14 09:28:02 |
| catalog_product_attribute | Product EAV          | Ready  | Schedule  | idle (0 in backlog) | 2026-06-22 10:09:25 |
| catalog_product_price     | Product Price        | Ready  | Schedule  | idle (0 in backlog) | 2026-06-14 12:44:58 |
| cataloginventory_stock    | Stock                | Ready  | Schedule  | idle (0 in backlog) | 2026-06-14 09:28:02 |
+---------------------------+----------------------+--------+-----------+---------------------+---------------------+

重建索引后，系统负载确实明显降了下来。

排查的细节后续补充一下，今晚安装 RuoYi Vue 的环境，折腾了一晚上，明天要早起，先睡了。

关于作者 🌱

我是来自山东烟台的一名开发者，有感兴趣的话题，或者软件开发需求，欢迎加微信 zhongwei 聊聊，或者关注我的个人公众号“大象工具”， 查看更多联系方式