05-25-2009
killall mysql
Well, if you want to kill everything from a specific daemon then i guess you could use this
PID=`ps -ef |grep mysql |grep -v grep | awk '{print $2}'`
for i in $PID; do echo "killing MySQL process with PID = $i"; kill -9 $i; done
bare in mind that this will also kill the MySQL daemon...Therefore better used as a stop script.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello guys,
I have a process named monitoreo, with 'monitoreo start' my process start until i kill them, now i want to do 'monitoreo stop' to kill them.
After 'monitoreo start' i have this process running:
ps -af
UID PID PPID C STIME TTY TIME CMD
ati 10958 1495 ... (5 Replies)
Discussion started by: Lestat
5 Replies
2. UNIX for Dummies Questions & Answers
Hello
We are using UNIX, (?) there were reports to us thAt their login was automatically killed, however we (root) did not issue a kill -9 PID, can anyone give me an idea what happen. To add, the user is not idled, he is actually doing something.
also, i search all the thread, donno if i... (5 Replies)
Discussion started by: lancemendioro
5 Replies
3. Shell Programming and Scripting
HI All
Im new to shell scripting...kindly plz help me...
I need a shell script for:
We have to take export of all db's on daily basis from all svr's and keep these export backups on diffrent server.
Plz help.
Regards
Gaurav (5 Replies)
Discussion started by: ergauravtaneja
5 Replies
4. Shell Programming and Scripting
hello Bros,
I need to write some script that i can put it on crontab which checks for a process X if running. If the process X is ruuning then take the PID and kill it or display message that says process X is not running.
I am using AIX 5.3
Thanks guys.:b: (2 Replies)
Discussion started by: malcomex999
2 Replies
5. Shell Programming and Scripting
Hi Experts, we do have a shell script for Unix Solaris, which will kill all the process manullay, it used to work in my previous env, but now it is throwing this error.. could some one please help me to resolve it
This is how we execute the script (and this is the requirement) ... (2 Replies)
Discussion started by: jonnyvic
2 Replies
6. Shell Programming and Scripting
Hello all... new to these forums and a bit of a newbie with linux aswell.
I need to figure out how to write a shell script to kill a process by name as given to the script as an argument. I've got that part working OK, but i need to make sure that the script does not allow processes that are... (6 Replies)
Discussion started by: cannon1707
6 Replies
7. UNIX for Dummies Questions & Answers
What I need to learn is how to use a script that launches background processes, and then kills those processes as needed.
The script successfully launches the script. But how do I check to see if the job exists before I kill it?
I know my problem is mostly failure to understand parameter... (4 Replies)
Discussion started by: holocene
4 Replies
8. Shell Programming and Scripting
Hi
I have the process to kill regulary, but the PSID is dymatic change and not sure how to kill the specific process ID
Check the tradekast_rvd is running , if such process, kill the els process id
ps -e f |grep tradekast_rvd
ps -ef |grep els
then I kill els process id
... (2 Replies)
Discussion started by: linux_user
2 Replies
9. HP-UX
Hi All,
One of our servers stopped responding , unable to take any logins into it, the response is almost nil...later it resumed
Also during this time one of our application processes which was costly on memory got killed..is it an OOM kill?
Would like to know to know how to avoid such... (4 Replies)
Discussion started by: baanprog
4 Replies
10. Shell Programming and Scripting
Hi,
I just random create 1000 folder which range from 0-20,000 . Inside all the folder, I have copy over the same program named as run.sh to run in each folder.
Can I know that how to write a master script to let it automatic run the "run.sh" in each different random folder create?
Some... (5 Replies)
Discussion started by: perl_beginner
5 Replies
LEARN ABOUT OPENSOLARIS
perror
perror(1) MySQL database perror(1)
NAME
perror - describes a system or MySQL error code.
SYNOPSIS
perror [OPTIONS] [ERRORCODE [ERRORCODE...]]
DESCRIPTION
Can be used to display a description for a system error code, or an MyISAM/ISAM table handler error code. The error messages are mostly
system dependent.
OPTIONS
-?|--help
Displays this help and exits.
-I|--info
Synonym for the above.
-s|--silent
Only print the error message
-v|--verbose
Print error code and message (default).
-V|--version
Displays version information and exits.
EXAMPLE
shell> perror 64 79 Error code 64: Machine is not on the network Error code 79: Can not access a needed shared library
SEE ALSO
isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi-
lege_tables(1), mysqlshow(1), mysql_zap(1), replace(1)
For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online
at http://www.mysql.com/doc/en/
BUGS
Please refer to http://bugs.mysql.com/ to report bugs.
AUTHOR
Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). This software comes with no
warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercur-
media.com)
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+--------------------+------------------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+--------------------+------------------------------------+
|Availability | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
+--------------------+------------------------------------+
|Interface Stability | External |
+--------------------+------------------------------------+
NOTES
Source for mysql is available on http://opensolaris.org.
MySQL 4.0 19 December 2000 perror(1)