summaryrefslogtreecommitdiff
path: root/Docs
diff options
context:
space:
mode:
authorunknown <monty@donna.mysql.fi>2001-05-12 09:24:35 +0300
committerunknown <monty@donna.mysql.fi>2001-05-12 09:24:35 +0300
commit9c3297c9b24d3cd9e09e2c98f349bd5cfae33f85 (patch)
treea30ac4edd45397b82c0763a1df7fd2ad938ae675 /Docs
parent442e091f623f9f114e914001af2833ad9a7d675b (diff)
downloadmariadb-git-9c3297c9b24d3cd9e09e2c98f349bd5cfae33f85.tar.gz
Added information about using mysql-max
sql/mysqld.cc: Fixes for Alpha cc compiler support-files/my-huge.cnf.sh: cleanup support-files/my-large.cnf.sh: cleanup support-files/my-medium.cnf.sh: cleanup support-files/my-small.cnf.sh: cleanup
Diffstat (limited to 'Docs')
-rw-r--r--Docs/manual.texi72
1 files changed, 60 insertions, 12 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi
index 2ede3648a9b..b3023a905c7 100644
--- a/Docs/manual.texi
+++ b/Docs/manual.texi
@@ -6001,9 +6001,15 @@ shell> scripts/mysql_install_db
shell> chown -R root /usr/local/mysql
shell> chown -R mysql /usr/local/mysql/var
shell> chgrp -R mysql /usr/local/mysql
+shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> /usr/local/mysql/bin/safe_mysqld --user=mysql &
@end example
+If you want have support for InnoDB tables, you should edit the
+@code{/etc/my.cnf} file and remove the @code{#} character before the
+parameters that starts with @code{innodb_...}. @xref{Option
+files}. @xref{InnoDB start}.
+
If you start from a source RPM, then do the following:
@example
@@ -8816,7 +8822,7 @@ This is also described in the @file{README} file that comes with the
@subsection Installing MySQL on Windows
If you don't have a copy of the @strong{MySQL} distribution, you should
-first download one from @uref{http://www.mysql.com/}.
+first download one from @uref{http://www.mysql.com/downloads/mysql-3.23.html}.
If you plan to connect to @strong{MySQL} from some other program, you will
probably also need the @strong{MyODBC} driver. You can find this at the
@@ -8843,6 +8849,36 @@ specify all paths with @samp{/} instead of @samp{\}. If you use
@samp{\}, you need to specify this twice, as @samp{\} is the escape
character in @strong{MySQL}. @xref{Option files}.
+Starting from @strong{MySQL} 3.23.38 the windows distribution includes
+both the normal and the @strong{MySQL-Max} binaries. The main benefit
+of using the normal @code{mysqld.exe} binary is that it's a little
+faster and uses less resources.
+
+Here is a list of the different @strong{MySQL} servers you can use:
+
+@multitable @columnfractions .25 .75
+@item @code{mysqld} @tab
+Compiled with full debugging and automatic memory allocation checking,
+symbolic links, BDB and InnoDB tables.
+@item @code{mysqld-opt} @tab
+Optimized binary with no support for transactional tables.
+@item @code{mysqld-nt} @tab
+Optimized for a Pentium pro processor. Has support for
+named pipes. One can run this version on Win98, but in
+this case no named pipes are created and one must
+have TCP/IP installed.
+@item mysqld-max @tab
+Optimized binary with support for symbolic links, BDB and InnoDB tables.
+@item mysqld-max-nt @tab
+Like mysqld-max, but compiled with support for named pipes.
+@end multitable
+
+All of the above binaries are optimized for the Pentium pro processor but
+should work on any Intel processor >= i386.
+
+NOTE: If you want to use InnoDB tables, you need to specify some startup
+options in your my.ini file! @xref{InnoDB start}.
+
@node Win95 start, NT start, Windows installation, Windows
@subsection Starting MySQL on Windows 95 or Windows 98
@@ -8857,15 +8893,6 @@ Winsock 2! You can get the newest Winsock from
@uref{http://www.microsoft.com/}. Win98 has the new Winsock 2 library, so
the above doesn't apply for Win98.
-There are 2 different @strong{MySQL} servers you can use:
-
-@multitable @columnfractions .25 .75
-@item @code{mysqld} @tab Compiled with full debugging and automatic memory allocation checking
-@item @code{mysqld-opt} @tab Optimized for a Pentium processor.
-@end multitable
-
-Both of the above should work on any Intel processor >= i386.
-
To start the @code{mysqld} server, you should start an MS-DOS window and type:
@example
@@ -8911,10 +8938,15 @@ should install @strong{MySQL} as a service on NT/Win2000:
@example
C:\mysql\bin\mysqld-nt --install
+
+or
+
+C:\mysql\bin\mysqld-max-nt --install
@end example
-(You could use the @code{mysqld} or @code{mysqld-opt} servers on NT,
-but those cannot be started as a service or use named pipes.)
+(You can also use @code{mysqld} binaries that doesn't end with
+@code{-nt.exe} on NT, but those cannot be started as a service or use
+named pipes.)
You can start and stop the @strong{MySQL} service with:
@@ -9863,6 +9895,10 @@ reload the grant tables.
@cindex server, starting problems
@cindex problems, starting the server
+If you are going to use tables that support transactions (BDB, InnoDB or
+Gemini), you should first create a my.cnf file and set startup options
+for the table types you plan to use. @xref{Table types}.
+
Generally, you start the @code{mysqld} server in one of three ways:
@itemize @bullet
@@ -23353,6 +23389,9 @@ type it should use for the table. @strong{MySQL} will always create a
@code{.frm} file to hold the table and column definitions. Depending on
the table type, the index and data will be stored in other files.
+Note that to use @code{InnoDB} tables you have to use at least
+the @code{innodb_data_file_path} startup option. @xref{InnoDB start}.
+
The default table type in @strong{MySQL} is @code{MyISAM}. If you are
trying to use a table type that is not compiled-in or activated,
@strong{MySQL} will instead create a table of type @code{MyISAM}. This
@@ -31719,6 +31758,14 @@ the following configure options:
@item CFLAGS=-DUSE_SYMDIR @tab Symbolic links support for Windows.
@end multitable
+You can find the @strong{MySQL}-max binaries at
+@uref{http://www.mysql.com/downloads/mysql-max-3.23.html}.
+
+The windows @strong{MySQL} 3.23 binary distribution includes both the
+standard @strong{mysqld.exe} binary and the @code{mysqld-max.exe} binary.
+@uref{http://www.mysql.com/downloads/mysql-3.23.html}.
+@xref{Windows installation}.
+
Note that as Berkeley DB and InnoDB are not available for all platforms,
some of the @code{Max} binaries may not have support for both of these.
You can check which table types are supported by doing the following
@@ -31780,6 +31827,7 @@ binaries includes:
@item Solaris-sparc @tab Y @tab Y
@item SCO OSR5 @tab Y @tab Y
@item UnixWare @tab Y @tab Y
+@item Windows/NT @tab Y @tab Y
@end multitable
@cindex tools, safe_mysqld