;
Cc: <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 2:43 AM
Subject: Re: innodb deadlock issue
> user_id is the primary key..
>
> relevant parts of show create table:
> | plx_user |CREATE TABLE `plx_user` (
> `user_id` int(11) NOT NULL auto_increment,
> `is_delete
user_id is the primary key..
relevant parts of show create table:
| plx_user |CREATE TABLE `plx_user` (
`user_id` int(11) NOT NULL auto_increment,
`is_deleted` int(11) NOT NULL default '0',
`edit_counter` int(11) NOT NULL default '0',
`sendlist_edit_counter` int(11) NOT NULL default '0',
Joe,
what does SHOW CREATE TABLE give as the table definition?
What do
EXPLAIN SELECT ... where user_id = 190864 and is_deleted = 0;
and
EXPLAIN SELECT ... where user_id = 190864;
say? If user_id is not the full primary key, then an index scan will happen
and deadlocks of the type below are p
