Skip to content

Instantly share code, notes, and snippets.

@ronaldbradford

ronaldbradford/vmselect.sql

Created May 31, 2024 13:58
Show Gist options
  • Save ronaldbradford/0b19ee98e8173d4a56ecd59f806289b9 to your computer and use it in GitHub Desktop.
Save ronaldbradford/0b19ee98e8173d4a56ecd59f806289b9 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Selects 1m/5m/15m/60m
Raw
vmselect.sql
SELECT 'Start' AS msg, NOW();
SHOW GLOBAL STATUS LIKE 'com_select';
SELECT SLEEP(60 * 1);
SELECT '1m' AS msg, NOW();
SHOW GLOBAL STATUS LIKE 'com_select';
SELECT SLEEP(60 * 4);
SELECT '5m' AS msg, NOW();
SHOW GLOBAL STATUS LIKE 'com_select';
SELECT SLEEP(60 * 10);
SELECT '15m' AS msg, NOW();
SHOW GLOBAL STATUS LIKE 'com_select';
SELECT SLEEP(60 * 45);
SELECT '1hr' AS msg, NOW();
SHOW GLOBAL STATUS LIKE 'com_select';
SELECT 'Done';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment