|
|
table types, 56–66
BDB tables, 66
HEAP tables, 63–65
and indexes, 152–153
InnoDB tables, 65–66
ISAM (Indexed Sequential Access Method) table type, 56
MERGE tables, 60–63
MyISAM table type, 56–60
compressed tables, 58–60
dynamic tables, 57–58
static tables, 57
table_cache variable, 367–368, 386
table_info method (Perl DBI), 604
Table_locks_immediate variable, 390
Table_locks_waited status value, 391
tables. See also information retrieval
adding new records to, 11–12
adding records from other tables, 96–98
analyzing, 282–284
with ANALYZE TABLE statement, 282–283
with myisamchk utility, 283–284
with mysqlcheck utility, 283
changing records, 24
checking, 284–288
with CHECK TABLE statement, 285–286
with myisamchk utility, 287–288
with mysqlcheck utility, 286–287
creating, 9–11
deleting records, 23–24, 98
files for, 263
joining, 32–35
listing existing, 11
locking, 118–124
avoiding, 124
name changes, 26
optimizing, 280–282
with myisamchk utility, 281–282
with mysqlcheck utility, 281
with OPTIMIZE statement, 280
PHP function to return name from query result, 592–593
PHP function to return resource to list, 588
relations between, 31–32
repairing, 288–298
with myisamchk utility, 291–292
with mysqlcheck utility, 290–291
with REPAIR TABLE, 289–290
structure changes, 25–26
symbolic linking, 476–477
table structure display, 11
tables method (Perl DBI), 604
tables_priv table
fields, 419
and user permissions, 422
table_type variable, 386
Taint attribute (Perl DBI), 613
TAN() function, 553–554
tar distribution, installing on Unix, 455–457
tar utility, 459
TCP/IP, for client access to server, 263
technology, application requirements, 186–187
Telnet, for connection to MySQL server, 6
terminators, for SELECT INTO backups, 316–317
testing
in application development, 189
database design, 248
example, 255–256
user-defined functions, 194
TEXT column type, 46
full-text index for, 132
index for, 141
text file, loading data into table from, 13
3rd normal form, 228–229
thread_cache_size variable, 387
thread_concurrency variable, 387
threads
optimizing record adds from multiple, 172–173
PHP function to return ID, 593
user variables and, 99–100
THREADSAFETY attribute (Python), 620
Threads_cached status value, 391
Threads_connected status value, 391
threads_connected variable, 368
Threads_created status value, 391
Threads_running status value, 391
threads_running variable, 369
thread_stack variable, 387
threshold
50-percent, 134
Boolean full-text searches and, 136
time. See date and time column types
TIME date column type, 51
TIME_FORMAT() function, 521
timepoint, for consistent read, 115
TIMESTAMP date column type, 51
TIMESTAMP variable, 393, 496
TIME_TO_SEC() function, 521
timezone variable, 387
TINYBLOB column type, 46
TINYINT column type, 42
TINYINT data type, 10
TINYTEXT column type, 46
tmpdir variable, 387
tmp_table_size variable, 387
TO_DAYS() function, 522
trace method (Perl DBI), 597, 599
TraceLevel attribute (Perl DBI), 613
trace_msg method (Perl DBI), 599
trailing spaces, and comparison operators, 72
transactions, 105–125
ACID conditions, 256–257
in BDB tables, 115–117
commands that end, 117–118
in InnoDB tables, 65–66, 105– 107
consistent reads, 107–108
read locks for sharing, 111– 112
read locks for updating, 109– 111
levels, 124–125
LOCK TABLES statement and, 122
transitive relationships, 225
and 3rd normal form, 228
TRIM() function, 542–543
troubleshooting, user-defined functions, 204
TRUNCATE() function, 554
TRUNCATE statement, 98, 497
and auto increment counter reset, 145
and transaction completion, 117
truth table, AND/OR, 14–15
tuple, 5
TYPE attribute (Perl DBI), 616
type conversion, for comparison operators, 72
type_info method (Perl DBI), 604
type_info_all method (Perl DBI), 604
|
|