That's exactly what I thought when reading Michael's email, but tried
anyways, thanks for clarification :)
2012/10/16
> 2012/10/16 12:57 -0400, Michael Dykman
> your now() statement is getting executed for every row on the select. try
> ptting the phrase up front
> as in:
> set @ut= u
2012/10/16 12:57 -0400, Michael Dykman
your now() statement is getting executed for every row on the select. try
ptting the phrase up front
as in:
set @ut= unix_timestamp(now())
and then use that in your statement.
Quote:
Functions that return the current date or time each are
Interesting thought, but I get the same result.
# Query_time: 0.001769 Lock_time: 0.001236 Rows_sent: 0 Rows_examined: 0
use kannel;
SET timestamp=1350413592;
select * from send_sms FORCE INDEX (priority_time) where time<=@ut order by
priority limit 0,11;
the MySQL i'm using is 5.5.28 from dotd
your now() statement is getting executed for every row on the select. try
ptting the phrase up front
as in:
set @ut= unix_timestamp(now())
and then use that in your statement.
On 2012-10-16 8:42 AM, "spameden" wrote:
Will do.
mysql> SHOW GLOBAL VARIABLES LIKE '%log%';
+---
Will do.
mysql> SHOW GLOBAL VARIABLES LIKE '%log%';
+-+-+
| Variable_name | Value
|
+-+-+
| back_log
On 10/15/2012 7:15 PM, spameden wrote:
Thanks a lot for all your comments!
I did disable Query cache before testing with
set query_cache_type=OFF
for the current session.
I will report this to the MySQL bugs site later.
First. What are all of your logging settings?
SHOW GLOBAL VARIAB
Thanks a lot for all your comments!
I did disable Query cache before testing with
set query_cache_type=OFF
for the current session.
I will report this to the MySQL bugs site later.
2012/10/16 Rick James
> **Ø **My initial question was why MySQL logs it in the slow log if the
> quer
Ø My initial question was why MySQL logs it in the slow log if the query uses
an INDEX?
That _may_ be worth a bug report.
A _possible_ answer... EXPLAIN presents what the optimizer is in the mood for
at that moment. It does not necessarily reflect what it was in the mood for
when it ran
ber 15, 2012 3:23 PM
To: Rick James
Cc: mysql@lists.mysql.com
Subject: Re: mysql logs query with indexes used to the slow-log and not logging
if there is index in reverse order
Sorry, my previous e-mail was a test on MySQL-5.5.28 on an empty table.
Here is the MySQL-5.1 Percona testing table:
mys
f I turn it off - it's all fine
My initial question was why MySQL logs it in the slow log if the query uses
an INDEX?
And why it's not logging if I create an INDEX (time, priority) (but in the
query there is FORCE INDEX (priority,time) specified, so MySQL shouldn't
use newly creat
not a 3-digit integer, it is a full 32-bit integer (4 bytes).
> Perhaps you should have SMALLINT UNSIGNED (2 bytes).
>
> * BIGINT takes 8 bytes -- usually over-sized.
>
>
> > -Original Message-
> > From: spameden [mailto:spame...@gmail.com]
> > Sent: Monday, O
IGINT takes 8 bytes -- usually over-sized.
> -Original Message-
> From: spameden [mailto:spame...@gmail.com]
> Sent: Monday, October 15, 2012 1:42 PM
> To: mysql@lists.mysql.com
> Subject: mysql logs query with indexes used to the slow-log and not
> logging if there is
Hi, I've just checked on MySQL-5.5.28
it acts absolutely same.
I need to use (priority,time) KEY instead of (time, priority) because query
results in better performance.
With first key used there is no need to sort at all, whilst if using latter:
mysql> *desc select * from send_sms_test FORCE IN
Hi, list.
Sorry for the long subject, but I'm really interested in solving this and
need a help:
I've got a table:
mysql> show create table send_sms_test;
+---+
We are running MySQL 5.0.45 on a Linux machine. I have enabled the general
query log and I notice that for some of the connections, the last command is
Quit but for some of the connections, the Quit command does not appear. What
do I have to do to ensure that the Quit command gets printed in t
You should keep it on in my opinion.
On Tue, May 13, 2008 at 6:04 PM, Nico Sabbi <[EMAIL PROTECTED]> wrote:
> Hi,
> I guess that when I'm using only Innodb and no replication I can
> safely disable mysql's (bin-) log files (that grow to no end) because
> Innodb has its own log files. Is it correc
Hi,
I guess that when I'm using only Innodb and no replication I can
safely disable mysql's (bin-) log files (that grow to no end) because
Innodb has its own log files. Is it correct?
Thanks,
Nico
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
I deleted some data in mysql. Is it possible to restore the data.
Maybe using MYSQL logs?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I deleted some data in mysql. Is it possible to restore the data.
Maybe using MYSQL logs?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 12:52 +0530 9/29/04, Kausalya Ramaswamy wrote:
Does mysql 4.0 onwards log cached querries also or only direct non cached
database access queries? i am getting enormous amount of log in the form of
querries. ours is a databse driven website using mysql and php.thanks for
the reply in advance
If y
Does mysql 4.0 onwards log cached querries also or only direct non cached
database access queries? i am getting enormous amount of log in the form of
querries. ours is a databse driven website using mysql and php.thanks for
the reply in advance
Thanks & Regards
Kausalya Ramaswamy
Scientific Of
At 3:02 -0800 10/25/02, neal wrote:
Could someone tell me where the logs are written to by default, for a 3.23
install of MySQL on Linux?
To the data directory. The location of this may vary per installation,
but you can discover it with this query:
SHOW VARIABLES LIKE 'datadir';
I looked i
neal,
Friday, October 25, 2002, 2:02:18 PM, you wrote:
n> Could someone tell me where the logs are written to by default, for a 3.23
n> install of MySQL on Linux?
n> I looked in /usr/share/mysql/english and each directory leading up to it,
n> but I didn't see anything resembling a log file.
By d
> Could someone tell me where the logs are written to by default, for a 3.23
> install of MySQL on Linux?
>
> I looked in /usr/share/mysql/english and each directory leading up to it,
> but I didn't see anything resembling a log file.
>
> Thanks.
> Neal
Logs are in your data directory with the T
Could someone tell me where the logs are written to by default, for a 3.23
install of MySQL on Linux?
I looked in /usr/share/mysql/english and each directory leading up to it,
but I didn't see anything resembling a log file.
Thanks.
Neal
-
HI
Probably a silly question, but how can I roll the logs for mysql?
I started it with
safe_mysqld --log-slow-queries --log &
So it created two logs in my /var/lib/mysql folder, one holding ALL
queries, and one for only the slow queries.
The "general" log is growing quite rapidly, and I would lik
At 7:32 +0100 9/10/02, nick gatsis wrote:
>Does anybody know how to make log files for each of my
>databases?
Log files are not written on a per-database basis.
>Thanx
>
>sql, query
-
Before posting, please check:
http://ww
Does anybody know how to make log files for each of my
databases?
Thanx
sql, query
Do You Yahoo!?
&Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&eegr; &dgr;&ohgr;&rgr;&egr;&aacgr;&ngr; @yahoo.gr &dgr;&igr;&egr;&uacgr;&thgr;&ugr
Hello All,
I need help with MySQL Log, can I know where does MySQL saves the log
files.
I need a log for ODBC; I have some problem with ODBC connection from
outside. I need to know what the Error is.
Please advice, Thanking in Advance.
Regards
Nitesh
I need help with the mysql logs.
I want the mysql to enter the time it takes each query to run as well in the log.
also i want to know from which file / program each query was run.
Is that possible ? if so how can i do it or where can i find more information.
thanks
eran
30 matches
Mail list logo