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

<< 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 85 CFLAGS="-O3 -mpentiumpro" CXX=gcc CXXFLAGS="-O3 -mpentiumpro \ -felide-constructors -fno-exceptions -fno-rtti" ./configure \ --prefix=/usr/local/mysql --enable-assembler \ --with-mysqld-ldflags=-all-static The binaries we provide on the MySQL web site at http://www.mysql.com/ are all compiled with full optimisation and should be perfect for most users. See Section 2.2.6 [MySQL binaries], page 75. There are some things you can tweak to make an even faster binary, but this is only for advanced users. See Section 5.5.3 [Compile and link options], page 365. If the build fails and produces errors about your compiler or linker not being able to create the shared library `libmysqlclient.so.#' (`#' is a version number), you can work around this problem by giving the --disable-shared option to configure. In this case, configure will not build a shared libmysqlclient.so.# library. You can congure MySQL not to use DEFAULT column values for non-NULL columns (that is, columns that are not allowed to be NULL). This causes INSERT statements to generate an error unless you explicitly specify values for all columns that require a non-NULL value. To suppress use of default values, run configure like this: shell> CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS ./configure By default, MySQL uses the ISO-8859-1 (Latin1) character set. To change the default set, use the --with-charset option: shell> ./configure --with-charset=CHARSET CHARSET may be one of big5, cp1251, cp1257, czech, danish, dec8, dos, euc_kr, gb2312, gbk, german1, hebrew, hp8, hungarian, koi8_ru, koi8_ukr, latin1, latin2, sjis, swe7, tis620, ujis, usa7, or win1251ukr. See Section 4.6.1 [Character sets], page 267. If you want to convert characters between the server and the client, you should take a look at the SET CHARACTER SET command. See Section 5.5.6 [SET], page 369. Warning: If you change character sets after having created any tables, you will have to run myisamchk -r -q on every table. Your indexes may be sorted incorrectly otherwise. (This can happen if you install MySQL, create some tables, then recongure MySQL to use a dierent character set and reinstall it.) With the option --with-extra-charset=LIST you can dene which additional char- acter sets should be compiled into the server. Here LIST is either a list of character sets separated with spaces, complex to include all characters that can't be dynamically loaded, or all to include all character sets into the binaries. To congure MySQL with debugging code, use the --with-debug option: shell> ./configure --with-debug This causes a safe memory allocator to be included that can nd some errors and that provides output about what is happening. See Section E.1 [Debugging server], page 758. If your client programs are using threads, you need to also compile a thread-safe ver- sion of the MySQL client library with the --enable-thread-safe-client congure options. This will create a libmysqlclient_r library with which you should link your threaded applications. See Section 8.4.8 [Threaded clients], page 604.

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