Go to the first, previous, next, last section, table of contents.
A
aborted clients
aborted connection
access control
access denied errors
access privileges
Access program
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
advertising, contact information
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
ANSI SQL, differences from
ANSI SQL92, extensions to
answering questions, etiquette
Apache
APIs
APIs, Perl
applying, patches
argument processing
arithmetic expressions
authentication tools
AUTO-INCREMENT, ODBC
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
benchmarking, tools
benchmarks
Berkeley_db
table type
Big5 Chinese character encoding
binary distributions
binary distributions, installing
binary distributions, on HP-UX
binary distributions, on Linux
binary log
Binlog_Dump
bit_functions, example
BitKeeper tree
BLOB
columns, default values
BLOB
columns, indexing
BLOB
, inserting binary data
BLOB
, size
books, about MySQL
Borland Builder 4 program
Borland C++ compiler
brackets, square
buffer sizes, client
buffer sizes, mysqld
server
bug reports, criteria for
bug reports, email address
bugs, known
bugs, reporting
building, client programs
C
C API, datatypes
C API, functions
C API, linking problems
C++
C++ APIs
C++ Builder
C++ compiler cannot create executables
C++ compiler, gcc
caches, clearing
calculating, dates
calling sequences, UDF
can't create/write to file
case sensitivity, in access checking
case sensitivity, in searches
case sensitivity, in string comparisons
case sensitivity, of database names
case sensitivity, of table names
case-sensitivity, in names
cast operators
casts
cc1plus
problems
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
changing socket location, changing socket location, changing socket location
changing, column order
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
columns, changing
columns, displaying
columns, indexes
columns, names
columns, other types
columns, selecting
columns, storage requirements
columns, types
command line history, command line history
command line options, mysql
command line tool
command syntax
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, with ANSI SQL
compatibility, with mSQL
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 Sybase
compiler, C++ gcc
compiling, on Windows
compiling, optimizing
compiling, problems
compiling, speed
compiling, statically
compiling, user-defined functions
compliance, Y2K
compress
, mysql
option
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
constant table, constant table
consultants, list of
contact information
Contrib
directory
contributed programs
contributing companies, list of
contributors, list of
control access
conventions, typographical
converters
converting, tools
copyrights
costs, licensing and 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, ISAM table handler
data, loading into tables
data, retrieving
data, size
database design
database names, case sensitivity, database names, case sensitivity
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, 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
dbServ
DBUG package
debug-info
, mysql
option
debug
, mysql
option
debugging, client
debugging, server
decimal point
default hostname
default installation location
default options
default values, BLOB
and TEXT
columns
default values, suppression
default, privileges
default-character-set
, mysql
option
delayed_insert_limit
deleting, rows
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
Eiffel Wrapper
email lists
email, technical support
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
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
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
extended email support
extensions, to ANSI SQL
extracting, dates
F
fatal signal 11
features of MySQL
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 keys, foreign keys, foreign keys
foreign keys, why not implemented
forums, Tek-Tips
free licensing
FreeBSD troubleshooting
full disk
full-text search
FULLTEXT
functionality, missing
functions for SELECT
and WHERE
clauses
functions, C API
functions, grouping
functions, native, adding
functions, new
functions, useful
functions, user-definable, adding
functions, user-defined
G
gcc
gdb, using
general information
General Public License
General Public License, MySQL
getting MySQL
global privileges
goals of MySQL
GPL, General Public License
GPL, GNU General Public License
grant tables
grant tables, re-creating
grant tables, sorting, grant tables, sorting
granting, privleges
GROUP BY
, aliases in
GROUP BY
, extensions to ANSI SQL, GROUP BY
, extensions to ANSI SQL
grouping, expressions
H
handling, errors
HEAP
table type
help option
help
, mysql
option
history file, 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
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, overview
installing, Perl
installing, Perl on Windows
installing, source distribution
installing, user-defined functions
integers
interface builder
internal compiler errors
internal locking
internals
Internet Service Providers
ISAM table handler
ISAM
table type
ISP services
J
Java connectivity
JDBC, 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 Library General Public License
LGPL, Lesser General Public License
libmysqld
library, mysqlclient
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, tables
Log files
log files
log files, maintaining
log files, names
log option
log, changes
login support
M
magazines, online
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
, make_binary_distribution
manual, available formats
manual, online location
manual, typographical conventions
manuals, about MySQL
master-slave setup
matching, patterns
max memory used
max_allowed_packet
max_join_size
memory usage, myisamchk
memory use, memory use
MERGE
table type
MERGE tables, defined
messages, languages
methods, locking
mirror sites
missing functionality
MIT-pthreads
modes, batch
modules, list of
monitor, terminal
mSQL compatibility
mSQL vs. MySQL
msql2mysql
, msql2mysql
multi mysqld
multi-byte characters
multi-column indexes
multi-part index
multibyte character sets
multiple servers
My, derivation
my.cnf
file
MyISAM
table type
MyISAM, compressed tables
myisamchk
, myisamchk
, myisamchk
myisamchk
, example output
myisamchk
, options
myisampack
, myisampack
MyODBC
MyODBC, reporting problems
mysladmn
mysql
MySQL AB, defined
MySQL binary distribution
mysql
command line options
MySQL history
MySQL mailing lists
MySQL name
MySQL source distribution
MySQL table types
MySQL tools, conversion
MySQL usage
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
mysql_install_db
script
mysqlaccess
, mysqlaccess
mysqladmin
, mysqladmin
, mysqladmin
, mysqladmin
, mysqladmin
, mysqladmin
, mysqladmin
mysqladmin option
mysqlbug
, mysqlbug
mysqlbug
script
mysqlbug
script, location
mysqlclient
library
mysqld
, mysqld
mysqld option
mysqld
options
mysqld options
mysqld
server, buffer sizes
mysqld
, starting
mysqld-max
mysqld_multi
mysqldump
, mysqldump
, mysqldump
, mysqldump
mysqlimport
, mysqlimport
, mysqlimport
, mysqlimport
, mysqlimport
mysqlshow
, 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
new procedures, adding
new users, adding
news sites
no matching rows
no-auto-rehash
, mysql
option
no-log option
no-named-commands
, mysql
option
no-pager
, mysql
option
no-tee
, mysql
option
non-delimited strings
Non-transactional tables
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, administrator
odbcadmin program
Old Photo Album
OLEDB
one-database
, mysql
option
online location of manual
online magazines
open source, defined
open tables, open tables
opening, tables
opens
operating systems, file size limits
operating systems, supported
operating systems, Windows versus Unix
operations, arithmetic
operators, cast
optimization, tips
optimizations
optimizing, DISTINCT
optimizing, LEFT JOIN
optimizing, LIMIT
optimizing, tables
option files
options, command line, mysql
options, command-line
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
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
payment information
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
PhoneSweep
PHP API
PHP, web sites
Pluribus
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, overview
PostgreSQL/MySQL, features
PostgreSQL/MySQL, strategies
prices, licensing and support
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
prompts, meanings
pronunciation, MySQL
Protocol mismatch
pwPage
Python APIs
Q
queries, C API results
queries, entering
queries, estimating performance
queries, examples
queries, speed of
queries, Twin Studeis project
query log
questions
questions, answering
quick
, mysql
option
quotes, in strings
quoting
quoting binary data
quoting strings
R
raw
, mysql
option
re-creating, grant tables
reconfiguring, reconfiguring
recovery, from crash
RedHat Package Manager, RedHat Package Manager
reducing, data size
references
regex
regular expression syntax, described
related information URLs
relational databases, defined
release numbers
releases, naming scheme
releases, testing
releases, updating
reordering, columns
repair options, myisamchk
repairing, tables
replace
, replace
replication
replication, commands
replication, two-way
reporting, bugs
reporting, errors, reporting, errors
reporting, MyODBC problems
reserved words, exceptions
restarting, the server
retrieving, data
retrieving, data from tables
return values, UDFs
revoking, privleges
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, defined
RPMs, for common tools
RTS-threads
running configure
after prior invocation
running, a web server
running, ANSI mode
running, batch mode
running, multiple servers
running, queries
S
safe-mode
command
safe-updates
, mysql
option
safe_mysqld
SCMDB
script files
scripts, scripts, scripts
scripts, mysql_install_db
scripts, mysqlbug
search engines, web
searching, and case-sensitivity
searching, full-text
searching, MySQL webpages
searching, two keys
security system
security, against crackers
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
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
speed, compiling
speed, increasing
speed, inserting
speed, linking
speed, of queries, speed, of queries
SQL commands, replication
SQL, defined
sql_yacc.cc
problems
square brackets
SSH
stability
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, minimizing
stored procedures and triggers, defined
storing, data
string collating
string comparisons, case sensitivity
string types
strings, defined
strings, escaping characters
strings, non-delimited
strings, quoting
striping, defined
sub-selects
superuser
support costs
support terms
support, BDB Tables
support, for operating systems
support, InnoDB Tables
support, licensing
support, mailing address
support, types
suppression, default values
Sybase compatibility
symbolic links, symbolic links
syntax, regular expression
system optimization
system table
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
, 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, optimizing
tables, repairing
tables, retrieving data
tables, selecting columns
tables, selecting rows
tables, sorting rows
tables, system
tables, too many
tables, unique ID for last row
tables, updating
tar, problems on Solaris
Tcl APIs
tcp-ip option
TCP/IP
technical support, by email
technical support, licensing
technical support, mailing address
tee
, mysql
option
Tek-Tips forums
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, optimization
ToDo list for MySQL
TODO, symlinks
tools, authentication
tools, benchmarking
tools, command line
tools, converting
tools, mysqld_multi
tools, RPMs for
tools, safe_mysqld
tools, useful
tools,, web
transaction-safe tables
transactions, support
triggers, stored
troubleshooting, FreeBSD
troubleshooting, Solaris
tutorial
Twin Studies, queries
type conversions
types, columns, types, columns
types, date
types, Date and Time
types, numeric
types, of support
types, of tables
types, portability
types, strings
types, time
typographical conventions
U
UDFs, compiling
UDFs, defined
UDFs, return values
unbuffered
, mysql
option
unique ID
Unireg, described
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, different architecture
uptime
URLS for downloading MySQL
URLs to MySQL information
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, of MySQL
users, root
uses, of MySQL
using multiple disks to start data
V
valid numbers, examples
VARCHAR
, size
variables, mysqld
variables, status
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 clients
web pages, miscellaneous
web search engines
web server, running
web sites
web tools
Web+
Webmerger
wild cards, in mysql.columns_priv
table
wild cards, in mysql.db
table
wild cards, in mysql.host
table
wild cards, in mysql.tables_priv
table
wildcards, and LIKE
wildcards, in mysql.user
table
Windows
Windows, compiling on
Windows, open issues
Windows, versus Unix
Word program
wrappers, Eiffel
write access, tmp
Y
Year 2000 compliance
Year 2000 issues
Go to the first, previous, next, last section, table of contents.