Date: Tue, 15 Apr 2008 17:07:14 +0200 From: "Vikash Badal" <Vikash.Badal@is.co.za> To: <freebsd-questions@freebsd.org> Subject: How do I use more process memory with mysqld Message-ID: <740109F1ED7BA14EB02307DEF26487AB111C888B@ZABRYSVISEX04.af.didata.local>
next in thread | raw e-mail | index | archive | help
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) =20 Origin =3D "GenuineIntel" Id =3D 0xf48 Stepping =3D 8 =20 Features=3D0xbfebfbff<FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PG= E ,MCA,C MOV,PAT,PSE36,CLFLUSH,DTS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE> =20 Features2=3D0x649d<SSE3,RSVD2,MON,DS_CPL,EST,CNTX-ID,CX16,<b14>> =20 AMD Features=3D0x20100800<SYSCALL,NX,LM> =20 AMD Features2=3D0x1<LAHF> =20 Cores per package: 2 =20 Logical CPUs per core: 2 real memory =3D 17716740096 (16896 MB) avail memory =3D 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): =20 cputime infinity secs =20 filesize infinity kB =20 datasize 33554432 kB =20 stacksize 524288 kB =20 coredumpsize infinity kB =20 memoryuse infinity kB =20 memorylocked infinity kB =20 maxprocesses 5547 =20 openfiles 11095 =20 sbsize infinity bytes =20 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 =20 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+Confiden= tiality+Notice+and+Disclaimer.htm. Should you not have Web access, send a= =20mail to disclaimers@is.co.za and a copy will be emailed to you.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?740109F1ED7BA14EB02307DEF26487AB111C888B>