< Day Day Up > |
Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] data importation problems diagnosing (High-Hat Airways) 2nd 3rd 4th High-Hat Airways 2nd 3rd resolving (High-Hat Airways) 2nd 3rd 4th protection clustering (MySQL Cluster) 2nd slave servers overhead reduction 2nd replication criteria 2nd data backups launching via MySQL Administrator 2nd 3rd via mysqldump utility 2nd 3rd via mysqlhotcopy utility 2nd 3rd data distribution node storage fragments replicas data exports binary-based method 2nd 3rd frequency of concurrency issues --lock-tables attribute 2nd --single-transaction attribute 2nd data reloading acceleration of 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th concurrency management 2nd 3rd error handling 2nd INSERT DELAYED operation multirow INSERT operation 2nd MyISAM engine recommendations 2nd 3rd 4th network performance parameters 2nd SELECT, INTO OUTFILE statement 2nd table locking 2nd in-memory processing advantages/disadvantages subsets retrieval of 2nd table schemas copying without associated data 2nd tables delaying index re-creation (mysqldump utility) 2nd 3rd text-based method 2nd 3rd data flushing (InnoDB) 2nd data modifications performance tips 2nd DELETE statement DELETE statement, DROP TABLE command 2nd DELETE statement, LOW PRIORITY option DELETE statement, QUICK option 2nd DELETE statement, TRUNCATE TABLE command 2nd indexes, disabling INSERT DELAYED statement 2nd 3rd INSERT LOW PRIORITY statement 2nd INSERT statement, multiple rows 2nd 3rd 4th INSERT, ON DUPLICATE KEY UPDATE statement 2nd 3rd data node clustering 2nd data nodes capacity parameters clustering (MySQL Cluster) 2nd clustering (MySQL Cluster) 2nd logging parameters clustering (MySQL Cluster) 2nd memory parameters clustering (MySQL Cluster) 2nd 3rd timing parameters clustering (MySQL Cluster) 2nd 3rd transaction parameters clustering (MySQL Cluster) 2nd 3rd data sets performance analysis pretesting preparations 2nd data storage InnoDB configuring 2nd 3rd 4th innodb autoextend increment variable innodb file io threads variable innodb open files server variable innodb tablespace monitor variable 2nd monitoring 2nd 3rd 4th tuning 2nd 3rd 4th data storage (MyISAM) optimal configuation table maintenance and repair 2nd 3rd 4th 5th table reporting and control 2nd 3rd 4th 5th table sorting resources 2nd data-loading operations performance tips 2nd DELETE statement DELETE statement, DROP TABLE command 2nd DELETE statement, LOW PRIORITY option DELETE statement, QUICK option 2nd DELETE statement, TRUNCATE TABLE command 2nd indexes, disabling INSERT DELAYED statement 2nd 3rd INSERT LOW PRIORITY statement 2nd INSERT statement, multiple rows 2nd 3rd 4th INSERT, ON DUPLICATE KEY UPDATE statement 2nd 3rd Database Storage Engines and Table Types (product suite category) 2nd ARCHIVE Berkeley Database (BDB) CSV EXAMPLE FEDERATED InnoDB ISAM MaxDB MEMORY MERGE MyISAM NDB CLUSTER storage engines ARCHIVE Berkeley Database (BDB) CSV 2nd FEDERATED 2nd InnoDB 2nd MaxDB MEMORY 2nd 3rd MERGE 2nd 3rd 4th MyISAM 2nd 3rd 4th 5th 6th 7th 8th 9th NDB CLUSTER selection options 2nd databases integrity primary keys, defining 2nd performance analysis pretesting preparations 2nd symbolic links (MyISAM) 2nd deadlocks transaction length debugging performance analysis 2nd decimal types (numbers) column performance implications dedicated subnets clustering (MySQL Cluster) DEFAULT constraint 2nd 3rd defragmenting tables myisamchk utility 2nd OPTIMIZER TABLE command 2nd 3rd tables (InnoDB) 2nd 3rd degraded concurrency transaction length DELETE statement data-loading operations DROP TABLE command 2nd LOW PRIORITY option QUICK option 2nd TRUNCATE TABLE command 2nd deploying disk drives speed issues descending indexes 2nd designing databases when not to normalize 2nd 3rd destroying connections cost of 2nd 3rd diagnosing application failures High-Hat Airways scenario 2nd 3rd 4th 5th large-sale data importation problems High-Hat Airways 2nd 3rd 4th server clustering problems High-Hat Airways 2nd 3rd 4th server outages High-Hat Airways scenario 2nd 3rd 4th stored procedure problems High-Hat Airways 2nd 3rd 4th transaction failures High-Hat Airways scenario 2nd 3rd 4th disabling extraneous services Windows tuning tip 2nd Disk Cleanup utility system files deleting (Windows) 2nd Disk Defragmenter utility disks defragmenting (Windows) 2nd 3rd disk drives access parameters modifying (Linux) 2nd autoextend variable settings (InnoDB) 2nd defragmenting (Windows Disk Defragmenter utility) 2nd 3rd performance tips deployment of speedy drives memory cache configuration 2nd RAID strategy implementation 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th temporary directory distribution 2nd disk striping (RAID 0) 2nd disks capacities performance analysis Linux reporting utilities iostat DISTINCT statement queries 2nd Distributed Computing Technologies (product suite category) MySQL Cluster Replication distributing temporary directories disk drive performance 2nd doulblewrite buffer InnoDB performance enhancer drivers (ODBC) Don't Cache Results setting Force Use of Named Pipes setting Use Compressed Protocol setting DROP TABLE command 2nd duplexing (RAID 0) 2nd dynamic hashing indexes |
< Day Day Up > |