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 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
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
.
This still seems to exist under 5.0.15-standard (at least under
mysql-standard-5.0.15-linux-i686-glibc23)
Can anyone from MySQL comment on this or should I open it as a bug?
Thanks,
JP
On 6/11/05, Jake Peavy <[EMAIL PROTECTED]> wrote:
Has anyone been able to use a named pipe for their g
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
Hi,
Mysql 4.0.14
In a seconrio, some reocrds are missing from a child
table. If we run this query it returns the missing
records:
select a.field1, b.field2 from table1 a left join
table2 b on (a.field1 = b.field1) where b.field1 is
null
I want to create entries in the child table (table2)
fo
Thanks,
I did think of it but not having the option as this is
linked to executables, which I'm sure have some sorts
of calculation for this field to calculate the next
value.
regards
--- Jigal van Hemert <[EMAIL PROTECTED]> wrote:
> > I want to create entries in the child table
> (table2)
>
> I want to create entries in the child table (table2)
> for the missing records. In table2 the primary key is
> of type Integer,
> for each new entry it should be
> Max(table2.PrimaryKeyfield) + 1.
Why not make the primary key in table2 autoincrement? If you have an
autoincrement field as primar
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
Håkon Eriksen wrote:
>Is there a way of turning on the general query log in the my.cnf file
>or do I have to edit the init-script?
>
>
Yes, all command-line options can be specified in my.cnf. Read the
following page for more info:
http://www.mysql.com/doc/O/p/Option_file
Is there a way of turning on the general query log in the my.cnf file
or do I have to edit the init-script?
Personally, I would very much like to have only one place to set all
the configuration options (preferrably my.cnf). Setting datadir and
other options both in the my.cnf file and the init
ity sprit and not just about dollars in pockets.
Peter Kelly - A Happy MySql User.
http://www.TrafficG.com
- Original Message -
From: "Paras Mukadam" <[EMAIL PROTECTED]>
To: "MySQL" <>
Sent: Monday, April 29, 2002 1:58 PM
Subject: general query
>
Hi.
On Mon, Apr 29, 2002 at 07:58:57AM -0500, [EMAIL PROTECTED] wrote:
> Hi Guru's,
>
> We say MySQL is open source database, so it can easily be adjusted to your
> requirements. But I wonder how many administrators have actually gone into
> the source code and made any modifications to match th
Hi Guru's,
We say MySQL is open source database, so it can easily be adjusted to your
requirements. But I wonder how many administrators have actually gone into
the source code and made any modifications to match their specific needs, if
any. If no, then why is MySQL better than other databases a
I'm just guessing here, but I suppose most of the char(1) fields are y/n
fields. If that's the case you should consider using a single BIGINT and
flag those bits instead. That would considerably reduce the size of the
table on one hand and I guess it should improve things speed-wise as well.
Obvi
Greer, Darren (MED) writes:
> If I move the status to another table, and then wanted to get a count of
> everyone who is of status 'A', how would that be any quicker? Would I
> join the tables?
Communication error - reattempting.
I meant that if you want to get the count of the number of 'A's
My suggestion (using a bigint and flagging the bits instead of using 40
char(1) fields) is only valid if you don't use any of those fields in WHERE
clauses in SELECT's. Not that you wouldn't be able to retrieve the entries
based on the respective field, but I don't think it would be indeed faster
PROTECTED]
Subject: Re: General Query time question
I didn't think/read far enough. One more attempt is due.
> > Correction on the query: SELECT count(*) as count FR
> OM userdata WHERE
> > status = 'A';
I didn't see that it was on that column you had an index
I didn't think/read far enough. One more attempt is due.
> > Correction on the query: SELECT count(*) as count FR
> OM userdata WHERE
> > status = 'A';
I didn't see that it was on that column you had an index,
so forget I said 'of course'. Have you used EXPLAIN to
figure out if the index is act
ogdan Stancescu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 10:37 AM
To: Greer, Darren (MED)
Cc: '[EMAIL PROTECTED]'
Subject: Re: General Query time question
I'm just guessing here, but I suppose most of the char(1) fields are y/n
fields. If that's the case yo
Greer, Darren (MED) writes:
> Correction on the query: SELECT count(*) as count FR
OM userdata WHERE
> status = 'A';
Ah. That does make a difference. MySQL is of course
forced to go through all of your data, counting the
number of rows with status 'A'. I don't believe an
index would do you much
Correction on the query: SELECT count(*) as count FROM userdata WHERE
status = 'A';
Sorry.
-Original Message-
From: Greer, Darren (MED)
Sent: Tuesday, January 08, 2002 10:20 AM
To: '[EMAIL PROTECTED]'
Subject: General Query time question
Hello all. I have a data
Hello all. I have a database which is around 10million rows. The
structure is as follows:
id int(11) NOT NULL- Auto Increment
address char(90) NOT NULL
status char(2) NOT NULL
country char(2)
state char(2)
areacode char(3)
...about 40 char(1) fields.
I have an unique index on address,
33 matches
Mail list logo
