Forget the question, I have found my answer, thanks!
The answer is in MySQL manual, section 2.12.5.3.
Seems AIX default to max 256MB memory without compilation options. Then a max of 2GB is possible.
Ben
Ben Clewett wrote:
Dear user,
Slightly off topic, but knowing that there seems to be somebody here who knows anything, I need advise from an AIX expert :)
Trying to run MySQL 4.1.8 on AIX 5.2.0.0. Finding it cannot malloc more than about 90 MB for whole MySQL. Sample error:
050215 8:44:41 InnoDB: Fatal error: cannot allocate 536887296 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 27043112 bytes. Operating system errno: 12 InnoDB: Cannot continue operation!
The machine has 4GB available.
My limits in /etc/security/limits are unlimited:
mysql: rss = -1 rss_hard = -1 stack = -1 stack_hard = -1 data = -1 data_hard = -1
I would be extremely interested if some AIX expert could advise me what is going on?
Kind regards,
Ben Clewett.
-- Ben Clewett Road Tech Computer System Ltd [EMAIL PROTECTED] http://www.roadrunner.uk.com +44(0)1923 460000
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
