|
|
main function
for aggregate user-defined functions, 201
for standard user-defined functions, 197–198
maintenance phase of database lifecycle, 249–250
example, 255–256
make command, 459, 465
MAKE_SET() function, 536
mandatory relationship, 214, 243, 243
many-to-many relationship, 213, 213, 243, 243
conversion to two one-to-many relationships, 244
master for replication, 337
commands for, 343
configuration file options, 340
MASTER_POS_WAIT() function, 566–567
MATCH() function, for full-text search, 133
MAX() function, 20–21, 556
index use for, 153
max_allowed packet variable, 383
max_binlog_cache_size variable, 384
max_binlog_size variable, 384
max_connect_errors variable, 384
max_connections variable, 368–373, 384
MAX_CONNECTIONS_PER_HOUR, 444
max_delayed_threads variable, 384
max_heap_table_size variable, 384
max_join_size variable, 384
MAX_JOIN_SIZE variable, 392, 496
MAX_QUERIES_PER_HOUR, 444, 445
max_sort_length variable, 384
max_tmp_tables variable, 384
MAX_UPDATES_PER_HOUR, 445
max_used_connections variable, 369, 389
max_user_connections variable, 384, 444
max_write_lock_count variable, 384
MD5() function, 567
MEDIUMBLOB column type, 46
MEDIUMINT column type, 43
MEDIUMTEXT column type, 46
memory
for HEAP tables, 63
and performance, 393
PHP function to free, 584–585
MERGE tables, and indexes, 152
message parameter, of user-defined init function, 197
metaphone, 194
Microsoft Access, exporting data to MySQL, 666
MIN() function, 22, 556–557
index use for, 153
MINUTE() function, 518
mirroring, 469, 470, 470
MOD() function, 550
modeling, 187
MODIFY clause, of ALTER TABLE statement, 26
MONTH() function, 29, 518
MONTHNAME() function, 519
moveToCurrentRow() method (Java), 637
moveToInsertRow() method (Java), 637
multicolumn indexes, auto increment field and, 150–151
multivalued dependencies, 234
my-huge.cnf file, 271, 366
my-large.cnf file, 271, 366
my-medium.cnf file, 271, 366
my-small.cnf file, 271, 366
my.cnf file, 269, 416
.MYD file extension, 57, 263
.MYI file extension, 152, 263
MyISAM table backups
with BACKUP command, 302– 305
by direct copying files, 307–309
restoring, 305–307
MyISAM table type, 56–60
compressed tables, 58–60
dynamic tables, 57–58
and indexes, 152
static tables, 57
myisam_bulk_insert_tree_size variable, 384
myisamchk utility
analyzing tables with, 283–284
checking tables with, 287–288
optimizing tables with, 281–282
repairing tables with, 291–292
using, 294–298
check options, 296–297
general options, 295–296, 298
repair options, 297–298
myisam_max_extra_sort_file_size variable, 385
myisam_max_sort_file_size variable, 385
myisampack utility, 58–60, 262
myisam_recover_options variable, 385
myisam_sort_buffer_size variable, 385
MyODBC
functions, 672–690
driver, 663
MySQL
basics, 4–5
configuration, 269–272
precedence of files, 269–270
sample files, 271, 366
executable files, 454
exporting data from Microsoft Access to, 666
logging, 272–279
binary update log, 273–276
error log, 272–273
query log, 273
rotating logs, 277–279
slow query log, 276–277
running in ANSI mode, 408
starting and shutting down
executables, 266
in Unix, 263–265
in Windows, 265–269
user-defined functions, 191–204
using different languages in, 408–413
character set, 409–413
error message display, 409
mysql command, options, 52–56
MYSQL data type (C), 645
mysql database, 416–445
permission tables, 417
columns_priv table fields, 419–420
db table fields, 418
func table fields, 420
GRANT and REVOKE to manipulate, 428–438
host table fields, 419
order of precedence, 422
populating, 422–440
tables_priv table fields, 419
user table fields, 417–418
MySQL server
changing variable values while running, 391–393
connecting to, 5–7
as root, 7
disconnecting from, 7
managing multiple, 461–464
PHP function to return status, 592
PHP function to return version, 585
programming, work division between server and application, 181–185
mysqladmin utility, 261, 361
to locate data directory, 262
processlist output, 369–373
to set passwords, 438
mysql_affected_rows() function (C), 648
mysql_affected_rows() function (PHP), 572
mysqlbinlog utility, 275, 331
mysql_change_user() function (C), 648
mysql_change_user() function (PHP), 572–573
mysql_character_set_name() function (C), 648
mysqlcheck utility, 262
analyzing tables with, 283
checking tables with, 286–287
optimizing tables with, 281
repairing tables with, 290–291
using, 292–294
mysql_client_encoding() function (PHP), 573
mysql_close() function (C), 648
mysql_close() function (PHP), 573
mysql_connect() function (C), 648
mysql_connect() function (PHP), 573–574
mysql_create_db() function (C), 648
mysql_create_db() function (PHP), 574
mysqld (server), 261, 454
options, 374–378
mysql_data_seek() function (C), 648
mysql_data_seek() function (PHP), 574–575
mysql_db_name() function (PHP), 575
mysql_db_query() function (PHP), 575
mysql_debug() function (C), 648
mysql_drop_db() function (C), 650
mysql_drop_db() function (PHP), 575–576
mysqld_safe script, 263
mysqldump, 261
for backups, 309–315
restoring database backed up with, 311–315
mysql_dump_debug_info() function (C), 650
mysqldumpslow utility, 277
mysql_eof() function (C), 650
mysql.err log, 272
mysql_errno() function (C), 650
mysql_errno() function (PHP), 576
mysql_error() function (C), 650
mysql_error() function (PHP), 576– 577
mysql_escape_string() function (C), 650
mysql_escape_string() function (PHP), 577
mysql_fetch_array() function (PHP), 577–578
mysql_fetch_assoc() function (PHP), 578
mysql_fetch_field() function (C), 651
mysql_fetch_field() function (PHP), 579
mysql_fetch_field_direct() function (C), 651
mysql_fetch_fields() function (C), 651
mysql_fetch_lengths() function (C), 651–652
mysql_fetch_lengths() function (PHP), 580
mysql_fetch_object() function (PHP), 580–581
mysql_fetch_row() function (C), 652
mysql_fetch_row() function (PHP), 581
MYSQL_FIELD data type (C), 645–647
mysql_field_count() function (C), 652
mysql_field_flags() function (PHP), 581–582
mysql_field_len() function (PHP), 582
mysql_field_name() function (PHP), 582–583
MYSQL_FIELD_OFFSET data type (C), 648
mysql_field_seek() function (C), 652
mysql_field_seek() function (PHP), 583
mysql_field_table() function (PHP), 583–584
mysql_field_tell() function (C), 653
mysql_field_type() function (PHP), 584
mysql_free_result() function (C), 653
mysql_free_result() function (PHP), 584–585
mysql_get_client_info() function (C), 653
mysql_get_client_info() function (PHP), 585
mysql_get_host_info() function (C), 653
mysql_get_host_info() function (PHP), 585
mysql_get_proto_info() function (C), 653
mysql_get_proto_info() function (PHP), 585
mysql_get_server_info() function (C), 653
mysql_get_server_info() function (PHP), 585
mysqlhotcopy utility, 262
for backups, 327–328
mysqlimport utility, 262
to restore backups from SELECT INTO, 325–326
mysql_info() function (C), 654
mysql_info() function (PHP), 586
mysql_init() function (C), 654
mysql_insert_id() function (C), 654
mysql_insert_id() function (PHP), 586
mysql_kill() function (C), 654
mysql_list_dbs() function (C), 654–655
mysql_list_dbs() function (PHP), 586–587
mysql_list_fields() function (C), 655
mysql_list_fields() function (PHP), 587
mysql_list_processes() function (C), 655
mysql_list_processes() function (PHP), 587–588
mysql_list_tables() function (C), 655–656
mysql_list_tables() function (PHP), 588
mysql_multi utility, 461–464
mysql_num_fields() function (C), 656
mysql_num_fields() function (PHP), 588–589
mysql_num_rows() function (C), 656
mysql_num_rows() function (PHP), 589
mysql_options() function (C), 656–657
mysql_pconnect() function (PHP), 176, 589–590
mysql_ping() function (C), 657
mysql_ping() function (PHP), 590
MYSQL_PWD variable, 416
mysql_query() function (C), 657
mysql_query() function (PHP), 590–591
mysql_real_connect() function (C), 657–658
mysql_real_escape_string() function (C), 658–659
mysql_real_escape_string() function (PHP), 591
mysql_real_query() function (C), 659
mysql_reload() function (C), 659
MYSQL_RES data type (C), 648
mysql_result() function (PHP), 591–592
MYSQL_ROW data type (C), 648
mysql_row_seek() function (C), 659
mysql_row_tell() function (C), 659–660
mysql_select_db() function (C), 660
mysql_select_db() function (PHP), 592
mysql.server script, 264
mysql_shutdown() function (C), 660
mysql_stat() function (C), 660
mysql_stat() function (PHP), 592
mysql_store_result() function (C), 660–661
mysql_tablename() function (PHP), 592–593
mysql_thread_id() function (C), 661
mysql_thread_id() function (PHP), 593
mysql_unbuffered_query() function (PHP), 593
mysql_use_result() function (C), 661
my_ulongong data type (C), 645
|
|