Dyntex.net Support Centre: MySQL Reference Manual p.89

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

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 89 shell> CFLAGS=-O3 shell> CXX=gcc shell> CXXFLAGS=-O3 shell> export CC CFLAGS CXX CXXFLAGS See Section 2.2.6 [MySQL binaries], page 75, for a list of ag denitions that have been found to be useful on various systems. If you get an error message like this, you need to upgrade your gcc compiler: client/libmysql.c:273: parse error before `__attribute__' gcc 2.8.1 is known to work, but we recommend using gcc 2.95.2 or egcs 1.0.3a instead. If you get errors such as those shown here when compiling mysqld, configure didn't correctly detect the type of the last argument to accept(), getsockname(), or getpeername(): cxx: Error: mysqld.cc, line 645: In this statement, the referenced type of the pointer value "&length" is "unsigned long", which is not compatible with "int". new_sock = accept(sock, (struct sockaddr *)&cAddr, &length); To x this, edit the `config.h' le (which is generated by configure). Look for these lines: /* Define as the base type of the last arg to accept */ #define SOCKET_SIZE_TYPE XXX Change XXX to size_t or int, depending on your operating system. (Note that you will have to do this each time you run configure because configure regenerates `config.h'.) The `sql_yacc.cc' le is generated from `sql_yacc.yy'. Normally the build process doesn't need to create `sql_yacc.cc', because MySQL comes with an already generated copy. However, if you do need to re-create it, you might encounter this error: "sql_yacc.yy", line xxx fatal: default action causes potential... This is a sign that your version of yacc is decient. You probably need to install bison (the GNU version of yacc) and use that instead. If you need to debug mysqld or a MySQL client, run configure with the --with- debug option, then recompile and link your clients with the new client library. See Section E.2 [Debugging client], page 763. 2.3.6 MIT-pthreads Notes This section describes some of the issues involved in using MIT-pthreads. Note that on Linux you should not use MIT-pthreads but install LinuxThreads! See Sec- tion 2.6.1 [Linux], page 106. If your system does not provide native thread support, you will need to build MySQL using the MIT-pthreads package. This includes older FreeBSD systems, SunOS 4.x, Solaris 2.4 and earlier, and some others. See Section 2.2.2 [Which OS], page 69. On most systems, you can force MIT-pthreads to be used by running configure with the --with-mit-threads option:

MySQL Reference Manual

Our Partners

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