Changeset 16e74d3 for server/databases
- Timestamp:
- 11/02/2011 05:08:32 AM (12 years ago)
- Branches:
- 10.0, 10.1, 11.0, 11.1, 11.2, 11.3, 12.0, 12.1, 7.10, 7.4, 7.5, 7.6, 7.6-blfs, 7.6-systemd, 7.7, 7.8, 7.9, 8.0, 8.1, 8.2, 8.3, 8.4, 9.0, 9.1, basic, bdubbs/svn, elogind, gnome, kde5-13430, kde5-14269, kde5-14686, kea, ken/TL2024, ken/inkscape-core-mods, ken/tuningfonts, krejzi/svn, lazarus, lxqt, nosym, perl-modules, plabs/newcss, plabs/python-mods, python3.11, qt5new, rahul/power-profiles-daemon, renodr/vulkan-addition, systemd-11177, systemd-13485, trunk, upgradedb, xry111/intltool, xry111/llvm18, xry111/soup3, xry111/test-20220226, xry111/xf86-video-removal
- Children:
- a5db8d2
- Parents:
- 7224506
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
server/databases/mysql.xml
r7224506 r16e74d3 5 5 %general-entities; 6 6 7 <!-- <!ENTITY mysql-download-http "http://mysql.mirrors.hoobly.com/Downloads/MySQL-5.0/mysql-&mysql-version;.tar.gz">8 <!ENTITY mysql-download-ftp "ftp://ftp.fu-berlin.de/unix/databases/mysql/Downloads/MySQL-5.0/mysql-&mysql-version;.tar.gz"> -->9 7 <!ENTITY mysql-download-http "&sources-anduin-http;/m/mysql-&mysql-version;.tar.gz"> 10 8 <!ENTITY mysql-download-ftp "&sources-anduin-ftp;/m/mysql-&mysql-version;.tar.gz"> 11 <!ENTITY mysql-md5sum " 43c11ad3dded693393c4815d24e2b0a5">12 <!ENTITY mysql-size "23 .8MB">13 <!ENTITY mysql-buildsize " 500 MB (additional 200 MB to run the test suite)">14 <!ENTITY mysql-time " 5.3 SBU (Test suite is an additional 55 minutes, only partially CPU dependent)">9 <!ENTITY mysql-md5sum "dcb6a06e68c5e8f30f57b15300730c9c"> 10 <!ENTITY mysql-size "23 MB"> 11 <!ENTITY mysql-buildsize "883 MB (additional 170 MB to run the test suite)"> 12 <!ENTITY mysql-time "3.9 SBU (Test suite is an additional 45 minutes, only partially CPU dependent)"> 15 13 ]> 16 14 … … 69 67 <itemizedlist spacing="compact"> 70 68 <listitem> 71 <para>Required Patch:72 <ulink url="&patch-root;/mysql-&mysql-version;-makefile-1.patch"/>73 </para>74 </listitem>75 <listitem>76 69 <para>Optional Documentation (see tip below): 77 70 <ulink url="http://dev.mysql.com/doc/"/> … … 82 75 <bridgehead renderas="sect3">MySQL Dependencies</bridgehead> 83 76 77 <bridgehead renderas="sect4">Required</bridgehead> 78 <para role="optional"><xref linkend="cmake"/></para> 79 84 80 <bridgehead renderas="sect4">Recommended</bridgehead> 85 81 <para role="optional"><xref linkend="openssl"/></para> 86 82 87 83 <bridgehead renderas="sect4">Optional</bridgehead> 88 <para role="optional"><xref linkend="tcpwrappers"/></para> 89 90 <!-- Removing libedit because it causes more problems than it solves. 91 92 <ulink url="http://sourceforge.net/projects/libedit/">libedit</ulink> 93 (as an alternative to readline)--> 84 <para role="optional"><xref linkend="tcpwrappers"/>, 85 <ulink url="http://packages.debian.org/squeeze/libaio-dev">libaio</ulink></para> 94 86 95 87 <para condition="html" role="usernotes">User Notes: … … 108 100 109 101 <note><para>There are a great many options available to 110 <userinput>./configure</userinput>. Check the output of the 111 <option>--help</option> option for additional customization 112 options.</para></note> 102 <userinput>cmake</userinput>. Check the output of the `<userinput>cmake . 103 -LH</userinput>` for additional customization options. See ithe <ulink 104 url="http://dev.mysql.com/doc/refman/5.5/en/source-configuration-options.html">MySQL 105 Documentation</ulink> for a full listing of all options.</para></note> 113 106 114 107 <para>Build and install <application>MySQL</application> by 115 108 running the following commands:</para> 116 109 117 <screen><userinput>patch -Np1 -i ../mysql-&mysql-version;-makefile-1.patch && 118 CFLAGS="-O3" \ 119 CXX=gcc \ 120 CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \ 121 ./configure --prefix=/usr \ 122 --sysconfdir=/etc \ 123 --libexecdir=/usr/sbin \ 124 --localstatedir=/srv/mysql \ 125 --enable-thread-safe-client \ 126 --enable-assembler \ 127 --enable-local-infile \ 128 --with-unix-socket-path=/var/run/mysql/mysql.sock \ 129 --without-debug \ 130 --without-readline \ 131 --with-plugins=innobase,myisam \ 132 --with-extra-charsets=all \ 133 --with-ssl=/usr && 110 <screen><userinput>cmake . \ 111 -DSYSCONFDIR=/etc \ 112 -DMYSQL_DATADIR=/srv/mysql \ 113 -DINSTALL_MYSQLDATADIR=/srv/mysql \ 114 -DCMAKE_INSTALL_PREFIX=/usr \ 115 -DINSTALL_BINDIR=bin \ 116 -DINSTALL_SBINDIR=sbin \ 117 -DINSTALL_DOCDIR=share/doc/mysql \ 118 -DINSTALL_DOCREADMEDIR=share/doc/mysql \ 119 -DINSTALL_INCLUDEDIR=include/mysql \ 120 -DINSTALL_INFODIR=share/info \ 121 -DINSTALL_LIBDIR=lib \ 122 -DINSTALL_MANDIR=share/man \ 123 -DINSTALL_MYSQLSHAREDIR=share/mysql \ 124 -DINSTALL_MYSQLTESTDIR=share/mysql-test \ 125 -DINSTALL_PLUGINDIR=lib/plugin \ 126 -DINSTALL_SCRIPTDIR=bin \ 127 -DINSTALL_SHAREDIR=share/mysql \ 128 -DINSTALL_SQLBENCHDIR=share/mysql-bench \ 129 -DINSTALL_SUPPORTFILESDIR=share/mysql/support-files \ 130 -DWITH_ZLIB=system \ 131 -DWITH_SSL=system \ 132 -DWITH_READLINE=system \ 133 -DMYSQL_UNIX_ADDR=/var/run/mysql/mysql.sock \ 134 -DWITH_ARCHIVE_STORAGE_ENGINE=1 \ 135 -DWITH_FEDERATED_STORAGE_ENGINE=1 \ 136 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \ 137 -DMYSQL_MAINTAINER_MODE=OFF \ 138 -DWITH_DEBUG=OFF && 134 139 make</userinput></screen> 135 140 … … 144 149 fail.</para> 145 150 151 <note><para>The ssl tests may fail due to expired certifictes.</para></note> 152 146 153 <para>Now, as the <systemitem class="username">root</systemitem> user:</para> 147 154 148 <screen role="root"><userinput>make benchdir_root=/tmp \ 149 testroot=/tmp install && 150 rm -rf /tmp/mysql-test /tmp/sql-bench && 151 pushd /usr/lib && 152 ln -v -sf mysql/libmysqlclient{,_r}.so* . && 153 popd && 154 155 pushd /usr/share/info && 156 rm -v dir && 157 for FILENAME in *; do 158 install-info $FILENAME dir 2>/dev/null 159 done && 160 popd</userinput></screen> 155 <screen role="root"><userinput>SEGMENTS="Client Server IniFiles ManPages" 156 SEGMENTS="$SEGMENTS Development Documentation Info Readme" 157 158 for segment in $SEGMENTS; do 159 cmake -DCMAKE_INSTALL_COMPONENT=$segment -P cmake_install.cmake 160 done 161 162 unset SEGMENTS</userinput></screen> 161 163 162 164 <tip> … … 167 169 </tip> 168 170 171 <note><para>If you only want to build and install the 172 <command>mysql</command> client, use:</para> 173 174 <screen><userinput>cmake . && 175 make mysqlclient libmysql</userinput></screen> 176 177 <para>Continue as root:</para> 178 179 <screen role="root"><userinput>make install</userinput></screen> 180 </note> 181 169 182 </sect2> 170 183 … … 172 185 <title>Command Explanations</title> 173 186 174 <para><parameter>CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors 175 -fno-exceptions -fno-rtti"</parameter>: These optimizations are recommended 176 by the developers.</para> 177 178 <para><parameter>--libexecdir=/usr/sbin</parameter>: This switch installs 179 the <command>mysqld</command> daemon and the 180 <command>mysqlmanager</command> program in an appropriate location.</para> 181 182 <para><parameter>--localstatedir=/srv/mysql</parameter>: This switch 183 forces <application>MySQL</application> to use 184 <filename class='directory'>/srv/mysql</filename> for database files and 185 other variable data.</para> 186 187 <para><parameter>--enable-thread-safe-client</parameter>: This 188 switch compiles a thread-safe <application>MySQL</application> client 189 library.</para> 190 191 <para><parameter>--enable-assembler</parameter>: This switch allows using 192 assembler versions of some string functions.</para> 193 194 <para><parameter>--enable-local-infile</parameter>: This switch enables 195 the <quote>LOAD DATA INFILE</quote> SQL statement.</para> 196 197 <para><parameter>--with-unix-socket-path=/var/run/mysql</parameter>: 198 This switch puts the unix-domain socket into the 199 <filename class="directory">/var/run/mysql</filename> directory instead of 200 the default <filename class="directory">/tmp</filename>.</para> 201 202 <para><parameter>--without-readline</parameter>: This switch forces the 203 build to use the system copy of <application>readline</application> instead 204 of the bundled copy.</para> 205 206 <para><parameter>--with-extra-charsets=all</parameter>: This switch enables 207 international character sets within the suite.</para> 208 209 <para><parameter>--with-plugins=innobase,myisam</parameter>: This switch enables 210 two useful table types. Check <command>./configure --help</command> for 211 other table types.</para> 212 213 <para><parameter>--with-ssl=/usr</parameter>: This switch enables encrypted 214 communication between client and server using OpenSSL.</para> 215 216 <para><command>make benchdir_root=... install</command>: This installs the 217 benchmark and test suites in a non-system location.</para> 218 219 <para><command>ln -v -sf mysql/libmysqlclient{,_r}.so* .</command>: This 220 command makes the <application>MySQL</application> shared libraries 221 available to other packages at run-time.</para> 222 223 <para><option>--with-libwrap</option>: This switch adds tcpwrappers 224 support to <application>MySQL</application>.</para> 225 226 <para><command>pushd ... popd</command>: This set of commands rebuilds the 227 <filename>/usr/share/info/dir</filename> file as the installation failed 228 to do so.</para> 187 <para><command>cmake -DCMAKE_INSTALL_COMPONENT=$segment ...</command>: This 188 command installs the appropriate portion of the package. Different 189 segemnts may be added or deleted as desired. Valid segments are listed 190 with `<command>make list_install_components</command>`. Note that the 191 'DataFiles' install segment does not honor the -DMYSQL_DATADIR or 192 -DINSTALL_MYSQLDATADIR statements.</para> 229 193 230 194 </sect2> … … 257 221 as the <systemitem class="username">root</systemitem> user:</para> 258 222 259 <screen role="root"><userinput>install -v -m644 /usr/share/mysql/ my-medium.cnf /etc/my.cnf</userinput></screen>223 <screen role="root"><userinput>install -v -m644 /usr/share/mysql/support-files/my-medium.cnf /etc/my.cnf</userinput></screen> 260 224 261 225 <para>You can now install a database and change the ownership to the … … 263 227 class="username">root</systemitem> user):</para> 264 228 265 <screen role="root"><userinput>mysql_install_db -- user=mysql &&229 <screen role="root"><userinput>mysql_install_db --basedir=/usr --datadir=/srv/mysql --user=mysql && 266 230 chgrp -v mysql /srv/mysql{,/test,/mysql}</userinput></screen> 267 231
Note:
See TracChangeset
for help on using the changeset viewer.