MySQL Administrators Guide and Language Reference (2nd Edition)

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]

variable-length blocks

variable-sized records

variables [See also binary logs, options.]

     connect_timeout

    environment [See mysql program, environment variables.]

     max_allowed_packet

     myisamchk

     mysql

     mysqladmin

     mysqlbinlog

     mysqldump

     net_buffer_length

     open_files_limit

     program

     shutdown_timeout

     status

         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

     system

         auto_increment_increment

         auto_increment_offset

         back_log

         basedir

         bdb_cache_size

         bdb_home

         bdb_log_buffer_size

         bdb_logdir

         bdb_max_lock

         bdb_shared_data

         bdb_tmpdir

         binlog_cache_size

         binlog_format

         bulk_insert_buffer_size

         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

         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

         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_delayed_threads

         max_error_count

         max_heap_table_size

         max_insert_delayed_threads

         max_join_size

         max_length_for_sort_data

         max_relay_log_size

         max_seeks_for_key

         max_sort_length

         max_tmp_tables

         max_user_connections

         max_write_lock_count

         multi_read_range

         myisam_data_pointer_size

         myisam_max_extra_sort_file_size

         myisam_max_sort_file_size

         myisam_recover_options

         myisam_repair_threads

         myisam_sort_buffer_size

         myisam_stats_method

         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

         optimizer_search_depth

         pid_file

         port

         preload_buffer_size

         protocol_version

         query_alloc_block_size

         query_cache_limit

         query_cache_min_res_unit

         query_cache_size

         query_cache_type

         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

         sync_frm

         system_time_zone

         table_cache

         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

variables command (mysqladmin)

VC++

verbose option

     myisamchk

     myisampack

     mysql

     mysql_upgrade

     mysqladmin

     mysqlcheck

     mysqld_multi script

     mysqldump

     mysqlimport

     mysqlshow

     perror

verifying

     connections

     package integrity

         cryptographic signatures

         MD5 checksums

         RPM packages

     requests

version command (mysqladmin)

version option

     myisamchk

     myisampack

     mysql

     mysqlaccess

     mysqladmin

     mysqlbinlog

     mysqlcheck

     mysqld

     mysqld_multi script

     mysqldump

     mysqlimport

     mysqlmanager

     mysqlshow

     NDB programs

     perror

version system variable (mysqld)

version_bdb system variable (mysqld)

version_comment system variable (mysqld)

version_compile_machine system variable (mysqld)

version_compile_os system variable (mysqld)

versions

     compatibility

     current

     downgrading

     multi-versioning InnoDB tables

     replication compatibility

     selecting

     upgrading

         5.0

         5.1

         different architectures

vertical bars (|)

vertical option

     mysql

     mysqladmin

viewing

     binary logs

     foreign keys

     MyISAM log files 2nd

     query results

     status variables

     system variables 2nd

     table details

views, updating

Категории