Hi Tim,
On Mon, Jun 22, 2009 at 4:41 PM, Little,
Timothy wrote:
> We have a 20 gig db (that includes the MYIs and MYDs and FRMs).
>
> We are wondering how long LVM snapshots take.. in that how long might
> the DB be read-locked? Do we have to read-lock it and flush tables?
>
> Are we talking half
Assuming that synchornizing the clocks between the systems is beyond
your control you could try getting the UTC timestamp from both
systems, then adjust your date/time math according to the difference
between them.
> select unix_timestamp(utc_timestamp());
It is more than a little hacky, but it
On 4 Jul 2009, at 07:48, Nathan Huang wrote:
I am going to fetch out the data from remote mysql database
according to timestamps colmmen, however my local date is different
from the one on remote mysql database,
how can I get right timestamp using the date of remote time zone?
that is to sa
When you are using SQL connected to the server (mysql -ublah) the timestamp
is the server one. If you use app time functions it will be client time.
Bottom line: use server sql functions.
Ciao
Claudio
Il giorno 4 lug, 2009 8:50 m., "Nathan Huang"
ha scritto:
Hi guys
I am going to fetch out the
