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.
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
Consider the folowing dataset:
+++-+-+---+
| id| Name | Location| OnOffFlag | Description |
+++-+-+---+
| 1 | Paper| Cabinet | 0 | Blah|
| 2
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
christoph.bo...@gmail.comwrote:
Consider
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