The origin of MySQL name

The origin of MySQL name

MySQL name Origin MySQL is a small relational database management system, the developer for the Swedish Mysqlab Company, was acquired by Sun Company on January 16, 2008. MySQL is widely used in small and medium-sized websites on the internet. Because of its small size, fast speed, low total cost of ownership, especially the open source, many small and medium-sized web sites in order to reduce the total cost of ownership of the site chose MySQL as the site database.

The intent of MySQL's original developers was to connect tables with mSQL and their own fast low-level routines (ISAM). However, after some testing, the developer concludes that mSQL is not as fast and flexible as they need to be. This led to the creation of a new SQL interface for their database using almost the same API interface as mSQL, so that the API was designed to allow for easier porting of third-party code written for mSQL to MySQL.

The name of the MySQL dolphin logo is called "Sakila", and it is selected by the founder of MySQL AB from a list of many names suggested by the user in the "Dolphin Naming" contest. The winning name is provided by Ambrose Twebaze, an open source software developer from Swaziland, Africa. According to Ambrose, Sakila comes from a Swaziland dialect called SiSwati, and is also the name of a small town in Arusha, Tanzania, near Ambrose's hometown of Uganda.

MySQL name Origin MySQL is a small relational database management system, the developer for the Swedish Mysqlab Company, was acquired by Sun Company on January 16, 2008. MySQL is widely used in small and medium-sized websites on the internet.

MySQL Overview

MySQL is a small relational database management system, the developer of the Swedish MySQL AB company. was acquired by Sun Company on January 16, 2008. In 2009, Sun was acquired by Oracal. No one is optimistic about MySQL's future. MySQL is now widely used in small and medium-sized websites on the internet. Because of its small size, fast speed, low total cost of ownership, especially the open source, many small and medium-sized web sites in order to reduce the total cost of ownership of the site chose MySQL as the site database.

MySQL name Origin MySQL is a small relational database management system, the developer for the Swedish Mysqlab Company, was acquired by Sun Company on January 16, 2008. MySQL is widely used in small and medium-sized websites on the internet.

MySQL features

1. Written in C and C + + and tested with a variety of compilers to ensure source code portability

2. Support for AIX, FreeBSD, HP-UX, Linux, MacOS, Novell Netware, OpenBSD, Os/2 Wrap, Solaris, Windows and many other operating systems

3. Provides APIs for a variety of programming languages. These programming languages include C, C + +, Python, Java, Perl, PHP, Eiffel, Ruby, and Tcl.

4. Support multi-threading, make full use of CPU resources

5. Optimized SQL query algorithm to improve query speed effectively

6. Can be used as a separate application in the Client server network environment, but also can be embedded in other software as a library to provide multi-language support, common encoding such as Chinese GB 2312, BIG5, Japanese shift_jis, etc. are available as data table name and data column name

7. Provide a variety of database connection paths such as TCP/IP, ODBC and JDBC

8. Provide management tools for managing, inspecting, and optimizing database operations

9. Can handle large databases with thousands records

MySQL name Origin MySQL is a small relational database management system, the developer for the Swedish Mysqlab Company, was acquired by Sun Company on January 16, 2008. MySQL is widely used in small and medium-sized websites on the internet.

Application of MySQL

Compared to other large databases such as Oracle, DB2, SQL Server, MySQL has its shortcomings, such as small size, limited functionality (MySQL cluster is relatively poor in functionality and efficiency), but this does not diminish its popularity. MySQL provides more than enough functionality for general personal users and small and midsize businesses, and because MySQL is open source software, it can significantly reduce total cost of ownership.

Currently, the popular web site architecture is lamp (linux+apache+mysql+php), that is, using Linux as the operating system, Apache as a Web server, MySQL as a database, PHP as a server-side script interpreter. Since these four software are free or open source software (FLOSS), using this method can build a stable, free website system without spending a penny.

MySQL Management

You can use the command-line tools to manage MySQL databases (command MySQL and mysqladmin), or you can download the graphics management tools MySQL administrator and MySQL Query Browser from the MySQL Web site.

phpMyAdmin is a MySQL repository system management program written by PHP that allows administrators to manage MySQL repositories in a web interface.

Phpmybackuppro is also written in PHP and can be used to create and manage databases through a web interface. It can create pseudo-cronjobs that can be used to automatically back up MySQL databases at a certain time or period.

In addition, there are other GUI management tools, such as the previous Mysql-front and Emsmysql Manager,navicat and so on.

MySQL's most common application architecture

Single point for small-scale applications

Replication (Replication) for small to medium-sized applications

Cluster (Cluster) for large-scale applications

A number of new features have been added to the MySQL4.1 version, including higher speed caching of primary keys, better support for subqueries, and geographic information-based queries that should be required by network dating sites.

Its simultaneous development of the 5.0 version of the target to the enterprise users, for all the new features in the 4.1 version, 5.0 full income pocket, and unique features: good support for foreign keys, system automatic error mechanism and full support for stored procedures.

MySQL name Origin MySQL is a small relational database management system, the developer for the Swedish Mysqlab Company, was acquired by Sun Company on January 16, 2008. MySQL is widely used in small and medium-sized websites on the internet.

MySQL Version History

MySQL is currently developing two versions of the software, version 4.1 and version 5.0. The 4.1 version of the code has been released and is expected to release the final code after 8 months. The final product of version 5.0 will be released in 6 months.

A number of new features have been added to the MySQL4.1 version, including higher speed caching of primary keys, better support for subqueries, and geographic information-based queries that should be required by network dating sites.

And the 5.0 version of its synchronous development has targeted the enterprise users, for all new features in the 4.1 version, 5.0 full income in the bag, and the following features: Good support for foreign keys, system automatic error mechanism and full support for stored procedures.

Early 2009. The MYSQL version 5.4 preview has been released.

The origin of MySQL name