10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello all,
I am working on a perl script which will read weblogic logfile and send the error messages to Zenoss Monitoring tool. At present the script works and it can able to send the error messages to Zenoss. The problem comes when the logrotate has been applied to the weblogic log file. At... (3 Replies)
Discussion started by: kar_333
3 Replies
2. Shell Programming and Scripting
Hi can anyone help me with a script to load output of the .ksh file into an Oracle database. I have attached sample output of the information that i need to load to the database (2 Replies)
Discussion started by: LucyYani
2 Replies
3. Shell Programming and Scripting
Hi All,
I need the modification for the below mentioned code (found in one more post https://www.unix.com/shell-programming-scripting/27161-script-generate-average-values.html) to find the average values for all the columns(but for a specific rows) and print the averages side by side.
I have... (4 Replies)
Discussion started by: ks_reddy
4 Replies
4. Programming
Hi Guys,
We are having one multi-threaded application.
The scenario is as follows:
--------------------------------- Client 1
|
APP Server -------------- Client 2
... (1 Reply)
Discussion started by: 14341
1 Replies
5. Shell Programming and Scripting
Hi All
I have this csv file and I need to calculate the average of FPS.
FPS:27.7420, Interval:1314184238772
FPS:25.9798, Interval:1314184242646
FPS:27.4772, Interval:1314184246311
FPS:26.1623, Interval:1314184250159
FPS:26.4515, Interval:1314184253972
FPS:31.5896, Interval:1314184257163... (24 Replies)
Discussion started by: sayachop
24 Replies
6. OS X (Apple)
My UNIX skills amount to "Google,Copy,Paste..." but I managed to get a useful log file generated by an automation system that runs 24/7. The log file exists on an Omneon Media Grid server where I monitor it via "tail -F /..." Unfortunately we have many workstations running Tiger 10.4.8 still and... (2 Replies)
Discussion started by: SolarDarkroom
2 Replies
7. Shell Programming and Scripting
hi Gurus,
Need to pick your brains on this minor script project.
I would like to continuously monitor a log file with sample log messages as below, and if PSOldGen percentage is either 99% or 100% for consecutively 10 times, alert someone.
{Heap before gc invocations=46516:
PSYoungGen ... (6 Replies)
Discussion started by: kenchen722
6 Replies
8. Shell Programming and Scripting
Hi I am trying to get a bourne shell script to sort a file for me. Here is what i currently have:
#/bin/sh
echo "Name Exam1 Exam2 Exam3 Total Grade" > final.txt
awk -f 9.awk grades.txt | sort +4 -5 >> final.txt
#BEGIN {printf "Name\tExam1\tExam2\tExam3\tTotal\tGrade";}
{
... (12 Replies)
Discussion started by: DualPandas
12 Replies
9. Shell Programming and Scripting
Hi All,
I have a log file with several entries which need to be converted in a different format:
A)
log "tcp://1.2.3.4:80"
should be translated to --> Logged this from host 1.2.3.4 port 80
B)
log "tcp://1.2.3.4:*" --> Logged this from host 1.2.3.4
C)
log "tcp://1.2.3.4:80,8080" -->... (9 Replies)
Discussion started by: morningSunshine
9 Replies
10. Shell Programming and Scripting
Hi All,
i've written script to collect the tablespaces and the datafiles related to each tablespaces with free space available and directed to two logfiles.. ( pasted below)
1. datafile_test.log
PSAPSR3
PSAPSR3700
PSAPSR3USR
2. freedata_test.log... (6 Replies)
Discussion started by: suri.tyson
6 Replies
MYSQLDUMPSLOW(1) MySQL Database System MYSQLDUMPSLOW(1)
NAME
mysqldumpslow - Summarize slow query log files
SYNOPSIS
mysqldumpslow [options] [log_file ...]
DESCRIPTION
The MySQL slow query log contains information about queries that take a long time to execute (see Section 5.2.5, "The Slow Query Log").
mysqldumpslow parses MySQL slow query log files and prints a summary of their contents.
Normally, mysqldumpslow groups queries that are similar except for the particular values of number and string data values. It "abstracts"
these values to N and 'S' when displaying summary output. The -a and -n options can be used to modify value abstracting behavior.
Invoke mysqldumpslow like this:
shell> mysqldumpslow [options] [log_file ...]
mysqldumpslow supports the following options.
o --help
Display a help message and exit.
o -a
Do not abstract all numbers to N and strings to 'S'.
o --debug, -d
Run in debug mode.
o -g pattern
Consider only queries that match the (grep-style) pattern.
o -h host_name
Host name of MySQL server for *-slow.log file name. The value can contain a wildcare. The default is * (match all).
o -i name
Name of server instance (if using mysql.server startup script).
o -l
Do not subtract lock time from total time.
o -n N
Abstract numbers with at least N digits within names.
o -r
Reverse the sort order.
o -s sort_type
How to sort the output. The value of sort_type should be chosen from the following list:
o t, at: Sort by query time or average query time
o l, al: Sort by lock time or average lock time
o s, as: Sort by rows sent or average rows sent
o c: Sort by count
o -t N
Display only the first N queries in the output.
o --verbose, -v
Verbose mode. Print more information about what the program does.
Example of usage:
shell> mysqldumpslow
Reading mysql slow query log from /usr/local/mysql/data/mysqld51-apple-slow.log
Count: 1 Time=4.32s (4s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
insert into t2 select * from t1
Count: 3 Time=2.53s (7s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
insert into t2 select * from t1 limit N
Count: 3 Time=2.13s (6s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
insert into t1 select * from t1
COPYRIGHT
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Sun Microsystems, Inc. (http://www.mysql.com/).
MySQL 5.1 04/06/2010 MYSQLDUMPSLOW(1)
01-01-2014
Help needed: script for timely average from log file
