<< 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
    606 MySQL Technical Reference for Version 4.0.3 Function When to call mysql_server_ init() Should be called before any other MySQL function is called, preferably early in the main() function. mysql_server_end() Should be called before your program exits. mysql_thread_ init() Should  be  called  in  each  thread  you  create  that  will  access MySQL. mysql_thread_end() Should be called before calling pthread_exit() Then you must link your code with libmysqld.a instead of libmysqlclient.a. The above  mysql_server_xxx  functions are also included in  libmysqlclient.a  to allow you  to  change  between  the  embedded  and  the  client/server  version  by  just  linking  your application with the right library.  See Section 8.4.5.1 [mysql server init], page 601. 8.4.9.2  Compiling Programs with libmysqld To  get  a  libmysqld  library  you  should  con gure  MySQL  with  the  --with-embedded- server option. When you link your program with libmysqld,  you must also include the system-speci c pthread libraries and some libraries that the MySQL server uses.  You can get the full list of libraries by executing mysql_config --libmysqld-libs. The correct ags for compiling and linking a threaded program must be used, even if you do not directly call any thread functions in your code. 8.4.9.3  Restrictions when using the Embedded MySQL Server The embedded server has the following limitations:    No support for ISAM tables.  (This is mainly done to make the library smaller)    No UDF functions.    No stack trace on core dump.    No internal RAID support.  (This is not normally needed as most OS has nowadays support for big les).    You can set this up as a server or a master (no replication).    You  can't  connect  to  the  embedded  server  from  an  outside  process  with  sockets  or TCP/IP. Some of these limitations can be changed by editing the `mysql_embed.h' include le and recompiling MySQL. 8.4.9.4  Using Option Files with the Embedded Server The following is the recommended way to use option les to make it easy to switch between a client/server application and one where MySQL is embedded.  See Section 4.1.2 [Option les], page 186.
     

    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