MySQL Chapter 1Linux教学课件.ppt

RHEL Clustering Storage Management MySQL Introduction to the MySQL products MySQL SQL/MySQL 事务，隔离，并发控制，锁 用户和权限 监控 STATUS 索引类型：查询 VARIABLES 备份和恢复 复制功能 集群 文件： 数据冗余和不一致性 数据访问困难 数据孤立 完整性问题 原子性问题 并发访问异常 安全性问题 DBMS 层次模型 网状模型 关系模型 RDBMS 文件： 表示层 文件 逻辑层 文件系统：存储引擎 物理层 元数据 数据：数据块 C/S：协议(mysql) 关系型数据 表示层：表 逻辑层：存储引擎 物理层：数据文件 数据存储和查询 存储管理器 查询管理器 thread reuse 单进程 多线程 守护线程 应用线程 10个用户 256M 1G 256M 32bit: 2.7G 64bit: smp: 对称多处理器 自然连接 user.shellid=shell.shellid E-R：实体-关系模型 MySQL插件式存储引擎 5.5.8： MyISAM 5.5.8后: InnoDB I/O操作：磁盘，块 Storage Engine: data block 20、4 Agenda Database SQL MySQL Installing MySQL Accessing MySQL command-line tools GUI tools Databases and DBMS Database To describe an assortment of products and systems that have included anything from a collection of files to a complex structure made up of user interfaces, data storage and access mechanisms, and client/server technologies. At its simplest, a database is a collection of data that is usually related in some fashion. Yet a database is more than simply a collection of related data. The data must be organized and classified in a structured format that is described by metadata, which is data that describes the data being stored. The Relational Model The relational data model represents a radical departure from the rigid structures of the hierarchical and network models. Applications accessing a hierarchical database rely on a defined implementation of that database, and the database structure must be hard-coded into the application’s programming language. If the database changes, the application must change. However, a relational database is independent of the application. Database Management Systems A DBMS is made up of a comprehensive set of server and client tools that support various administrative and data-related tasks At the very least, a DBMS must store data and allow data to be retrieved and modified in a way that protects the data against operations that could corrupt or insert inconsistencies