Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: integer treated as text?
Top Forums Shell Programming and Scripting integer treated as text? Post 302348414 by shantanuo on Friday 28th of August 2009 07:14:48 AM
Old 08-28-2009
integer treated as text?
The following script should kill all the queries taking more than say 600 seconds. But it seems that it is killing queries taking more than 6 seconds.

>> sh myscript.sh 600

Code:
#!/bin/bash
#kill runaway processes
SEC=$1
ifs='|'
if [[ $SEC -lt 1 ]]; then
echo "Usage: $0 seconds"
exit 1
fi
mysqladmin processlist -v | grep Query | grep -Evi "delete|update|insert|alter table" | while read dummy qid qusr qhost qdb qstat qsec qstat2 query
do
  if [[ $qsec > $SEC ]]; then
    echo "Killing query $qid..."
    mysqladmin kill $qid
  fi
done

Last edited by Franklin52; 08-28-2009 at 08:20 AM.. Reason: Please use code tags!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

ksh script: 'exit' being treated as 'break 2'

hi, in a korn shell script, has anyone ever seen an 'exit' being treated as a 'break 2'? I have a script which has 3 nested loops. Within the inner most loop, i'm trying to exit the script on a fault condition. instead of exiting, it's acting as a 'break 2' and then continuing on with the... (4 Replies)
Discussion started by: gsatch
4 Replies

2. IP Networking

how to pass integer

i am writing a client and server program client program main() { int sockfd,n; char str; struct sockaddr_in sock; if ((sockfd=socket(AF_INET,SOCK_STREAM,0))<0) { perror("SOCKET ERROR"); } bzero(&sock,sizeof(sock)); sock.sin_family=AF_INET; (1 Reply)
Discussion started by: ramneek
1 Replies

3. Shell Programming and Scripting

get integer part

Hi, I did a df|awk| command and it returns a percentage "94%", how could I only get the integer part "94" out of it, so I can compare it to another number, I knwo that I have to pipe it to sth, but "grep " did not work, it still give me number WITH the percentage, does someone know what... (3 Replies)
Discussion started by: ericaworld
3 Replies

4. Programming

error: initializer expression list treated as compound expression

I had seen this error for the first time ..... error: initializer expression list treated as compound expression please help.... (12 Replies)
Discussion started by: arunchaudhary19
12 Replies

5. Shell Programming and Scripting

Array values treated as one

I want each integer to be a value/element in the array, however the string is being treated as one. How can I stream these into distinct values? PSF6INDEX=`(snmpwalk -v 2c -c 'H0meru!es' ${SWITCH} .1.3.6.1.2.1.2.2.1.2 | grep 'GigabitEthernet' | sed 's/IF-MIB::ifDescr\.//g' | awk '{print $1}' |... (1 Reply)
Discussion started by: cytriesbash
1 Replies

6. Shell Programming and Scripting

Text data string conversion to Integer

Folks Appreciate your help in understanding issue in relation to below. I need to pul uvalue from a file (tmpfile) and compare it with a number to make decision. Using #!/bin/sh contents of tmpfile : Slot uvalue : 0.16 How I am pulling it: unifval=`awk '/uvalue/ {print $4}' tmpfile` ... (1 Reply)
Discussion started by: wndgs
1 Replies

7. UNIX for Dummies Questions & Answers

integer to string

Hi all, is there an easy way to convert integer to string in bash? I have numbers like 1, 2, ..., 112, ... and I would like to get 001 002 003 004 ... Thank you, Sarah (4 Replies)
Discussion started by: f_o_555
4 Replies

8. Shell Programming and Scripting

how to compare string integer with an integer?

hi, how to I do this? i="4.000" if ; then echo "smaller" fi how do I convert the "4.000" to 4? Thanks! (4 Replies)
Discussion started by: h0ujun
4 Replies

9. Shell Programming and Scripting

Compare the text/integer value from the log file

i have some log (temp.txt) file like temp.txt: Filesystem size used avail capacity Mounted on /dev/md/dsk/d30 9.8G 9.7G 14M 100% /opt /dev/md/dsk/d72 187M 61M 107M 37% /osmf/mgmt /dev/md/dsk/d71 187M 140M 29M 83% /export/home /dev/md/dsk/d70 7.9G 4.3G 3.5G 56% /var/crash /dev/md/dsk/d74... (6 Replies)
Discussion started by: doubt
6 Replies

10. Programming

Are These All The Integer Types In C

Hello and Good day, I am currently studying C and I just finished learning about variables mainly those of integer type. I am wondering if the list below are all there is to integer variables and there are still more that i have to learn. Here are the list: Char Short int long long long... (3 Replies)
Discussion started by: split_func0
3 Replies

LEARN ABOUT OPENSOLARIS

mysqld_multi

mysqld_multi(1) 						  MySQL database						   mysqld_multi(1)

NAME

       mysqld_multi  - is meant for managing several mysqld processes running in different UNIX sockets and TCP/IP ports.

USAGE

       mysqld_multi [OPTIONS] {start|stop|report} [GNR,GNR,GNR...]

SYNOPSIS

       mysqld_multi  [--config-file=...]   [--example]	[--help]  [--log=...]	[--mysqladmin=...]   [--mysqld=...]   [--no-log]  [--password=...]
       [--tcp-ip] [--user=...]	[--version]

DESCRIPTION

       mysqld_multi

       --config-file=...
	      Alternative config file. NOTE: This will not affect this program's own options (group [mysqld_multi]), but  only	groups	[mysqld#].
	      Without this option everything will be searched from the ordinary my.cnf file.

       --example
	      Give an example of a config file.

       --help Print this help and exit.

       --log=...
	      Log file. Full path to and the name for the log file. NOTE: If the file exists, everything will be appended.

       --mysqladmin=...
	      mysqladmin binary to be used for a server shutdown.

       --mysqld=...
	      mysqld  binary  to be used. Note that you can give mysqld_safe to this option also. The options are passed to mysqld. Just make sure
	      you have mysqld in your environment variable PATH or fix mysqld_safe.

       --no-log
	      Print to stdout instead of the log file. By default the log file is turned on.

       --password=...
	      Password for user for mysqladmin.

       --tcp-ip
	      Connect to the MySQL server(s) via the TCP/IP port instead of the UNIX socket. This affects stopping and reporting. If a socket file
	      is  missing,  the  server  may still be running, but can be accessed only via the TCP/IP port. By default connecting is done via the
	      UNIX socket.

       --user=...
	      MySQL user for mysqladmin.

       --version
	      Print the version number and exit.

NOTE

       Please see the mysql manual for more detailed information on this.

SEE ALSO

       isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1),  mysqld_safe(1),  mysqldump(1),  mysql_fix_privilege_tables(1),
       mysqlshow(1), mysql_zap(1), perror(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						   mysqld_multi(1)
All times are GMT -4. The time now is 09:24 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy