Date: Tue, 15 Nov 2005 02:57:04 -0500 From: Ashok Shrestha <ashok.shrestha@gmail.com> To: freebsd-database@freebsd.org, freebsd-performance@freebsd.org Subject: HowTo Get Max Peform with MySQL 5.0 and FreeBSD 5.4 ?? Message-ID: <79e2026f0511142357m6093e636y6a988725d783391f@mail.gmail.com>
next in thread | raw e-mail | index | archive | help
I'm using MySQL 5.0.15 with FreeBSD 5.4-RELEASE amd64. The box specs: CPU: Dual Core AMD Opteron(tm) Processor 275 (2193.76-MHz K8-class CPU) Memory: 4 GB My databases will be anywhere from 2GB-20GB. I would like to get the maximum performance out of this box. What options (MAKE, kernel, etc...) should I use to achieve this? What about loading the INDEX file into memory? Should I build WITH_LINUXTHREADS? Is it still necessary to do so on FreeBSD 5.4? I know it is better on a 4.X machine. Note: It is not possible to buil= d WITH_LINUXTHREADS on a FreeBSD 5.4 AMD64. What are the advantages of building with (MAKE) BUILD_OPTIMIZED? Is there an advantage in using a 64bit FreeBSD? How should I configure the following in /etc/loader.conf? I could not find an authoritative definition any of these variables; do you know of any? kern.maxdsiz=3D"3221225472" # 3GB; should it be closer to 4GB? kern.dfldsiz=3D"3221225472" # 3GB; should it be closer to 4GB? kern.maxssiz=3D"134217728" # 128MB; what is this? stack size? how large sho= uld I make it? -- Ashok Shrestha
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?79e2026f0511142357m6093e636y6a988725d783391f>