N??j??j{zw???oz??
?i, all
I have a mysql server (dual P4 2.0G, 1G MEM, RH8.0, Mysql 4.0.12),
There are 2 tables defined as follow:
create table a (
imgid int not null,
parent int,
imgtype char(3),
img longtext,
primary key (imgid),
key (parent, imgid)
) type = innodb;
I run a site with a few million MySQL requests a day, but I've run
into a strange problem which I'm trying to slove.
The server is running mysql 4.0.14, Apache 2.0.47, mod_perl2-1.99r09,
DBI 1.38 and DBD-mysql 2.1026 on a FreeBSD 4.8 machine.
About once or twice a day, I get a bunch of slow