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]

language option 2nd

language system variable (mysqld)

languages

     character sets

         adding

         configuring

         default

         lowercase/uppercase

         multi-byte characters

         MySQL Configuration Wizard

         troubleshooting

     Cluster requirements

     error messages

     string collating

large-pages option (mysqld)

large_file_support system variable (mysqld)

large_pages system variable (mysqld)

last_insert_id dynamic system variable

LAST_INSERT_ID( ) function

Last_query_cost status variable

layouts

LCPs (Local Checkpoints)

LD_LIBRARY_PATH environment variable

LD_RUN_PATH environment variable

Least Recently Used (LRU)

ledir option (mysqld_safe script)

LEFT JOIN

     EXPLAIN statements

     optimization

leftmost prefixes (indexes)

license system variable (mysqld)

licensing

     MaxDB

     Web site

LIKE comparisons

LIMIT clauses

limitations

     account resources

     Cluster 2nd

         adding/dropping nodes

         behavior non-compliance

         error reporting

         missing features

         multi-computer

         multiple management servers

         multiple network interfaces

         multiple servers

         MySQL 4.1

         node maximums

         online schema changes

         performance

         syntax noncompliance

         transactions

         unsupported features

     design

     FEDERATED storage engine

     privileges

     replication

limits

line-numbers option (mysql)

lines-terminated-by option

     mysqldump

     mysqlimport

links

     speed

     symbolic

Linux

     error codes

     installation

     RPM Package Manager

LOAD DATA LOCAL statements

LOAD INDEX INTO CACHE statement

LOAD_EVENT event

Loader (MaxDB)

Local Checkpoints (LCPs)

local option (mysqlimport)

local-infile option

     mysql

     mysqld

local-load option (mysqlbinlog)

local_infile system variable 2nd

localization

LOCK TABLES privilege

lock-all-tables option (mysqldump)

lock-tables option

     mysqldump

     mysqlimport

locked_in_memory system variable (mysqld)

locking

     external

         avoiding

         crash recovery

         disabling 2nd 3rd

         enabling

     InnoDB tables

         configuring

         deadlocks

         intention locks

         modes

         next-key

         shared mode

     intention locks

     methods

     multiple granularity

     page-level

     phantom problem, avoiding

     row-level

     rows

     table-level

     type compabitibility matrix

LockPagesInMainMemory parameter (config.ini file)

log files

     binary

         deleting

         extensions

         index files

         options

         performance

         processing

         purpose

         replication

         synchronizing to disk

         transactions

         viewing

     Cluster

        event logs [See Cluster, event logs.]

         parameters 2nd

     configuring

     error 2nd

     events

     flags

     general query

     maintenance

     MyISAM 2nd

     names

     ndbd

     relay 2nd

     replication formats

     slow 2nd

log option

     mysqld

     mysqld_multi script

     mysqlmanager

log system variable (mysqld)

log-bin option (mysqld)

log-bin-index option (mysqld)

log-bin-trust-function-creators option (mysqld)

log-bin-trust-routine-creators option (mysqld)

log-error option

     mysqld

     mysqld_safe

log-isam option (mysqld)

log-long-format option (mysqld)

log-queries-not-using-indexes option (mysqld)

log-short-format option (mysqld)

log-slave-updates option (replication)

log-slow-admin-statements option (mysqld)

log-slow-queries option (mysqld)

log-warnings option

     mysqld

     replication

log_bin system variable (mysqld)

log_bin_trust_function_creators system variable 2nd

log_bin_trust_routine_creators system variable (mysqld)

log_error system variable (mysqld)

LOG_EVENT_BINLOG_IN_USE_F flag

LOG_EVENT_SUPPRESS_USE_F flag

LOG_EVENT_THREAD_SPECIFIC_F flag

log_slave_updates system variable (mysqld)

log_slow_queries system variable (mysqld)

log_warnings system variable 2nd

LogDestination parameter (config.ini file)

long password hashes

long_query_time dynamic system variable

long_query_time system variable

LongMessageBuffer parameter (config.ini file) 2nd

loose index scans

loose option

low-priority option (mysqlimport)

low-priority-updates option (mysqld)

low_priority_updates system variable 2nd

lower_case_file_system system variable (mysqld)

lower_case_table_names system variable (mysqld)

LRU (Least Recently Used)