from:http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html
SET GLOBAL time_zone = timezone;
from:http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_utc-timestamp
* UTC_TIMESTAMP, UTC_TIMESTAMP()
I have the same results, according to the docs timezone is the
Hi,
I'm busy creating an index on a 518505 record table on a single column
which is now taking about 2 hours on the copy to tmp table process
The server is a 2gig ram Intel(R) Xeon(TM) CPU 3.00GHz running on a
hardware raid 5. The inno config was left as a standard install from
my-medium
Hi Alex,
with MySQL 4.1.22 there is not much you can do.
MySQL alter tables recreating a new temporary one and swapping then
afterwards.
In my opinion the effort to speed up the process is not worth for just this
alter table.
Cheers
Claudio
2011/6/21 Alex Schaft al...@quicksoftware.co.za
Hi!
SQL Maestro Group announces the release of SQL Maestro for MySQL 11.6,
a powerful Windows GUI solution for MySQL administration and database
development.
The new version is immediately available for download at
http://www.sqlmaestro.com/products/mysql/maestro/
Please note that before June
snip
-Original Message-
From: sono...@fannullone.us [mailto:sono...@fannullone.us]
Sent: Monday, June 20, 2011 6:01 PM
To: mysql@lists.mysql.com
Cc: wha...@bfs.de; Jerry Schwartz
Subject: Re: SELECT records less than 15 minutes old
On Jun 20, 2011, at 10:11 AM, Jerry Schwartz wrote:
Hi all,
I need to document the switch between master and slave
and I want to double check if the outlined procedure is correct.
We have a simple master slave replication setup on OEL 5.5 and MySQL
5.5.13.
Original config: machineA master, machineB slave.
Target: machineB master, machineA not