MySQL: General Information

Rate this item
(0 votes)

b2ap3_thumbnail_iStock_000024176180XSmall.jpgMySQL is a famous database management system (DBMS), widely used in combination with PHP.

Database is a structured collection of data. The data may range from a simple list of items to be purchased to a catalog of exhibit items in the picture gallery or to a large amount of information in the corporate network. To record, retrieve and process data stored in the computer database, one needs such software as MySQL. Since computers have no difficulties processing large amount of data, database management plays a key role in calculations. Database management may be provided by a separate utility or by a code integrated into other applications.

MySQL is a relational database management system. In relational database, data are not just piled up but stored in separate tables. This approach provides higher speed and flexibility. Tables are connected to each other with special relations. Thus query execution benefits from simultaneous processing of data stored in various tables. SQL as a part of MySQL is a language of structured queries and a widely used standard language applied to access database.

MySQL is an open source software which may be modified in any way one desires. This software is available on the Internet for free download and use. Every user may utilize and modify the source code according to his needs. MySQL is available under the terms of the GNU (General Public License), http://www.gnu.org/licenses/, which regulates the use aspects of this software.

Why do programmers prefer MySQL? MySQL is fast, reliable and easy to operate. Among other advantages it has a convenient interface. Originally MySQL was designed to operate large databases at a higher speed than the existing analog applications at that time. Already for several years this software is successfully used in commercial production which has high requirements. MySQL is being constantly updated. At present it has a range of useful functions. Due to its availability, speed and reliability MySQL is an excellent choice to access databases via the Internet.

MySQL technical capacity

MySQL is a client-server system with the integrated multithreaded SQL-server which works on many system platforms and maintains various client applications and libraries, administration features and a wide range of APIs.

MySQL also exists as a multithreaded library which may be integrated into the user application to make it more compact and easy to operate. There is a lot of available software for MySQL, which is for the most part free.

MySQL structure

MySQL consists of two parts: the server and the client.

MySQL server works constantly in the computer. Client applications (like PHP scripts) transmit SQL-queries to MySQL server via sockets (that is via network). The server processes them and stores the result. In other words, the script (client) indicates the information it wishes to receive from the database server. Afterwards the server sends a reply (result) to the client (script).

Why is the result transmitted not in whole? The result can be too large. Consequently its transition via network takes a lot of time. Usually, one doesn’t need to get the whole result at once that is all tuples which satisfy a query expression. For example, one may only need to calculate a number of tuples satisfying a query expression or to select only first ten tuples. Socket application implies client-server technology, which presupposes that one should run MySQL that receives and processes queries from applications. Since it takes only one computer to run the software, the costs of MySQL-server installation and maintenance are quite low.

MySQL consists of three levels: databases, tables, and tuples. Physically, databases and tables are represented with file extensions like frm, MYD, MYI. Logically, table is represented by a total of tuples. MySQL database name is unique within the system. Table name is unique within the database and the field name – within the table. One MySQL server can maintain several databases simultaneously, which can be accessed using login and password. After the access has been granted, one can create or delete a table, add tuples, etc. Usually login and password are provided by hosting providers who secure MySQL support for their users.

Last modified on Thursday, 28 May 2015 16:14
Data Recovery Expert

Viktor S., Ph.D. (Electrical/Computer Engineering), was hired by DataRecoup, the international data recovery corporation, in 2012. Promoted to Engineering Senior Manager in 2010 and then to his current position, as C.I.O. of DataRecoup, in 2014. Responsible for the management of critical, high-priority RAID data recovery cases and the application of his expert, comprehensive knowledge in database data retrieval. He is also responsible for planning and implementing SEO/SEM and other internet-based marketing strategies. Currently, Viktor S., Ph.D., is focusing on the further development and expansion of DataRecoup’s major internet marketing campaign for their already successful proprietary software application “Data Recovery for Windows” (an application which he developed).

5 comments

  • Comment Link lose weight fast Tuesday, 19 December 2017 09:45 posted by lose weight fast

    Content is what it's about people and this is what I call good content. The information here is both interesting and informative. This might make a good resource for people seeking content ideas.

  • Comment Link Lyle Thursday, 28 September 2017 17:21 posted by Lyle

    Great work! That is the kind of info that should be shared across the
    web. Shame on the seek engines for no longer positioning this post higher!
    Come on over and seek advice from my site . Thank you =)

  • Comment Link weight loss Wednesday, 30 August 2017 04:25 posted by weight loss

    It is obvious that the following post is one of the best I have found today. It's also evident the individual who's webpage this is put alot of work in it. Good work!

  • Comment Link Diet Plans Sunday, 23 October 2016 17:16 posted by Diet Plans

    It is evident that this blog post is among the finest I have found today. It's also obvious the person who's page this is put alot of work into it. Great work!

  • Comment Link Terrence Thursday, 09 June 2016 05:54 posted by Terrence

    Love the share!

Leave a comment

Make sure you enter the (*) required information where indicated. HTML code is not allowed.