you can use watch instead of the explicit loop

while true; do mysql -h 127.0.0.1  magento2 -u root -e 'show full processlist'; sleep 2; done;
Magento 2 high MySQL CPU usage troubleshooting
5
1
Yegor Shytikov
Sylvain Witmeyer
·Follow
Apr 13, 2021
--
you can use watch instead of the explicit loop
watch -n 2 'mysql ...'
--
--
Written by Sylvain Witmeyer159 Followers
·82 Following
AWS Solutions Architect at National Bank of Canada — https://sylwit.com
Responses (1)
Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams