在运行SQL脚本的共享网络中查找IP地址 [英] Finding the IP address in a shared network running an SQL script

问题描述

在我们的服务器中，每天早上运行一个cron作业，并且由于脚本执行而导致所有API因服务器而停止。

In our server one cron job is running everyday morning and is causing all the API depending on the server is stopped due that script execution.

The MySQL admin shows the script is running in the panel

。有没有办法找出哪个机器正在运行crone作业。



谢谢



我的尝试：



我曾尝试在每台机器上看到每个crone状态，但我们有很多系统正在运行。我正在寻找一个更好的解决方案来解决这个问题

. Is there any way to find out from which machine that crone job is running.

THanks

What I have tried:

Ive tried to see every crone status in each machine, but we have a lot of systems up and running. I am seeking for a better solutions for this problem to get sorted

推荐答案

我不知道你为什么来这里。这个问题是关于MySQL管理的，而不是编写代码。



我认为你要找的命令是 SHOW PROCESSLIST [ ^ ]

I don't know why you're here. This question is about MySQL administration, not writing code.

I think the command you're looking for is SHOW PROCESSLIST[^]

这篇关于在运行SQL脚本的共享网络中查找IP地址的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！