"select max(field) from table" returns the greatest field's value in the first
file of the RAID table (successive files are not considered), adding a where
clause (for ex. "select max(field) from table where field2 >= 2000000") the
problem seems not to exist. I don't know if the bug is limited to the
'max()' function, but, for the use I make of mysql, this is a big problem.
Environment:
Linux 2.2.19
MySQL 3.23.38
mysql's data directory is on a NFS partition
below the create statement I used to create my table:
create table urlword(url_id integer auto_increment primary key,
site_id integer not null,
deleted tinyint DEFAULT 0 NOT NULL,
url varchar(128) not null,
next_index_time INT NOT NULL,
status int(11) DEFAULT '0' NOT NULL,
crc char(32) DEFAULT '' NOT NULL,
last_modified varchar(32) DEFAULT '' NOT NULL,
etag varchar(48) DEFAULT '' NOT NULL,
last_index_time INT NOT NULL,
referrer int(11) DEFAULT '0' NOT NULL,
tag int(11) DEFAULT '0' NOT NULL,
hops int(11) DEFAULT '0' NOT NULL,
redir integer,
origin integer,
unique index(url),
index(next_index_time),
index(hops,next_index_time),
index crc (site_id,crc(8))) DELAY_KEY_WRITE=1 RAID_TYPE=STRIPED RAID_CHU
NKS=8 RAID_CHUNKSIZE=153600 PACK_KEYS=1 TYPE=MyISAM;
the mysql configuration file is my-huge.cnf taken from the mysql's
source-distribution.
P.
PS
I didn't subscribe the mailing list, can you reply to [EMAIL PROTECTED] please?
Thanks
---------------------------------------------------------
Patrizio Bruno
DADA spa / Special Projects
Viale Giovine Italia
50122 Firenze
Italy
tel +39 055200211
fax +39 0552478143
PGP PublicKey available at: http://www.keyserver.net/en/
---------------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
