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 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
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
.
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 general
:
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
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)
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 primary
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)
for
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
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
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_files.html
-myk
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
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 their
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 Guru's,
We say MySQL is open source database, so it can easily be adjusted to your
requirements. But I wonder how
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,
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 database which is around
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
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 you should consider using
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
]
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,
so forget I said 'of course'. Have you used
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
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.
31 matches
Mail list logo