<< 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
    126 MySQL Technical Reference for Version 4.0.3 2.6.4.4  OpenBSD 2.8 Notes Our  users  have  reported  that  OpenBSD  2.8  has  a  threading  bug  which  causes  problems with MySQL. The OpenBSD Developers have xed the problem, but as of January 25th, 2001, it's only available in the \-current" branch.  The symptoms of this threading bug are: slow response, high load, high CPU usage, and crashes. If you get an error like Error in accept:: Bad file descriptor or error 9 when trying to open tables or directories, the problem is probably that you haven't allocated enough le descriptors for MySQL. In this case try starting safe_mysqld as root with the following options: --user=mysql --open-files-limit=2048 2.6.4.5  BSD/OS Version 2.x Notes If you get the following error when compiling MySQL, your ulimit value for virtual memory is too low: item_func.h: In method `Item_func_ge::Item_func_ge(const Item_func_ge item_func.h:28: virtual memory exhausted make[2]: *** [item_func.o] Error 1 Try using  ulimit -v 80000  and run  make  again.   If this doesn't work and you are using bash, try switching to csh or sh; some BSDI users have reported problems with bash and ulimit. If  you  are  using  gcc,  you  may  also  use  have  to  use  the  --with-low-memory   ag  for configure to be able to compile `sql_yacc.cc'. If you get problems with the current date in MySQL, setting the TZ variable will probably help.  See Appendix F [Environment variables], page 770. 2.6.4.6  BSD/OS Version 3.x Notes Upgrade to BSD/OS Version 3.1.  If that is not possible, install BSDIpatch M300-038. Use the following command when con guring MySQL: shell> env CXX=shlicc++ CC=shlicc2 \ ./configure \ --prefix=/usr/local/mysql \ --localstatedir=/var/mysql \ --without-perl \ --with-unix-socket-path=/var/mysql/mysql.sock The following is also known to work: shell> env CC=gcc CXX=gcc CXXFLAGS=-O3 \ ./configure \ --prefix=/usr/local/mysql \ --with-unix-socket-path=/var/mysql/mysql.sock
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    MERCHANT ACCOUNTS
    DEDICATED SERVERS
    E-COMMERCE HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN
    REGISTRATION
    MANAGE
    YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    Corporate Info
    ABOUT US
    OUR NETWORK
    CONTACT US
    SITE MAP
    UNIX Web Hosting | Merchant Accounts | Dedicated Hosting | E-Commerce Hosting
    Domain Registration | About Us | Our Network | Contact Us | Site Map
    Our Partners
    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