1) CREATE TABLE `summary_rts` ( `cid` int(11) NOT NULL default '0', `hits` int(10) unsigned default '0', `uniq` int(10) unsigned default '0', `reload` int(10) unsigned default '0', `hourly` int(10) unsigned default '0', `daily` int(10) unsigned default '0', `mtime` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`cid`,`mtime`), KEY `time` (`mtime`) ) TYPE=InnoDB
CREATE TABLE `summary_rts_old` ( `cid` int(11) NOT NULL default '0', `hits` int(10) unsigned default '0', `uniq` int(10) unsigned default '0', `reload` int(10) unsigned default '0', `hourly` int(10) unsigned default '0', `daily` int(10) unsigned default '0', `mtime` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`cid`,`mtime`), KEY `time` (`mtime`) ) TYPE=InnoDB > create table rank_union select * from summary_rts union select * from summary_rts_old; The error began to occur after the sum of rows was roughly 200,000. InnoDB free space was in the range of 4 gigs and disk space > 2gigs. 2) Can't really give tables and queries here since they form a large set of statistical analysis queries. Only information I can helpfully give is that the same set of roughly 30 queries is run every 5 seconds 24/7. After about 5-7 days the db server segv's on both our 4.4-release machines. Ric. ----- Original Message ----- From: "Carsten Gehling" <[EMAIL PROTECTED]> To: "Richard Clarke" <[EMAIL PROTECTED]>; "MYSQL" <[EMAIL PROTECTED]> Sent: Saturday, May 18, 2002 9:48 PM Subject: SV: 4.0.1 Bugs > > Fra: Richard Clarke [mailto:[EMAIL PROTECTED]] > > Sendt: 18. maj 2002 22:29 > > Emne: 4.0.1 Bugs > > > > > > List, > > I wondered if any movement has been made to determine the cause of the > > following "bugs" that I have come across using Mysql 4.0.1. > > > > 1) select....union causes a temporary table full type error when the > > datasets aren't even that large and when there is bags of disk space. > > > > 2) Under FreeBSD 4.4-RELEASE I can guarantee my database will crash after > > roughly 5-7 days of running the same set of queries a squillion > > times (with > > no changes made to the queries). Memory usage is fine and swap space is > > ample. > > May we see a) your queries and b) the tables involved? Without such > information it would just be a guessing game... > > - Carsten > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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