Go to the first, previous, next, last section, table of contents.

Concept Index

  • --with-raid link errors

    • A

  • aborted clients
  • aborted connection
  • access control
  • access denied errors
  • access privileges
  • Access program
  • account privileges, adding
  • accounts, anonymous user
  • accounts, root
  • ACID
  • ACID
  • ACLs
  • ActiveState Perl
  • adding, character sets
  • adding, native functions
  • adding, new account privileges
  • adding, new functions
  • adding, new user privileges
  • adding, new users, adding, new users
  • adding, procedures
  • adding, user-defined 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
  • ALLOW_INVALID_DATES SQL mode
  • altering, database
  • altering, schema
  • anonymous user, anonymous user, anonymous user, anonymous user
  • ANSI mode, running
  • ANSI SQL mode, ANSI SQL mode
  • ANSI_QUOTES SQL mode
  • answering questions, etiquette
  • Apache
  • API's, list of
  • APIs
  • APIs, Perl
  • ARCHIVE storage engine, ARCHIVE storage engine
  • ARCHIVE table type, ARCHIVE table type
  • argument processing
  • arithmetic expressions
  • attackers, security against
  • 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 storage engine, BDB storage engine
  • BDB table type, BDB table type
  • BDB tables
  • benchmark suite
  • benchmarks
  • BerkeleyDB storage engine, BerkeleyDB storage engine
  • BerkeleyDB table type, BerkeleyDB table type
  • Big5 Chinese character encoding
  • binary distributions
  • binary distributions, installing
  • binary distributions, on Linux
  • binary log
  • bit_functions, example
  • BitKeeper tree
  • BLOB columns, default values
  • BLOB columns, indexing, BLOB columns, indexing
  • BLOB, inserting binary data
  • BLOB, size
  • blocking_queries, mysqlcc option
  • 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, data types
  • C API, functions
  • C API, linking problems
  • C Prepared statement API, functions
  • 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 identifiers
  • case sensitivity, in names
  • case sensitivity, in searches
  • case sensitivity, in string comparisons
  • case-sensitivity, in access checking
  • case-sensitivity, of database names
  • case-sensitivity, of table names
  • cast functions
  • 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
  • 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 comments
  • 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, mysql
  • command-line options, mysql
  • command-line options, mysqladmin
  • command-line options, mysqlcc
  • command-line tool
  • commands out of sync
  • commands, for binary distribution
  • commands, replication masters
  • commands, replication slaves
  • comments, adding
  • comments, starting
  • compatibility, between MySQL versions, 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, optimizing
  • compiling, problems
  • compiling, speed
  • compiling, statically
  • compiling, user-defined functions
  • compliance, Y2K
  • compress, mysql option
  • compress, mysqlcc option
  • compressed tables, compressed tables
  • concurrent inserts
  • Conditions
  • config-file, mysqld_multi 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, connect_timeout variable, connect_timeout variable
  • connecting, remotely with SSH
  • connecting, to the server, connecting, to the server
  • connecting, verification
  • connection, aborted
  • connection_name, mysqlcc option
  • Connector/J
  • Connector/JDBC
  • Connector/ODBC, Connector/ODBC
  • Connector/ODBC, reporting problems
  • Connectors, MySQL
  • constant table, constant table
  • contributing companies, list of
  • contributors, list of
  • control access
  • conventions, typographical
  • copying databases
  • copying tables
  • counting, table rows
  • crash
  • crash, recovery
  • crash, repeated
  • crash-me
  • crash-me program, crash-me program
  • creating, bug reports
  • creating, database
  • creating, databases
  • creating, default startup options
  • creating, schema
  • creating, tables
  • CSV storage engine, CSV storage engine
  • CSV table type, CSV table type
  • Cursors
  • customer support, mailing address
  • customers, of MySQL

    • D

  • data types
  • data types, C API
  • data, character sets
  • data, importing
  • data, loading into tables
  • data, retrieving
  • data, size
  • database design
  • database names, case sensitivity
  • database names, case-sensitivity
  • database, altering
  • database, creating
  • database, deleting
  • database, mysql option
  • database, mysqlcc option
  • databases, backups
  • databases, copying
  • databases, creating
  • databases, defined
  • databases, displaying
  • databases, dumping, databases, dumping
  • databases, information about
  • databases, names
  • databases, replicating
  • databases, selecting
  • databases, symbolic links
  • databases, using
  • DataJunction
  • 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
  • DB2 SQL mode
  • DBI interface
  • DBI/DBD interface
  • DBUG package
  • debug-info, mysql option
  • debug, mysql option
  • debugging, client
  • debugging, server
  • decimal point
  • decode_bits myisamchk variable
  • default hostname
  • default installation location
  • default options
  • default values, default values, default values
  • default values, BLOB and TEXT columns
  • default values, implicit
  • default values, suppression
  • DEFAULT, constraint
  • default, privileges
  • default-character-set, mysql option
  • defaults, embedded
  • delayed_insert_limit
  • deleting, database
  • deleting, foreign key, deleting, foreign key
  • deleting, function
  • deleting, index, deleting, index
  • deleting, primary key
  • deleting, rows
  • deleting, schema
  • deleting, table
  • deleting, user, deleting, user
  • deleting, users, deleting, users
  • deletion, mysql.sock
  • Delphi program
  • derived tables
  • 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
  • display width
  • displaying, database information
  • displaying, information, Cardinality
  • displaying, information, Collation
  • displaying, information, SHOW, displaying, information, SHOW, displaying, information, SHOW, displaying, information, SHOW
  • displaying, table status
  • DNS
  • Documenters, list of
  • downgrading
  • downloading
  • dropping, user, dropping, user
  • dumping, databases, dumping, databases
  • dynamic table characteristics

    • E

  • Eiffel Wrapper
  • email lists
  • embedded MySQL server library
  • entering, queries
  • ENUM, size
  • environment variables, environment variables, environment variables
  • environment variables, list of
  • environment varible, PATH
  • Errcode
  • errno
  • error messages, can't find file
  • error messages, displaying
  • error messages, languages
  • ERROR_FOR_DIVISION_BY_ZERO SQL mode
  • 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 storage engine, EXAMPLE storage engine
  • EXAMPLE table type, EXAMPLE table type
  • example, mysqld_multi 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

  • FALSE, testing for
  • fatal signal 11
  • features of MySQL
  • FEDERATED storage engine, FEDERATED storage engine
  • FEDERATED table type, FEDERATED table type
  • field, changing
  • files, binary log
  • files, config.cache
  • files, error messages
  • files, log, files, log
  • files, `my.cnf'
  • 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
  • filesort optimization
  • floating-point number
  • floats
  • flush tables
  • force, mysql option
  • foreign key, constraint
  • foreign key, deleting, foreign key, deleting
  • foreign keys, foreign keys, foreign keys
  • Forums
  • FreeBSD troubleshooting
  • ft_max_word_len myisamchk variable
  • ft_min_word_len myisamchk variable
  • ft_stopword_file myisamchk variable
  • full disk
  • full-text search
  • FULLTEXT
  • function, deleting
  • functions
  • functions for SELECT and WHERE clauses
  • functions, C API
  • functions, C Prepared statement API
  • functions, cast
  • functions, grouping
  • functions, native, adding
  • functions, new
  • functions, user-defined
  • functions, user-defined, adding

    • G

  • gcc
  • gdb, using
  • general information
  • General Public License
  • 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 FLOSS License Exception
  • grant tables
  • grant tables, re-creating
  • grant tables, sorting, grant tables, sorting
  • grant tables, upgrading
  • granting, privileges
  • graphical tool
  • GROUP BY, aliases in
  • GROUP BY, extensions to standard SQL, GROUP BY, extensions to standard SQL
  • grouping, expressions
  • GUI tool

    • H

  • Handlers
  • handling, errors
  • HEAP storage engine, HEAP storage engine
  • HEAP table type, HEAP table type
  • help, mysql option
  • help, mysqlcc option
  • help, mysqld_multi option
  • HIGH_NOT_PRECEDENCE SQL mode
  • hints, hints, hints, hints
  • hints, index, hints, index
  • history of MySQL
  • history_size, mysqlcc option
  • host table
  • host table, sorting
  • host, mysql option
  • host, mysqlcc option
  • hostname caching
  • hostname, default
  • html, mysql option

    • I

  • ID, unique
  • identifiers
  • identifiers, case sensitivity
  • ignore-space, mysql option
  • IGNORE_SPACE SQL mode
  • implicit default values
  • importing, data
  • increasing with replication, speed
  • increasing, performance
  • index hints, index hints
  • index, deleting, index, deleting
  • indexes
  • indexes, and BLOB columns, indexes, and BLOB columns
  • indexes, and IS NULL
  • indexes, and LIKE
  • indexes, and NULL values
  • indexes, and TEXT columns, indexes, and TEXT columns
  • indexes, assigning to key cache
  • indexes, block size
  • indexes, columns
  • indexes, leftmost prefix of
  • indexes, multi-column
  • indexes, multiple-part
  • indexes, names
  • indexes, use of
  • InnoDB
  • InnoDB storage engine, InnoDB storage engine
  • InnoDB table type, InnoDB table type
  • InnoDB tables
  • INSERT DELAYED
  • inserting, speed of
  • installation layouts
  • installation overview
  • 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
  • introducer, string literal, introducer, string literal
  • invalid data, constraint
  • IRC
  • ISAM storage engine, ISAM storage engine
  • ISAM table type, ISAM table type

    • J

  • Java connectivity
  • JDBC

    • K

  • key cache, assigning indexes to
  • Key cache, MyISAM
  • key space, MyISAM
  • key_buffer_size myisamchk variable
  • 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
  • libmysqld
  • libraries, list of
  • library, mysqlclient
  • License
  • limitations, design
  • limitations, replication
  • limits, file-size
  • linking
  • linking, errors
  • linking, problems
  • linking, speed
  • links, symbolic
  • Linux, binary distribution
  • Linux, source distribution
  • literals
  • loading, tables
  • local-infile, mysql option
  • local-infile, mysqlcc option
  • locking
  • locking methods
  • locking, page-level
  • locking, row-level, locking, row-level
  • locking, table-level
  • log files
  • Log files
  • log files, maintaining
  • log files, names
  • log, changes
  • log, mysqld_multi option

    • 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_allowed_packet variable, max_allowed_packet variable
  • max_join_size variable, max_join_size variable
  • MAXDB SQL mode
  • maximum memory used
  • MBR
  • MEMORY storage engine, MEMORY storage engine
  • MEMORY table type, MEMORY table type
  • memory usage, myisamchk
  • memory use, memory use
  • MERGE storage engine, MERGE storage engine
  • MERGE table type, 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
  • msql2mysql
  • MSSQL SQL mode
  • multi mysqld
  • multi-byte character sets
  • multi-byte characters
  • multi-column indexes
  • multiple servers
  • multiple-part index
  • My, derivation
  • `my.cnf' file
  • MyISAM key cache
  • MyISAM storage engine, MyISAM storage engine
  • MyISAM table type, MyISAM table type
  • MyISAM, compressed tables, MyISAM, compressed tables
  • MyISAM, size
  • myisam_block_size myisamchk variable
  • myisamchk, myisamchk
  • myisamchk, example output
  • myisamchk, options
  • myisampack, myisampack, myisampack, myisampack
  • MyODBC
  • MyODBC, reporting problems
  • mysql, mysql
  • MySQL binary distribution
  • mysql command-line options
  • mysql commands, list of
  • MySQL Dolphin name
  • MySQL history
  • mysql history file
  • MySQL mailing lists
  • MySQL name
  • mysql prompt command
  • MySQL source distribution
  • mysql status command
  • MySQL storage engines
  • MySQL table types
  • MySQL version
  • MySQL++
  • MySQL, defined
  • MySQL, introduction
  • MySQL, pronunciation
  • mysql.server
  • mysql.sock, changing location of
  • mysql.sock, protection
  • MYSQL323 SQL mode
  • MYSQL40 SQL mode
  • mysql_config
  • mysql_fix_privilege_tables, mysql_fix_privilege_tables
  • mysql_install_db
  • mysql_install_db script
  • mysqlaccess
  • mysqladmin, mysqladmin, mysqladmin, mysqladmin, mysqladmin, mysqladmin, mysqladmin, mysqladmin
  • mysqladmin command-line options
  • mysqladmin, mysqld_multi option
  • mysqlbinlog, mysqlbinlog
  • mysqlbug
  • mysqlbug script
  • mysqlbug script, location
  • mysqlcc, mysqlcc
  • mysqlcc command-line options
  • mysqlcheck
  • mysqlclient library
  • mysqld
  • mysqld options
  • mysqld options
  • mysqld server, buffer sizes
  • mysqld, starting
  • mysqld-max, mysqld-max
  • mysqld, mysqld_multi option
  • mysqld_multi, mysqld_multi
  • mysqld_safe, mysqld_safe
  • mysqldump, mysqldump, mysqldump
  • mysqlhotcopy
  • mysqlimport, mysqlimport, mysqlimport, mysqlimport
  • mysqlshow
  • mysqltest, MySQL Test Suite

    • N

  • named pipes, named pipes
  • named-commands, mysql option
  • names
  • names, case sensitivity
  • names, variables
  • naming, releases of MySQL
  • native functions, adding
  • native thread support
  • negative values
  • nested queries
  • nested query
  • nesting queries
  • net etiquette, net etiquette
  • net_buffer_length variable, net_buffer_length variable
  • netmask notation, in mysql.user table
  • NetWare
  • new procedures, adding
  • new users, adding, new users, adding
  • no matching rows
  • no-auto-rehash, mysql option
  • no-beep, mysql option
  • no-log, mysqld_multi option
  • no-named-commands, mysql option
  • no-pager, mysql option
  • no-tee, mysql option
  • NO_AUTO_CREATE_USER SQL mode
  • NO_AUTO_VALUE_ON_ZERO SQL mode
  • NO_DIR_IN_CREATE SQL mode
  • NO_FIELD_OPTIONS SQL mode
  • NO_KEY_OPTIONS SQL mode
  • NO_TABLE_OPTIONS SQL mode
  • NO_UNSIGNED_SUBTRACTION SQL mode
  • NO_ZERO_DATE SQL mode
  • NO_ZERO_IN_DATE SQL mode
  • non-delimited strings
  • Non-transactional tables
  • NOT NULL, constraint
  • 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
  • odbcadmin program
  • one-database, mysql option
  • online location of manual
  • ONLY_FULL_GROUP_BY SQL mode
  • Open Source, defined
  • open tables, open tables
  • open_files_limit variable
  • OpenGIS
  • opening, tables
  • opens
  • OpenSSL
  • operating systems, file-size limits
  • operating systems, supported
  • operating systems, Windows versus Unix
  • operations, arithmetic
  • operators
  • operators, cast, operators, cast
  • optimization, tips
  • optimizations, optimizations
  • optimizer, controlling
  • optimizing, DISTINCT
  • optimizing, filesort
  • optimizing, GROUP BY
  • optimizing, LEFT JOIN
  • optimizing, LIMIT
  • optimizing, tables
  • option files, option files
  • options, command-line
  • options, command-line, mysql
  • options, command-line, mysqladmin
  • options, command-line, mysqlcc
  • options, configure
  • options, myisamchk
  • options, provided by MySQL
  • options, replication
  • OR Index Merge optimization
  • Oracle compatibility, Oracle compatibility, Oracle compatibility
  • ORACLE SQL mode
  • ORDER BY, aliases in
  • overview

    • P

  • pack_isam
  • packages, list of
  • page-level locking
  • pager, mysql option
  • parameters, server
  • password encryption, reversibility of
  • password, root user
  • password, mysql option
  • password, mysqlcc option
  • password, mysqld_multi option
  • passwords, for users
  • passwords, forgotten
  • passwords, lost
  • passwords, resetting
  • passwords, security
  • passwords, setting, passwords, setting, passwords, setting
  • PATH environment variable
  • 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
  • permission checks, effect on speed
  • perror
  • perror
  • PHP API
  • PIPES_AS_CONCAT SQL mode
  • plugins_path, mysqlcc option
  • port, mysql option
  • port, mysqlcc option
  • portability
  • portability, types
  • porting, to other systems
  • post-install, multiple servers
  • post-installation, setup and testing
  • PostgreSQL compatibility
  • POSTGRESQL SQL mode
  • PRIMARY KEY, constraint
  • primary key, deleting
  • privilege information, location
  • privilege system
  • privilege system, described
  • privilege, changes
  • privileges, access
  • privileges, adding
  • privileges, default
  • privileges, deleting, privileges, deleting
  • privileges, display
  • privileges, dropping, privileges, dropping
  • 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, time zone
  • procedures, adding
  • procedures, stored, procedures, stored
  • process support
  • processes, display
  • processing, arguments
  • program variables, setting
  • programs, client
  • programs, crash-me
  • programs, list of
  • prompt, mysql option
  • prompts, meanings
  • pronunciation, MySQL
  • Protocol mismatch
  • protocol, mysql option
  • Python API

    • Q

  • queries, entering
  • queries, estimating performance
  • queries, examples
  • queries, speed of
  • queries, Twin Studies project
  • Query Cache
  • query log
  • query, mysqlcc option
  • questions
  • questions, answering
  • quick, mysql option
  • quotes, in strings
  • quoting
  • quoting binary data

    • R

  • RAID, compile errors
  • RAID, table type
  • raw, mysql option
  • re-creating, grant tables
  • read_buffer_size myisamchk variable
  • REAL_AS_FLOAT SQL mode
  • reconfiguring, reconfiguring
  • reconnect, mysql option
  • recovery, from crash
  • reducing, data size
  • references
  • regex
  • register, mysqlcc option
  • regular expression syntax, described
  • relational databases, defined
  • release numbers
  • releases, naming scheme
  • releases, testing
  • releases, updating
  • reordering, columns
  • repair options, myisamchk
  • repairing, tables
  • replace
  • replace utility
  • replication
  • replication limitations
  • replication masters, commands
  • replication options
  • replication slaves, commands
  • reporting, bugs
  • reporting, Connector/ODBC problems
  • 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
  • row-level locking
  • rows, counting
  • rows, deleting
  • rows, locking
  • rows, matching problems
  • rows, selecting
  • rows, sorting
  • RPM file
  • RPM Package Manager
  • RTS-threads
  • running configure after prior invocation
  • running, ANSI mode
  • running, batch mode
  • running, multiple servers
  • running, queries

    • S

  • safe-updates option
  • safe-updates, mysql option
  • safe_mysqld
  • Sakila
  • schema, altering
  • schema, creating
  • schema, deleting
  • script files
  • scripts, scripts
  • scripts, mysql_install_db
  • scripts, mysqlbug
  • scripts, SQL
  • searching, and case sensitivity
  • searching, full-text
  • searching, MySQL Web pages
  • searching, two keys
  • security system
  • security, against attackers
  • SELECT, Query Cache
  • select_limit variable, select_limit variable
  • selecting, databases
  • SEQUENCE
  • sequence emulation
  • sequences
  • server administration
  • server variables, server variables, server variables
  • server, connecting, server, connecting
  • server, debugging
  • server, disconnecting
  • server, restart
  • server, shutdown
  • server, starting
  • server, starting and stopping
  • server, starting problems
  • server, mysqlcc option
  • servers, multiple
  • SET, size
  • setting passwords
  • setting program variables
  • setting, passwords
  • setup, post-installation
  • shell syntax
  • showing, database information
  • shutdown_timeout variable
  • shutting down, the server
  • silent column changes
  • silent, mysql option
  • silent, mysqld_multi 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
  • socket, mysqlcc option
  • Solaris installation problems
  • Solaris troubleshooting
  • sort_buffer_size myisamchk variable
  • sort_key_blocks myisamchk variable
  • sorting, character sets
  • sorting, data
  • sorting, grant tables, sorting, grant tables
  • sorting, table rows
  • source distribution, installing
  • source distributions, on Linux
  • Spatial Extensions in MySQL
  • speed, compiling
  • speed, increasing with replication
  • speed, inserting
  • speed, linking
  • speed, of queries, speed, of queries
  • SQL commands, replication masters
  • SQL commands, replication slaves
  • SQL scripts
  • SQL, defined
  • SQL-92, extensions to
  • sql_yacc.cc problems
  • square brackets
  • SSH
  • SSL and X509 Basics
  • SSL command-line options
  • SSL related options, SSL related options
  • stability
  • Standard SQL, differences from
  • standard SQL, extensions to
  • 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, mysqladmin
  • startup parameters, mysqlcc
  • startup parameters, tuning
  • statically, compiling
  • status command, results
  • status variables, status variables
  • status, tables
  • stopping, the server
  • storage engines, choosing
  • storage of data
  • storage requirements, column type
  • storage space, minimising
  • stored procedures
  • stored procedures and triggers, defined
  • STRICT SQL mode
  • STRICT_ALL_TABLES SQL mode
  • STRICT_TRANS_TABLES SQL mode, STRICT_TRANS_TABLES SQL mode
  • string collating
  • string comparisons, case sensitivity
  • string literal introducer, string literal introducer
  • string replacement, replace utility
  • string types
  • strings, defined
  • strings, escaping characters
  • strings, non-delimited
  • striping, defined
  • subqueries
  • subquery
  • subselects
  • superuser
  • support, for operating systems
  • support, mailing address
  • suppression, default values
  • Sybase compatibility
  • symbolic links, symbolic links
  • syntax, regular expression
  • syntax, mysqlcc option
  • syntax_file, mysqlcc option
  • system optimization
  • system table
  • system variables, system variables, 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 scans, avoiding
  • table types, choosing
  • table, changing, table, changing, table, changing
  • table, deleting
  • table-level locking
  • table, mysql option
  • tables, ARCHIVE
  • tables, BDB
  • tables, Berkeley DB
  • tables, changing column order
  • tables, checking
  • tables, closing
  • tables, compressed
  • tables, compressed format
  • tables, constant, tables, constant
  • tables, copying
  • tables, counting rows
  • tables, creating
  • tables, CSV
  • tables, defragment, tables, defragment
  • tables, defragmenting
  • tables, deleting rows
  • tables, displaying
  • tables, displaying status
  • tables, dumping, tables, dumping
  • tables, dynamic
  • tables, error checking
  • tables, EXAMPLE
  • tables, FEDERATED
  • tables, flush
  • tables, fragmentation
  • tables, grant
  • tables, HEAP
  • tables, host
  • tables, improving performance
  • tables, information
  • tables, information about
  • tables, InnoDB
  • tables, ISAM
  • tables, loading data
  • tables, maintenance regimen
  • tables, maximum size
  • tables, MEMORY
  • tables, MERGE
  • tables, merging
  • tables, multiple
  • tables, MyISAM
  • tables, names
  • tables, open
  • tables, opening
  • tables, optimizing
  • tables, partitioning
  • 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, mysqld_multi option
  • TCP/IP, TCP/IP
  • 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
  • Texinfo
  • TEXT columns, default values
  • TEXT columns, indexing, 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
  • time zone problems
  • timeout, timeout, timeout
  • timeout, connect_timeout variable, timeout, connect_timeout variable, timeout, connect_timeout variable
  • timeout, shutdown_timeout variable
  • TIMESTAMP, and NULL values
  • tips, optimization
  • ToDo list for MySQL
  • TODO, embedded server
  • TODO, symlinks
  • tools, command-line
  • tools, graphical
  • tools, GUI
  • tools, list of
  • tools, mysqld_multi
  • tools, mysqld_safe
  • tools, safe_mysqld
  • TRADITIONAL SQL mode
  • TRADITONAL SQL mode
  • transaction-safe tables, transaction-safe tables
  • transactions, support, transactions, support
  • translations_path, mysqlcc option
  • Translators, list of
  • triggers
  • troubleshooting, FreeBSD
  • troubleshooting, Solaris
  • TRUE, testing for
  • tutorial
  • Twin Studies, queries
  • type conversions
  • types, columns, types, columns
  • types, data
  • 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
  • UNKNOWN, testing for
  • unloading, tables
  • unnamed views
  • 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, different architecture
  • upgrading, grant tables
  • upgrading, to 5.0
  • uptime
  • URLs for downloading MySQL
  • user privileges, adding
  • user privileges, deleting, user privileges, deleting
  • user privileges, dropping, user privileges, dropping
  • user table, sorting
  • user variables
  • user-defined functions, adding, user-defined functions, adding
  • user, mysql option
  • user, mysqlcc option
  • user, mysqld_multi option
  • usernames, and passwords
  • users, adding, users, adding
  • users, deleting, users, deleting
  • users, root
  • uses, of MySQL
  • using multiple disks to start data
  • UTF-8
  • UTF8

    • V

  • valid numbers, examples
  • VARCHAR, size
  • variables, mysqld
  • variables, server, variables, server
  • variables, status, variables, status
  • variables, system, variables, system
  • variables, System
  • variables, user
  • variables, values
  • verbose, mysql option
  • verbose, mysqld_multi option
  • version, choosing
  • version, latest
  • version, mysql option
  • version, mysqlcc option
  • version, mysqld_multi option
  • vertical, mysql option
  • views, views
  • views, updatable, views, updatable
  • virtual memory, problems while compiling
  • Visual Basic

    • W

  • wait, mysql option
  • Well-Known Binary format
  • Well-Known Text format
  • What is an X509/Certificate?
  • What is encryption
  • widths, display
  • 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 format
  • WKT format
  • Word program
  • wrappers, Eiffel
  • write access, tmp
  • write_buffer_size myisamchk variable

    • X

  • xml, mysql option

    • Y

  • Year 2000 compliance
  • Year 2000 issues

    • Go to the first, previous, next, last section, table of contents.