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
ptimizer's choice.
>
> ** **
>
> *From:* spameden [mailto:spame...@gmail.com]
> *Sent:* Monday, October 15, 2012 3:29 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
From: spameden [mailto:spame...@gmail.com]
Sent: Monday, October 15, 2012 3:29 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, forgot to say:
mysql> show variables lik
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
Sorry, forgot to say:
mysql> show variables like 'long_query_time%';
+-+---+
| Variable_name | Value |
+-+---+
| long_query_time | 10.00 |
+-+---+
1 row in set (0.00 sec)
It's getting in the log only due:
mysql> sh
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:
mysql> select count(*) from send_sms_test;
+--+
| count(*) |
+--+
| 143879 |
+--+
1 row in set (0.03 sec)
Without LIMIT:
mysql> desc select * from send_s
* Rows = 11 / 22 -- don't take the numbers too seriously; they are crude
approximations based on estimated cardinality.
* The 11 comes from the LIMIT -- therefore useless in judging the efficiency.
(The 22 may be 2*11; I don't know.)
* Run the EXPLAINs without LIMIT -- that will avoid the bogu
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
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
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
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
18 matches
Mail list logo
