Okay, as I've noted in other questions, I'm not a sophisticated database user even though I took my first course in relational algebra from ted Codd. I've now inherited an application that occasionally gets into what, to my naive mind, strikes me as a bad place.
SHOW PROCESSLIST; shows multiple locked thrads, each of them with exactly identical
INSERT statements, viz:
INSERT LOW_PRIORITY IGNORE INTO node (f0, f1, f2, f3) VALUES ('group', 'larry', 'moe', 'curly')
Am I right that this is a Bad Thing? What would the expected consequences be?
As requested, here's the table:
CREATE TABLE `node` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `graph` varchar(100) CHARACTER SET latin1 DEFAULT NULL, `f1` varchar(200) NOT NULL, `f2` varchar(200) NOT NULL, `f3` mediumtext NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `nodeindex` (`graph`(20),`f1`(100),`f2`(100),`f3`(100)), KEY `ix_node_f1` (`f1`), KEY `ix_node_graph` (`graph`), KEY `ix_node_f3` (`f3`(255)), KEY `ix_node_f2` (`f2`), KEY `node_po` (`f2`,`f3`(130)), KEY `node_so` (`f1`,`f3`(130)), KEY `node_sp` (`f1`,`f2`(130)), FULLTEXT KEY `node_search` (`f3`) ) ENGINE=MyISAM AUTO_INCREMENT=455854703 DEFAULT CHARSET=utf8