Hi all!
I have built MySQL-4.0.3 with -march=k6 (gcc-2.95.3) in my CFLAGS
(everything else was as recommended in the INSTALL instructions). I did
a little testing before dumping our data into it, and it seemed OK :)
However now MySQL is crashing on one particular query only (it has been
fine for a couple of weeks, until today). I have tried running a check
tables on it (MyISAM) and it's not damaged.
Should I start to suspect that I'm not allowed to compile with
-march=k6? Has anyone else had experience (good or bad) with K6
optimisations?
The query which is crashing it is a very simple select statement from
the PHP-based asset / issue tracking software 'IRM':
SELECT DISTINCT(ID) FROM tracking WHERE (tracking.computer = 45 and
tracking.is_group = "no") ORDER BY date DESC
Tracking definition:
CREATE TABLE tracking (
ID int(11) NOT NULL auto_increment,
date datetime default NULL,
closedate datetime default NULL,
status enum('new','old','wait','assigned','active','complete') default
NULL,
author varchar(200) default NULL,
assign varchar(200) default NULL,
computer int(11) default NULL,
contents text,
priority tinyint(4) NOT NULL default '1',
is_group enum('no','yes') NOT NULL default 'no',
uemail varchar(100) default NULL,
emailupdates varchar(4) default NULL,
PRIMARY KEY (ID)
) TYPE=MyISAM;
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
---------------------------------------------------------------------
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
