I'm having an annoying time trying to make MySQL run with a large
amount of buffer memory. I have 4Gb of RAM and 8Gb of swap and I need
to increase the data size limit for the _mysql login class. Currently
it's set to unlimited but it doesn't seem to be coming through to the
_mysql login class:
$ ulimit -a
time(cpu-seconds) unlimited
file(blocks) unlimited
coredump(blocks) unlimited
data(kbytes) 1048576
stack(kbytes) 8192
lockedmem(kbytes) 1101134
memory(kbytes) 3301268
nofiles(descriptors) 2048
processes 1310
$ whoami
_mysql
I need to increase the data limit as we're hitting the limits with the
large InnoDB pool size. I must be doing something wrong but I can't
see the obvious problem that I'm hitting. Help? I have a large
InnoDB buffer pool configured and every time I fire up MySQL I keep
getting this error:
# Starting mysqld daemon with databases from /var/mysql
090609 21:23:51 mysqld started
090609 21:23:51 InnoDB: Error: cannot allocate 1073758208 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 14810216 bytes. Operating system errno: 12
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
InnoDB: Note that in most 32-bit computers the process
InnoDB: memory space is limited to 2 GB or 4 GB.
InnoDB: We keep retrying the allocation for 60 seconds...
MySQL comes up but the innodb tables don't. This is the latest 4.5
release, upgraded yesterday, running the latest package of MySQL.
Haylp!
G.
--
Imagine there were no hypothetical situations.
http://playr.co.uk/
