Micah Stevens wrote:
If you want to control the server process, you'll need to start the
server process with those options, this mysqld, and the command line
options are here:
http://dev.mysql.com/doc/refman/5.1/en/server-options.html
Thanks for the link, I am going through it.
For your
Hi All,
I have enabled slow query log.
Generally this file will have sql's which take more than long-query time to
execute and also sql's not using indexes.
But i see sql's which does not come under the above condition.
I have set the long-query time to 1 Sec .
The query takes less than 1 sec to
Hi all,
As my query yesterday did not generate any responses (possibly it was too
long and maybe not well written) I am trying to simplify the query:
What does the following error mean:
ERROR: Error in Log_event::read_log_event(): 'read error', data_len: 173056,
event_type: 73
And what is the
I'm just guessing, but if the slow query log time resolution is seconds,
perhaps 0.5 and higher rounds up?
Or, perhaps it has an index, but it can't be used in that query.
What does EXPLAIN [paste query here] tell you?
--
MySQL General Mailing List
For list archives:
Hi,
I don't quite understand (or even know) what the proper way to compare a
DATETIME column to a given DATE value is. I've used various methods but I'd
like to know if there's a better way to compare these values.
Right now I have a query with this in the WHERE clause (customer.created_dt
is a
-Original Message-
From: Johnny Withers [mailto:joh...@pixelated.net]
Sent: Wednesday, December 31, 2008 1:13 PM
To: MySQL General List
Subject: Compare DATETIME to DATE
Hi,
I don't quite understand (or even know) what the proper way to compare
a
DATETIME column to a given DATE value
Truncate the time part of the datetime field when doing the compare
AND DATE_FORMAT(customer.created_dt, '%Y-%m-%d 00:00:00') BETWEEN '2008-12-30'
AND '2008-12-30'
Should work. Probably not the most efficient. The other options would be to
use take end date + 1 day, minue 1 second. That's
Just thought I would take this opportunity to wish everyone on the list
a happy, prosperous and peaceful 2009.
John Daisley
Email: john.dais...@butterflysystems.co.uk
Mobile: 07812 451238
MySQL Certified Database Administrator (CMDBA)
MySQL Certified Developer (CMDEV)
MySQL Certified Associate
Hello mysql and Happy New Year,
I am working with a Forum database. It contains a forums table, a
posts table and a threads table. Some of the posts contain flash
objects that I can find using a query like this one:
SELECT `pagetext`, `postid` FROM `post` WHERE `pagetext` LIKE
HAPPY NEW YEAR
- Original Message -
From: John Daisley john.dais...@mypostoffice.co.uk
To: MySQL General List mysql@lists.mysql.com
Sent: Thursday, January 01, 2009 7:25 AM
Subject: Happy New Year
Just thought I would take this opportunity to wish everyone on the list
a happy,
Happy Gnu Year to everyone!!
On Wed, Dec 31, 2008 at 11:30 PM, Prathima Rao prathiman...@vsnl.netwrote:
HAPPY NEW YEAR
- Original Message - From: John Daisley
john.dais...@mypostoffice.co.uk
To: MySQL General List mysql@lists.mysql.com
Sent: Thursday, January 01, 2009 7:25 AM
11 matches
Mail list logo