Sponsored Content
Full Discussion: Cron job for MySQL process
Top Forums Shell Programming and Scripting Cron job for MySQL process Post 302972551 by chapeupreto on Friday 6th of May 2016 04:56:33 PM
Old 05-06-2016
Hello there!
Maybe you could use a shell script in order to accomplish that task.
This is how I thought about it:

From 5 a.m to 7.am there are 2 hours, then 7200 seconds.
You want to run the
Code:
mysql

action every 5 seconds, then you need to run it 1440 times.

So, you could try something like the following:

Code:
#!/bin/bash

for i in {1..1440}; do
  mysql -ufoo --password='' -te "show full processlist" > /home/foo/log/show_processlist.log.`date +\%Y\%m\%d-\%H\%M` 2>&1
  sleep 5;
done

Say you save this script as filename
Code:
mysql_log.sh

Then, all you have to do now is to configure your crontab to run this script at exactly 5 a.m (one time only). Something like this:

Code:
0 5 * * * mysql_log.sh 2>&1

That action will last till 7 am.

Hope it helps and I hope someone points a better solution too.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

killing unix job after the job process completes

Hi, Thanks in advance. i need to kill a unix background running job after that job process completes. i can kill a job by giving the following unix command kill -9 processid how to kill the job after the current process run gets completed ? Appreciate your valuable help. ... (1 Reply)
Discussion started by: dtazv
1 Replies

2. Solaris

killing a unix job after the job process gets completed

Hi, Thanks in advance. i need to kill a unix background running job after that job process completes. i can kill a job by giving the following unix command kill -9 processid how to kill the job after the current process run gets completed ? Appreciate your valuable help. Thanks... (7 Replies)
Discussion started by: dtazv
7 Replies

3. UNIX for Dummies Questions & Answers

CRON usage for CRON job

can anybody explain the usage of CRON for adding a cron job. please provide an example also for better understanding !!! Thanks (1 Reply)
Discussion started by: skyineyes
1 Replies

4. Solaris

cron job starts new cron proccess

I run cron in solaris 10 zone. One cron job which syncing files to nfs mounted on container, creates after finishing another cron proccess(/usr/sbin/cron), and after 100 existing cron proccesses next cron job will not start. It's too weird for me, I'm not able to solve this problem. Theoretically... (3 Replies)
Discussion started by: ron76
3 Replies

5. Solaris

Cron Job -- auto start process when it dies

I would like to setup a Cron job to check weather X process is running or not. if it is not running then start that X process with a log message.... can any one help writing a script? thanks (3 Replies)
Discussion started by: chandravadrevu
3 Replies

6. UNIX for Dummies Questions & Answers

cron job is unable to process

Hi All, I have got a shell script that excutes some job and mails me the output as an attachment. While running the script manually, its perfect. when i am scheduling the job through crontab, i am getting the mail. but the attachment but this is a blank file. after the scheduler run, i can... (2 Replies)
Discussion started by: gotam
2 Replies

7. Shell Programming and Scripting

Cron job and shell script to kill a process if memory gets to high

Hello, I'd like to set a cron job that runs a shell script every 30 minutes or so to restart a java based service if the memory gets above 80%. Any advice on how to do this? Thanks in advance! - Ryan (19 Replies)
Discussion started by: prometheon123
19 Replies

8. Solaris

Cron job running even after cron is removed

Hi , I have removed a cron for particular user , but cron job seems to be running even after the cron entry is removed. The purpose of the cron was to sendmail to user ( it uses mailx utility ) I have restarted cron and sendmail service still user is getting mail alerts from the cron job. And... (4 Replies)
Discussion started by: chidori
4 Replies

9. Shell Programming and Scripting

Commented cron job -- cron monitoring

Hi I have a requirement to write a shell script,that will check the all commented job in cron job.Please help !! (2 Replies)
Discussion started by: netdbaind
2 Replies

10. Shell Programming and Scripting

Cron job - Need to run Cron every quarter at particular time

Hi, 1) If some job supposed to run on 1st of every month at 7 AM In cron job when we have a blackout on the 1st ( i.e when 1st falls on a sunday ) how can we make the job run the next business day? 2) How can we run a job on 25th of every quarter 7 AM(jan,apr,jul,oct) And if 25th... (5 Replies)
Discussion started by: System Admin 77
5 Replies
WATCHDOGD(8)						    BSD System Manager's Manual 					      WATCHDOGD(8)

NAME
watchdogd -- watchdog daemon SYNOPSIS
watchdogd [-dnSw] [--debug] [--softtimeout] [--softtimeout-action action] [--pretimeout timeout] [--pretimeout-action action] [-e cmd] [-I file] [-s sleep] [-t timeout] [-T script_timeout] DESCRIPTION
The watchdogd utility interfaces with the kernel's watchdog facility to ensure that the system is in a working state. If watchdogd is unable to interface with the kernel over a specific timeout, the kernel will take actions to assist in debugging or restarting the computer. If -e cmd is specified, watchdogd will attempt to execute this command with system(3), and only if the command returns with a zero exit code will the watchdog be reset. If -e cmd is not specified, the daemon will perform a trivial file system check instead. The -n argument 'dry-run' will cause watchdog not to arm the system watchdog and instead only run the watchdog function and report on fail- ures. This is useful for developing new watchdogd scripts as the system will not reboot if there are problems with the script. The -s sleep argument can be used to control the sleep period between each execution of the check and defaults to 10 seconds. The -t timeout specifies the desired timeout period in seconds. The default timeout is 128 seconds. One possible circumstance which will cause a watchdog timeout is an interrupt storm. If this occurs, watchdogd will no longer execute and thus the kernel's watchdog routines will take action after a configurable timeout. The -T script_timeout specifies the threshold (in seconds) at which the watchdogd will complain that its script has run for too long. If unset script_timeout defaults to the value specified by the -s sleep option. Upon receiving the SIGTERM or SIGINT signals, watchdogd will first instruct the kernel to no longer perform watchdog checks and then will terminate. The watchdogd utility recognizes the following runtime options: -I file Write the process ID of the watchdogd utility in the specified file. -d --debug Do not fork. When this option is specified, watchdogd will not fork into the background at startup. -S Do not send a message to the system logger when the watchdog command takes longer than expected to execute. The default behaviour is to log a warning via the system logger with the LOG_DAEMON facility, and to output a warning to standard error. -w Complain when the watchdog script takes too long. This flag will cause watchdogd to complain when the amount of time to execute the watchdog script exceeds the threshold of 'sleep' option. --pretimeout timeout Set a "pretimeout" watchdog. At "timeout" seconds before the watchdog will fire attempt an action. The action is set by the --pretimeout-action flag. The default is just to log a message (WD_SOFT_LOG) via log(9). --pretimeout-action action Set the timeout action for the pretimeout. See the section Timeout Actions. --softtimeout Instead of arming the various hardware watchdogs, only use a basic software watchdog. The default action is just to log(9) a message (WD_SOFT_LOG). --softtimeout-action action Set the timeout action for the softtimeout. See the section Timeout Actions. Timeout Actions The following timeout actions are available via the --pretimeout-action and --softtimeout-action flags: panic Call panic(9) when the timeout is reached. ddb Enter the kernel debugger via kdb_enter(9) when the timeout is reached. log Log a message using log(9) when the timeout is reached. printf call the kernel printf(9) to display a message to the console and dmesg(8) buffer. Actions can be combined in a comma separated list as so: log,printf which would both printf(9) and log(9) which will send messages both to dmesg(8) and the kernel log(4) device for syslog(8). FILES
/var/run/watchdogd.pid EXAMPLES
Debugging watchdogd and/or your watchdog script. This is a useful recipe for debugging watchdogd and your watchdog script. (Note that ^C works oddly because watchdogd calls system(3) so the first ^C will terminate the "sleep" command.) Explanation of options used: 1. Set Debug on (--debug) 2. Set the watchdog to trip at 30 seconds. (-t 30) 3. Use of a softtimeout: 3.1. Use a softtimeout (do not arm the hardware watchdog). (--softtimeout) 3.2. Set the softtimeout action to do both kernel printf(9) and log(9) when it trips. (--softtimeout-action log,printf) 4. Use of a pre-timeout: 4.1. Set a pre-timeout of 15 seconds (this will later trigger a panic/dump). (--pretimeout 15) 4.2. Set the action to also kernel printf(9) and log(9) when it trips. (--pretimeout-action log,printf) 5. Use of a script: 5.1. Run "sleep 60" as a shell command that acts as the watchdog (-e 'sleep 60') 5.2. Warn us when the script takes longer than 1 second to run (-w) watchdogd --debug -t 30 --softtimeout --softtimeout-action log,printf --pretimeout 15 --pretimeout-action log,printf -e 'sleep 60' -w Production use of example 1. Set hard timeout to 120 seconds (-t 120) 2. Set a panic to happen at 60 seconds (to trigger a crash(8) for dump analysis): 2.1. Use of pre-timeout (--pretimeout 60) 2.2. Specify pre-timeout action (--pretimeout-action log,printf,panic ) 3. Use of a script: 3.1. Run your script (-e '/path/to/your/script 60') 3.2. Log if your script takes a longer than 15 seconds to run time. (-w -T 15) watchdogd -t 120 --pretimeout 60 --pretimeout-action log,printf,panic -e '/path/to/your/script 60' -w -T 15 SEE ALSO
watchdog(4), watchdog(8), watchdog(9) HISTORY
The watchdogd utility appeared in FreeBSD 5.1. AUTHORS
The watchdogd utility and manual page were written by Sean Kelly <smkelly@FreeBSD.org> and Poul-Henning Kamp <phk@FreeBSD.org>. Some contributions made by Jeff Roberson <jeff@FreeBSD.org>. The pretimeout and softtimeout action system was added by Alfred Perlstein <alfred@freebsd.org>. BSD
November 16, 2014 BSD
All times are GMT -4. The time now is 08:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy