MySQL Administrator's Bible- P19

MySQL Administrators Bible- P19: Với tập trung đặc biệt vào việc phát hành lớn tiếp theo của MySQL, nguồn tài nguyên này cung cấp một khuôn khổ vững chắc cho bất cứ ai mới vào MySQL hoặc chuyển từ một nền tảng cơ sở dữ liệu, cũng như các quản trị MySQL kinh nghiệm. Các bộ đôi tác giả cao hồ sơ cung cấp bảo hiểm thiết yếu của các nguyên tắc cơ bản của phạm vi bảo hiểm cơ sở dữ liệu quản lý, bao gồm cả cách tiếp cận độc đáo MySQL của các tính năng cơ sở...
Nội dung trích xuất từ tài liệu:
MySQL Administrators Bible- P19T Index tables (continued) thawing, 406 definition extensions, 147–150 third-party packages flushing, 63 MySQL Proxy, 750–751 implementing cache, 424–427 problems with, 11 lock priority, 129 threads locking, 336, 338–341 flushing, 63 maintenance extensions, 150–156 profiling, 578 Maria configuration, 398–400 replication and, 524–529 MERGE, 510–513 server maintenance extensions, 130 MySQL deviations, 106 slave promotion and, 730–731 mysqlslap, 551–552 test mode, 560–561 partitioning. See partitioning time privileges, 482 event scheduling, 289–290 query analysis. See query analysis functions, 797–806 scans vs. indexes, 222 start and end times for periodic events, 293–294 server maintenance extensions, 130–131 TIME type, 183–184 setting characters sets and collation, 101 time zones SHOW commands, 146–147 datetime types, 183, 192–193 SHOW CREATE commands, 138 language structure, 97–98 SQL mode definitions, 206–207 TIMESTAMP data type, 183–192 SQL modes, 210–211 TINYINT(1), 180–183 system, 476–478 TINYTEXT, 164 types, 375 tokens views. See MySQL views keyword, 774–782 tablespaces Lua, 760–763 Falcon, 408–409 proxy, 772–774 InnoDB, 384–394 tools target hosts, 467 for accessing MySQL. See accessing MySQL temporary tables optimizing away Using temporary, 620–623 backup, 445–446 profiling, 577 benchmarking. See benchmarking on triggers, 247–248 correcting data drift, 540–543 TEMPTABLE, 310 monitoring. See monitoring systems terminators, 88–89 MySQL Proxy. See MySQL Proxy test modes, SysBench query analysis. See query analysis CPU, 554 query optimization. See query optimization I/O, 555–557 TRADITIONAL, 211 memory, 559–561 training, 820 mutex, 557–559 Transactional database only, 33 OLTP, 561–565 transactions test servers, 443 ACID compliance, 320–322 testing Falcon parameters, 404, 406 functions, 789–792 FEDERATED table limitations, 417 ideas, 620 InnoDB support, 384 TEXT data types isolation levels, 325–335 defined, 160–161 locking and deadlocks, 336–343 functions, 806–810 Maria support for, 371 indexing, 226–227 MySQL deviations, 110–111 sizes, 164 overview, 319–320 text files PBXT configuration, 411–412 creating from database table, 126–127 recovering, 343–344 LOAD DATA INFILE, 122–123 statement extensions, 156–158 852 Index U statements, 322–325 unique index values, 602–603 storage engine support, 377 unique key constraints summary, 344–345 creating and dropping, 231–232transform functions, 108 defined, 219–231transliterations, 108 KEY_COLUMN_USAGE, 682–684transparent partitioning, 513–514 TABLE_CONSTRAINTS, 681–682TRIGGERS, 685–686 Unixtriggers case-sensitivity, 90–91 caching with, 427 configuration file, 31 changing, 246–247 debugging account problems, 492 creating, 243–244 installing MySQL from archive package, data security using, 664–665 18–20 dropping, 244–245 installing MySQL on, 13–20 finding all, 252 monitoring. See monitoring systems multiple SQL statements in, 245–246 post-install configuration on, 36–39 overview, 242–243 resetting root password, 489–490 replication and limitations, 254–255 starting and stopping MySQL on System-V based, runtime behavior, 248–252 42–43 SHOW commands, 147 unlocking, 338–340 SHOW CREATE ...