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 s
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
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
>>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. <<
The point is you "can" make modifications if you want to
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
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 database which is around 1
14 matches
Mail list logo
