Go to the first, previous, next, last section, table of contents.
--with-raid
link errors
A
aborted clients
aborted connection
access control
access denied errors
access privileges
Access program
ACID
ACID
ACLs
ActiveState Perl
adding, character sets
adding, native functions
adding, new functions
adding, new user privileges
adding, new users
adding, procedures
adding, user-definable functions
administration, server
ADO program
age, calculating
alias names, case-sensitivity
aliases, for expressions
aliases, for tables
aliases, in GROUP BY
clauses
aliases, in ORDER BY
clauses
aliases, names
aliases, on expressions
anonymous user, anonymous user, anonymous user, anonymous user
ANSI mode, running
answering questions, etiquette
Apache
APIs
APIs, Perl
applying, patches
argument processing
arithmetic expressions
AUTO-INCREMENT, ODBC
AUTO_INCREMENT
AUTO_INCREMENT
, and NULL
values
B
backing up, databases, backing up, databases
backslash, escape character
backups
backups, database
batch mode
batch
, mysql
option
BDB
table type
BDB
tables
benchmark suite
benchmarks
BerkeleyDB
table type
Big5 Chinese character encoding
binary distributions
binary distributions, installing
binary distributions, on HP-UX
binary distributions, on Linux
binary log
bit_functions, example
BitKeeper tree
BLOB
columns, default values
BLOB
columns, indexing
BLOB
, inserting binary data
BLOB
, size
Borland Builder 4 program
Borland C++ compiler
brackets, square
buffer sizes, client
buffer sizes, mysqld
server
bug reports, criteria for
bugs database
bugs, known
bugs, reporting
bugs.mysql.com
building, client programs
C
C API, datatypes
C API, functions
C API, linking problems
C Prepared statements API, functions
C++
C++ APIs
C++ Builder
C++ compiler cannot create executables
C++ compiler, gcc
caches, clearing
calculating, dates
calling sequences for aggregate functions, UDF
calling sequences for simple functions, UDF
can't create/write to file
case-sensitivity, in access checking
case-sensitivity, in names
case-sensitivity, in searches
case-sensitivity, in string comparisons
case-sensitivity, of database names
case-sensitivity, of table names
cast operators
casts
cc1plus
problems
certification
ChangeLog
changes to privileges
changes, log
changes, version 3.19
changes, version 3.20
changes, version 3.21
changes, version 3.22
changes, version 3.23
changes, version 4.0
changes, version 4.1
changes, version 5.0
changing socket location, changing socket location, changing socket location
changing, column
changing, column order
changing, field
changing, table, changing, table, changing, table
character sets, character sets
Character sets
character sets, adding
character-sets-dir
, mysql
option
characters, multi-byte
check options, myisamchk
checking, tables for errors
checksum errors
Chinese
choosing types
choosing, a MySQL version
clearing, caches
client programs, building
client tools
clients, debugging
clients, threaded
closing, tables
ColdFusion program
collating, strings
column names, case-sensitivity
column, changing
columns, changing
columns, displaying
columns, indexes
columns, names
columns, other types
columns, selecting
columns, storage requirements
columns, types
command syntax
command-line history
command-line options, mysql
command-line tool
commands out of sync
commands, for binary distribution
commands, list of
commands, replication
comments, adding
comments, starting
commercial support, types
communications protocols
comparisons, MySQL vs. others
compatibility, between MySQL versions, compatibility, between MySQL versions, compatibility, between MySQL versions, compatibility, between MySQL versions
compatibility, with mSQL
compatibility, with ODBC, compatibility, with ODBC, compatibility, with ODBC, compatibility, with ODBC, compatibility, with ODBC, compatibility, with ODBC, compatibility, with ODBC
compatibility, with Oracle, compatibility, with Oracle, compatibility, with Oracle
compatibility, with PostgreSQL
compatibility, with standard SQL
compatibility, with Sybase
compiler, C++ gcc
compiling, on Windows
compiling, optimising
compiling, problems
compiling, speed
compiling, statically
compiling, user-defined functions
compliance, Y2K
compress
, mysql
option
compressed tables, compressed tables
config-file option
config.cache
config.cache
file
configuration files
configuration options
configure option, --with-low-memory
configure
script
configure
, running after prior invocation
connect_timeout
variable
connecting, remotely with SSH
connecting, to the server, connecting, to the server
connecting, verification
connection, aborted
Connector/J
Connector/ODBC
constant table, constant table
consulting
contact information
contributed programs
contributing companies, list of
contributors, list of
control access
conventions, typographical
converters
converting, tools
copyrights
costs, support
counting, table rows
crackers, security against
crash
crash, recovery
crash, repeated
crash-me
crash-me program, crash-me program
creating, bug reports
creating, databases
creating, default startup options
creating, tables
customer support, mailing address
customers, of MySQL
CVS tree
D
data, character sets
data, importing
data, loading into tables
data, retrieving
data, size
database design
database names, case-sensitivity, database names, case-sensitivity
database, deleting
database
, mysql
option
databases, backups
databases, creating
databases, defined
databases, displaying
databases, dumping, databases, dumping
databases, information about
databases, MySQL vs. others
databases, names
databases, replicating
databases, selecting
databases, symbolic links
databases, using
DataJunction
datatypes, C API
Date and Time types
date calculations
DATE columns, problems
date functions, Y2K compliance
date types
date types, Y2K issues
date values, problems
db
table, sorting
DBI
interface
DBI
Perl module
DBI/DBD
DBUG package
debug-info
, mysql
option
debug
, mysql
option
debugging, client
debugging, server
decimal point
default hostname
default installation location
default options
default values, default values, default values
default values, BLOB
and TEXT
columns
default values, suppression, default values, suppression
default, privileges
default-character-set
, mysql
option
defaults, embedded
delayed_insert_limit
deleting, database
deleting, function
deleting, index, deleting, index
deleting, primary key
deleting, rows
deleting, table
deletion, mysql.sock
Delphi
Delphi program
design, choices
design, issues
design, limitations
developers, list of
development source tree
digits
directory structure, default
disconnecting, from the server
disk full
disk issues
disks, splitting data across
display size
displaying, database information
displaying, information, SHOW
displaying, table status
DNS
downgrading
downloading
dumping, databases, dumping, databases
dynamic table characteristics
E
e-mail lists
Eiffel Wrapper
embedded MySQL server library
employment with MySQL
employment, contact information
enable-named-commands
, mysql
option
entering, queries
ENUM, size
environment variables, environment variables, environment variables, environment variables
environment variables, list of
Errcode
errno
error mesaages, can't find file
error messages, displaying
error messages, languages
errors, access denied
errors, checking tables for
errors, common
errors, directory checksum
errors, handling for UDFs
errors, known
errors, linking
errors, list of
errors, reporting, errors, reporting, errors, reporting
escape characters
estimating, query performance
example option
examples, compressed tables
examples, myisamchk
output
examples, queries
Excel
execute
, mysql
option
expression aliases, expression aliases
expressions, extended
extensions, to standard SQL
extracting, dates
F
fatal signal 11
features of MySQL
field, changing
files, binary log
files, config.cache
files, error messages
files, log, files, log
files, not found message
files, permissions
files, query log
files, repairing
files, script
files, size limits
files, slow query log
files, text
files, tmp
files, update log
files,`my.cnf'
floating-point number
floats
flush tables
force
, mysql
option
foreign key, constraint
foreign keys, foreign keys, foreign keys
free licensing
FreeBSD troubleshooting
full disk
full-text search
FULLTEXT
function, deleting
functions for SELECT
and WHERE
clauses
functions, C API
functions, C Prepared statements API
functions, grouping
functions, native, adding
functions, new
functions, user-definable, adding
functions, user-defined
G
gcc
gdb, using
general information
General Public License
General Public License, MySQL
geographic feature
geometry
geospatial feature
getting MySQL
GIS, GIS
global privileges
goals of MySQL
GPL, General Public License
GPL, GNU General Public License
GPL, MySQL
grant tables
grant tables, re-creating
grant tables, sorting, grant tables, sorting
granting, privileges
GROUP BY
, aliases in
GROUP BY
, extensions to standard SQL, GROUP BY
, extensions to standard SQL
grouping, expressions
H
handling, errors
HEAP
table type
help option
help
, mysql
option
hints, hints, hints, hints, hints
history file
history of MySQL
host
table
host
table, sorting
host
, mysql
option
hostname caching
hostname, default
HP-UX, binary distribution
html
, mysql
option
I
ID, unique
ignore-space
, mysql
option
importing, data
increasing, performance
increasing, speed
index, deleting, index, deleting
indexes
indexes, and BLOB
columns
indexes, and IS NULL
indexes, and LIKE
indexes, and NULL
values
indexes, and TEXT
columns
indexes, block size
indexes, columns
indexes, leftmost prefix of
indexes, multi-column
indexes, multi-part
indexes, names
indexes, use of
InnoDB
table type
InnoDB
tables
INSERT DELAYED
inserting, speed of
installation layouts
installation overview
Installing many servers
installing, binary distribution
installing, Linux RPM packages
installing, Mac OS X PKG packages
installing, overview
installing, Perl
installing, Perl on Windows
installing, source distribution
installing, user-defined functions
integers
internal compiler errors
internal locking
internals
Internet Relay Chat
Internet Service Providers
IRC
ISAM
table type
ISP services
J
Java connectivity
JDBC
jobs at MySQL
K
key space, MyISAM
keys
keys, foreign, keys, foreign
keys, multi-column
keys, searching on two
keywords
known errors
L
language support
last row, unique ID
layout of installation
leftmost prefix of indexes
legal names
LGPL, GNU Lesser General Public License
LGPL, GNU Library General Public License
LGPL, Lesser General Public License
LGPL, Library General Public License
libmysqld
library, mysqlclient
licenses
licensing costs
licensing policy
licensing terms
licensing, contact information
licensing, examples
licensing, free
limitations, design
limits, file-size
linking
linking, errors
linking, problems
linking, speed
links, symbolic
Linux, binary distribution
literals
loading, tables
locking
locking methods
locking, row-level
locking, tables
Log files
log files
log files, maintaining
log files, names
log option
log, changes
logos
M
Mac OS X, installation
mailing address, for customer support
mailing list address
mailing lists
mailing lists, archive location
mailing lists, guidelines
main features of MySQL
maintaining, log files
maintaining, tables
make_binary_distribution
manual, available formats
manual, online location
manual, typographical conventions
master-slave setup
matching, patterns
max memory used
max_allowed_packet
max_join_size
MBR
memory usage, myisamchk
memory use, memory use
MERGE
table type
MERGE tables, defined
messages, languages
methods, locking
Minimum Bounding Rectangle
mirror sites
MIT-pthreads
modes, batch
modules, list of
monitor, terminal
mSQL compatibility
mSQL vs. MySQL, protocol
mSQL, MySQL vs mSQL, overview
msql2mysql
multi mysqld
multi-byte character sets
multi-byte characters
multi-column indexes
multi-part index
multiple servers
My, derivation
`my.cnf' file
MyISAM
table type
MyISAM, compressed tables, MyISAM, compressed tables
MyISAM, size
myisamchk
, myisamchk
myisamchk
, example output
myisamchk
, options
myisampack
, myisampack
, myisampack
MyODBC
MyODBC, reporting problems
mysql
MySQL AB, defined
MySQL binary distribution
MySQL certification
mysql
command-line options
MySQL consulting
MySQL Dolphin name
MySQL history
MySQL mailing lists
MySQL name
MySQL source distribution
MySQL table types
MySQL tools, conversion
MySQL training
MySQL version
MySQL, defined
MySQL, introduction
MySQL, pronunciation
mysql.sock, changing location of
mysql.sock
, protection
mysql_fix_privilege_tables
mysql_install_db
mysql_install_db
script
mysqlaccess
mysqladmin
, mysqladmin
, mysqladmin
, mysqladmin
, mysqladmin
, mysqladmin
, mysqladmin
mysqladmin option
mysqlbinlog
, mysqlbinlog
mysqlbug
mysqlbug
script
mysqlbug
script, location
mysqlclient
library
mysqld
mysqld option
mysqld
options
mysqld options
mysqld
server, buffer sizes
mysqld
, starting
mysqld-max
mysqld_multi
mysqld_safe
mysqldump
, mysqldump
, mysqldump
mysqlimport
, mysqlimport
, mysqlimport
, mysqlimport
mysqlshow
mysqltest, MySQL Test Suite
N
named pipes
names
names, case-sensitivity
names, variables
naming, releases of MySQL
native functions, adding
native thread support
negative values
net etiquette, net etiquette
net_buffer_length
netmask notation, in mysql.user
table
NetWare, NetWare
new procedures, adding
new users, adding
no matching rows
no-auto-rehash
, mysql
option
no-beep
, mysql
option
no-log option
no-named-commands
, mysql
option
no-pager
, mysql
option
no-tee
, mysql
option
non-delimited strings
Non-transactional tables
NOT NULL, constraint
Novell NetWare, Novell NetWare
NULL value
NULL
values, and indexes
NULL
values, vs. empty values
NULL
, testing for null, NULL
, testing for null, NULL
, testing for null, NULL
, testing for null
NULL
values, and AUTO_INCREMENT
columns
NULL
values, and TIMESTAMP
columns
numbers
numeric types
O
ODBC
ODBC compatibility, ODBC compatibility, ODBC compatibility, ODBC compatibility, ODBC compatibility, ODBC compatibility, ODBC compatibility
ODBC, administrator
odbcadmin program
OLEDB
one-database
, mysql
option
online location of manual
Open Source
, defined
open tables, open tables
OpenGIS
opening, tables
opens
OpenSSL
operating systems, file-size limits
operating systems, supported
operating systems, Windows versus Unix
operations, arithmetic
operators, cast, operators, cast
optimisation, tips
optimisations
optimising, DISTINCT
optimising, LEFT JOIN
optimising, LIMIT
optimising, tables
option files
options, command-line
options, command-line, mysql
options, configure
options, myisamchk
options, provided by MySQL
options, replication
Oracle compatibility, Oracle compatibility, Oracle compatibility
ORDER BY
, aliases in
overview
P
pack_isam
pager
, mysql
option
parameters, server
partnering with MySQL AB
password encryption, reversibility of
password option
password, root user
password
, mysql
option
passwords, for users
passwords, forgotten
passwords, resetting
passwords, security
passwords, setting, passwords, setting, passwords, setting
patches, applying
pattern matching
performance, benchmarks
performance, disk issues
performance, estimating
performance, improving, performance, improving
Perl API
Perl DBI/DBD, installation problems
Perl, installing
Perl, installing on Windows
Perl, modules
permission checks, effect on speed
perror
PHP API
port
, mysql
option
portability
portability, types
porting, to other systems
post-install, many servers
post-installation, setup and testing
PostgreSQL compatibility
PostgreSQL vs. MySQL, benchmarks
PostgreSQL vs. MySQL, features
PostgreSQL vs. MySQL, overview
PostgreSQL vs. MySQL, strategies
prices, support
PRIMARY KEY, constraint
primary key, deleting
privilege information, location
privilege system
privilege system, described
privilege, changes
privileges, access
privileges, adding
privileges, default
privileges, display
privileges, granting
privileges, revoking
problems, access denied errors
problems, common errors
problems, compiling
problems, DATE
columns
problems, date values
problems, installing on IBM-AIX
problems, installing on Solaris
problems, installing Perl
problems, linking
problems, ODBC
problems, reporting
problems, starting the server
problems, table locking
problems, timezone
procedures, adding
procedures, stored
process support
processes, display
processing, arguments
products, selling
programs, client
programs, contributed
programs, crash-me
programs, list of, programs, list of
prompt
command
prompt
, mysql
option
prompts, meanings
pronunciation, MySQL
Protocol mismatch
protocol
, mysql
option, protocol
, mysql
option
Python API
Q
queries, entering
queries, estimating performance
queries, examples
queries, speed of
queries, Twin Studeis project
Query Cache
query log
questions
questions, answering
quick
, mysql
option
quotes, in strings
quoting
quoting binary data
quoting strings
R
RAID, compile errors
RAID, table type
raw
, mysql
option
re-creating, grant tables
reconfiguring, reconfiguring
reconnect
, mysql
option
recovery, from crash
reducing, data size
references
regex
regular expression syntax, described
relational databases, defined
release numbers
releases, naming scheme
releases, testing
releases, updating
reordering, columns
repair options, myisamchk
repairing, tables
replace
replication
replication, commands
reporting, bugs
reporting, errors, reporting, errors
reporting, MyODBC problems
reserved words, exceptions
restarting, the server
retrieving, data from tables
return values, UDFs
revoking, privileges
root password
root user, password resetting
rounding errors, rounding errors
rows, counting
rows, deleting
rows, locking
rows, matching problems
rows, selecting
rows, sorting
RPM file
RPM Package Manager
RTS-threads
running a web server
running configure
after prior invocation
running, ANSI mode
running, batch mode
running, multiple servers
running, queries
S
safe-mode
command
safe-updates
, mysql
option
safe_mysqld
Sakila
script files
scripts, scripts, scripts
scripts, mysql_install_db
scripts, mysqlbug
searching, and case-sensitivity
searching, full-text
searching, MySQL web pages
searching, two keys
security system
security, against crackers
SELECT
, Query Cache
select_limit
selecting, databases
selling products
sequence emulation
server administration
server, connecting, server, connecting
server, debugging
server, disconnecting
server, restart
server, shutdown
server, starting
server, starting and stopping
server, starting problems
servers, multiple
services, ISP
services, web
SET, size
set-variable
, mysql
option
setting, passwords
setup, post-installation
shell syntax
showing, database information
shutting down, the server
silent column changes
silent
, mysql
option
size of tables
sizes, display
skip-column-names
, mysql
option
skip-line-numbers
, mysql
option
slow queries
slow query log
socket location, changing
socket
, mysql
option
Solaris installation problems
Solaris troubleshooting
sorting, character sets
sorting, data
sorting, grant tables, sorting, grant tables
sorting, table rows
source distribution, installing
Spatial Extensions in MySQL
speed, compiling
speed, increasing
speed, inserting
speed, linking
speed, of queries, speed, of queries
SQL commands, replication
SQL, defined
SQL-92, extensions to
sql_yacc.cc
problems
square brackets
SSH
SSL and X509 Basics
SSL related options
stability
Standard SQL, differences from
standards compatibility
Starting many servers
starting, comments
starting, mysqld
starting, the server
starting, the server automatically
startup options, default
startup parameters
startup parameters, mysql
startup parameters, tuning
statically, compiling
status
command
status command, results
status, tables
stopping, the server
storage of data
storage requirements, column type
storage space, minimising
stored procedures and triggers, defined
string collating
string comparisons, case-sensitivity
string types
strings, defined
strings, escaping characters
strings, non-delimited
strings, quoting
striping, defined
subSELECT
s
superuser
support costs
support terms
support, for operating systems
support, licensing
support, mailing address
support, types
suppression, default values, suppression, default values
Sybase compatibility
symbolic links, symbolic links
syntax, regular expression
system optimisation
system table
system variables
system, privilege
system, security
T
table aliases
table cache
table is full, table is full
table names, case-sensitivity, table names, case-sensitivity
table types, choosing
table, changing, table, changing, table, changing
table, deleting
table
, mysql
option
tables, BDB
tables, Berkeley DB
tables, changing column order
tables, checking
tables, closing
tables, compressed
tables, compressed format
tables, constant, tables, constant
tables, counting rows
tables, creating
tables, defragment, tables, defragment
tables, defragmenting
tables, deleting rows
tables, displaying
tables, displaying status
tables, dumping, tables, dumping
tables, dynamic
tables, error checking
tables, flush
tables, fragmentation
tables, grant
tables, HEAP
tables, host
tables, improving performance
tables, information
tables, information about
tables, ISAM
tables, loading data
tables, locking
tables, maintenance regimen
tables, maximum size
tables, merging
tables, multiple
tables, names
tables, open
tables, opening
tables, optimising
tables, RAID
tables, repairing
tables, retrieving data
tables, selecting columns
tables, selecting rows
tables, sorting rows
tables, symbolic links
tables, system
tables, too many
tables, unique ID for last row
tables, updating
tar, problems on Solaris
Tcl API
tcp-ip option
TCP/IP
technical support, licensing
technical support, mailing address
tee
, mysql
option
temporary file, write access
temporary tables, problems
terminal monitor, defined
testing mysqld, mysqltest
testing, connection to the server
testing, installation
testing, of MySQL releases
testing, post-installation
testing, the server
Texinfo
TEXT
columns, default values
TEXT
columns, indexing
text files, importing
TEXT
, size
thread packages, differences between
thread support
thread support, non-native
threaded clients
threads, threads
threads, display
threads, RTS
time types
timeout, timeout, timeout
timeout, connect_timeout
variable
TIMESTAMP
, and NULL
values
timezone problems
tips, optimisation
ToDo list for MySQL
TODO, embedded server
TODO, symlinks
tools, command-line
tools, converting
tools, mysqld_multi
tools, mysqld_safe
tools, safe_mysqld
trademarks
training
transaction-safe tables, transaction-safe tables
transactions, support, transactions, support
triggers, stored
troubleshooting, FreeBSD
troubleshooting, Solaris
tutorial
Twin Studies, queries
type conversions
types of support
types, columns, types, columns
types, date
types, Date and Time
types, numeric
types, of tables
types, portability
types, strings
types, time
typographical conventions
U
UCS-2
UDFs, compiling
UDFs, defined
UDFs, return values
unbuffered
, mysql
option
Unicode
unique ID
UNIQUE, constraint
unloading, tables
update log
updating, releases of MySQL
updating, tables
upgrading
upgrading, 3.20 to 3.21
upgrading, 3.21 to 3.22
upgrading, 3.22 to 3.23
upgrading, 3.23 to 4.0
upgrading, 4.0 to 4.1, upgrading, 4.0 to 4.1
upgrading, different architecture
uptime
URLs for downloading MySQL
user names, and passwords
user option
user privileges, adding
user
table, sorting
user variables
user-defined functions, adding, user-defined functions, adding
user
, mysql
option
users, adding
users, root
uses, of MySQL
using multiple disks to start data
UTF-8
utilities
V
valid numbers, examples
VARCHAR
, size
variables, mysqld
variables, status
variables, System
variables, user
variables, values
verbose
, mysql
option
version option
version, choosing
version, latest
version
, mysql
option
vertical
, mysql
option
views
virtual memory, problems while compiling
Visual Basic
W
wait
, mysql
option
web server, running
Well-Known Binary representation
Well-Known Text representation
What is an X509/Certificate?
What is encryption
wildcards, and LIKE
wildcards, in mysql.columns_priv
table
wildcards, in mysql.db
table
wildcards, in mysql.host
table
wildcards, in mysql.tables_priv
table
wildcards, in mysql.user
table
Windows
Windows, compiling on
Windows, open issues
Windows, upgrading
Windows, versus Unix
WKB
WKT
Word program
wrappers, Eiffel
write access, tmp
X
xml
, mysql
option
Y
Year 2000 compliance
Year 2000 issues
Go to the first, previous, next, last section, table of contents.