<< 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

    124 MySQL Technical Reference for Version 4.0.3 2.6.3.2  Solaris x86 Notes On Solaris 2.8 on x86, mysqld will core dump if you run 'strip' in. If you are using gcc or egcs on Solaris x86 and you experience problems with core dumps under load, you should use the following configure command: CC=gcc CFLAGS="-O3 -fomit-frame-pointer -DHAVE_CURSES_H" \ CXX=gcc \ CXXFLAGS="-O3 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -DHAVE_CURSES_H" \ ./configure --prefix=/usr/local/mysql This will avoid problems with the libstdc++ library and with C++ exceptions. If this doesn't help, you should compile a debug version and run it with a trace le or under gdb.  See Section E.1.3 [Using gdb on mysqld], page 760. 2.6.4  BSD Notes This section provides information for the various BSD avours, as well as speci c versions within those. 2.6.4.1  FreeBSD Notes FreeBSD 3.x is recommended for running MySQL since the thread package is much more integrated. The easiest and therefore the preferred way to install is to use the mysql-server and mysql- client ports available on http://www.freebsd.org/. Using these gives you:    A working MySQL with all optimisations known to work on your version of FreeBSD enabled.    Automatic con guration and build.    Startup scripts installed in /usr/local/etc/rc.d.    Ability to see which les that are installed with pkg info -L. And to remove them all with pkg delete if you no longer want MySQL on that machine. It is recommended you use MIT-pthreads on FreeBSD 2.x and native threads on Versions 3 and up.  It is possible to run with native threads on some late 2.2.x versions but you may encounter problems shutting down mysqld. The  MySQL  `Makefile's  require  GNU  make  (gmake)  to  work.   If  you  want  to  compile MySQL you need to install GNU make  rst. Be sure to have your name resolver setup correct.  Otherwise, you may experience resolver delays or failures when connecting to mysqld. Make sure that the localhost entry in the `/etc/hosts' le is correct (otherwise, you will have problems connecting to the database).  The `/etc/hosts' le should start with a line:
     

    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
  • 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