初識mysql

wl365365發表於2015-07-02

What is MySQL

my oracle是一個非常流行的開源的資料庫,具有以下的特點:
MySQL is a database management system

MySQL databases are relational

MySQL software is Open Source

The MySQL Database Server is very fast, reliable, scalable, and easy to use

MySQL Server works in client/server or embedded systems

A large amount of contributed MySQL software is available


Which MySQL Version and Distribution to Install

mysql的版本在各個平臺的支援


當我們在選擇安裝mysql的時候,分為開發者版本和GA版本,開發者版本會提供一些新的特性,但是如果是生產的話還是安裝GA的版本
First, decide if you want to install a development release or a GA release. Development releases have the newest features, but are not recommended for production use. GA (General Availability) releases, also called production or stable releases, are meant for production use. We recommend to use the most recent GA release.

mysql的版本號

The naming scheme in MySQL 5.6 uses release names that consist of three numbers and a suffix; for example,mysql-5.6.1-m1. The numbers within the release name are interpreted as follows:

  • The first number (5) is the major version and describes the file format. All MySQL 5 releases have the same file format.-------大版本號

  • The second number (6) is the release level. Taken together, the major version and release level constitute the release series number.-------release的級別

  • The third number (1) is the version number within the release series. This is incremented for each new release. Usually you want the latest version for the series you have chosen.

MySQL的版本命名機制使用由3個數字和一個字尾組成的版本號。例如,像mysql-5.1.26-rc的版本號這樣解釋:

  ·第1個數字(5)是主版本號,描述了檔案格式。所有版本5的發行都有相同的檔案格式。

  ·第2個數字(6)是發行級別。主版本號和發行級別組合到一起便構成了發行序列號。

  ·第3個數字(1)是在此發行系列的版本號,隨每個新分發版遞增。通常你需要已經選擇的發行(release)的最新版本(版本)。

   每次更新後,版本字串的最後一個數字遞增。如果相對於前一個版本增加了新功能或有微小的不相容性,字串的第二個數字遞增。如果檔案格式改變,第一個數字遞增。

   字尾顯示發行的穩定性級別。透過一系列字尾顯示如何改進穩定性。可能的字尾有:

  • If there is no suffix, it indicates that the release is a General Availability (GA) or Production release. GA releases are stable, having successfully passed through all earlier release stages and are believed to be reliable, free of serious bugs, and suitable for use in production systems. Only critical bugfixes are applied to the release.

  • mN (for example, m1m2m3, ...) indicate a milestone number. MySQL development uses a milestone model, in which each milestone proceeds through a small number of versions with a tight focus on a small subset of thoroughly tested features. Following the releases for one milestone, development proceeds with another small number of releases that focuses on the next small set of features, also thoroughly tested. Features within milestone releases may be considered to be of pre-production quality.

  • rc indicates a Release Candidate. Release candidates are believed to be stable, having passed all of MySQL's internal testing, and with all known fatal runtime bugs fixed. However, the release has not been in widespread use long enough to know for sure that all bugs have been identified. Only minor fixes are added.



  ·rc
    是釋出代表;是一個發行了一段時間的beta版本,看起來應該執行正常。只增加了很小的修復。(釋出代表即以前所稱的gamma 版)

  ·如果沒有字尾
    這意味著該版本已經在很多地方執行一段時間了,而且沒有非平臺特定的缺陷報告。這就是我們稱為一個產品(穩定)或“通用”版本的東西。 

How to Get MySQL

可以透過網站 http://dev.mysql.com/downloads/   下載我們需要的版本


   

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22039464/viewspace-1720229/,如需轉載,請註明出處,否則將追究法律責任。