Hi all,
Recently I am redesigning our website architecture.
I have two servers located at Location_A and Location_B serving the same
http://www.ourexample.com and loadbalancing via DNS round-robin.Location_A
and Location_B are connected via Internet(NOT in A LAN).
The mysql database can be "synchro
How about this?
update t set onoffflag = if (name <> 'China', onoffflag, ( if (location =
'Table', 1, 0) ));
This leaves any onoffflag untouched if name is not China, which I assume you
wanted to do.
On Thu, Jan 8, 2009 at 2:18 PM, Christoph Boget
wrote:
> Consider the folowing dataset:
Consider the folowing dataset:
+++-+-+---+
| id| Name | Location| OnOffFlag | Description |
+++-+-+---+
| 1 | Paper| Cabinet | 0 | Blah|
| 2
Baron Schwartz wrote:
In contrast, InnoDB actually needs to "shut down" to cleanly close its table
structures before you can physically copy the filesystem.
Actually, not true -- an LVM snapshot (or other snapshot) is a great
way to take a backup of InnoDB. You just need a truly atomic
sn
Hi David,
I think try using show full processlist that shall tell the query that is
running. I think the problem is with your query only. we need to fine tune
the query. Please send the query and the explain plan for the same. share
more stats on things that you notice during that time.
Regards
