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] objects Perl DBI API OCT() function OCTET_LENGTH() function ON clause granting privileges 2nd 3rd retrieving rows from tables ON DELETE CASCADE keyword ON DELETE keyword ON DELETE SET NULL keyword open_files_limit variable opening tags PHP API 2nd 3rd PHP scripts OpenSSL obtaining operators 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th arithmetic 2nd 3rd 4th 5th 6th type conversion bit 2nd 3rd type conversion bit operators 2nd cast 2nd comparison 2nd 3rd 4th 5th 6th 7th 8th 9th 10th type conversion 2nd grouping logical 2nd 3rd 4th 5th 6th type conversion pattern-matching 2nd 3rd 4th 5th 6th 7th 8th 9th 10th type conversion PHP API === precedence 2nd 3rd 4th optimization. [See query optimization]2nd [See also performance tuning] OPTIMIZE TABLE statement 2nd 3rd 4th optimizing myisamchk utility tables 2nd option files 2nd 3rd 4th 5th 6th 7th for connection parameters 2nd reading 2nd 3rd 4th for multiple servers 2nd 3rd security 2nd server connections via 2nd setting variables in 2nd starting server with 2nd OPTION keyword setting variables options for multiple servers startup options 2nd for programs 2nd boolean option syntax 2nd environment variables 2nd logging options, list of 2nd myisamchk and isamchk utilities 2nd 3rd 4th 5th 6th 7th myisampack and pack_isam utilities 2nd 3rd 4th 5th mysql program 2nd 3rd 4th 5th 6th mysql_config utility 2nd mysql_install_db script 2nd mysqlacces script 2nd 3rd mysqladmin utility 2nd 3rd mysqlbinlog utility 2nd 3rd mysqlcheck utility 2nd 3rd 4th 5th 6th mysqld server 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th mysqld_multi script 2nd 3rd mysqld_safe script 2nd mysqldump program 2nd 3rd 4th 5th 6th 7th 8th 9th mysqlhotcopy utility 2nd 3rd 4th mysqlimport utility 2nd 3rd 4th 5th mysqlshow utility 2nd option files 2nd 3rd 4th 5th 6th 7th SSL options, list of 2nd standard options, list of 2nd 3rd SQL statements. [See SQL statements] OR bitwise operator (|) OR logical operator (||) 2nd ORD() function ORDER BY clause altering tables deleting table rows generating summaries 2nd 3rd 4th 5th joining SELECT statements together retrieving results in random order 2nd retrieving rows from tables sorting query results 2nd 3rd 4th unions updating tables ORDER_BY_RAND() PHP president quiz example ORDER_BY_RAND() function origin. [See history] out-of-range values type conversion 2nd output formatting 2nd 3rd 4th 5th writing Web output CGI.pm Perl module 2nd 3rd 4th output formatting customizing 2nd Perl DBI API 2nd 3rd 4th 5th 6th 7th 8th 9th 10th over-indexing overriding MySQL query optimizer 2nd |