Make homepage|Add to favorites
 

MYSQL TOOLS
reviews, articles, tips & snippets

 
Buy SQL » Articles for 08.11.2011

What is MySQL DBMS?

Author: admin on 8-11-2011, 17:48

 

MySQL is the world's most popular open source database software, with over 100 million copies of its software downloaded or distributed throughout it's history. With its superior speed, reliability, and ease of use, MySQL has become the preferred choice for Web, Web 2.0, SaaS, ISV, Telecom companies and forward-thinking corporate IT Managers because it eliminates the major problems associated with downtime, maintenance and administration for modern, online applications.

 

Many of the world's largest and fastest-growing organizations use MySQL to save time and money powering their high-volume Web sites, critical business systems, and packaged software — including industry leaders such as Yahoo!, Alcatel-Lucent, Google, Nokia, YouTube, Wikipedia, and Booking.com.

 

The flagship MySQL offering is MySQL Enterprise, a comprehensive set of production-tested software, proactive monitoring tools, and premium support services available in an affordable annual subscription.

 

MySQL is a key part of LAMP (Linux, Apache, MySQL, PHP / Perl / Python), the fast-growing open source enterprise software stack. More and more companies are using LAMP as an alternative to expensive proprietary software stacks because of its lower cost and freedom from platform lock-in.

 

MySQL was originally founded and developed in Sweden by two Swedes and a Finn: David Axmark, Allan Larsson and Michael "Monty" Widenius, who had worked together since the 1980's. More historical information on MySQL is available on Wikipedia

 

 

What is MySQL?

 

MySQL is a very popular database management system with open source software, developed by MySQL AB. MySQL AB is a commercial company that builds its business on its services, focusing on the database MySQL.

MySQL is a database management system.

Database is called a structured set of data. This can be anything from a simple list of purchases to the image gallery. To add, access and process data stored in a computer database, you need a database management system such as MySQL. Since computers are very good at handling large amounts of data, databases play a central role in computing, as standalone utilities or as parts of other software packages.
MySQL is a relational DBMS.
A relational database stores data in separate tables. This adds speed and flexibility. Tables are linked by certain relationships that make it possible to combine data from multiple tables in one query. MySQL SQL-part focus on Structured Query Language, the most common standardized language used to refer to computer databases.
MySQL is Open Source Software.

Open Source means that texts are open for reading and editing of all comers. Anybody can download MySQL from the Internet and use it absolutely free. Anyone can learn the source code and modify it at will.MySQL uses the GPL license (GNU General Public License), to determine what you can do with software in different situations. If you feel uncomfortable or GPL must implement MySQL in a commercial software program, you can buy commercially patented version of the authors.
Why use MySQL?
MySQL is very fast, reliable and easy to use. If this is what you are looking for, you should try it. MySQL also has a very practical set of features developed in very close cooperation with users. You can find a comparison of the effectiveness of MySQL to some other database administrators to benchmark page. MySQL was originally designed to handle very large databases much faster than existing solutions, and successfully used in industrial environments vysokotrebovatelnyh for several years. With the constant development of MySQL today offers a rich and powerful set of functions. Connectivity, speed and defense make MySQL very suitable for accessing the databases from the Internet.
Technical capabilities of MySQL.

MySQL is a system of "client-server", consisting of multi-threaded SQL-Server, which supports various functions of several different client programs and libraries, administrative tools, and several programming interfaces.
MySQL has a lot of additional programs.
Probably you will find that your favorite application or language already supports MySQL.

Profiler for MySQL - Jet Profiler

Author: Dicentis on 8-11-2011, 17:17

 

is a real-time query performance and diagnostics tool for the MySQL database server. It's core features:

  • Query, table and user performance
  • Graphical visualisation
  • Low overhead
  • User friendly