Alex, because 512 MB is not an InnoDB or MySQL restriction, it must be an OS restriction :).
I assume you have not allocated 1.5 GB of MySQL key_buffer. Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables ----- Alkuperäinen viesti ----- Lähettäjä: "Varshavchick Alexander" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Tuesday, October 21, 2003 2:55 PM Aihe: Re: InnoDB or OS restriction? > Hi Heikki, > > here is a snip from the original posting which you probably have > overlooked: > > > > > The first strange thing is that MAXDSIZ and DFLDSIZ in kernel config are > > > > setted to 1536M > > Regards > > ---- > Alexander Varshavchick, Metrocom Joint Stock Company > Phone: (812)118-3322, 118-3115(fax) > > On Mon, 20 Oct 2003, Heikki Tuuri wrote: > > > Date: Mon, 20 Oct 2003 22:05:07 +0300 > > From: Heikki Tuuri <[EMAIL PROTECTED]> > > To: [EMAIL PROTECTED] > > Subject: Re: InnoDB or OS restriction? > > > > Alex, > > > > in FreeBSD user process memory space is often restricted to 512 MB. You have > > to reconfigure or recompile the FreeBSD kernel to increase that limit. > > > > Best regards, > > > > Heikki Tuuri > > Innobase Oy > > http://www.innodb.com > > Foreign keys, transactions, and row level locking for MySQL > > InnoDB Hot Backup - a hot backup tool for InnoDB: now > > also backs up your MyISAM tables > > > > > > ----- Original Message ----- > > From: "alex" <[EMAIL PROTECTED]> > > Newsgroups: mailing.database.myodbc > > Sent: Monday, October 20, 2003 1:30 PM > > Subject: Re: InnoDB or OS restriction? > > > > > > > Hi again, > > > > > > as there was not a single answer to my question I can imagine that no one > > > encountered the same issue, but anyways, can there be any hints? First of > > > all, are there any means of looking at mysql memory allocation list > > > grouped by some major parts - for example, > > > innodb main pool - can be retrieved from innodb monitor > > > innodb additional pool - can be retrieved from innodb monitor > > > myisam main cache - ...? > > > myisam sort buffer - ...? > > > memory allocated from OS - ...? > > > > > > The questiion is why mysql is trying to allocate memory via malloc from OS > > > while the innodb additional pool is occupied only by 50%? Or is it myisam > > > buffer that mysql is trying to extend? > > > > > > Regards > > > > > > --- > > > Alex > > > > > > On Tue, 14 Oct 2003, alex wrote: > > > > > > > Hi people, > > > > > > > > I have mysql 4.0.7-gamma/linuxthreads running under FreeBSD 4.6.2 > > (server > > > > has 4G phisical memory), and occasionally mysql traps with the message: > > > > > > > > InnoDB: Fatal error: cannot allocate 1064960 bytes of > > > > InnoDB: memory with malloc! Total allocated memory > > > > InnoDB: by InnoDB 513951016 bytes. Operating system errno: 12 > > > > InnoDB: Cannot continue operation! > > > > > > > > The first strange thing is that MAXDSIZ and DFLDSIZ in kernel config are > > > > setted to 1536M, and the second one is that each time it happens, while > > > > the number of bytes reported to cannot be allocated is different, total > > > > memory allocated by InnoDB is exactly the same - 513951016 bytes. Which > > > > restrictions are the cause of this - InnoDB's or FreeBSD's? > > > > > > > > Thanks in advance > > > > > > > > ---- > > > > Alex > > > > > > > > -- > > > > MySQL General Mailing List > > > > For list archives: http://lists.mysql.com/mysql > > > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]