How do I use more process memory with mysqld

[Vikash Badal]

Greetings,

I am trying to get mysql to use more memory, at present it seems stuck
at around 1G

>From the mysql lists the it was suggested that I increase kern.maxdsiz,
kern.dfdl, kern.maxssiz

In /boot/loader.conf.


Having set the values of kern.maxdsiz and  kern.dfdl mto 6G, I still
cant use more than 1G on mysql:


sysctl -a | grep kern.max
kern.maxvnodes: 100000
kern.maxproc: 6164
kern.maxfiles: 12328
kern.maxfilesperproc: 11095
kern.maxprocperuid: 5547
kern.maxusers: 384


>From dmesg:

CPU: Intel(R) Xeon(TM) CPU 2.80GHz (2793.20-MHz K8-class CPU)
  Origin = "GenuineIntel"  Id = 0xf48  Stepping = 8
 
Features=0xbfebfbff<FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE
,MCA,C
MOV,PAT,PSE36,CLFLUSH,DTS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE>
  Features2=0x649d<SSE3,RSVD2,MON,DS_CPL,EST,CNTX-ID,CX16,<b14>>
  AMD Features=0x20100800<SYSCALL,NX,LM>
  AMD Features2=0x1<LAHF>
  Cores per package: 2
  Logical CPUs per core: 2
real memory  = 17716740096 (16896 MB)
avail memory = 16638013440 (15867 MB)


uname -a
FreeBSD greateastern.dial-up.net 6.1-RELEASE-p5 FreeBSD 6.1-RELEASE-p5
#0:

limits -H
Resource limits (current):
  cputime          infinity secs
  filesize         infinity kB
  datasize         33554432 kB
  stacksize          524288 kB
  coredumpsize     infinity kB
  memoryuse        infinity kB
  memorylocked     infinity kB
  maxprocesses         5547
  openfiles           11095
  sbsize           infinity bytes
  vmemoryuse       infinity kB

>From top

93 processes:  1 running, 92 sleeping
CPU states:  1.1% user,  0.0% nice,  0.6% system,  0.1% interrupt, 98.2%
idle
Mem: 980M Active, 8893M Inact, 344M Wired, 616M Cache, 214M Buf, 2477M
Free
Swap: 31G Total, 116K Used, 31G Free

  PID USERNAME  THR PRI NICE   SIZE    RES STATE  C   TIME   WCPU
COMMAND
48647 mysql      35  20    0   963M   938M kserel 0 718.9H 22.17% mysqld



Please advise

Vikash
Please note: This email and its content are subject to the disclaimer as displayed at the following link http://www.is.co.za/legal/E-mail+Confidentiality+Notice+and+Disclaimer.htm. Should you not have Web access, send a mail to disclaimers at is.co.za and a copy will be emailed to you.