History of mysql database (MySQL development history)

The history of MySQL can be traced back to 1979. At that time, Oracle Bone Inscriptions was just tinkering around the edges, and Microsoft's SQLServer was still missing. Once there was a man named MontyWidenius, who worked in a small company called TcX, and designed a report tool with BASIC, which could run on a computer with a main frequency of 4M and a memory of 16KB. Soon after, this tool was rewritten in C language and transplanted to Unix platform. At that time, it was just a very low-level report-oriented storage engine. This tool is called Unireg.

However, this small company has limited resources and Monty is extremely talented. Faced with the unfavorable conditions of limited resources, he can give full play to his potential and always strive to write the most efficient code. And thus formed a habit. Monty has some other colleagues. Few people can keep writing those codes for 20 years, but Monty did.

In 1990, some customers of TcX began to request SQL support for their API. At that time, some people thought of using commercial databases directly, but Monty felt that the speed of commercial databases was not satisfactory. So, with the help of mSQL code, he integrated it into his own storage engine. But unfortunately, the effect is not very good. Therefore, Monty is ambitious and determined to rewrite an SQL support himself.

1996, MySQL 1.0 release, only for a small number of people, equivalent to internal release. 1June, 1996, MySQL 3.11released, hehe, there is no 2.x version. At first, only the binary version under Solaris was provided. A month later, the Linux version appeared.

In the next two years, MySQL was transplanted to various platforms in turn. At the time of release, the authorization strategy adopted is somewhat different: free commercial use is allowed, but MySQL cannot be released together with its own products. If you want to publish it together, you must use a special license, which means spending money. Of course, business support also costs money. Others are available to users. This special license has brought some income to MySQL, thus laying a good foundation for its sustainable development. Think about it carefully, PostgreSQL has been at a low point in recent years, which may be related to its complete free and unrestricted.

MySQL3.22 should be an iconic version, providing basic SQL support.

The first edition of MySQL relational database was released in1998+1October. It uses the multithreading mechanism provided by the system kernel to provide a complete multithreading operation mode, provides programming interfaces (APIs) for C, C, Eiffel, Java, Perl, PHP, Python, Tcl and other programming languages, supports various field types, and provides complete operators to support SELECT and WHERE operations in queries.

MySQL is open source, and anyone can download it under the license of GeneralPublicLicense and modify it according to personal needs. MySQL has attracted much attention because of its speed, reliability and adaptability.

1999-2000, a company was established in Sweden called MySQLAB(AB means "joint stock company" in Swedish). Several people were hired to develop BerkeleyDB engine in cooperation with Sleepycat. Because BDB supports transaction processing, MySQL began to support transaction processing.

In April 2000, MySQL sorted out the old storage engine and named it MyISAM. At the same time, in 200 1, HeikikiTuuri made a suggestion to MySQL, hoping to integrate their storage engine InnoDB, which also supports transaction processing and row-level locking.

Unfortunately, now it seems that both BDB and InnoDB have been acquired by Oracle Bone Inscriptions. In order to eliminate competitors, even if it is open source, it is unscrupulous.

The official combined version of MySQL and InnoDB is 4.0.

In MySQL5.0, from June 5438 to February 2003, views and stored procedures began to appear. Of course, there are also many bugs in this period.

MySQL was acquired by Sun Company on June 65438+ 10, 2008.

Recently, MySQL founder MontyWidenius has submitted his resignation to Sun. The boss is leaving.

It is said that the company acquired by Sun is unlucky. Don't know the future of MySQL. I hope you have a good trip. I believe MySQL has a long life.

Today, the combination of mysql and php is absolutely perfect. Many large websites also use mysql database. The development prospect of mysql is very bright!