Process running but not in htop?

Question

MySQL

Hello. There is a script on the server that runs on cron and writes info to the log file. The start time is 20:00 and that's ok, it works. But now (10:00), I went to the server and see that the new log file was created 10 minutes ago and is being filled right now. That is, this script is working right now. I did not run it with my hands, the time on the server is correct, and most importantly, this process is not in htop. What can be wrong?

Answer 1

SELECT DISTICT product_id  FROM t AS t1
LEFT JOIN t AS t2 ON t1.product_id = t2.product_id
WHERE t1.param_id = 1 AND t2.param_id = 2 OR t1.param_id = 2 AND t2.param_id = 1

Answer 2

(`param_id = 1` or `param_id` = 2)
if it is not clear, write questions in the comments..

Answer 3

SELECT product_id FROM params WHERE param_id IN(1,2)

Answer 4

It may be that you run htop not as root and it only sees processes owned by the user. If the pid of the process is reflected in the logs, you can find it by it.