mysqldumpslow error

2012-01-16 Thread List Man
I am using debian squeeze and mysql 5.1.45. I am trying to use mysqldumpslow -s c -t 10, but I keep getting the following error: Can't determine basedir from 'my_print_defaults mysqld' output: --general_log=on. Does anyone have any idea as to why? I am not getting anything from google. TIA

Re: mysqldumpslow

2010-12-21 Thread 杨涛涛
Yeah, It can only parse the local file. If you expect to parse the remote one, just download it,haha. 杨涛 我博客1:http://yueliangdao0608.cublog.cn My 我博客2:http://yueliangdao0608.blog.51cto.com 2010/12/19 Eric Bergen eric.ber...@gmail.com I don't think so. mysqldumpslow parses the log file

Re: mysqldumpslow

2010-12-18 Thread Eric Bergen
I don't think so. mysqldumpslow parses the log file on the local server. On Fri, Dec 17, 2010 at 3:01 AM, partha sarathy par...@mafiree.com wrote: Is it possible to run mysqldumpslow on a remote host? -Partha -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

mysqldumpslow

2010-12-17 Thread partha sarathy
Is it possible to run mysqldumpslow on a remote host? -Partha -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysqldumpslow output interpretation

2006-11-28 Thread Chris
Anil Doppalapudi wrote: Hi List, Any update on this Thanks Anil Hi List, Below is the output of mysqldumpslow. In the output query execution time is showing -ve value how to interpret the below output i.e how to interpret -ve value for query execution time please advice Nobody has

RE: mysqldumpslow output interpretation

2006-11-24 Thread Anil Doppalapudi
Hi List, Any update on this Thanks Anil Hi List, Below is the output of mysqldumpslow. In the output query execution time is showing -ve value how to interpret the below output i.e how to interpret -ve value for query execution time please advice Count: 1 Time=4294967223.00s

mysqldumpslow errors

2002-03-12 Thread Michael Widenius
Hi! Steven == Steven Roussey [EMAIL PROTECTED] writes: Description: Steven 1. Handling of string simplification confused, crashes perl! Steven 2. Format of slow log had changed a while back, so now the Steven timing information is broken in mysqldumpslow How-To-Repeat

mysqldumpslow errors

2002-03-11 Thread Steven Roussey
Description: 1. Handling of string simplification confused, crashes perl! 2. Format of slow log had changed a while back, so now the timing information is broken in mysqldumpslow How-To-Repeat: uploaded to mysql secret: n54-slow.log.gz gunzip n54

BUGs in mysqldumpslow + fixes

2002-03-09 Thread Steven Roussey
(BTW, mysqldumpslow does not seem to be in the RPMs for v4.) mysqldumpslow (perl itself, I guess) dumps core and acts incorrectly when dealing with simplifying strings. Fix: Change: s/'([^\\\']|\\.|\'\')+'/'S'/g; s/([^\\\]|\\.|\\)+/S/g; To: s/''/'S'/g; s//S/g

mysqldumpslow

2002-02-27 Thread Steven Roussey
I'm trying to find what causes mysqldumpslow to crash for us every time the log is anything but trivial. The following does not crash it, but it does give incorrect results: # User@Host: apache[apache] @ morpheus.e [1.1.1.1] # Query_time: 8 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 replace

where is mysqldumpslow?

2002-02-04 Thread J. Ceferino Ortega
From the manual (section 4.9.5 'The Slow Query Log'): The slow query log can be used to find queries that take a long time to execute and are thus candidates for optimisation. With a large log, that can become a difficult task. You can pipe the slow query log through the mysqldumpslow command

Updated mysqldumpslow command

2001-03-08 Thread Tim Bunce
Attached is an updated version of the mysqldumpslow command that's supplied in the mysql distribution. The mysqldumpslow, for those who've not tried it, makes it very easy to summarize and analyze the contents of the 'slow query log'. This update was prompted by the need to support the newer