<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • Return to Table of Contents
    • Table of Contents
    1. General Information
    2. MySQL Installation
    3. Tutorial Introduction
    4. Database Administration
    5. MySQL Optimisation
    6. MySQL Language Reference
    7. MySQL Table Types
    8. MySQL APIs
    9. Extending MySQL
    Chapter 2:  MySQL Installation 125 127.0.0.1 localhost localhost.your.domain The recommended way to compile and install MySQL on FreeBSD with gcc (2.95.2 and up) is: CC=gcc CFLAGS="-O2 -fno-strength-reduce" \ CXX=gcc CXXFLAGS="-O2 -fno-rtti -fno-exceptions -felide-constructors \ -fno-strength-reduce" \ ./configure --prefix=/usr/local/mysql --enable-assembler gmake gmake install ./scripts/mysql_install_db cd /usr/local/mysql ./bin/mysqld_safe & If you notice that  configure  will use MIT-pthreads,  you should read the MIT-pthreads notes.  See Section 2.3.6 [MIT-pthreads], page 89. If  you  get  an  error  from  make install  that  it  can't   nd  `/usr/include/pthreads', configure  didn't  detect  that  you  need  MIT-pthreads.   This  is   xed  by  executing  these commands: shell> rm config.cache shell> ./configure --with-mit-threads FreeBSD is also known to have a very low default le handle limit.  See Section A.2.16 [Not enough le handles], page 636.  Uncomment the ulimit -n section in safe mysqld or raise the limits for the mysqld user in /etc/login.conf (and rebuild it with cap mkdb /etc/login.conf). Also be sure you set the appropriate class for this user in the password le if you are not using the default (use:  chpass mysqld-user-name).  See Section 4.7.2 [safe_mysqld], page 274. If you have a lot of memory you should consider rebuilding the kernel to allow MySQL to take more than 512M of RAM. Take a look at option MAXDSIZ in the LINT con g le for more info. If you get problems with the current date in MySQL, setting the TZ variable will probably help.  See Appendix F [Environment variables], page 770. To get a secure and stable system you should only use FreeBSD kernels that are marked -RELEASE. 2.6.4.2  NetBSD notes To compile on NetBSD you need GNU make.  Otherwise, the compile will crash when make tries to run lint on C++  les. 2.6.4.3  OpenBSD 2.5 Notes On OpenBSD Version 2.5, you can compile MySQL with native threads with the following options: CFLAGS=-pthread CXXFLAGS=-pthread ./configure --with-mit-threads=no
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN REGISTRATION
    MANAGE YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    SITE MAP
    Home
    Hosting Plans | Domain Registration | About Us | Contact Us | Site Map
    Terms of Use | Privacy Policy | Guarantees
    Merchant Accounts

    SpiritHost - web hosting for spiritual and education sites
    SpiritHit.com - Religious and Spiritual Portal

    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved

  • Return to Table of Contents
    		•
  • Back to top
    • Web Hosting: Manuals & FAQ's
    1. Unix-Based Web Hosting
    2. Unix Dedicated Servers
    3. Windows Dedicated Servers
    4. CuteFTP User’s Guide
    5. CuteHTML User’s Guide
    6. WS_FTP Pro User's Guide
    7. Miva Order User's Guide
    8. Miva Merchant User's Guide