简介
1,Why Use MySQL?
快速,稳定,它是免费软件也是商业软件,支持transactions, row-level locking, foreign keys, subqueries, and full text
searching. Version 5.0 will add stored procedures to the list.
易于安装使用,对系统要求低
2,Why MySQL Instead of Another Database?
性能,价格,功能的最佳结合.(一下略)
3,What's Different in MySQL 4.0 and 4.1?
长期以来MySQL 3.23 是最新版本,2003-04,MySQL 4.0.13 发布
a,The InnoDB engine is ACID compliant, supporting transactions, foreign keys, and
row-level locking.
b,MySQL now uses a query cache, storing the results returned by queries for later
reuse and, hence, greatly improving performance for common queries.
c,Full-text indexing and searching, which were added in 3.23.23, have been
improved with the addition of Boolean mode.
d,MERGE tables now support
INSERT and
AUTO_INCREMENT.
e,The result sets from
SELECT queries can now be merged with
UNION.
f,You can now delete rows from multiple tables with a single
DELETE
statement.
g,User privilege management has been refined. More privileges have been added to
give you a finer grain of control, and you can also now limit a user's resource
use.
h,You can now make changes to server configuration without having
to restart the server.
i,A new C language library, libmysqld, is now available to allow you to embed
MySQL servers in your programs.
j,Replication, which has been available since 3.23.15, has been
improved in various ways, mostly bug fixes. For example, you can now set up a
slave using
LOAD DATA FROM MASTER, rather than having to use mysqldump
or a tool like mysqlsnapshot.
In 4.1, there are some additional improvements. The most important change is the
addition of subqueries and derived tables. You also get Unicode support, support
for OpenGIS geographical data storage, and a host of other minor improvements.
目前公司所用的版本.4.0.21-standard
The biggest change in version 5.0 is the addition of stored procedures, which
have already been implemented in this pre-alpha. Other changes are also planned,
including support for cursors, RTREE indexes, true VARCHARs, and a host
of other minor features.
Version 5.1 should support foreign keys for all table types
(among a host of other features).
We will focus on five key areas: installing and configuring MySQL, designing and
creating databases with MySQL, using MySQL, administering MySQL, and optimizing
MySQL. We will cover all the core skills necessary to use MySQL on a
professional basis.
第一部分:MYSQL 基础
Chapter 1. Installing MySQL
配置系统
做一下配置,
1,InnoDB
阅读(2266) | 评论(0) | 转发(0) |
