Richard, can you upload via ftp gzipped dumps of the two tables in the UNION to /pub/mysql/secret at support.mysql.com?
About the crashes which occur in 5 - 7 days: please send me the error log of MySQL 'hostname'.err so that I can resolve the stack dumps, if they exist. 4.0.1 is already a rather old release and several bugs have been fixed since then. Unfortunately, 3.23 does not support unions. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB ----- Original Message ----- From: ""Richard Clarke"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Sunday, May 19, 2002 12:27 AM Subject: Re: 4.0.1 Bugs > 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 > --------------------------------------------------------------------- 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
