3 messages in com.mysql.lists.mysqlRe: init-file problem.
FromSent OnAttachments
Peter Zaitsev14 Feb 2000 01:25 
sas...@mysql.com14 Feb 2000 10:37 
Michael Widenius14 Feb 2000 22:06 
Subject:Re: init-file problem.
From:Michael Widenius (mon@monty.pp.sci.fi)
Date:02/14/2000 10:06:30 PM
List:com.mysql.lists.mysql

"sasha" == sasha <sas@mysql.com> writes:

sasha> Peter Zaitsev wrote:

I have mysqld 3.23.10 running on SuSe 6.3

It works almost fine so far but the problem I've found. Currently the problem is if I provide mysqld specifed init file afterwards i cant shutdown it - after issuing the shutdown command many of mysqld processes still exist so I can't start mysqld again. Well I can't even kill it with normal signal only kill -9 bring it down. Without initfile - everything works fine. With other simplier initfile - also.

Can you provide a full example of this?

<cut>

The other question is why mysql does not support autoincrement columns in heap tables - this is bad a bit....

sasha> This has to do with a different way of storing data, heap tables are sasha> implememented different than MyISAM. I'll let Monty comment on the
details, as sasha> he is more familiar with the subject.

The main problem is that heap tables don't have any notion of how to order numbers. We shall however look at adding this in the future.

Regards, Monty