Hi,
I have a query that keeps coming up in my slow queries log. The whole
database is innodb and i'm using mysql 4.1.11 on 64bit intel running red
hat linux. There are less than 100 rows in the offending table at anyone
time, and the server load rarely creeps up above 0.5
If i try to manually insert this row, i cant make it take longer than a
fraction of a second. I do get a few other random queries in the log
that take an age but this one comes up a lot.
Does anyone know if there are any issues with ON DUPLICATE KEY UPDATE,
or using varchar fields as a primary key?
if not how can i investigate this further? Table and query below
Thanks in advance
Tony
CREATE TABLE `tblSessionData` (
`sessionKey` varchar(32) NOT NULL default '',
`data` text NOT NULL,
`expiry` int(11) NOT NULL default '0',
PRIMARY KEY (`sessionKey`),
KEY `expiry` (`expiry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Query_time: 26 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
INSERT INTO dbseInfrastructure.tblSessionData
(sessionKey,expiry,data)
VALUES
('1dbeb00777bf1cd20f8e12d044f4fa4c',
1121252767, 'intRightBanner|i:6;formRequiredFields|a:2:{s:8:\"username
\";i:0;s:8:\"password\";i:0;}formValidation|a:2:{s:8:\"username
\";i:0;s:8:\"password\";i:0;}')
ON DUPLICATE KEY UPDATE
expiry=1121252767
,data='intRightBanner|
i:6;formRequiredFields|a:2:{s:8:\"username\";i:0;s:8:\"password
\";i:0;}formValidation|a:2:{s:8:\"username\";i:0;s:8:\"password\";
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
