-ALTER DATABASE Syntax”DECIMAL Data Type Changes”GRANT Syntax”-# [debug_options]-# [debug_options]-# debug_options-#debug_options--Information--abort-slave-event-count--add-drop-database--add-drop-table--add-drop-trigger--add-locks--addtodest--all-databasesndbinfo MySQL Cluster Information Database”--all-in-1--all-tablespaces--allow-keywords--allow-suspicious-udfs--allowold--analyze--apply-slave-statements--auto-generate-sql--auto-generate-sql-add-autoincrement--auto-generate-sql-execute-number=N--auto-generate-sql-guid-primary--auto-generate-sql-load-type=type--auto-generate-sql-secondary-indexes=N--auto-generate-sql-unique-query-number=N--auto-generate-sql-unique-write-number=N--auto-generate-sql-write-number--auto-generate-sql-write-number=N--auto-repair--auto-vertical-output--autoclose--autocommit=0--base64-output--base64-output=ALWAYS--base64-output=AUTO--base64-output=DECODE-ROWS--base64-output=NEVER--base64-output[=value]--basedir--basedir=path--bdb-logdir--bdb-logdir=file_name--bdb-no-recover--bdb-shared-data--bdb-tmpdir=path--big-tables--bind-address--bind-address=127.0.0.1--bind-address=IP--bind-address=ip_address--binlog-checksum={NONE|CRC32}--binlog-do-db--binlog-do-db=db1--binlog-do-db=db_name--binlog-do-db=mysql--binlog-do-db=sales--binlog-format--binlog-format=MIXED--binlog-format=ROW--binlog-format=STATEMENT--binlog-format=type--binlog-format={ROW|STATEMENT|MIXED}--binlog-ignore-db--binlog-ignore-db=db_name--binlog-ignore-db=mysql--binlog-ignore-db=sales--binlog-row-event-max-size--binlog-row-event-max-size=N--binlog-rows-query-log-events--binlog_format=STATEMENT--block-search=offset--bootstrap--brief--character-set-client-handshake--character-set-filesystem=charset_name--character-set-server--character-set-server=charset_name--character-set-server=latin1--character-sets-dir--character-sets-dir=path--character_set_server--charset=path--check-only-changed--check-upgrade--checkpoint--checkpoint=db_name.tbl_name--chroot--chroot=path--collation-server--collation-server=collation_name--collation-server=latin1_swedish_ci--collation_server--column-type-info--columns=column_list--comments--commit--commit=N--compact--compatible--compatible=name--compatible=oracle--complete-insert--compress--concurrency=N--config-cache--config-file--config-file=file_name--config-file=path_name--consoleInnoDB General Troubleshooting”SHOW ENGINE INNODB
STATUS and the InnoDB Monitors”InnoDB Tablespace”--copy--core-file-size--core-file-size=size--correct-checksum--count--count=N--create--create-and-drop-schema--create-and-drop-schema=value--create-options--create-schema=value--create=value--csv[=file_name]--daemon--data-file-length=len--database--database=db_name--databasesndbinfo MySQL Cluster Information Database”--datadir--datadir=path--db=db_name--debug--debug-check--debug-info--debug-sync-timeout=N--debug-sync-timeout[=N]--debug="..."--debug="d,parser_debug"--debug=+P--debug=N--debug=T--debug=d,general,query--debug=debug_options--debug[=debug_options]--default-auth--default-auth=plugin--default-auth=plugin_name--default-character-setLOAD DATA INFILE
Syntax”--default-character-set=charset_name--default-character-set=latin1--default-character-set=system_character_set--default-character-set=utf8--default-collation--default-collation=collation_name--default-storage-engineInnoDB Startup Options and System Variables”InnoDB”--default-storage-engine=type--default-table-type--default-table-type=type--default-time-zone--default-time-zone=timezone--default.key_buffer_size=256K--defaults-extra-file--defaults-extra-file=file_name--defaults-extra-file=path--defaults-fileInnoDB”--defaults-file=file_name--defaults-group-suffix--defaults-group-suffix=_other--defaults-group-suffix=str--defaults-group-suffix=suffix--delay-key-write--delay-key-write-for-all-tables--delay-key-write=ALL--delay-key-write=OFF--delay-key-write[={OFF|ON|ALL}]--delay_key_write=1--delay_key_write=ON--delayed-insert--delete--delete-master-logs--delimiter--delimiter=str--demangle--des-key-file--des-key-file=file_name--description--detach=N--disable-auto-rehash--disable-community-features--disable-debug-sync--disable-grant-options--disable-keys--disable-log-bin--disable-named-commands--disable-plugin_name--disable-profiling--disable-shared--disconnect-slave-event-count--dryrun--dump--dump-date--dump-slave--dump-slave[=value]--embedded--enable-community-features--enable-debug-sync--enable-local-infile--enable-named-pipe--enable-plugin_name--enable-profiling--enable-thread-safe-client--engine-condition-pushdown=1--engine=engine_name--event-scheduler--event-scheduler=DISABLED--event-scheduler[=value]--events--example--execute--execute=statement--exit-info[=flags]--extend-check--extended--extended-insert--external-locking--extra-file=file_name--federated--fields-enclosed-by--fields-enclosed-by=...--fields-enclosed-by=char--fields-escaped-by=...--fields-escaped-by=char--fields-optionally-enclosed-by=...--fields-optionally-enclosed-by=char--fields-terminated-by=...--fields-terminated-by=str--fields-xxx--first-slave--fix-db-names--fix-table-names--flush--flush-logs--flush-privileges--flush_time=val--flushlog--force--force-read--foreground--general-log--general-log[={0|1}]--general_log--general_log[={0|1}]--general_log_file--general_log_file=file_name--header_file=file_name--help--hex-blob--host=
Sign”--host=127.0.0.1--host=host_name--host=localhost--howto--i-am-a-dummy--ignore--ignore-builtin-innodb--ignore-db-dir--ignore-db-dir=--ignore-db-dir=dir_name--ignore-db-dir=lost+found--ignore-lines=N--ignore-spaces--ignore-table=db_name.tbl_name--in_file=file_name--include--include-master-host-port--info--information--init-fileMEMORY Storage Engine”--init-file=file_name--init-rpl-role--init_connect="SET NAMES 'utf8'"--initial--initial-start--innodb-autoinc-lock-mode--innodb-safe-binlog--innodb-status-file--innodb-status-file=1--innodb-xxx--innodb=OFF--innodb[=value]--innodb_checksums--innodb_file_per_table--innodb_locks_unsafe_for_binlog--innodb_rollback_on_timeout--innodb_support_xa--insert-ignore--install--install [service_name]--install-manual--install-manual [service_name]--install[=name]--iterations=N--join=big_tbl_name--keep_files_on_create--keepold--key_buffer_size=32M--keys--keys-used=val--language--language=lang_name, -L lang_name--large-pages--lc-messages--lc-messages-dir--lc-messages-dir=path--lc-messages=locale_name--ldata=path--ledir--ledir=path--length--libmysqld-libs--libs--libs_r--line-numbers--lines-terminated-by--lines-terminated-by="\r\n"--lines-terminated-by=...--lines-terminated-by=str--local--local-infile--local-infile=0--local-infile=1--local-infile=OFF--local-infile[=1]--local-infile[={0|1}]--local-load--local-load=path--local-service--lock-all-tables--lock-directory--lock-directory=path--lock-tables--log--log-binCHANGE MASTER TO Syntax”PURGE BINARY LOGS Syntax”--log-bin-index[=file_name]--log-bin-trust-function-creators--log-bin-trust-function-creators=1--log-bin-trust-function-creators[={0|1}]--log-bin-trust-routine-creators--log-bin-trust-routine-creators=1--log-bin-trust-routine-creators[={0|1}]--log-bin-use-v1-events--log-bin-use-v1-row-events--log-bin-use-v1-row-events[={0|1}]--log-bin=base_name.extension--log-bin=log_name--log-bin=old_host_name-bin--log-bin[=base_name]--log-bin[=file_name]--log-error--log-error my-errors--log-error=file_name--log-error[=file_name]--log-isam[=file_name]--log-output--log-output=TABLE--log-output=TABLE,FILE--log-output[=value,...]--log-queries-not-using-indexes--log-raw--log-short-format--log-slave-updates--log-slow-admin-statements--log-slow-queries--log-slow-queries[=file_name]--log-slow-slave-statements--log-tc-size--log-tc-size=size--log-tc=file_name--log-update--log-warnings--log-warnings=0--log-warnings=2--log-warnings[=level]--log=file_name--log[=file_name]--loose--loose-opt_name--loose-skip-innodb--low-priority--low-priority-updates--lower-case-table-names=0--malloc-lib--malloc-lib=--malloc-lib=/path/to/some/library--malloc-lib=[lib_name]--malloc-lib=tcmalloc--master-connect-retry--master-connect-retry=seconds--master-data--master-data=2--master-data[=value]--master-host--master-host=host_name--master-info-file--master-info-file=file_name--master-info-repository--master-info-repository=TABLE--master-info-repository={FILE|TABLE}--master-password--master-password=password--master-port--master-port=port_number--master-retry-count--master-retry-count=count--master-ssl--master-ssl*--master-ssl-ca--master-ssl-ca=file_name--master-ssl-capath--master-ssl-capath=directory_name--master-ssl-cert--master-ssl-cert=file_name--master-ssl-cipher--master-ssl-cipher=cipher_list--master-ssl-key--master-ssl-key=file_name--master-user--master-user=user_name--master-verify-checksum={0|1}--master-xxx--max-binlog-dump-events=N--max-binlog-size--max-record-length--max-record-length=len--max-relay-log-size--max-relay-log-size=size--max-seeks-for-key=1000--max_connect_errors=999999999--max_join_size--maximum-query_cache_size=32M--maximum-query_cache_size=4M--maximum-var_name=value--medium-check--memlock--method=command--min-examined-row-limit=number--my-plugin=ON--my-print-defaults=path--my_plugin=ON--myisam-block-size--myisam-block-size=N--myisam-recoverMyISAM Startup Options”MyISAM Table Maintenance Schedule”MyISAM Storage Engine”--myisam-recover-optionsMyISAM Startup Options”MyISAM Queries”MyISAM Table Maintenance Schedule”MyISAM Storage Engine”--myisam-recover-options=BACKUP,FORCE--myisam-recover-options=mode--myisam-recover-options[=option[,option]...]]--myisam-recover=BACKUP,FORCE--myisam-recover=mode--myisam-recover[=option[,option]...]]--mysqladmin=prog_name--mysqld-version--mysqld-version=debug--mysqld-version=suffix--mysqld=mysqld_safe--mysqld=path--mysqld=prog_name--name_file=file_name--named-commands--ndb--ndb-batch-size=#--ndb-blob-read-batch-bytes=bytes--ndb-blob-write-batch-bytes=bytes--ndb-cluster-connection-pool--ndb-cluster-connection-pool=#--ndb-cluster-connection-pool=4--ndb-connectstring--ndb-connectstring=connect_string--ndb-connectstring=management_host--ndb-force-send=1--ndb-index-stat-enable=0--ndb-log-apply-status--ndb-log-empty-epochs--ndb-log-empty-epochs=0--ndb-log-empty-epochs=1--ndb-log-empty-epochs=[0|1]--ndb-log-transaction-id--ndb-log-update-as-write--ndb-log-update-as-write=0--ndb-log-update-as-write=OFF--ndb-log-updated-only--ndb-nodeid=#--ndb-use-exact-count=0--ndb-wait-connected=seconds--ndb-wait-setup=seconds--ndb_optimization_delay=milliseconds--ndb_optimized_node_selection--ndbclusterSHOW ENGINES Syntax”ndbinfo MySQL Cluster Information Database”--ndbcluster --ndb-connectstring=management_host--ndbinfo-database=name--ndbinfo-table-prefix--nice=priority--no-auto-rehash--no-autocommit--no-beep--no-create-db--no-defaults--no-log--no-named-commands--no-set-names--no-symlinks--no-tablespaces--nodaemon--noindices--nowait-nodes--nowait-nodes=3--nowait-nodes=3,5--nowait-nodes=node_id_1[, node_id_2[, ...]]--number-char-cols=N--number-int-cols=N--number-of-queries=N--numeric-dump-file=file_name--offset=N--old-alter-table--old-passwords--old-style-user-limits--old_server--one-database--only-print--open-files-limit--open-files-limit=count--opt--opt_name--opt_name=value--optimize--order-by-primary--out_dir=path--out_file=file_name--pager[=command]--parallel-recover--partition[=value]--password--password=--password=pass_val--password=password--password=your_pass--password[=pass_val]--password[=password]--performance_schema_consumer_consumer_name=value--performance_schema_instrument--performance_schema_instrument=instrument_name=value--performance_schema_max_mutex_classes=200--performance_schema_max_mutex_classes=N--performance_schema_max_mutex_instances=N--pid-file=file_name--pid-file=path--pipe--plan--plugin-dir--plugin-dir=dir_name--plugin-dir=path--plugin-dir=path_name--plugin-ini=file_name--plugin-innodb_file_per_table--plugin-loadINSTALL PLUGIN Syntax”--plugin-load-add--plugin-load-add=plugin_list--plugin-load=auth_simple.so--plugin-load=plugin_list--plugin-sql-mode--plugin-xxx--plugin_dir--plugin_dir=path--plugin_name=0--plugin_name=1--plugin_name=FORCE--plugin_name=FORCE_PLUS_PERMANENT--plugin_name=OFF--plugin_name=ON--plugin_name[=ON]--plugindir--port--port-open-timeout=num--port=port_num--port=port_number--position=N--post-query=value--post-system=str--pre-query=value--pre-system=str--prefix--preserve-schema--preview--print-defaults--prompt--prompt=format_str--protocol=MEMORY--protocol=PIPE--protocol=SOCKET--protocol=TCP--protocol={TCP|SOCKET|PIPE|MEMORY}--query--query-cache-size=0--query=value--quick--quiet--quote-names--read-from-remote-server--read-only--reconnect--record_log_pos--record_log_pos=db_name.tbl_name--recover--regexp=expr--regexp=pattern--relative--relay-log=
Sign”--relay-log-index--relay-log-index=file_name--relay-log-info-file--relay-log-info-file=file_name--relay-log-info-repository--relay-log-info-repository=TABLE--relay-log-info-repository={FILE|TABLE}--relay-log-purge={0|1}--relay-log-recovery--relay-log-recovery={0|1}--relay-log-space-limit--relay-log-space-limit=size--relay-log=file_name--relay-log=myhost-bin--relay-log=relay_log_index--relnotes--reload--remove--remove [service_name]--remove[=name]--repair--replace--replicate-*--replicate-*-db--replicate-*-table--replicate-[do|ignore]-table--replicate-do-*--replicate-do-dbSHOW SLAVE STATUS Syntax”START TRANSACTION,
COMMIT, and
ROLLBACK Syntax”--replicate-do-db=db1--replicate-do-db=db_name--replicate-do-db=dbx--replicate-do-db=mysql--replicate-do-db=sales--replicate-do-tableSHOW SLAVE STATUS Syntax”--replicate-do-table=db_name.tbl_name--replicate-do-table=mysql.ndb_apply_status--replicate-ignore-*--replicate-ignore-dbSHOW SLAVE STATUS Syntax”START TRANSACTION,
COMMIT, and
ROLLBACK Syntax”--replicate-ignore-db=db_name--replicate-ignore-db=mysql--replicate-ignore-db=sales--replicate-ignore-table--replicate-ignore-table=db_name.tbl_name--replicate-ignore-table=mysql.ndb_apply_status--replicate-rewrite-db--replicate-rewrite-db=from_name->to_name--replicate-same-server-id--replicate-wild-do-tableSHOW SLAVE STATUS Syntax”--replicate-wild-do-table=databaseA.%--replicate-wild-do-table=databaseB.%--replicate-wild-do-table=databaseC.%--replicate-wild-do-table=db%.t1--replicate-wild-do-table=db_name.%--replicate-wild-do-table=db_name.tbl_name--replicate-wild-do-table=foo%.%--replicate-wild-do-table=foo%.bar%--replicate-wild-do-table=my\\_own\\%db--replicate-wild-do-table=my\_own\%db--replicate-wild-ignore-table--replicate-wild-ignore-table=db_name.%--replicate-wild-ignore-table=db_name.tbl_name--replicate-wild-ignore-table=foo%.bar%--replicate-wild-ignore-table=norep%--report-host--report-host=host_name--report-password--report-password=password--report-port--report-port=slave_port_num--report-user--report-user=user_name--resetmaster--resetslave--result-file--result-file=file_name--result-file=name--rhost=host_name--rollback--routines--rows=N--rpl-recovery-rank--rpm--safe-mode--safe-recover--safe-show-database--safe-updates--safe-user-create--secure-auth--secure-file-priv--secure-file-priv=path--select_limit--server-id--server-id-bits--server-id-bits=#--server-id-bits=N--server-id=value--service-startup-timeout=file_name--set-auto-increment[=value]--set-character-set=name--set-charset--set-charset=charset_name--set-collation--set-collation=name--set-variable--set-variable=option=value--set-variable=var_name=value--shared-memory--shared-memory-base-name--shared-memory-base-name=name--short-form--show-slave-auth-info--show-table-type--show-warnings--sigint-ignore--silent--single-transaction--skip--skip-add-drop-table--skip-add-locks--skip-auto-rehash--skip-base64-output--skip-character-set-client-handshake--skip-column-names--skip-comments--skip-compact--skip-concurrent-insert--skip-disable-keys--skip-dump-date--skip-engine_name--skip-event-scheduler--skip-events--skip-extended-insert--skip-external-locking--skip-grant-tablesCREATE FUNCTION Syntax for User-Defined
Functions”INSTALL PLUGIN Syntax”--skip-host-cache--skip-innodbInnoDB Startup Options and System Variables”SHOW ENGINES Syntax”InnoDB”--skip-innodb-checksums--skip-innodb_adaptive_hash_index--skip-innodb_checksums--skip-innodb_doublewrite--skip-kill-mysqld--skip-line-numbers--skip-lock-tables--skip-locking--skip-log-warnings--skip-merge--skip-name-resolve--skip-named-commands--skip-ndbcluster--skip-networkingCan't connect to [local] MySQL server”MySQL server has gone away”--skip-new--skip-opt--skip-partition--skip-plugin-innodb_file_per_table--skip-plugin_name--skip-quick--skip-quote-names--skip-reconnect--skip-routines--skip-safemalloc--skip-set-charset--skip-show-database--skip-slave-startCHANGE MASTER TO Syntax”START SLAVE Syntax”--skip-ssl--skip-stack-trace--skip-super-large-pages--skip-symbolic-linksCREATE TABLE Syntax”--skip-symlink--skip-syslog--skip-thread-priority--skip-triggers--skip-tz-utc--skip-use-db--skip-write-binlog--skip-xxx--skip_grant_tables--slave--slave-load-tmpdir--slave-load-tmpdir=file_name--slave-net-timeout--slave-net-timeout=seconds--slave-parallel-workers--slave-skip-errors--slave-skip-errors=[err_code1,err_code2,...|all]--slave-sql-verify-checksum--slave-sql-verify-checksum={0|1}--slave_compressed_protocol={0|1}--sleep--sleep=delay--slow-query-log--slow-query-log[={0|1}]--slow-start-timeout=timeout--slow_query_log--slow_query_log[={0|1}]--slow_query_log_file--slow_query_log_file=file_name--socketCan't connect to [local] MySQL server”--socket=/path/to/socket--socket=file_name--socket=path--sort-records=N--sort-records=index_num--sort-recover--sort_buffer_size=16M--spassword--spassword[=password]--sporadic-binlog-dump-fail--sql-bin-update-same--sql-mode--sql-mode=""--sql-mode="mode_value"--sql-mode="modes"--sql-mode=IGNORE_SPACE--sql-mode=value[,value[,value...]]--sql_mode="TRADITIONAL,ALLOW_INVALID_DATES"--srcdir=path--ssl--ssl*--ssl-ca--ssl-ca=file_name--ssl-capath--ssl-capath=dir_name--ssl-capath=directory_name--ssl-cert--ssl-cert=file_name--ssl-cipher=cipher_list--ssl-crl--ssl-crl=file_name--ssl-crlpath--ssl-crlpath=dir_name--ssl-key--ssl-key=file_name--ssl-verify-server-cert--ssl-xxx--standalone--start-datetime--start-datetime=datetime--start-position--start-position=N--start_row=N--statefile=file_name--stats--status--stop-datetime--stop-datetime=datetime--stop-never--stop-never-slave-server-id--stop-never-slave-server-id=id--stop-position--stop-position=N--suffix=str--super-large-pages--superuser=user_name--symbols-file=file_name--sysconfdir--sysdate-is-now--syslog--syslog-tag=tag--tab--tab=path--table_cache--table_open_cache--tables--tc-heuristic-recover={COMMIT|ROLLBACK}--tcp-ip--tee=file_name--temp-pool--test--thread_cache_size=5'--thread_handling=no-threads--thread_stack=N--timezone--timezone=timezone--timezone=timezone_name--tmpdir--tmpdir=path--to-last-log--transaction-isolation--transaction-isolation=level--type=engine_name--tz-utc--unbuffered--unpack--update-state--upgrade-system-tables--use-frm--use-manager--use-mysqld_safe--use-symbolic-links--use-threads--use-threads=N--userFile' Not Found and
Similar Errors”=
Sign”--user=mysql--user=root--user=user_name--user={user_name|user_id}--var_name=value--verbose--version--vertical--wait[=count]--warnings--where='where_condition'--windows--with-archive-storage-engine--with-berkeley-db--with-big-tables--with-blackhole-storage-engine--with-charset--with-charset=MYSET--with-charset=charset_name--with-collation--with-comment--with-csv-storage-engine--with-debug--with-debug=full--with-debug[=full]--with-embedded-privilege-control--with-embedded-server--with-example-storage-engine--with-extra-charsets=LIST--with-extra-charsets=charset_name--with-extra-charsets=complex--with-federated-storage-engine--with-libwrap--with-low-memory--with-max-indexes=N--with-mysql-sock[=DIR]--with-mysqld-ldflags=-all-static--with-mysqld-ldflags=-rdynamic--with-named-z-libs--with-ndb-sci=/opt/DIS--with-ndb-sci=/your/path/to/SCI--with-ndb-shm--with-ndbcluster--with-openssl--with-partition--with-pdo-mysql[=DIR]--with-plugin-PLUGIN--with-plugins--with-plugins=max--with-plugins=max-no-innodb--with-plugins=ndbcluster--with-ssl--with-ssl=path--with-tcp-port--with-unix-socket-path--with-vio--with-yassl--with-zlib-dir=no|bundled|DIR--with-zlib-dir[=DIR]--without-plugin-PLUGIN--without-query-cache--without-server--write-binlog--xml-1--' as the Start of a Comment”HASH Partitioning”mysql_affected_rows()”-?-B-C-C charset_name-C path-D db_name-D path-DBIG_TABLES-DBUILD_CONFIG=mysql_release-DCMAKE_BUILD_TYPE=Debug-DCMAKE_INSTALL_PREFIX=dir_name-DCPACK_MONOLITHIC_INSTALL=1-DDEFAULT_CHARSET=MYSET-DDEFAULT_CHARSET=charset_name-DENABLED_LOCAL_INFILE=1-DENABLE_DEBUG_SYNC=0-DENABLE_DEBUG_SYNC=1-DENABLE_DTRACE=0-DENABLE_DTRACE=1-DINSTALL_SQLBENCHDIR=-DMEMCACHED_HOME=path-DSAFEMALLOC-DUSE_ALARM_THREAD-DWITHOUT_PERFSCHEMA_STORAGE_ENGINE=1-DWITH_ARCHIVE_STORAGE_ENGINE-DWITH_BLACKHOLE_STORAGE_ENGINE-DWITH_BUNDLED_LIBEVENT=OFF-DWITH_BUNDLED_MEMCACHED=OFF-DWITH_DEBUG=1-DWITH_EMBEDDED_SERVER=1-DWITH_EXAMPLE_STORAGE_ENGINE-DWITH_EXTRA_CHARSETS=all-DWITH_EXTRA_CHARSETS=charset_name-DWITH_EXTRA_CHARSETS=complex-DWITH_FEDERATED_STORAGE_ENGINE-DWITH_LIBWRAP=1-DWITH_PARTITION_STORAGE_ENGINE-DWITH_SSL=system-DWITH_ZLIB={system|bundled}-F-F file_name-F str-H file_name-H host_name-I-I/usr/local/mysql/include-K-L-L/usr/lib/gcc-lib/... -lgcc-L/usr/local/mysql/lib -lmysqlclient -lz-N file_name-O var_name=value-O file_name-P-P port_num-P[password]-Q-R index_num-R record_pos_file record_pos-S-S path-T-T [flags]-T path-U user_name-V-W-W [level]-a-b path-c-c column_list-c file_name-d-d db_name-d path-eLOAD XML Syntax”MyISAM Tables for Errors”-e "configuration_string"-e reconf=false-e engine_name-e file_name-e num-e statement-f-f N-felide-constructors-fno-exceptions-fno-rtti-fomit-frame-pointer-g pattern-g suffix-h-h host_name-h localhost-iMyISAM Tables for Errors”pdb to create a Windows crashdump”-i N-i delay-i file_name-i name-j N-j big_tbl_name-k-l-l path-libmysqlclient-libmysqld-lmysqlclient-lmysqlclient -lz-lmysqld-lz-m-n-n N-n file_name-o-o N-o noatime-o offset-pKEY Partitioning”-p N-p num-p path-p[pass_val]-p[password]-ppassword-q-q value-rMyISAM Tables”-r file_name-r name-sMyISAM Tables for Errors”MyISAM Tables”MyISAM Table Maintenance Schedule”-s at-s file_name-s num-s sort_type-signal-skip-auto-rehash-slow_query_log_file-t-t number_of_worker_threads-t N-t path-u-u {user_name|user_id}-u user_name-vMyISAM Tables for Errors”-v -v -v-w 'where_condition'-w write_file-w[count]-x-x N-y-y N-ândb-log-update-as-write=OFF-ândb-log-updated-only/passive/uninstallArbitrationArbitrationDelayArbitrationRankArbitrationTimeoutBackupDataBufferSizeBackupDataDirBackupLogBufferSizeBackupMaxWriteSizeBackupMemoryBackupReportFrequencyBackupWriteSizeBatchSizeBatchSizePerLocalScanBuildIndexThreadsCMAKE_INSTALL_PREFIXChecksumCom_alter_eventCom_create_eventCom_dealloc_sqlCom_deleteCom_drop_eventCom_execute_sqlCom_prepare_sqlCom_selectCom_show_create_eventCom_show_eventsCom_stmt_closeCom_stmt_executeCom_stmt_fetchCom_stmt_prepareCom_stmt_reprepareCom_stmt_resetCom_stmt_send_long_dataCompressedBackupCompressedLCPConnectCheckIntervalDelayCrashOnCorruptedTupleDEFAULT_CHARSETDEFAULT_COLLATIONDISABLE_GRANT_OPTIONSDataDirDataMemoryThe table is full”ndbinfo memoryusage Table”DefaultOperationRedoProblemActionDiskCheckpointSpeedDiskCheckpointSpeedInRestartDiskIOThreadPoolDiskPageBufferMemoryExecuteOnComputerExtraSendBufferMemoryFileSystemPathFileSystemPathDDFileSystemPathDataFilesFileSystemPathUndoFilesFragmentLogFileSizeHAVE_EMBEDDED_PRIVILEGE_CONTROLHeartbeatIntervalDbApiHeartbeatIntervalDbDbHeartbeatOrderHeartbeatThreadPriorityHostNameHostName1IdSHOW COLLATION Syntax”SHOW PROCESSLIST Syntax”INFORMATION_SCHEMA COLLATIONS Table”INFORMATION_SCHEMA PROCESSLIST Table”IndexMemoryndbinfo memoryusage Table”InitFragmentLogFilesInitialLogFileGroupInitialNoOfOpenFilesInitialTablespaceInnodb_buffer_pool_read_ahead_rndInnodb_buffer_pool_read_ahead_seqLockExecuteThreadToCPULockMaintThreadsToCPULockPagesInMainMemoryLogDestinationLogLevelCheckpointLogLevelCongestionLogLevelConnectionLogLevelErrorLogLevelNodeRestartLogLevelShutdownLogLevelStartupLogLevelStatisticLongMessageBufferMYSQL_MAINTAINER_MODEMYSQL_TCP_PORTMYSQL_UNIX_ADDRMaxBufferedEpochsMaxDMLOperationsPerTransactionMaxLCPStartDelayMaxNoOfAttributesMaxNoOfConcurrentIndexOperationsMaxNoOfConcurrentOperationsMaxNoOfConcurrentScansMaxNoOfConcurrentSubOperationsMaxNoOfConcurrentTransactionsMaxNoOfExecutionThreadsMaxNoOfFiredTriggersMaxNoOfLocalOperationsMaxNoOfLocalScansMaxNoOfOpenFilesMaxNoOfOrderedIndexesMaxNoOfSavedMessagesMaxNoOfSubscribersMaxNoOfSubscriptionsMaxNoOfTablesMaxNoOfTriggersMaxNoOfUniqueHashIndexesMaxParallelScansPerFragmentMaxStartFailRetriesMemReportFrequencyNameSHOW AUTHORS Syntax”SHOW CONTRIBUTORS Syntax”SHOW ENGINE Syntax”SHOW EVENTS Syntax”SHOW PLUGINS Syntax”SHOW TABLE STATUS Syntax”INFORMATION_SCHEMA EVENTS Table”INFORMATION_SCHEMA PLUGINS Table”ndbinfo MySQL Cluster Information Database”Ndb_cluster_node_idNdb_conflict_fn_epochNdb_conflict_fn_epoch_transNdb_conflict_fn_maxNdb_conflict_fn_oldNdb_conflict_trans_conflict_commit_countNdb_conflict_trans_detect_iter_countNdb_conflict_trans_reject_countNdb_conflict_trans_row_conflict_countNdb_conflict_trans_row_reject_countNoOfDiskPagesToDiskAfterRestartACCNoOfDiskPagesToDiskAfterRestartTUPNoOfDiskPagesToDiskDuringRestartACCNoOfDiskPagesToDiskDuringRestartTUPNoOfFragmentLogFilesNoOfReplicasNodeIdNodeId1NodeId2OverloadLimitPerformance_schema_accounts_lostPerformance_schema_hosts_lostPerformance_schema_locker_lostPerformance_schema_users_lostPortNumberQuestionsRealtimeSchedulerReceiveBufferMemoryRedoOverCommitCounterRedoOverCommitLimitReservedSendBufferMemoryRestartOnErrorInsertRpl_statusSYSCONFDIRSchedulerExecutionTimerSchedulerSpinTimerSendBufferMemorySendLimitSendSignalIdServerPortSharedBufferSizeSharedGlobalMemorySsl_cipherStartFailRetryDelayStartFailureTimeoutStartNoNodeGroupTimeoutStartPartialTimeoutStartPartitionedTimeoutStartupStatusReportFrequencyTcpBind_INADDR_ANYText in this styleTimeBetweenEpochsTimeBetweenEpochsTimeoutTimeBetweenGlobalCheckpointsTimeBetweenInactiveTransactionAbortCheckTimeBetweenLocalCheckpointsTimeBetweenWatchDogCheckTimeBetweenWatchDogCheckInitialTotalSendBufferMemoryTransactionBufferMemoryTransactionDeadlockDetectionTimeoutTransactionInactiveTimeoutUndoDataBufferUndoIndexBufferWITH_BUNDLED_MEMCACHEDWITH_COMMENTWITH_NDBCLUSTER_STORAGE_ENGINEWITH_PERFSCHEMA_STORAGE_ENGINE\G\q\s\t\u db_nameallansiauto_increment_incrementauto_increment_offsetautomatic_sp_privilegesbasedirbinlog_cache_sizebinlog_checksumbinlog_row_imagebinlog_rows_query_log_eventscALTER TABLE Examples”CREATE TABLE ...
SELECT Syntax”GROUP BY and HAVING with Hidden
Columns”RANGE COLUMNS partitioning”character-sets-dir=pathcharacter_set_clientcharacter_set_servercharsetcheckcollation_servercompressconnect_timeoutconnectstring=connect_stringcountcsvdALTER TABLE Examples”LEFT JOIN and RIGHT JOIN
Optimization”RANGE COLUMNS partitioning”databasedatadirdbSHOW PROCESSLIST Syntax”mysql_change_user()”mysql_create_db()”mysql_drop_db()”mysql_real_connect()”mysql_select_db()”INFORMATION_SCHEMA PARAMETERS Table”INFORMATION_SCHEMA PROCESSLIST Table”INFORMATION_SCHEMA ROUTINES Table”debug={true|false}decode_bitsdefault-storage-enginedefault-table-typedefaults-extra-filedelimiterdescriptioneengine_condition_pushdownevent-scheduler=DISABLEDevent_schedulerextended-statusexternal_userflush-hostsflush-logsflush-privilegesflush-statusflush-tablesflush-threadsforeign_key_checksft_max_word_lenft_min_word_lenft_stopword_filehave_innodbhave_ndbclusterhave_partition_enginehave_partitioninghave_profilinghostmysql_connect()”mysql_real_connect()”InnoDB”ignore_builtin_innodbinit-fileinnodbinnodb-safe-binloginnodb-status-file=1innodb_adaptive_flushinginnodb_adaptive_hash_indexinnodb_adaptive_max_sleep_delayinnodb_additional_mem_pool_sizeinnodb_analyze_is_persistentinnodb_autoextend_incrementinnodb_autoinc_lock_modeinnodb_buffer_pool_awe_mem_mbinnodb_buffer_pool_dump_at_shutdowninnodb_buffer_pool_dump_nowinnodb_buffer_pool_filenameinnodb_buffer_pool_instancesinnodb_buffer_pool_load_abortinnodb_buffer_pool_load_at_startupinnodb_buffer_pool_load_nowinnodb_buffer_pool_sizeinnodb_change_buffer_max_sizeinnodb_change_bufferinginnodb_checksum_algorithminnodb_checksumsinnodb_commit_concurrencyinnodb_concurrency_ticketsinnodb_data_file_pathinnodb_data_home_dirinnodb_doublewriteinnodb_fast_shutdowninnodb_file_formatinnodb_file_format_checkinnodb_file_format_maxinnodb_file_io_threadsinnodb_file_per_tableInnoDB Startup Options and System Variables”innodb_flush_log_at_trx_commitinnodb_flush_methodinnodb_flush_neighborsinnodb_force_recoveryinnodb_io_capacityinnodb_large_prefixinnodb_lock_wait_timeoutinnodb_locks_unsafe_for_binloginnodb_log_arch_dirinnodb_log_archiveinnodb_log_buffer_sizeinnodb_log_file_sizeinnodb_log_files_in_groupinnodb_log_group_home_dirinnodb_lru_scan_depthinnodb_max_dirty_pages_pctinnodb_max_purge_laginnodb_mirrored_log_groupsinnodb_monitor_disableinnodb_monitor_enableinnodb_monitor_resetinnodb_monitor_reset_allinnodb_old_blocks_pctinnodb_old_blocks_timeinnodb_open_filesinnodb_print_all_deadlocksinnodb_purge_batch_sizeinnodb_purge_threadsinnodb_read_ahead_thresholdinnodb_read_io_threadsinnodb_replication_delayinnodb_rollback_on_timeoutinnodb_rollback_segmentsinnodb_spin_wait_delayinnodb_stats_methodinnodb_stats_on_metadatainnodb_stats_persistent_sample_pagesinnodb_stats_sample_pagesinnodb_stats_transient_sample_pagesinnodb_strict_modeinnodb_support_xainnodb_sync_spin_loopsinnodb_table_locksinnodb_thread_concurrencyinnodb_thread_sleep_delayinnodb_use_legacy_cardinality_algorithminnodb_use_native_aioinnodb_use_sys_mallocinnodb_write_io_threadsinteractive_timeoutkey_buffer_sizelanguageledirlengthmysql_hex_string()”mysql_real_escape_string()”mysql_real_query()”mysql_stmt_fetch()”mysql_stmt_prepare()”mysql_stmt_send_long_data()”licenseloglog-slave-updateslog_bin_trust_routine_creatorslog_slow_querieslower_case_table_namesmaster_verify_checksummax_allowed_packetmax_binlog_cache_sizemax_binlog_stmt_cache_sizemax_connectionsmax_long_data_sizemax_user_connectionsmulti_range_countmyisam_block_sizemyisam_max_extra_sort_file_sizemyisam_stats_methodmyisamchkmysqlCREATE FUNCTION Syntax for User-Defined
Functions”CREATE SERVER Syntax”CREATE USER Syntax”Client does not support authentication protocol”DROP FUNCTION Syntax”DROP USER Syntax”FLUSH Syntax”GRANT Syntax”HELP Syntax”MySQL server has gone away”RENAME USER Syntax”REVOKE Syntax”SET PASSWORD Syntax”SHOW GRANTS Syntax”mysql_change_user()”mysql_client_find_plugin()”mysql_client_register_plugin()”mysql_close()”mysql_errno()”mysql_error()”mysql_get_ssl_cipher()”mysql_init()”mysql_load_plugin()”mysql_real_escape_string()”mysql_select_db()”mysql_ssl_set()”mysql_stmt_execute()”mysql_stmt_fetch()”mysql_stmt_send_long_data()”InnoDB”FEDERATED Table Using
CONNECTION”PKG”InnoDB Tables”mysql Database Tables”FLUSH”mysql System Database”mysql_pluginmysqlaccessmysqlbinlogmysqldCan't connect to [local] MySQL server”FEDERATED Storage Engine Overview”InnoDB Startup Options and System Variables”pdb to create a Windows crashdump”mysqld_safemysqldumpmysqldumpslowmysqlhotcopymysqlslapndb-connectstringndb_autoincrement_prefetch_szndb_log_binlog_indexndb_optimization_delayndb_table_no_loggingndbdnet_buffer_lengthnet_retry_countnet_write_timeoutniceoffsetopen-files-limitopen_files_limitppartitionpasswordperformance_schemaSHOW ENGINE Syntax”performance_schema”pid-filepipepluginprocesslistqueryquery_cache_typeread_buffer_sizeread_onlyreconf={true|false}reconnectrecord_bufferrehashreplication-ignore-tableresolve_stack_dumprole=role_namerowsrpl_recovery_ranksselect_limitserver-idserver_idset-variable=option=valueshutdownshutdown_timeoutskip-networkingskip-slave-startslaveslave_sql_verify_checksumslave_type_conversionssocketsort_buffer_sizesort_key_blockssourcesql-mode=""sql-mode="modes"sql_log_updatesql_low_priority_updatesstart-slavestats_methodstatusANALYZE TABLE Syntax”CHECK TABLE Syntax”OPTIMIZE TABLE Syntax”REPAIR TABLE Syntax”ndbinfo nodes Table”ndbinfo transporters Table”stop-slavesyslogsystemtableEXPLAIN Output Format”FROM Clause”table_typetestInnoDB Table Monitor Output”LOAD XML Syntax”SHOW EVENTS Syntax”INFORMATION_SCHEMA Searches”InnoDB Tables”INFORMATION_SCHEMA Queries”INFORMATION_SCHEMA PARTITIONS Table”thread_handlingtmpdirtypeCREATE FUNCTION Syntax for User-Defined
Functions”EXPLAIN Output Format”InnoDB Table Monitor Output”mysql_client_find_plugin()”mysql_load_plugin()”INFORMATION_SCHEMA ROUTINES Table”updateuse db_nameuserDROP USER Syntax”Ignoring user”mysql_options()”mysql_real_connect()”InnoDB”variablesversionwaitwarning_countwarningswith-unix-socket-path
User Comments
Add your own comment.