High Performance MySQL: Optimization, Backups, Replication, and More
| [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] C API 2nd 3rd 4th 5th 6th 7th client programs compiling and linking 2nd 3rd error checking 2nd 3rd 4th 5th option files 2nd processing command-line arguments 2nd 3rd 4th 5th 6th 7th 8th 9th reading option files 2nd 3rd 4th server connections 2nd 3rd compiling 2nd data types non-scalar 2nd 3rd 4th 5th 6th 7th 8th scalar 2nd embedded server applications 2nd 3rd 4th 5th executable binary for 2nd example client programs external support functions administrative checking return values 2nd connection management 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th debugging 2nd deprecated 2nd 3rd 4th 5th 6th 7th 8th embedded server communication 2nd error handling 2nd information gathering 2nd 3rd 4th parameters 2nd queries 2nd 3rd 4th 5th result set processing 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th threaded client 2nd header files 2nd history of libraries 2nd linking 2nd macros 2nd memory management mysql_config utility 2nd portability query handling 2nd calculations on result sets 2nd escape characters 2nd 3rd general purpose example 2nd 3rd image data 2nd interactive query program example 2nd mysql_store_result() versus mysql_use_result() 2nd 3rd process_query() alternatives 2nd result set metadata 2nd 3rd 4th 5th table information with result set 2nd 3rd 4th without result set 2nd server connections with connection parameters 2nd 3rd 4th SSL support 2nd 3rd 4th system requirements 2nd text manipulation troubleshooting function return values 2nd NULL column values 2nd uninitialized connection handler pointers 2nd uninitialized result buffer pointers C-style comments 2nd 3rd 4th CA (Certificate Authority) certificates cache resetting 2nd cache size query optimization 2nd 3rd 4th caches flushing 2nd caching queries calculating columns with expressions 2nd calculations on result sets 2nd canceling queries caret (^) bitwise XOR operator cartesian products CASCADE keyword dropping tables cascaded deletes CASE comparison operator 2nd case sensitivity character sets data directory filenames 2nd database and table names grant table scope columns selecting column types 2nd SQL statement naming conventions 2nd cast functions 2nd cast operators 2nd CAST() function 2nd 3rd CEILING() function CERATE TEMPORARY TABLES privilege Certificate Authority (CA) certificates certificate files certificates X509 certificates requiring CGI scripts Apache Web server setup 2nd 3rd installing CGI.pm Perl module 2nd 3rd 4th escaping HTML and URL text 2nd input parameters 2nd invoking scripts with parameters 2nd 3rd 4th 5th 6th writing Web output 2nd 3rd 4th CHANGE clause ALTER TABLE statement 2nd CHANGE COLUMN clause altering tables CHANGE MASTER statement 2nd 3rd CHANGED option error checking tables 2nd CHAR columns. [See fixed-length columns] CHAR string type 2nd 3rd 4th 5th 6th 7th CHAR() function forcing type conversion CHAR_LENGTH() function character data types. [See string data types] CHARACTER SET option creating tables setting variables character sets 2nd case sensitivity configuring support for 2nd converting tables to MySQL 4.1 2nd converting tables to MySQL 4.1 default character set setting determining usage 2nd displaying supported 2nd setting default setting for columns specifying 2nd 3rd support after MySQL 4.1 2nd support prior to MySQL 4.1 2nd Unicode support 2nd CHARACTER_LENGTH() function CHARACTER_SET attribute specifying character sets 2nd string column types 2nd 3rd 4th character_set variable character_sets variable characters versus bytes (string length) 2nd CHARSET() function CHECK clause creating tables CHECK TABLE statement 2nd 3rd 4th 5th CHECKSUM option creating tables choosing. [See selecting]2nd [See selecting]3rd [See selection criteria] ChopBlanks attribute Perl DBI API CIPHER keyword granting privileges CIPHER option granting privileges class methods Perl DBI API 2nd 3rd 4th 5th 6th 7th 8th 9th clear command client access software selecting ISPs client libraries. [See APIs] client library. [See C API] client programs command-line arguments processing 2nd 3rd 4th 5th 6th 7th 8th 9th compiling and linking 2nd 3rd error checking 2nd 3rd 4th 5th examples obtaining option files 2nd reading 2nd 3rd 4th query handling 2nd calculations on result sets 2nd escape characters 2nd 3rd general purpose example 2nd 3rd image data 2nd interactive query program example 2nd mysql_store_result() versus mysql_use_result() 2nd 3rd process_query() alternatives 2nd result set metadata 2nd 3rd 4th 5th table information with result set 2nd 3rd 4th without result set 2nd server connections 2nd 3rd with connection parameters 2nd 3rd 4th SSL support 2nd 3rd 4th system requirements 2nd troubleshooting function return values 2nd NULL column values 2nd uninitialized connection handler pointers 2nd uninitialized result buffer pointers client programs. [See programming MySQL] client software reasons for installing 2nd client/server architecture access control to data directory 2nd 3rd 4th client/server architecture of MySQL 2nd 3rd clients mysql mysqladmin mysqldump closing tags PHP API 2nd 3rd PHP scripts COALESCE() function COLLATE cast operator COLLATE operator column aliases 2nd column declarations 2nd column names in expressions 2nd column types 2nd 3rd 4th 5th 6th 7th 8th attributes 2nd creating tables 2nd 3rd date and time types 2nd 3rd 4th 5th 6th attributes 2nd DATE type 2nd 3rd DATETIME type 2nd 3rd input formats for 2nd 3rd ranges for storage requirements TIME type 2nd 3rd 4th TIMESTAMP type 2nd 3rd 4th 5th 6th YEAR type 2nd 3rd year value interpretations 2nd 3rd zero values displaying information about 2nd numeric types 2nd 3rd 4th 5th 6th 7th attributes 2nd 3rd BIGINT 2nd DECIMAL 2nd 3rd 4th 5th 6th 7th DOUBLE 2nd 3rd FLOAT 2nd 3rd floating-point numbers 2nd 3rd 4th 5th 6th INT 2nd integers 2nd 3rd 4th MEDIUMINT 2nd ranges for selecting 2nd 3rd SMALLINT 2nd storage requirements TINYINT 2nd query optimization 2nd 3rd selecting 2nd 3rd 4th AUTO_INCREMENT columns case sensitivity 2nd indexes 2nd performance issues 2nd 3rd 4th 5th 6th 7th 8th 9th 10th range of values in column 2nd 3rd types of values in column 2nd 3rd 4th 5th string types 2nd 3rd 4th 5th 6th 7th 8th attributes 2nd 3rd 4th BLOB string type 2nd 3rd CHAR string type 2nd 3rd 4th 5th 6th 7th ENUM string type 2nd 3rd 4th 5th 6th 7th 8th 9th length in characters versus bytes 2nd LONGBLOB string type 2nd LONGTEXT string type 2nd MEDIUMBLOB string type 2nd MEDIUMTEXT string type 2nd SET string type 2nd 3rd 4th 5th 6th 7th 8th 9th size and storage requirements TEXT string type 2nd 3rd TINYBLOB string type 2nd TINYTEXT string type 2nd VARCHAR string type 2nd 3rd 4th 5th 6th 7th versus data types column-level privileges granting 2nd Column_name column (grant tables) columns calculating with expressions 2nd case sensitivity changing type of 2nd comparisons importance of column type on indexed columns 2nd displaying 2nd naming conventions qualifying references to selecting for indexes 2nd columns_priv table (in grant table) command history list server connections via 2nd command-line starting servers command-line arguments passwords as processing 2nd 3rd 4th 5th 6th 7th 8th 9th commands mysql program 2nd 3rd mysql program history file 2nd mysqladmin utility 2nd 3rd perldoc COMMENT keyword creating tables COMMENT option creating tables comment styles 2nd 3rd 4th lacking support comments in PHP API Perl DBI API COMMIT statement 2nd 3rd 4th 5th 6th commit() Perl DBI database handle method Perl DBI transactions committing transactions 2nd comparison functions 2nd 3rd 4th comparison operators 2nd 3rd 4th 5th 6th 7th 8th 9th 10th type conversion 2nd comparisons importance of column type on indexed columns 2nd compiled languages versus interpreted languages 2nd compilers for client programs compiling C API 2nd client programs 2nd 3rd composite indexes 2nd compressing dump files CONCAT() function forcing type conversion type conversion CONCAT_WS() function concatenation (strings) 2nd concurrency query optimization 2nd concurrency. [See transactions] CONCURRENT clause loading data concurrent inserts concurrent_insert variable configure utility (UNIX) 2nd clearing stored information configuring multiple servers 2nd configuring servers administration duties connect command connect() Perl DBI class method 2nd 3rd 4th 5th 6th 7th Perl DBI connections 2nd Perl DBI error handling 2nd connect_cached() Perl DBI class method 2nd connect_timeout variable 2nd connection identifiers PHP API 2nd connection management functions C API 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th PHP API 2nd 3rd 4th 5th 6th connection parameters command-line arguments for processing 2nd 3rd 4th 5th 6th 7th 8th 9th in client programs 2nd 3rd 4th option files for 2nd reading 2nd 3rd 4th Perl DBI API 2nd 3rd 4th 5th 6th CONNECTION_ID() function connections ***same as network connections*** creating accounts for 2nd listening for 2nd localhost 2nd securing. [See also external security] SSL 2nd 3rd 4th SSL connections specifying in GRANT statement 2nd TCP/IP connections establishing terminating via mysql command 2nd 3rd 4th via option files 2nd via shell aliases 2nd via shell history list 2nd connections to server. [See server connections] connections. [See server connections] connectivity options selecting ISPs 2nd consistency (transactions) constraints. [See foreign keys, primary keys] CONV() function 2nd conversion. [See type conversion] CONVERT() function 2nd forcing type conversion specifying character sets convert_character_set variable converting fixed-length columns to variable-length columns table types 2nd tables to MyISAM to MySQL 4.1 2nd 3rd to MyISAM tables variable-length columns to fixed-length columns 2nd copying databases 2nd 3rd advantages and disadvantages 2nd with mysqldump utility InnoDB and BDB tables 2nd copying and pasting queries 2nd copying. [See also backing up] COS() function cost selecting ISPs 2nd 3rd COT() function count() PHP query processing COUNT() function 2nd generating summaries 2nd 3rd 4th 5th 6th 7th 8th 9th counters generating 2nd 3rd crash recovery administration duties CRC32() function create command CREATE DATABASE statement 2nd 3rd 4th 5th displaying CREATE FUNCTION statement 2nd CREATE INDEX statement 2nd 3rd 4th 5th 6th CREATE privilege 2nd 3rd CREATE TABLE statement 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th creating tables from query results 2nd 3rd 4th displaying MERGE tables 2nd provisional creation table storage options 2nd temporary tables 2nd CREATE TEMPORARY TABLES privilege cron jobs scheduling preventive maintenance crontab file scheduling log file expiration 2nd CROSS JOIN keyword retrieving rows from tables cross joins CURDATE() function 2nd currency. [See money] CURRENT_DATE() function CURRENT_TIME() function CURRENT_TIMESTAMP() function CURTIME() function customer service selecting ISPs 2nd customizing input handling 2nd output formatting 2nd |