2012/9/5 Adarsh Sharma eddy.ada...@gmail.com
Actually that query is not my concern :
i have a query that is taking so much time :
Slow Log Output :
# Overall: 195 total, 16 unique, 0.00 QPS, 0.31x concurrency _
# Time range: 2012-09-01 14:30:01 to 2012-09-04 14:13:46
#
I already attached the list.
Attaching one more time thanks for the interest.
Cheers
On Wed, Sep 5, 2012 at 11:44 AM, Manuel Arostegui man...@tuenti.com wrote:
2012/9/5 Adarsh Sharma eddy.ada...@gmail.com
Actually that query is not my concern :
i have a query that is taking so much
true Michael, pasting the output :
CREATE TABLE `WF_1` (
`id` varchar(255) NOT NULL,
`app_name` varchar(255) DEFAULT NULL,
`app_path` varchar(255) DEFAULT NULL,
`conf` text,
`group_name` varchar(255) DEFAULT NULL,
`parent_id` varchar(255) DEFAULT NULL,
`run` int(11) DEFAULT NULL,
...@gmail.com]
Sent: Wednesday, September 05, 2012 11:27 AM
To: Michael Dykman
Cc: mysql@lists.mysql.com
Subject: Re: Understanding Slow Query Log
true Michael, pasting the output :
CREATE TABLE `WF_1` (
`id` varchar(255) NOT NULL,
`app_name` varchar(255) DEFAULT NULL,
`app_path
Ok, this raises a question for me - what's a better way to do pagination?
On 9/5/12 2:02 PM, Rick James wrote:
* LIMIT 0, 50 -- are you doing pagination via OFFSET? Bad idea.
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
Sometimes it pays to stay in bed
...@ihouseweb.com]
Sent: Wednesday, September 05, 2012 2:05 PM
To: mysql@lists.mysql.com
Subject: Re: Understanding Slow Query Log
Ok, this raises a question for me - what's a better way to do
pagination?
On 9/5/12 2:02 PM, Rick James wrote:
* LIMIT 0, 50 -- are you doing pagination via OFFSET
: Understanding Slow Query Log
Ok, this raises a question for me - what's a better way to do
pagination?
On 9/5/12 2:02 PM, Rick James wrote:
* LIMIT 0, 50 -- are you doing pagination via OFFSET? Bad idea.
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
Sometimes
I suggested will (probably) be much faster.
-Original Message-
From: Suresh Kuna [mailto:sureshkumar...@gmail.com]
Sent: Saturday, September 01, 2012 1:03 AM
To: Adarsh Sharma
Cc: mysql@lists.mysql.com
Subject: Re: Understanding Slow Query Log
Disable log-queries-not-using-indexes
Message-
From: Suresh Kuna [mailto:sureshkumar...@gmail.com]
Sent: Saturday, September 01, 2012 1:03 AM
To: Adarsh Sharma
Cc: mysql@lists.mysql.com
Subject: Re: Understanding Slow Query Log
Disable log-queries-not-using-indexes to log only queries 100 sec.
Just do /var/lib
Hi all,
I am using Mysql Ver 14.14 Distrib 5.1.58 in which i enabled slow query log
by setting below parameters in my.cnf :
log-slow-queries=/usr/local/mysql/slow-query.log
long_query_time=100
log-queries-not-using-indexes
I am assuming from the inf. from the internet that long_query_time
...@gmail.com:
Hi all,
I am using Mysql Ver 14.14 Distrib 5.1.58 in which i enabled slow query log
by setting below parameters in my.cnf :
log-slow-queries=/usr/local/mysql/slow-query.log
long_query_time=100
log-queries-not-using-indexes
I am assuming from the inf. from the internet
Disable log-queries-not-using-indexes to log only queries 100 sec.
Just do /var/lib/mysql/slow-queries.log it will clear the log.
On Sat, Sep 1, 2012 at 12:34 PM, Adarsh Sharma eddy.ada...@gmail.comwrote:
Hi all,
I am using Mysql Ver 14.14 Distrib 5.1.58 in which i enabled slow query log
Hi Machiel,
The below link will help you.
mk-query-digesthttp://www.xaprb.com/blog/category/maatkit/
Regards,
Krishna
On Tue, Feb 16, 2010 at 12:51 PM, Machiel Richards machi...@rdc.co.zawrote:
Hi All
I hope that someone can assist me with this.
We have
with the Slow Query Log
enabled but to use a very large value of --long-query-time to
essentially ignore every query. Then, when you want to capture slow
queries, you reset --long-query-time to a reasonable value.
Unfortunately, this requires a restart to initialize. After that you can
adjust
Hi All
I hope that someone can assist me with this.
We have a client with a production MySQL database running
MySQL 5.0.
Their slow query counts have skyrocketed over the last week
and I found that their slow query logs are
Use an etl tool like Talend to load the slow query log into a table. We do
something similar with the general query log very successfully with mysql 5
Even with 5.1 i would use this approach over the built in log tables as the
built in log tables impact performance quite significantly
2009/10/7 Brown, Charles cbr...@bmi.com:
Hello All. I would like to implement MYSQL slow query log in table. Can
someone kindly assist me with the table definition and implementation.
SHOW CREATE TABLE mysql.slow_log;
http://dev.mysql.com/doc/refman/5.1/en/log-tables.html
--
Jaime Crespo
Crespo Rincón [mailto:jcre...@warp.es]
Sent: Thursday, October 08, 2009 10:17 AM
To: Brown, Charles
Cc: Daevid Vincent; mysql@lists.mysql.com
Subject: Re: MYSQL slow query log in table.
2009/10/7 Brown, Charles cbr...@bmi.com:
Hello All. I would like to implement MYSQL slow query log in table
Hello All. I would like to implement MYSQL slow query log in table. Can
someone kindly assist me with the table definition and implementation.
Thanks so much in advance
This message is intended only for the use of the Addressee and
may contain
Questions Folks:
(1) What do you about un-index searches. How can one report and monitor them?
(2) What do you do with the slow-query log. Are there any utilities or scripts
out there to filter and manage this log?
Thanks
This message
Meyer; Mark Phillips
Subject: Questions on un-index searches and slow-query-log
Questions Folks:
(1) What do you about un-index searches. How can one report and monitor them?
(2) What do you do with the slow-query log. Are there any utilities or scripts
out there to filter and manage this log
And an answer to 2): http://www.maatkit.org/doc/mk-query-digest.html
On Tue, Oct 6, 2009 at 02:59, Brown, Charles cbr...@bmi.com wrote:
Questions Folks:
(1) What do you about un-index searches. How can one report and monitor them?
(2) What do you do with the slow-query log. Are there any
I am trying to monitor a specific issue, and I know it is related to
only one database. There is a lot of other noise in the logs if I
enable query logging.
Is there any way to limit query logging to just one database?
--
Scott * If you contact me off list replace talklists@ with scott@ *
Is there anyway to keep updates and deletes from showing up in the slow
query logs?
It executes in 0 sec when you run it. It might be in the query cache.
Try it with SQL_NO_CACHE. But even then it might run faster than it
did when it got logged in the slow log, because the table's data might
be in memory and therefore faster to access.
The point is that the slow query log
# Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 150
SELECT SUM(COUNTER_VALUE) FROM STO_LIS sl, SCAT_LIS sfl WHERE l.STO_LIS_ID
=sfl.LIS_ID AND sfl.CAT_ID = '-1';
This is what is there in the slow-query log
On 1/2/09, Baron Schwartz ba...@xaprb.com wrote:
It executes in 0 sec when
|
++
1 row in set (0.00 sec)
On 12/31/08, Baron Schwartz ba...@xaprb.com wrote:
Hi,
On Wed, Dec 31, 2008 at 8:44 AM, Ananda Kumar anan...@gmail.com wrote:
Hi All,
I have enabled slow query log.
Generally this file will have sql's which take more than long-query time
Hi All,
I have enabled slow query log.
Generally this file will have sql's which take more than long-query time to
execute and also sql's not using indexes.
But i see sql's which does not come under the above condition.
I have set the long-query time to 1 Sec .
The query takes less than 1 sec
I'm just guessing, but if the slow query log time resolution is seconds,
perhaps 0.5 and higher rounds up?
Or, perhaps it has an index, but it can't be used in that query.
What does EXPLAIN [paste query here] tell you?
--
MySQL General Mailing List
For list archives: http
hi again,
for those that are interested: the problem was indeed the filesystem
with slow lookups of BIG directories (this had nothing to do with mysql
but caused much iowait and therefore the mysql process had been heavily
impacted).
Soenke Ruempler - NorthClick wrote:
I assume that those
Hi,
On Mon, Mar 17, 2008 at 12:59 PM, Soenke Ruempler - NorthClick
[EMAIL PROTECTED] wrote:
hi again,
for those that are interested: the problem was indeed the filesystem
with slow lookups of BIG directories (this had nothing to do with mysql
but caused much iowait and therefore the mysql
Hi Baron,
Baron Schwartz wrote:
I'd be interested to know what filesystem you're using and how big the
directories are. When you say big, do you mean number of entries in
the directory, or space used?
There were about 70k files in /tmp (caused by a mistake). the web
application on this
Wow! 70k files in /tmp. Hell of a mistake :) I hope it doesn't happen often.
Arthur
On 3/17/08, Soenke Ruempler - NorthClick [EMAIL PROTECTED] wrote:
Hi Baron,
There were about 70k files in /tmp (caused by a mistake). the web
application on this server had many lookups to tmp and those were
hi,
I've just ran into some problems analyzing the slow-query-log.
1. I have many entries like:
# Time: 080312 13:07:33
# [EMAIL PROTECTED]: cms[cms] @ localhost []
# Query_time: 17 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
COMMIT;
# [EMAIL PROTECTED]: cms[cms] @ localhost
I want to know how to configurate slow-query-log to let it not record the
update sql.
I just want to know how the slow select statement ,not the update or insert.
Anybody's reply is appreciated,thanks.
--
I'm a mysql DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
Hi List,
Anybody knows a tool for viewing mysql server general query log in
linux.
Thanks
Ashok
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I would like to empty the slow query log without restarting MySQL.
If I simply delete lines, the server will no longer write to the file. I have
tried leaving the header, but still no writes unless I restart MySQL.
I am on RHEL4.
The group and owner of the file are correct:
4 -rw-rw
On 8/7/07, Boyd Hemphill [EMAIL PROTECTED] wrote:
I would like to empty the slow query log without restarting MySQL.
If I simply delete lines, the server will no longer write to the file. I
have tried leaving the header, but still no writes unless I restart MySQL.
I am on RHEL4.
The group
On 6/26/07, Brown, Charles [EMAIL PROTECTED] wrote:
The MYSQL general query log does not include timestamp of queries that
it logs because queries are logged many many seconds before they are
executed.
Which version of MySQL are you running? I'm running 5.0.22 on my
desktop, but I'm fairly
The MYSQL general query log does not include timestamp of queries that
it logs because queries are logged many many seconds before they are
executed. Can someone help me associated queries found in the query log
with wall clock? I am trying to get a list of queries that were executed
within
Before I do this, I just wanted to check with you all to see if this
is the correct command:
/etc/rc.d/init.d/mysqld restart --log-slow-queries
If so, where exactly will I find the slow query log?
Will the slow query log be turned off by default next time I restart it?
--
MySQL General
Brian Dunning wrote:
Before I do this, I just wanted to check with you all to see if this is
the correct command:
/etc/rc.d/init.d/mysqld restart --log-slow-queries
If so, where exactly will I find the slow query log?
Will the slow query log be turned off by default next time I restart
My MySQL server (4.0.20, Linux) was running slowly. I checked the slow queries
log, and found many of these during the problem period:
# Time: 060730 20:44:40
# [EMAIL PROTECTED]: xxx []
# Query_time: 68 Lock_time: 0 Rows_sent: 0 Rows_examined: 2
# administrator command: Quit;
# [EMAIL
TK wrote:
My MySQL server (4.0.20, Linux) was running slowly. I checked the slow queries
log, and found many of these during the problem period:
# Time: 060730 20:44:40
# [EMAIL PROTECTED]: xxx []
# Query_time: 68 Lock_time: 0 Rows_sent: 0 Rows_examined: 2
# administrator command: Quit;
#
Mac OS X 10.4.6 (Tiger), MySQL 5.0.21.
Hi folks. I'm needing to start up my general query log to see what's
ticking me off.
I've looked into safe_mysqld but it's confusing as ... something
that's confusing.
Anybody know how I can easily turn this thing on for a day, then turn
it off
PROTECTED] wrote:
Mac OS X 10.4.6 (Tiger), MySQL 5.0.21.
Hi folks. I'm needing to start up my general query log to see what's
ticking me off.
I've looked into safe_mysqld but it's confusing as ... something
that's confusing.
Anybody know how I can easily turn this thing on for a day, then turn
it off
Yes. idea #1 -- reply all, including the list.
idea #2 -- what's in the error logs?
Check that the user that runs mysql has permission to write to the
file and that /var/log exists.
-Sheeri
On 5/19/06, Rich [EMAIL PROTECTED] wrote:
Hi there.
I added the my.cnf file (it wasn't there) and
Why this list goes private I'll never know. I guess that's why I
always get two copies.
In the errors log:
Found option without preceding group in config file: /etc/my.cnf at
line: 1
Fatal error in defaults handling. Program aborted
/var/log/ does indeed exist
root runs mysqld
On
That means that your options have no group. Options should go under
the program they're intended to be run under, for instance
[mysqldump]
user=root
[mysql.client]
user=guest
[mysqld]
log=/path/to/logfile
You want the mysqld program (mysql server) to use the general log, so
put it under a
Hello,
Is there a way to enable the Slow Query Log on the fly without having to
restart mysqld
Regards,
Marc.
On Wed, 2006-04-05 at 11:38 +0200, Mechain Marc wrote:
Is there a way to enable the Slow Query Log on the fly without having to
restart mysqld
No.
Petr
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Thank you for your answer.
But is there a chance to be able to do it one day?
I think it could be a nice feature.
Marc.
-Message d'origine-
De : Petr Chardin [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 5 avril 2006 13:06
À : Mechain Marc
Cc : MySQL
Objet : Re: Slow query log
Mechain Marc wrote:
Hi,
Thank you for your answer.
But is there a chance to be able to do it one day?
I think it could be a nice feature.
Marc.
That should be asked to one of the devs.
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL
2006/4/5, Mechain Marc [EMAIL PROTECTED]:
Hi,
Thank you for your answer.
But is there a chance to be able to do it one day?
I think it could be a nice feature.
You still have the option to sponsor that feature ;-D
--
MySQL General Mailing List
For list archives:
Hi;
My query.log is full of 'show innodb status' queries.
How do I get this ascii log file not to log these. OR some help with a
grep script to copy the file without these lines.
I noticed the same in the logs of a 4.1 test server. I put it down to
MySQL Administrator which was monitoring the
On 1/27/06, Imran Chaudhry [EMAIL PROTECTED] wrote:
Hi;
My query.log is full of 'show innodb status' queries.
How do I get this ascii log file not to log these. OR some help with a
grep script to copy the file without these lines.
I noticed the same in the logs of a 4.1 test server. I
2006/1/25, Nathan Gross [EMAIL PROTECTED]:
Hi;
My query.log is full of 'show innodb status' queries.
How do I get this ascii log file not to log these. OR some help with a
grep script to copy the file without these lines.
If you have a linux box (or any acceptable shell)
cat query.log | grep
Aye. -v. thanks!
-nat
On 1/26/06, Pooly [EMAIL PROTECTED] wrote:
2006/1/25, Nathan Gross [EMAIL PROTECTED]:
Hi;
My query.log is full of 'show innodb status' queries.
How do I get this ascii log file not to log these. OR some help with a
grep script to copy the file without these lines.
Hi;
My query.log is full of 'show innodb status' queries.
How do I get this ascii log file not to log these. OR some help with a
grep script to copy the file without these lines.
Thanks
-nat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I have entries in my slow query log for identical queries but, as you can see
from the log entries below (including one irrelevant query), the number rows
examined and returned varies. The tables are _not_ being updated.
The query cache is 'on demand', so I'm also not sure why the subsequent
Hi,
Could anyone explain what might be the possible reasons that in the slow
query log(running read-only queries) the most very slow queries(taking
200-300sec) were the queries:
1. create table ... type = MyISAM
2. show slave status
Thanks,
Jenny
Hi Gleb,
Thanks a lot.
On Mon, 2005-12-12 at 23:44, Gleb Paharenko wrote:
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/log-file-maintenance.html
abdulazeem wrote:
Hi,
Iam running a mysql server version 5.0.15. My mysql query log is
occupying nearly 21 GB
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/log-file-maintenance.html
abdulazeem wrote:
Hi,
Iam running a mysql server version 5.0.15. My mysql query log is
occupying nearly 21 GB of disk space. how do i truncate the same ?
Thanks in advance,
Abdul
Hi,
Iam running a mysql server version 5.0.15. My mysql query log is
occupying nearly 21 GB of disk space. how do i truncate the same ?
Thanks in advance,
Abdul.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
query log
(or any of the other logfiles for that matter)?
I tried the following as user mysql:
rm /var/lib/mysql/myhost.log
mkfifo -m 0660 /var/lib/mysql/myhost.log
but the mysql server would not start.
Sure: Works as designed.
man 2 open will tell you that an open() call on a named pipe
:
Has anyone been able to use a named pipe for their general query log
(or any of the other logfiles for that matter)?
I tried the following as user mysql:
rm /var/lib/mysql/myhost.log
mkfifo -m 0660 /var/lib/mysql/myhost.log
but the mysql server would not start.
I think it would be very
Has anyone been able to use a named pipe for their general query log
(or any of the other logfiles for that matter)?
I tried the following as user mysql:
rm /var/lib/mysql/myhost.log
mkfifo -m 0660 /var/lib/mysql/myhost.log
but the mysql server would not start.
I think it would be very
Hello.
You have an application which executes prepared statements.
See:
http://dev.mysql.com/doc/mysql/en/c-api-prepared-statements.html
MySQL doesn't log to the slow log a prepared statement. You
can enable general query log which logs prepared statements.
Andrea Gangini [EMAIL
PROTECTED]: mmareuser[mmareuser] @ localhost.localdomain [127.0.0.1]
# Query_time: 28 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
# administrator command: Prepare Execute;
I thought that the slow query log would dump the SQL of the queries
causing slow-downs.
Did I made some mistake in configuring
log.
Does anyone know of a utility that will processes the general query log
(not the binary log or the binary log text file from mysqlbinlog) to
rerun the queries?
The program would need to...
...strip file header information
...strip the leading non query info from the line
...handle queries
does anyone know of a utility that will processes the query log to rerun
the queries?
The program would need to...
...strip the leading non query info from the line
...handle queries that span multiple lines
...change databases when appropriate before queries
...add the ; to the end
Daniel Gaddis wrote:
does anyone know of a utility that will processes the query log to rerun
the queries?
The program would need to...
...strip the leading non query info from the line
...handle queries that span multiple lines
...change databases when appropriate before queries
...add
PROTECTED]
Sent: Sunday, January 02, 2005 3:58 AM
To: mysql@lists.mysql.com mysql@lists.mysql.com
Subject: Re: is there a utility like mysqlbinlog but instead processes
the query log?
On 30 Dec 2004, at 13:26, Daniel Gaddis wrote:
is there a utility like mysqlbinlog but instead processes the query
On 30 Dec 2004, at 13:26, Daniel Gaddis wrote:
is there a utility like mysqlbinlog but instead processes the query
log?
I would like to reprocess the queries from the query log.
I don't see another reply to this on the list, so I hope it helps - the
query log is already in plain-text, so you
is there a utility like mysqlbinlog but instead processes the query log?
I would like to reprocess the queries from the query log.
Thanks,
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is there a utility like mysqlbinlog but instead processes the query log?
I would like to reprocess the queries from the query log.
additional features that would be nice would include:
listing unique queries
the number of times each unique query is executed
Thanks,
Daniel
--
MySQL
I noticed something interesting with our slow-query log and am looking for
an answer.
Our slow-query log is set for to record anything over 7 seconds.
In monitoring the server I ran the show full processlist I occasionally
see entries like
| ID | USER | HOST | DATABASE | Query
5:25 AM
Subject: Re: Query Log
Lou Olsten [EMAIL PROTECTED] wrote:
I'm pretty sure that the answer to this is No, you cannot but I
figured I'd check
anyway...
As I go back through my query log, I'd like to know the user that issued
the statement.
If the user is still connected, I can
Lou Olsten [EMAIL PROTECTED] wrote:
I'm pretty sure that the answer to this is No, you cannot but I figured I'd check
anyway...
As I go back through my query log, I'd like to know the user that issued the
statement.
If the user is still connected, I can cross reference it with the SHOW
Which query log are you referring to? The user and the host are both logged
in the slow query and general logs.
-Original Message-
From: Lou Olsten
To: [EMAIL PROTECTED]
Sent: 5/3/04 4:59 PM
Subject: Query Log
I'm pretty sure that the answer to this is No, you cannot but I
figured I'd
I'm pretty sure that the answer to this is No, you cannot but I figured I'd check
anyway...
As I go back through my query log, I'd like to know the user that issued the
statement. If the user is still connected, I can cross reference it with the SHOW
PROCESSLIST ID, but if they have signed
Hi,
I think log-slow-queries belongs in the [mysqld] section of my.cnf, not
[mysqld_safe].
Hope that helps.
Matt
- Original Message -
From: MaFai
To: [EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 9:00 PM
Subject: Slow query log setting
Hello, mysql,
I have set the slow
Hello, mysql,
I have set the slow query parameter in the my.cnf as the following.
[safe_mysqld]
err-log=/var/log/mysqld.log
log-slow-queries=/var/log/mysqlslow.log
pid-file=/var/run/mysqld/mysqld.pid
After I check the status of mysql today,we found 6 slow query occur.
Moritz Steiner [EMAIL PROTECTED] wrote:
I want to turn on and off the general query log from time to time. Is
there a possibility to do this without changing the my.cnf file and
restarting the server.
I thought for example set option log=ON
You can do
SET SQL_LOG_OFF=1;
to turn off
I want to turn on and off the general query log from time to time. Is
there a possibility to do this without changing the my.cnf file and
restarting the server.
I thought for example set option log=ON
Thanks,
Moritz
of transactions that have been committed!).
Thanks again,
Chris
Heikki Tuuri wrote:
Chris,
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, May 29, 2003 10:17 AM
Subject: Re: Query log/binlog inconsistency
On Wed, May 28, 2003 at 05:05
Hi,
I'm running into an issue on MySQL 4.0.12 (not tested on other releases) using
an InnoDB table type, where an update query is getting written to the query log
but never being propogated as far as the binlog. The query is also not updating
the DB, though according to the connection layer
On Wed, May 28, 2003 at 05:05:38PM -0700, Chris Tucker wrote:
Hi,
I'm running into an issue on MySQL 4.0.12 (not tested on other
releases) using an InnoDB table type, where an update query is
getting written to the query log but never being propogated as far
as the binlog. The query
Chris,
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, May 29, 2003 10:17 AM
Subject: Re: Query log/binlog inconsistency
On Wed, May 28, 2003 at 05:05:38PM -0700, Chris Tucker wrote:
Hi,
I'm running into an issue
I have a need to find out how long each of the queries executed
against a mysql server are taking.
I found this post, which indicates that this information can be found
in the general query log:
http://www.phpbuilder.com/mail/php-general/2002122/0876.php
The manual note about it says the binary
At 16:52 -0500 2/26/03, 1LT John W. Holmes wrote:
I have a need to find out how long each of the queries executed
against a mysql server are taking.
Why can't there just be a function that returns this? I mean, it's already
printed to the screen when you're running from the command line.
Hello,
Can anyone recommend a script to analyze a mysql server general query log.
My goal is to determine which users are putting the most load on the server.
Any other methods to achieve this same goal would be appreciated as well.
Thank you
MySQL gurus:
I'm a big fan of the general query log for taking the occasional audit
of activity against our database server, as well as a tool for checking
on the efficiency of new (mostly PHP) projects that interact with MySQL.
What I don't like is that I have to stop and restart the server
Hi, all!
I am compile mysql-4.0.9 for PPC64 with GLIBC64. It's nothing about
logging in mysql.server startup script and in my.cnf, but mysqld
create log file and write a lot of queries to it. How i can disable
this?
My configure options:
./configure --without-berkley-db
At 18:59 +0300 1/10/03, Andrey V. Ignatov wrote:
Hi, all!
I am compile mysql-4.0.9 for PPC64 with GLIBC64. It's nothing about
logging in mysql.server startup script and in my.cnf, but mysqld
create log file and write a lot of queries to it. How i can disable
this?
My configure options:
It's *nothing* about query logging in configuration files!
# mysqld --print-defaults
mysqld would have been started with the following arguments:
--port=3306
--socket=/var/run/mysqld/mysqld.sock
--skip-locking
--set-variable=max_connect_errors=1000
--set-variable=max_connections=600
At 23:45 +0300 1/10/03, Andrey V. Ignatov wrote:
It's *nothing* about query logging in configuration files!
# mysqld --print-defaults
mysqld would have been started with the following arguments:
--port=3306
--socket=/var/run/mysqld/mysqld.sock
--skip-locking
--set-variable=max_connect_errors=1000
1) logs file names: hostname.log , hostname-bin.001-4 and all of
them created in datadir. hostname = sql3
2) i am delete all log files from /var/lib/mysql and run
mysqld --user=mysql
And all files create again :(
-rw-rw1 mysqlmysql 14686 Jan 11 01:40 sql3-bin.001
-rw-rw1
hi all,
anyone knows if it is possible to create the query log
in a mysql table instead of in a text file?
Otherwise ... is there a way to import it into a
table?
Thanks to all.
Natale Babbo
sql, query
__
Yahoo
: question about query log
hi all,
anyone knows if it is possible to create the query log
in a mysql table instead of in a text file?
Otherwise ... is there a way to import it into a
table?
Thanks to all.
Natale Babbo
sql, query
1 - 100 of 116 matches
Mail list logo