Trust me, I read it.
We had an I18N product at my last company and all our time was stored in
UTC in mySQL and we'd alter it on the fly for each user. This isn't rocket
science. It's done every day in probably many of the sites you visit and
don't even know it.
To clarify for you (again):
*
right the unix times in the example table were just that - examples
from a few days ago...
the example with the query was a 'real one' something that happened today...
it's a 64 bit machine. the unix times are stored in a bigint column.
the times in the column and the update statement
I've got a fair few number of queries to be checked over. Will send
them tommorrow
On 4 Oct 2010, at 18:27, Gavin Towey wrote:
Include the query, EXPLAIN output, and the relavant SHOW CREATE
TABLE table \G output. Someone should be able to offer suggestions.
-Original Message-
Fr
Those unix_time values don't seem to correspond to the dates you have.
select NOW(), UNIX_TIMESTAMP(NOW());
+-+---+
| NOW() | UNIX_TIMESTAMP(NOW()) |
+-+---+
| 2010-10-04 13:18:08 |1286223488
hi all...
i'm doing tests with a table that gets updated based on random unix
times it contains. there is a column that has a bunch or random times
that look like:
+-+---+
| date_time | unix_time|
+-+--
Include the query, EXPLAIN output, and the relavant SHOW CREATE TABLE table \G
output. Someone should be able to offer suggestions.
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Monday, October 04, 2010 8:54 AM
To: Joerg Bruehe
Cc: [MySQL]
Subject: Re
On 10/4/2010 12:32 PM, Tompkins Neil wrote:
Account Number : uk600724
Dear Sir/Madam,
The MySQL database version which you have supplied to us is version 5.0.77.
However, it would appear that we require version to be at least 5.1.43.
How can we get our MySQL db upgraded to this version or g
Account Number : uk600724
Dear Sir/Madam,
The MySQL database version which you have supplied to us is version 5.0.77.
However, it would appear that we require version to be at least 5.1.43.
How can we get our MySQL db upgraded to this version or greater ?
Regards
Neil Tompkins
Jörg
Thanks for the useful reply. Maybe I can EXPLAIN my select queries for you
to advise if any changes need to be made ?
Regards
Neil
On Mon, Oct 4, 2010 at 3:38 PM, Joerg Bruehe wrote:
> Hi!
>
>
> Neil Tompkins wrote:
> > Thanks for your reply. So should we create individual indexes on each
Hi!
Neil Tompkins wrote:
> Thanks for your reply. So should we create individual indexes on each
> field or a multiple column index ??
This question cannot be answered without checking and measuring your
installation. The decision whether to create an index is always an act
of balancing:
- If t
On Mon, Oct 4, 2010 at 3:03 AM, monloi perez wrote:
> 1) While inserting and connection lost, what will happen? Is the query
> going to be there forever?
>
No. Depending on the timing of the connection loss, the statement may
complete or be rolled back. it will not just hang there. Transact
Aha! You are precisely correct. Thank you!
On 3 October 2010 21:16, Dan Nelson wrote:
> In the last episode (Oct 03), George Larson said:
>> I have an InnoDB table with a 'Data_length' of 114688 and 'Data_free'
>> of '3896508416'. If I'm correctly understanding what I've been
>> reading, those
12 matches
Mail list logo
