Can someone tell me if what I'm trying to do can be done more efficiently? I just got off the phone with Rackspace when my server was hung up, and they found a whole bunch of this one same query was all stacked up with waiting queries and locked.
Here's the query: $query = "insert ignore into stats (ip,id,type,date,time) values ('".$_SERVER['REMOTE_ADDR']."','$id','listen',NOW(),NOW())"; Here's the table: CREATE TABLE IF NOT EXISTS `stats` ( `ip` varchar(20) NOT NULL default '', `id` mediumint(9) NOT NULL default '0', `type` varchar(20) NOT NULL default '', `date` date NOT NULL default '0000-00-00', `time` time NOT NULL default '00:00:00', PRIMARY KEY (`ip`,`id`,`type`), KEY `report` (`id`,`date`), KEY `type_date` (`type`,`date`), KEY `id_type` (`id`,`type`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; There are about 16.5 million records in the table. Thanks! - Brian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org