slack 12(32bit) mysql will use 8GB RAM

[gerski]

Hello Guys,

Have you experience using slackware 12 running mysql with 8gig memory? when i run mysqltuner it shows:

[OK] Currently running supported MySQL version 5.0.67
[!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM
[!!] Allocating > 2GB RAM on 32-bit systems can cause system instability

but my memory is 8GIG and i have enabled HIGHMEM so my top shows:

MemTotal: 8307436 kB

is there any way that i can maximize my mysql usage without upgrading to slackware 13 (supports 64 bit)? and without installing new OS?

[gardo]

Looks like your running 32bit Linux. You can only read up to 3.2 gig of RAM on 32bit OS. Looks like you don't have a choice but to upgrade to Slakware 13.0.

[mflorell]

MySQL CAN use 8GB of RAM in 32bit mode. I have done it before. The limitation is PER THREAD, not for MySQL in it's entirety.

Check your my.cnf settings and make sure they are set properly for the memory that you have.

[gardo]

Oh yeah. I forgot. You can enable the kernel PAE to access more than 3.2 gig of RAM.

[gerski]

Yes in kernel i have enable HIGHMEM to enable 64GIG..

here is my.cnf

Code: Select all

[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
skip-name-resolve
key_buffer = 1536M
max_allowed_packet = 4M
table_cache = 2048
sort_buffer_size = 8M
read_buffer_size = 8M
read_rnd_buffer_size = 32M
myisam_sort_buffer_size = 256M
thread_cache_size = 16
query_cache_size = 128M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8

[mysqldump]
quick
max_allowed_packet = 64M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 1024M
sort_buffer_size = 1024M
read_buffer = 8M
write_buffer = 8M

[myisamchk]
key_buffer = 1024M
sort_buffer_size = 1024M
read_buffer = 8M
write_buffer = 8M

[mysqlhotcopy]
interactive-timeout

what i have done is in my-huge.cnf since it is used for 1G to 2G i have multiply all the value by 4 meaning 2X4 = 8..