Index
[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
[X]
[Y]
[Z]
safe-mode option (mysqld)
safe-recover option (myisamchk)
safe-show-database option (mysqld) 2nd
safe-updates option (mysql) 2nd
safe-user-create option (mysqld) 2nd
safe_show_database system variable
Sakila
SAP DB
[See features, MaxDB.]
SBR (statement-based replication)
scalability
Scalable Coherent Interface
[See sockets, SCI.]
scans (Cluster)
scheduling table maintenance
SCI (Scalable Coherent Interface)
sockets, configuring
driver installation
network structure
package installation
requirements
testing
Transporters
scripts [See also clients, programs.]
configure
mysqld-max
running after prior invocation
source distribution installations
mysql.server 2nd
mysql_fix_privilege
mysql_install_db 2nd 3rd
mysql_safe
mysql_upgrade 2nd
mysqlbug
mysqld.server
mysqld_multi 2nd 3rd
GNRs
invoking
option file example
options
mysqld_safe 2nd 3rd
editing
NetWare
options
server startup
secondary indexes
Secure Sockets Layer (SSL)
secure-auth option
mysql
mysqld 2nd
secure_auth system variable 2nd
security
ACLs
attackers
Cluster 2nd
data protection
databases
escaping special characters
firewalls
LOAD DATA LOCAL statements
mailing list
mysqld
options
starting
overview
passwords 2nd
privileges
[See accounts, privileges.]
unencrypted data on Internet
Security Options dialog box
SELECT INTO TABLE extension
SELECT privilege
SELECT statements
identifier
query cache
configuring
defragmenting
disabling
functionality
identical queries
incoming queries
maintenance
non-cached queries
options
performance monitoring
status
transactions
variable-length blocks
query speed
type
Select_full_join status variable
Select_full_range_join status variable
select_limit variable
Select_range status variable
Select_range_check status variable
Select_scan status variable
selecting
[See storage engines, choosing.]
selective backups
SendBufferMemory parameter (config.ini file)
SendLimit parameter (config.ini file)
SendSignalId parameter (config.ini file)
SCI section
SHM section
TCP_DEFAULT section
SERIALIZABLE isolation level
Server Type dialog box
server-side programs
server_id system variable 2nd
ServerPort parameter (config.ini file)
servers
auto-reconnect, disabling
connecting 2nd
master
forcing to block updates
multiple-master replication
multiple
client programs
data directory sharing
options
Unix
Windows
mysqld-max 2nd
BDB support
configure options
NDB Cluster support
storage engine support
parameters
restarting
scripts
shutting down
slave
configuring
connections
formats
last statement date
starting
troubleshooting
starting/stopping
Windows installation
selecting
starting as Windows service
starting for first time
starting from command line
Service Options dialog box
Services program
session variables
SET command (mysqlmanager)
SET constraints
SET DEFAULT action
SET NULL action
SET PASSWORD statement
set-auto-increment option (myisamchk)
set-character-set option (myisamchk)
set-charset option (mysqldump)
set-collation option (myisamchk)
setting
[See Cluster, configuring.]
share-nothing architectures
shared-memory connections
shared-memory option (mysqld)
shared-memory-base-name option
multiple servers
mysqld
shared_memory system variable
shared_memory_base_name system variable
SharedBufferSize parameter (config.ini file)
sharing
data across disks
key caches
locks
tablespaces
shell syntax
ShmKey parameter (config.ini file)
ShmSize parameter (config.ini file)
short password hashes
short-form option (mysqlbinlog)
SHOW command
mysqlmanager
ndb_mgm
SHOW DATABASES privilege
SHOW ENGINE INNODB STATUS statement
SHOW INSTANCE OPTIONS command (mysqlmanager)
SHOW INSTANCE STATUS command (mysqlmanager)
SHOW INSTANCES command (mysqlmanager)
SHOW VIEW privilege
show-table-type option (mysqlshow)
show-warnings option (mysql)
shutdown command (mysqladmin) 2nd
SHUTDOWN command (ndb_mgm)
SHUTDOWN privilege
shutdown process
shutdown-delay option (mysqlmanager)
shutdown_timeout variable (mysqladmin)
shutting down
Cluster 2nd
servers
sigint-ignore option (mysql)
signatures
silent option
myisamchk
myisampack
mysql
mysqladmin
mysqlcheck
mysqld_multi script
mysqlimport
perror
single replication channels
single-master replication
single-part indexes 2nd
single-sweep multi-join method
single-transaction option (mysqldump)
single-user mode (Cluster)
size
block buffers
data 2nd
files
InnoDB tables
MyISAM key caches
mysqld buffers
tables
skip-bdb option (mysqld) 2nd
skip-column-names option (mysql)
skip-comments option (mysqldump)
skip-concurrent-insert option (mysqld)
skip-external-locking option (mysqld)
skip-grant-tables option (mysqld) 2nd
skip-host-cache option (mysqld)
skip-innodb option (mysqld)
skip-line-numbers option (mysql)
skip-name-resolve option (mysqld) 2nd
skip-ndbcluster option (mysqld)
skip-networking option (mysqld) 2nd
skip-safemalloc option (mysqld)
skip-show-database option (mysqld) 2nd
skip-slave-start option (replication)
skip-stack-trace option (mysqld)
skip-symbolic-links option (mysqld)
skip-thread-priority option (mysqld)
skip_external_locking system variable (mysqld)
skip_networking system variable (mysqld)
skip_show_database system variable (mysqld)
slave servers
configuring
connections
formats
last statement date
thread states
slave-load-tmpdir option (replication)
slave-net-timeout option (replication)
slave-skip-errors option (replication)
slave_compressed_protocol system variable 2nd 3rd
SLAVE_EVENT event
slave_load_tmpdir system variable (mysqld)
slave_net_timeout system variable 2nd
Slave_open_temp_tables status variable
Slave_retried_transactions status variable
Slave_running status variable
slave_skip_errors system variable
slave_transaction_retries system variable 2nd
sleep option (mysqladmin)
Sleepycat Web site
slow logs 2nd
slow queries
Slow_launch_threads status variable
slow_launch_time system variable 2nd
Slow_queries status variable
socket option
multiple servers
mysql
mysqladmin
mysqlbinlog
mysqlcheck
mysqld
mysqld_safe
mysqldump
mysqlhotcopy
mysqlimport
mysqlmanager
mysqlshow
socket system variable (mysqld)
sockets
location 2nd
SCI
software
[See clients, programs.]
Solaris x86_64 issues
Solaris, troubleshooting
sort-index option (myisamchk)
sort-records option (myisamchk)
sort-recover option (myisamchk)
sort-union access algorithm
sort_buffer_size system variable
myisamchk
mysqld
sort_key_blocks system variable
Sort_merge_passes status variable
Sort_range status variable
Sort_rows status variable
Sort_scan status variable
sorting
character sets
db tables
grant tables 2nd
host tables
source distributions
commands
installing
compiling problems
configure script
development source tree
MIT-pthreads
overview
Windows
Windows
spassword option (mysqlaccess)
speed
compiling
deleting
increasing with replication
inserting
linking
optimization tips
permission checks effect on
queries
[See queries, ; speed.]
UPDATE statements
split brain scenario
SQL (Structured Query Language)
extensions
modes 2nd
ALLOW_INVALID_DATES
ANSI 2nd
ANSI_QUOTES
DB2
default
ERROR_FOR_DIVISION_BY_ZERO
IGNORE_SPACE
MAXDB
MSSQL
MYSQL323
MYSQL40
mysqld
NO_AUTO_CREATE_USER
NO_AUTO_VALUE_ON_ZERO
NO_BACKSLASH_ESCAPES
NO_DIR_IN_CREATE
NO_FIELD_OPTIONS
NO_KEY_OPTIONS
NO_TABLE_OPTIONS
NO_UNSIGNED_SUBTRACTION
NO_ZERO_DATE
NO_ZERO_IN_DATE
ONLY_FULL_GROUP_BY
ORACLE
PIPES_AS_CONCAT
POSTGRESQL
REAL_AS_FLOAT
STRICT 2nd
STRICT_ALL_TABLES
STRICT_TRANS_TABLES 2nd
TRADITIONAL 2nd
nodes
accessing
configuring
defined
installing
queries, running
standards, differences with MySQL
atomic operations
comments
foreign keys
SELECT INTO TABLE extension
stored procedures
subqueries
transactions
triggers
views
statements, executing
SQL-92
sql-mode option (mysqld)
SQL:1999
SQL:2003
sql_auto_is_null dynamic system variable
sql_big_selects dynamic system variable
sql_big_tables dynamic system variable
sql_buffer_result dynamic system variable
SQL_CACHE option
sql_log_bin dynamic system variable
sql_log_off dynamic system variable
sql_log_update dynamic system variable
sql_low_priority_updates dynamic system variable
sql_max_join_size dynamic system variable
sql_mode system variable 2nd
SQL_NO_CACHE option
sql_notes dynamic system variable
sql_quote_show_create dynamic system variable
sql_safe_updates dynamic system variable
sql_select_limit dynamic system variable
sql_slave_skip_counter system variable 2nd
sql_warnings dynamic system variable
square brackets ([ ])
SSH
clients
remote connections
SSL (Secure Sockets Layer)
ssl option
SSL protocol
certificates, configuring
OpenSSL
options
overview
yaSSL
Ssl status variable
ssl-ca option
ssl-capath option
ssl-cert option
ssl-cipher option
ssl-key option
stability
standalone options
mysqld
mysqlmanager
standard MySQL clients
standard SQL
differences with MySQL
atomic operations
comments
foreign keys
SELECT INTO TABLE extension
stored procedures
subqueries
transactions
triggers
views
extensions
standards compatibility 2nd
atomic operations
comments
foreign keys 2nd
SELECT INTO TABLE extension
stored procedures
subqueries
transactions
triggers
views
START command (ndb_mgm)
START INSTANCE command (mysqlmanager)
start-datetime option (mysqlbinlog)
start-position option (mysqlbinlog)
start-slave command (mysqladmin)
START_EVENT_V3 event
StartFailureTimeout parameter (config.ini file)
starting
Cluster 2nd 3rd
initialization
modes
stages
startup events
comments
data
MySQL Configuration Wizard
MySQL Installation Wizard
mysqld
mysqld.server
mysqld_multi
mysqld_safe
mysqlmanager
normal user
ndb_mgm
ndbd
nodes
options
BDB storage engine
InnoDB storage engine
servers
as Windows service
automatically
command line
first time
troubleshooting
StartPartialTimeout parameter (config.ini file)
StartPartitionedTimeout parameter (config.ini)
startup events
startup parameters
mysqladmin
character-sets-dir
compress
count
debug
default-character-set
force
help
host
password
port
protocol
relative
silent
sleep
socket
user
verbose
version
vertical
wait
tuning
statement-based replication (SBR) 2nd
statements
CREATE TABLE 2nd
DELETE
EXPLAIN
ALL joins
column length mismatches
condition pushdowns
constant tables
distinct values
eq_ref tables
EXTENDED keyword
Extra column
filesorts
index joins
index scans
index_merge joins
index_subquery join
indexes
join types
keys
LEFT JOIN
multiple-table joins
number of rows
possible_keys column
queries
[See queries, ; speed.]
ranges
ref column
ref tables
ref_or_null joins
SELECT statement identifier
SELECT statement type
system tables
tables
temporary tables
unique_subquery join
WHERE clause
GRANT
accounts, creating
privileges
INSERT
concurrent 2nd
grant privileges
speed
LOAD DATA LOCAL
LOAD INDEX INTO CACHE
REVOKE
SELECT
identifier
query cache
query speed
type
SET PASSWORD
SHOW ENGINE INNODB STATUS
SQL
UPDATE
static tables
statically compiling
statistics events (Cluster)
stats_method system variable
status command
mysql
mysqladmin
STATUS command (ndb_mgm)
status files (replication)
status option (mysqlshow)
status variables
Aborted_clients
Aborted_connects
Binlog_cache_disk_use
Binlog_cache_use
Bytes_received
Bytes_sent
Com
Compression
Connections
Created_tmp_disk_tables
Created_tmp_files
Created_tmp_tables
Delayed_errors
Delayed_insert_threads
Delayed_writes
Flush_commands
Handler_commit
Handler_delete
Handler_discover
Handler_read_first
Handler_read_key
Handler_read_next
Handler_read_prev
Handler_read_rnd
Handler_read_rnd_next
Handler_rollback
Handler_update
Handler_write
Innodb_buffer_pool_pages_data
Innodb_buffer_pool_pages_dirty
Innodb_buffer_pool_pages_flushed
Innodb_buffer_pool_pages_free
Innodb_buffer_pool_pages_latched
Innodb_buffer_pool_pages_misc
Innodb_buffer_pool_pages_total
Innodb_buffer_pool_read_ahead_rnd
Innodb_buffer_pool_read_ahead_seq
Innodb_buffer_pool_read_requests
Innodb_buffer_pool_reads
Innodb_buffer_pool_wait_free
Innodb_buffer_pool_write_requests
Innodb_data_fsyncs
Innodb_data_pending_fsyncs
Innodb_data_pending_reads
Innodb_data_pending_writes
Innodb_data_read
Innodb_data_reads
Innodb_data_writes
Innodb_data_written
Innodb_dblwr_pages_written
Innodb_dblwr_writes
Innodb_log_waits
Innodb_log_write_requests
Innodb_log_writes
Innodb_os_log_fsyncs
Innodb_os_log_pending_fsyncs
Innodb_os_log_pending_writes
Innodb_os_log_written
Innodb_page_size
Innodb_pages_created
Innodb_pages_read
Innodb_pages_written
Innodb_row_lock_current_waits
Innodb_row_lock_time
Innodb_row_lock_time_avg
Innodb_row_lock_time_max
Innodb_row_lock_waits
Innodb_rows_deleted
Innodb_rows_inserted
Innodb_rows_read
Innodb_rows_updated
Key_blocks_not_flushed
Key_blocks_unused
Key_blocks_used
Key_read_requests
Key_reads
Key_write_requests
Key_writes
Last_query_cost
Max_used_connections
Not_flushed_delayed_rows
Open_files
Open_streams
Open_tables
Opened_tables
Qcache_free_blocks
Qcache_free_memory
Qcache_hits
Qcache_inserts
Qcache_lowmem_prunes
Qcache_not_cached
Qcache_queries_in_cache
Qcache_total_blocks
Questions
Rpl_status
Select_full_join
Select_full_range_join
Select_range
Select_range_check
Select_scan
Slave_open_temp_tables
Slave_retried_transactions
Slave_running
Slow_launch_threads
Slow_queries
Sort_merge_passes
Sort_range
Sort_rows
Sort_scan
Ssl
Table_locks_immediate
Table_locks_waited
Threads_cached
Threads_connected
Threads_created
Threads_running
Uptime
viewing
STOP command (ndb_mgm)
STOP INSTANCE command (mysqlmanager)
stop-datetime option (mysqlbinlog)
stop-position option (mysqlbinlog)
stop-slave command (mysqladmin)
STOP_EVENT event
StopOnError parameter (config.ini file)
stopping
Cluster
servers
storage
data
host
in-memory
indexes
minimizing
MyISAM
formats
tables
privilege information 2nd
transactions
storage engines
ARCHIVE 2nd
BDB
characteristics
installing
mysqld-max support
operating systems supported
overview
restrictions
startup options
troubleshooting
BLACKHOLE 2nd
choosing
Cluster supported
CSV 2nd
EXAMPLE 2nd
FEDERATED
flow of information
forum
functionality
limitations
overview
tables, creating
InnoDB
[See configuring, InnoDB storage engine.]
MEMORY
characteristics
forum
overview
tables, creating
MERGE
advantages
disadvantages
forum
overview
problems
queries, issuing
remapping
tables, creating
MyISAM
automatic recovery
characteristics
corrupted tables
forum
key caches
key space
maintenance
overview
startup options
storage 2nd
system variables
tables not closed properly
mysqld-max support
NDB Cluster
[See enabling, NDB Cluster storage engine.]
node process
[See log files, ndbd.]
storage nodes 2nd
backups
boolean values
buffering
checkpointing
defined
disk paging
identifying
intervals
logging 2nd
memory
metadata objects
multiple
scans/buffering
temporary storage
timeouts
transactions
storage_engine system variable 2nd
stored procedures
stored routines
Strict Mode Options dialog box
STRICT SQL mode 2nd
STRICT_ALL_TABLES SQL mode
STRICT_TRANS_TABLES SQL mode 2nd
strings
collating
replacing
striping
Structured Query Language
[See nodes, SQL.]
structured system variables
subqueries
subscribing, mailing lists
suffix option (mysqlhotcopy)
SUPER privilege
Super Smack
superuser option (mysqlaccess)
superusers
support
autodiscovery (NDBCluster)
BDB 2nd
data types
debugging
forums
IRC
mailing lists
answering questions
Cluster
guidelines
listing of
MaxDB
MySQL security
net etiquette
non-English
subscribing/unsubscribing
MaxDB
native threads
NDB Cluster
NetWare
non-native threads
operating systems 2nd
storage engines
TCP/IP
time zones
transactions
suppressing default values
symbolic links
symbolic-links option (mysqld)
sync-bdb-logs option (mysqld)
sync_binlog system variable
InnoDB tables
mysqld
sync_frm system variable 2nd
Synchronization Manager (MaxDB)
system
bottlenecks
finding
sources
crashes
errors
optimization
restarts
security
ACLs
attackers
data protection
databases
escaping special characters
firewalls
LOAD DATA LOCAL statements
mysqld
overview
passwords
privileges
restart mode (Cluster)
unencrypted data on Internet
tables
EXPLAIN statements
testing/repairing
upgrading
system variables
auto_increment_increment 2nd
auto_increment_offset 2nd
back_log
basedir
bdb_cache_size
bdb_home
bdb_log_buffer_size
bdb_logdir
bdb_max_lock
bdb_shared_data
binlog_cache_size
binlog_format
bulk_insert_buffer_size 2nd
character_set_client
character_set_connection
character_set_database
character_set_filesystem
character_set_results
character_set_server
character_set_system
character_sets_dir
collation_connection
collation_database
collation_server
completion_type
concurrent_insert
connect_timeout
datadir
date_format
datetime_format
dbd_tmpdir
default
default_week_format
delay_key_write
delayed_insert_limit
delayed_insert_timeout
delayed_queue_size
div_precision_increment
dynamic
enabling/disabling 2nd
engine_condition_pushdown
expire_logs_days
flush
flush_time
ft_boolean_syntax
ft_max_word_len
ft_min_word_len
ft_query_expansion_limit
ft_stopword_file
global
group_concat_max_len
have_archive
have_bdb
have_blackhole_engine
have_compress
have_crypt
have_csv
have_example_engine
have_geometry
have_innodb
have_isam
have_ndbcluster
have_openssl
have_query_cache
have_raid
have_row_based_replication
have_rtree_keys
have_symlink
init_connect
init_file
init_slave
innodb
InnoDB storage engine
innodb_additional_mem_pool_size
innodb_autoextend_increment
innodb_buffer_pool_awe_mem_mb
innodb_buffer_pool_size
innodb_checksums
innodb_commit_concurrency
innodb_concurrency_tickets
innodb_data_file_path
innodb_data_home_dir
innodb_doublewrite
innodb_fast_shutdown
innodb_file_io_threads
innodb_file_per_table
innodb_flush_log_at_trx_commit
innodb_flush_method
innodb_force_recovery
innodb_lock_wait_timeout
innodb_locks_unsafe_for_binlog
innodb_log_arch_dir
innodb_log_archive
innodb_log_buffer_size
innodb_log_file_size
innodb_log_files_in_group
innodb_log_group_home_dir
innodb_max_dirty_pages_pct
innodb_max_purge_lag
innodb_mirrored_log_groups
innodb_open_files
innodb_safe_binlog
innodb_support_xa
innodb_sync_spin_loops
innodb_table_locks
innodb_thread_sleep_delay
interactive_timeout
join_buffer_size
key_buffer_size
key_cache_age_threshold
key_cache_block_size
key_cache_division_limit
language
large_file_support
large_pages
license
local_infile
locked_in_memory
log
log_bin
log_bin_trust_function_creators
log_bin_trust_routine_creators
log_error
log_slave_updates
log_slow_queries
log_warnings
long_query_time
low_priority_updates
lower_case_file_system
lower_case_table_names
max_allowed_packet
max_binlog_cache_size
max_binlog_size
max_connect_errors
max_connections
MAX_CONNECTIONS_PER_HOUR
max_delayed_threads
max_error_count
max_heap_table_size
max_insert_delayed_threads
max_join_size
max_length_for_sort_data
MAX_QUERIES_PER_HOUR
max_relay_log_size
max_seeks_for_key
max_sort_length
max_tmp_tables
MAX_UPDATES_PER_HOUR
max_user_connections 2nd
max_write_lock_count
multi_read_range
MyISAM tables
myisam_data_pointer_size
myisam_max_extra_sort_file_size 2nd
myisam_max_sort_file_size 2nd
myisam_recover_options
myisam_repair_threads
myisam_sort_buffer_size 2nd
myisam_stats_method 2nd
mysqld
named_pipe
net_buffer_length
net_read_timeout
net_retry_count
net_write_timeout
new
old_passwords
one_shot
open_files_limit
optimizer_prune_level 2nd
optimizer_search_depth 2nd
pid_file
port
preload_buffer_size
protocol_version
query_alloc_block_size
query_cache_limit 2nd
query_cache_min_res_unit 2nd
query_cache_size 2nd
query_cache_type 2nd
query_cache_wlock_invalidate
query_prealloc_size
range_alloc_block_size
read_buffer_size
read_only
read_rnd_buffer_size
relay_log_purge
secure_auth
server_id
session
shared_memory
shared_memory_base_name
skip_external_locking
skip_networking
skip_show_database
slave_compressed_protocol
slave_load_tmpdir
slave_net_timeout
slave_skip_errors
slave_transaction_retries
slow_launch_time
socket
sort_buffer_size
sql_mode
sql_slave_skip_counter
storage_engine
structured
sync_binlog 2nd
sync_frm
system_time_zone
table_cache 2nd
table_type
thread_cache_size
thread_concurrency
thread_stack
time_format
time_zone
tmp_table_size
tmpdir
transaction_alloc_block_size
transaction_prealloc_size
tx_isolation
updatable_views_with_limit
values
version
version_bdb
version_comment
version_compile_machine
version_compile_os
viewing 2nd
wait_timeout
system_time_zone system variable (mysqld)
|
