Re: Stored procedure runs indefinitely, but the steps within can be run individually with no issue (5.7)

[Peter Brawley]

Is max_execution_time set to 300?

Execute show variables like '%timeout%';

Re stubs, it's standard debugging method in all languages, in mysql eg ...

create procedure xxx (...)
begin
  set @t=now(6);
  ...
  select timediff(now(6),@t) as t, var1, var2, ...
  ...
  select timediff(now(6),@t) as t, var1, var2, ...
end;