11-28-2002
Hi,
OS - Digital Unix 4.0D
File System is advfs
Hard Disk 9GB x 3 RAID 5 for this file system
Binary Executables and Ascii files are present in this directory.
ls -ln also takes time
Regds
Wilson
9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I am experiencing a problem where under a dial condition I am experiencing packet loss, which is failrly normal, but the response to the packet loss is taking bewteen 6 and 10 seconds. Could someone please advise what the industry standard is on the response time under a packet loss senario. (1 Reply)
Discussion started by: shane
1 Replies
2. UNIX for Advanced & Expert Users
in HP-UX how i can measure the response time
and how can i find the maximum IO (1 Reply)
Discussion started by: salhoub
1 Replies
3. SCO
Hi All
We have one SCO Server here and it never gives us any trouble. Until Now!! Well its not earth shattering but we have one user who is complaining of a very slow response time when changing to his Home Directory. Other users who have similar profiles are OK. I have su'd to this user and I can... (0 Replies)
Discussion started by: JohnOB
0 Replies
4. IP Networking
My company has a private network, including a Apache web server (Linux) and some WinXP machines. The web server had been configured to use mod_proxy to connect to window update site via another company proxy server. It works for few years.
Recently, some parties had setup a DNS server on the... (2 Replies)
Discussion started by: donaldfung
2 Replies
5. Emergency UNIX and Linux Support
Hi,
My application runs on AIX, and clients complain of 3am slowdowns. This seems to have increased in the recent past.
Can someone guide me what are the various things that I need to be looking at on he AIX box, that could be causing slowdowns.
Thanks in Advance. (4 Replies)
Discussion started by: ggayathri
4 Replies
6. AIX
Hi All.
We are using AIX 5.3 ML9. There is 1 Gig NIC installed on two servers (Primary and Secondary) with Full Duplex Mode. We have scheduled a cronjob to copy the backup from primary to secondary thru FTP on WAN. The total data size is 15 GB and it took 9 Hours and 18 Mins with transfer rate... (6 Replies)
Discussion started by: lodhi1978
6 Replies
7. Post Here to Contact Site Administrators and Moderators
Hi,
I am experiencing slow response of unix.com from past 3-4 days.
like-
- most of the time the page does not reload instantly (when I do a manual reload from browser)
- not able to view graphics. ( displays only text).
- when posting into forum, the page gets stuck for considerably long... (6 Replies)
Discussion started by: clx
6 Replies
8. Solaris
Solaris terminal responding very slow .. we have recently put a T3 hardware in to production , the applications running are it are perfectly and no complaints from user ..but when i ssh to the server ... the terminal response is very very slow .. it takes 3 seconds to show the character i type ..... (3 Replies)
Discussion started by: skamal4u
3 Replies
9. Shell Programming and Scripting
Hi All
I have been asked to write scripts within our monitoring tool for a vast requirement set.
One of the requirements is below:
• Lowest, Highest & Average response times of the Documentum process threads serving client requests
Essentially they want a view where we can see the... (4 Replies)
Discussion started by: simpsa27
4 Replies
LEARN ABOUT LINUX
mysqldumpslow
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 wildcard. 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 r, ar: Sort by rows sent or average rows sent
o c: Sort by count
By default, mysqldumpslow sorts by average query time (equivalent to -s at).
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 (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.
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
Oracle Corporation (http://dev.mysql.com/).
MySQL 5.5 01/30/2014 MYSQLDUMPSLOW(1)