Thanks for getting back to me so swiftly, I've been banging my head
against this for a couple of days now... :(
On 9 Jun 2009, at 22:06, Daniel Ouellet wrote:
Gaby Vanhegan wrote:
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:
How do you start your MySQL, do you actually tell it to use that
class?
The server is started thusly:
sudo -c _mysql /usr/local/bin/mysqld_safe &
And also:
# getcap -c datasize -f /etc/login.conf _mysql
=infinity
# getcap -c datasize-max -f /etc/login.conf _mysql
=2048M
# getcap -c datasize-cur -f /etc/login.conf _mysql
=2048M
On 9 Jun 2009, at 22:07, Ted Unangst wrote:
There are hard limits that you can't exceed.
If the machine has mare than enough physical RAM and tons of swap, is
there no way to configure MySQL to hold a 2Gb buffer in memory? I
really want to avoid building a custom kernel and it feels like I
should be able to get this working using login.conf, ulimit and sysctl
settings. Or is this a wall that is not meant to be broken through?
G.
--
Being drunk is feeling sophisticated without being able to say it.
http://www.playr.co.uk/
