y Wallace [mailto:awall...@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 &
re than 10,000 pages.
10,000 * 10,000 = 100 million !
> -Original Message-
> From: Andy Wallace [mailto:awall...@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 q
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
---Original Message-
> From: Adarsh Sharma [mailto:eddy.ada...@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` (
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,
`
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 wrote:
>
>
> 2012/9/5 Adarsh Sharma
>
>> Actually that query is not my concern :
>>
>> i have a query that is taking so much time :
>> Slow Log Output :
>>
2012/9/5 Adarsh Sharma
> 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
> # Attribute tota
f so, the query
> will get slower. Meanwhile, the index 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:
ll
get slower. Meanwhile, the index 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: Understa
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 wrote:
> Hi all,
>
> I am using Mysql Ver 14.14 Distrib 5.1.58 in which i enabled sl
>
> 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
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 is in
to setup the machine 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 tha
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 wrote:
> Hi All
>
>
>
>I hope that someone can assist me with this.
>
>
>
>We have a client
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
Jaime 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 :
> Hello All. I would like to implement MYSQL slow query log in table. Can
&
2009/10/7 Brown, Charles :
> 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
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
And an answer to 2): http://www.maatkit.org/doc/mk-query-digest.html
On Tue, Oct 6, 2009 at 02:59, Brown, Charles 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 uti
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
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 is
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?
# 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 wrote:
>
> It executes in 0 sec
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 quer
--+
| NULL |
++
1 row in set (0.00 sec)
On 12/31/08, Baron Schwartz wrote:
>
> Hi,
>
> On Wed, Dec 31, 2008 at 8:44 AM, Ananda Kumar wrote:
> > Hi All,
> > I have enabled slow query log.
> > Generally this file will have s
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 arch
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 les
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 tho
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 serv
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
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 s
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] @ loca
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]
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 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 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
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 a
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 it
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
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;
# [
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 PROTEC
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 sec
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
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 p
t;[EMAIL 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 t
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
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: http://lists.mysql.c
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 General
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 lo
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]
Hello,
Is there a way to enable the Slow Query Log on the fly without having to
restart mysqld
Regards,
Marc.
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 s
> 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
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 the
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 |
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:http://lis
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
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.
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 ?
>
>
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
eneral 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 &qu
wrote:
>
> 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 se
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 Ga
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 config
query 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 qu
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 the ; to
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 of the
PROTECTED]
Sent: Sunday, January 02, 2005 3:58 AM
To:
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
> log?
> I would like to repr
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, s
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 | HOS
ECTED]>
Sent: Tuesday, May 04, 2004 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 t
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" bu
"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 th
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
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,
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.
Bu
"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"
Yo
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
ds 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 We
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,
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
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
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. Hopefu
> 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. Hopefully
I've missed something and it's already there,
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
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
1) logs file names: .log , -bin.00<1-4> and all of
them created in datadir. = 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 mysqlmysql
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
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
--default-c
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:
./configu
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
--with-named-curses-libs=
uary 08, 2003 12:25 PM
Subject: 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 al
1 - 100 of 117 matches
Mail list logo
