Re: 4.0.1 Bugs

2002-05-23 Thread Richard Clarke
: [EMAIL PROTECTED] Sent: Thursday, May 23, 2002 5:15 AM Subject: Re: 4.0.1 Bugs I had problems with unions that result in large queries too. I found that MySQL 4 was using Heap tables for Unions. One can Increase the Heap Table size to help, but What about alot of conncurrent users running unions

Re: 4.0.1 Bugs

2002-05-22 Thread Heikki Tuuri
, 2002 12:02 PM Subject: Re: 4.0.1 Bugs Heikki, As for my crashes. This one is a little hard, see, we have two machines that do this. Both however, display little to no information in the log. One server just says mysql restarted followed by mysql was shut down incorrectly

Re: 4.0.1 Bugs

2002-05-22 Thread Michael Grover
PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Sent: Sunday, May 19, 2002 12:02 PM Subject: Re: 4.0.1 Bugs Heikki, As for my crashes. This one is a little hard, see, we have two machines that do this. Both however, display little to no information in the log. One server

Re: 4.0.1 Bugs

2002-05-19 Thread Heikki Tuuri
: Sunday, May 19, 2002 12:02 PM Subject: Re: 4.0.1 Bugs Heikki, As for my crashes. This one is a little hard, see, we have two machines that do this. Both however, display little to no information in the log. One server just says mysql restarted followed by mysql was shut down incorrectly

Re: 4.0.1 Bugs

2002-05-19 Thread Heikki Tuuri
: Sunday, May 19, 2002 12:02 PM Subject: Re: 4.0.1 Bugs Heikki, As for my crashes. This one is a little hard, see, we have two machines that do this. Both however, display little to no information in the log. One server just says mysql restarted followed by mysql was shut down incorrectly

Re: 4.0.1 Bugs

2002-05-19 Thread Richard Clarke
Clarke [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, May 19, 2002 1:01 PM Subject: Re: 4.0.1 Bugs Richard, the assertion failure below is very probably caused by the SHOW CREATE TABLE memory corruption bug which was fixed in 3.23.48, but not yet in 4.0.1. It is usually caused

Re: 4.0.1 Bugs

2002-05-19 Thread Heikki Tuuri
manual and latest news on InnoDB - Original Message - From: Richard Clarke [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED]; Heikki Tuuri [EMAIL PROTECTED] Sent: Sunday, May 19, 2002 3:25 PM Subject: Re: 4.0.1 Bugs Heikki, My set of queries performs about 4/5 show create table

4.0.1 Bugs

2002-05-18 Thread Richard Clarke
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) selectunion 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

SV: 4.0.1 Bugs

2002-05-18 Thread Carsten Gehling
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) selectunion causes a temporary table full type

Re: 4.0.1 Bugs

2002-05-18 Thread Richard Clarke
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) selectunion causes

Re: 4.0.1 Bugs

2002-05-18 Thread Heikki Tuuri
- 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