Re: 4.0.1 Bugs

2002-05-23 Thread Richard Clarke
ROTECTED]> Cc: <[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 >

Re: 4.0.1 Bugs

2002-05-22 Thread Michael Grover
p://www.innodb.com for the online manual and latest news on InnoDB > > > > - Original Message - > > From: "Richard Clarke" <[EMAIL PROTECTED]> > > To: "Heikki Tuuri" <[EMAIL PROTECTED]> > > Sent: Sunday, May 19, 2002 12:02 PM &

Re: 4.0.1 Bugs

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

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,

Re: 4.0.1 Bugs

2002-05-19 Thread Richard Clarke
"Heikki Tuuri" <[EMAIL PROTECTED]> To: "Richard 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 TAB

Re: 4.0.1 Bugs

2002-05-19 Thread Heikki Tuuri
ri" <[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 just says mys

Re: 4.0.1 Bugs

2002-05-19 Thread Heikki Tuuri
ri" <[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 just says mys

Re: 4.0.1 Bugs

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

Re: 4.0.1 Bugs

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