--- Sasha Pachev <[EMAIL PROTECTED]> wrote:
> Very possibly a bug. INNODB deadlocks itself during
> the operation, then detects
> the deadlock and aborts the transaction. If this is
> indeed a bug, I am sure
> Heikki would like to fix it ASAP.
There actually was a "create index" that was being
--- "PARTHA DUTTA, BLOOMBERG/ 499 PARK"
<[EMAIL PROTECTED]> wrote:
> Hello all, I would like to find out if anyone has
> implemented an architecture
> where a hardware load balancer is placed in front of
> some MySQL servers in a
> Multi-master replication scheme. I want to use the
> load balanc
I have a table called web_master which has as a
primary key column called web_id.
When I try to create another table as a select, I get
the following error message [note, that group_id is
indexed]:
mysql> create table sort_test as select * from
web_master where group_id = 69;
ERROR 1205: Lock w
