Re: Sort_merge_passes increasing at 38 per minute...

[Rick James]

That is a tiny table -- 1.5MB. The buffer pool is also small: 64MB. No reason for a sort to take even 1 second.

That UPDATE might do all that the Stored Procedure was going to do, and do it faster, and without worrying about transactions. (I cannot verify that it is exactly what you need.)

If there are other tables, or if this table grows a lot, then consider your settings, based on
http://mysql.rjweb.org/doc.php/memory

You have expensive stuff?
`price` decimal(30,2) NOT NULL,
allows up to
$9,999,999,999,999,999,999,999,999,999.99
(hehe)