Memory usage for MySQL
ds at hacked.com.br
Sun Jul 23 15:42:33 UTC 2006
From what I read you should only change kern.maxdsiz, changing
kern.dfldsiz makes every process allocating this amount of memory by
default, thats bad.
kern.maxdsiz="1395864371" # 1.3GB
#kern.dfldsiz="1395864371" # 1.3GB
#kern.maxssiz="134217728" # 128MB
would do the trick for you, check limits also and see what the init
scripts may be limiting on this process.
Thaddeus Quintin wrote:
> I'm working on a FreeBSD 6.1 machine and setting up MySQL 5.0 with
> some InnoDB tables.
> The machine has 2GB of RAM and will primarily be used as a database
> machine and will also be serving files over NFS (not high volume).
> The issue that I'm having is that when I start up MySQL I get a couple
> "Out of Memory" errors before it actually starts up. Looks like this-
> 060719 11:55:35 InnoDB: Started; log sequence number 0 43656
> /usr/local/libexec/mysqld: Out of memory (Needed 950109184 bytes)
> /usr/local/libexec/mysqld: Out of memory (Needed 712581120 bytes)
> 060719 11:55:35 [Note] /usr/local/libexec/mysqld: ready for connections.
> Version: '5.0.22-log' socket: '/tmp/mysql.sock' port: 3306
> If I reduce or increase the innodb_buffer_pool_size variable for MySQL
> I can eliminate or increase the number of errors. This set of errors
> was with innodb_buffer_pool_size set to 600M
> This is what top currently shows for MySQL-
> PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND
> 871 mysql 8 20 0 1196M 159M kserel 0 0:01 0.00% mysqld
> I tweaked /boot/loader.conf to allow larger data size for processes
> already (rebooted after changes)-
> kern.maxdsiz="1395864371" # 1.3GB
> kern.dfldsiz="1395864371" # 1.3GB
> kern.maxssiz="134217728" # 128MB
> If there's an out of memory error, how come MySQL starts up? Is this
> something to be concerned about? What else should I be checking to
> figure this out?
> freebsd-questions at freebsd.org mailing list
> To unsubscribe, send any mail to
> "freebsd-questions-unsubscribe at freebsd.org"
More information about the freebsd-questions