DML extensions 4. DROP extensions 4. Server maintenance extensions 4. The SET extension and user-defined variables 4. Local variables in stored code 4. Assigning values to dynamic server variables 4. The SHOW extension 4. Table definition extensions 4. Table maintenance extensions 4. Index and data corruption 4. Fragmentation 4. Reclaiming disk space 4. Maintaining table statistics 4. Getting a table checksum 4. Transactional statement extensions 4. Summary 5.
Character String Types 5. Length 5. CHAR Length 5. TEXT sizes 5. Character string type attributes 5. National Character String Types 5. Binary Large Object String Types 5. BLOB values 5. Numeric Types 5.
Numeric data sizes and ranges 5. Integer sizes and ranges 5. BIT size and range 5. FLOAT size and range 5. Numeric data type attributes 5. Boolean Types 5. Datetime Types 5. Allowed input values 5. Microsecond input 5. Automatic updates 5. Conversion issues 5. Other conversion issues 5. Datetime data type attributes 5.
The effect of time zones 5. Interval Types 5. Enumerations 5. Choosing SQL Modes 5. Invalid Data 5. SQL modes 5. SQL mode functionality 5. SQL mode definitions 5. Summary 6. Looking at Keys and Indexes 6. Using Indexes to Speed Up Lookups 6. Creating and dropping indexes 6. Index order 6. Index length 6. Index types 6. Redundant indexes 6. Creating and Dropping Key Constraints 6. Creating and dropping unique key constraints 6. Creating and dropping foreign key constraints 6. Foreign key constraints and data changes 6.
Requirements for foreign key constraints 6. Summary 7. Stored Routines, Triggers, and Events 7. Comparing Stored Routines, Triggers, and Events 7. Using Triggers 7. Creating a trigger 7. Dropping a trigger 7. Multiple SQL statements in triggers 7. Changing a trigger 7. Triggers on views and temporary tables 7. Trigger runtime behavior 7.
Character set and collation 7. Changing whom a trigger is invoked as 7. Finding all triggers 7. Trigger storage and backup 7. Triggers and replication 7. Trigger limitations 7. Using Stored Routines 7. Performance implications of stored routines 7. Stored procedures vs. Creating a stored routine 7. Invoking a stored procedure 7. Dropping a stored routine 7. Multiple SQL statements in stored routines 7.
INOUT arguments to a stored procedure 7. Local variables 7. Stored routine runtime behavior 7. How the stored routine runs 7. Options when creating routines 7. Comments 7. Language 7. Determinism 7. SQL usage 7. Creating a basic stored function 7. Invoking a stored function 7. Changing a stored routine 7. Naming: stored routines 7.
Stored procedure result sets 7. Stored routine errors and warnings 7. Conditions and handlers 7. Handlers 7. Conditions 7. Stored routine flow control 7. CASE 7. WHILE 7. LOOP 7. LEAVE 7. Recursion 7.
Stored routines and replication 7. Stored function limitations 7. Stored routine backup and storage 7. Using Cursors 7. Using Events 7. Turning on the event scheduler 7. Creating an event 7. Dropping an event 7. Multiple SQL statements in events 7. Start and end times for periodic events 7. Event status 7. Finding all events 7. Changing an event 7. After the last execution of an event 7. Event logging 7. Event runtime behavior 7. Changing whom an event is invoked as 7.
Event limitations 7. Event backup and storage 7. Summary 8. MySQL Views 8. Defining Views 8. View definition limitations and unexpected behavior 8. Security and privacy 8. Specify a view's definer 8. Abstraction and simplification 8. Performance 8. View algorithm 8. Materialized views and view indexes 8. Simulating check constraints 8.
Updatable views 8. Updatable view limitations 8. Updatable view problems 8. Changing a View Definition 8. Replication and Views 8. Summary 9. Transactions in MySQL 9. Atomicity 9. Consistency 9. Isolation 9. Durability 9. Using Transactional Statements 9. Savepoints 9. Using Isolation Levels 9. Multi-version concurrency control 9. Explaining Locking and Deadlocks 9. Table-level locks 9. Page-level locks 9. Row-level locks 9. Summary III.
Choosing Optimal Hardware Tuning the Operating System Operating system architecture File systems and partitions Buffers Kernel parameters Linux Open files limit Swap memory Other daemons Status variables System variables Option file Overall mysqld options MyISAM storage engine options InnoDB storage engine options Falcon storage engine options Maria storage engine options Query cache options Dynamic variables Storage Engines Understanding Storage Engines Storage engines as plugins Storage engine comparison Using Different Storage Engines MyISAM storage engine MyISAM configuration options MyISAM utilities Merge storage engine InnoDB storage engine Tablespace configuration variables Performance configuration variables InnoDB tablespace management Working with ibdata Files Adding an additional ibdata file to a shared tablespace Removing or reorganizing shared tablespace files Moving from a shared tablespace file to per-table tablespace InnoDB log files and crash recovery Maria storage engine Maria configuration options Log configuration parameters Page cache configuration Maria table options Miscellaneous configuration Maria command-line tools Falcon storage engine Architectural overview Falcon configuration options Performance optimization configuration Transactional support configuration Record cache configuration Serial log configuration Falcon tablespace management Creating a new tablespace Creating tables and indexes PBXT storage engine PBXT configuration options Transaction configuration Data log configuration File growth variables Installing the PBXT binary plugin NDB storage engine Archive storage engine Blackhole storage engine CSV storage engine Working with Storage Engines Summary Caching with MySQL Implementing Cache Tables Working with the Query Cache What gets stored in the query cache?
Query cache memory usage and tuning Query cache fragmentation Utilizing Memcached Backups and Recovery Uses for backups Disaster recovery Data recovery Easy test server creation Easy slave creation Backup frequency What to back up Backup locations Backup methods File system snapshot ZFS LVM SAN-based Microsoft VSS Online backup Commercial options InnoDB hot backup Zmanda R1Soft Copying Databases to Another Machine Recovering from Crashes Planning for Disasters User Management Access control lists Wildcards System tables Managing User Accounts Global Database Table Column Routine Resetting the Root Password Windows server Unix-Based server Debugging User Account Problems Bad password Access issues Client does not support authentication protocol Search Engine.
The high-profile author duo provides essential coverage of the fundamentals of MySQL database managementincluding MySQL's unique approach to basic database features and functionsas well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.
MySQL Bible. Comprehensive coverage: This Bible covers both beginning-level and advanced topics.
0コメント