S

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)