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 [EMAIL PROTECTED] and a copy will be emailed to you. _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
