MySQL Administrator's Bible- P19

Chia sẻ: Thanh Cong | Ngày: | Loại File: PDF | Số trang:6

Thêm vào BST

Báo xấu

93
lượt xem 14
download

Download Vui lòng tải xuống để xem tài liệu đầy đủ

MySQL Administrator's 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ở...

Chủ đề:

Bình luận(0) Đăng nhập để gửi bình luận!

Lưu

Nội dung Text: MySQL Administrator's Bible- P19

T Index tables (continued) thawing, 406 deﬁnition extensions, 147–150 third-party packages ﬂushing, 63 MySQL Proxy, 750–751 implementing cache, 424–427 problems with, 11 lock priority, 129 threads locking, 336, 338–341 ﬂushing, 63 maintenance extensions, 150–156 proﬁling, 578 Maria conﬁguration, 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 deﬁnitions, 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 proﬁling, 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 deﬁned, 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 ﬁles PBXT conﬁguration, 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–232 transform functions, 108 deﬁned, 219–231 transliterations, 108 KEY_COLUMN_USAGE, 682–684 transparent partitioning, 513–514 TABLE_CONSTRAINTS, 681–682 TRIGGERS, 685–686 Unix triggers case-sensitivity, 90–91 caching with, 427 conﬁguration ﬁle, 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 ﬁnding all, 252 monitoring. See monitoring systems multiple SQL statements in, 245–246 post-install conﬁguration 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 commands, 138 UNSIGNED, 178 storage and backup, 252–254 UPDATE stored routines, events and, 241–242 DML extensions, 120 summary, 300 EXPLAIN on, 614 using cursors, 287–289 foreign key constraints and, 234 on views and temporary tables, 247–248 invoking triggers, 242–243 troubleshooting upsert statements, 112–114 foreign key constraints, 235–237 updating MySQL server, 47–48 datetime types, 187–188 TRUE, 95 indexes, 223 truncation keys and indexes, 220 error handling, 275–281 memcached, 438 stored routine warning, 257–259 SERIALIZABLE isolation levels and, 334–335 TRUNCATE, 120 view, 313–316 tuning MySQL servers. See MySQL server tuning upgrading mysqld, 45–47, 257 tuning query caches, 429–433 upsert statements tunneling, ssh. See ssh tunneling DML extensions, 120 type, 596–606 MySQL deviations, 112–114 types, data. See data types use (\u), 57 types, index. See index types user management Typical installation, 21–22 accounts, 478–487 debugging account problems, 490–494 learning about, 473–478 U resetting root password, 487–490 \u (use), 57 summary, 494 UDFs (user-deﬁned functions), 241–242 USER_PRIVILEGES, 715–716 UFS (Unix ﬁle system), 355 user-deﬁned functions (UDFs), 241–242 undo logs, 343–344 user-deﬁned types, 108 UNION user-deﬁned variables, 131–135 EXPLAIN and, 591–592 usernames MERGE tables, 512–513 command-line tool options, 50 ORDER BY, 127 managing. See user management table deﬁnition extensions, 150 wildcards and blank values in, 650 853
U Index users local in stored routines, 262–264 changing event, 299 mysqladmin commands, 64 changing stored routine, 264–265 Performance Metrics and SHOW GLOBAL changing trigger, 250–252 STATUS, 570–572 group meetings, 819 in server option ﬁle. See option ﬁles managing with SQL Administrator, 77 server status, 360–361 MySQL community, 6–7 server system, 361 privileges and privilege levels, 651–653 SET extension and user-deﬁned, 131–135 resources, 130 setting characters sets and collation, 101–104 Security Options screen, 35–36 SHOW commands, 147 Using filesort, 618–620 SQL modes, 201 Using temporary, 620–623 system views, 710–711 utf8 character set vendor-supplied packages, 11 charsets and collations, 100 versions deﬁned, 93 choosing MySQL, 11–12 index length, 227 command-line tool options, 53 utilities, MyISAM, 380–381 end of life, 569 mysqladmin commands, 64 V upgrading mysqld, 45–47 vertical partitioning, 496 validation, 656–665 viewing values events, 295 assigning to user-deﬁned variables, 131–135 triggers, 252 BLOB, 169 VIEWS, 674–676 coercibility, 811 views COMMAND in PROCESSLIST, 699–700 EXPLAIN and, 591 data access strategy, 600–603 datetime types, 185–187 INFORMATION_SCHEMA database system. See ENUM and SET data types, 198–200 MySQL Data Dictionary enumerations, 195–197 MySQL. See MySQL views EXPLAIN Extra, 609–611 SHOW CREATE commands, 139 key constraints. See key constraints on triggers, 247–248 mysqldumpslow, 583–584 visitor count caching, 424–427 NOT NULL. See NOT NULL volume groups, 455–460 NULL. See NULL Volume Shadow Copy Service (Microsoft VSS), 460 partitioning algorithms, 496–497 STATE in PROCESSLIST, 701–709 stored routine SQL usage, 267–268 W subquery for select_type, 611 warm backups type, 597 deﬁned, 441 VARBINARY, 170 tools, 446 VARCHAR warnings deﬁned, 160–161 creating events, 292 length, 163–164 logging, 518 sizing, 608 SHOW commands, 147 variable-length strings SQL modes, 201–203 binary data types, 171 stored routine, 257–259, 274–275 character string types, 160–161 trigger, 245 national character string types, 166 weekly backups, 444 variables WHERE benchmarking recommendations, 565–566 optimizing by eliminating functions, 625–626 InnoDB conﬁguration, 384–385 SHOW and, 136 854
Index Z WHILE, 283 wrappers, 450–451 Widenius, Michael, 4 wrappers, transaction, 320 wildcard characters write locks in ACLs, 650 deﬁned, 336–337 deﬁned, 475–476 row-level, 341–342 Windows table-level, 339–341 case-sensitivity, 91 writes, proﬁling. See proﬁling conﬁguration ﬁle, 31 Conﬁguration Wizard on, 31–36 connecting to non-Windows machine, 51–52 X copying databases to backup, 467 XFS, 355 installing MySQL on, 20–24 XML (eXtensible Markup Language) monitoring. See monitoring systems functions, 812 mysql commands, 57–58 LOAD XML INFILE, 123–124 PATH variable conﬁguration, 42–44 resetting root password, 488–489 starting and stopping from as service, 26–29 starting and stopping from command line, 25–26 Y yanking, 58 tuning, 352–357 YEAR data type, 183–184 upgrading mysqld, 46–47 YEAR_MONTH data type, 193–194 WITH CHECK OPTION simulating check constraints in views, 310–312 on views that reference other views, 312–313 Wizards Z Zenoss Core, 641–642 Conﬁguration, 31–36 zero dates, 207–209 installation, 20–24 ZEROFILL, 179 Workbench, MySQL, 80–83 ZFS, 355, 453–454 working sets, 350 Zmanda, 466 wrapper tables, 383–384 855
The books you read to succeed. Get the most out of the latest software and leading-edge technologies with a Wiley Bible—your one-stop reference. 978-0-470-26017-3 978-0-470-04030-0 978-0-470-25704-3 978-0-470-37918-9 Wiley and the Wiley logo are registered trademarks of John Wiley & Sons, Inc. Available wherever books are sold. All other trademarks are the property of their respective owners.