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/[email protected]
