MySQL

From Wikiversity
(Redirected from Topic:MySQL)
Jump to navigation Jump to search

School:Computer ScienceTopic:Computer ProgrammingTopic:DatabasesTopic:MySQL

What is MySQL?[edit]

MySQL is a multithreaded, multi-user, SQL Database Management System. It is often accessed and managed through PHP-driven content management systems. (MediaWiki, the wiki engine for Wikiversity is an example of a system that uses MySQL.)

The open source MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, which holds the copyright to most of the codebase. Both the MySQL server software itself and the client libraries are distributed under a dual-licensing format. (MediaWiki deploys MySQL under the GNU General Public License).

Prerequisites[edit]

Learners interested in MySQL may wish to enroll at Databases and Web Design.

  1. Introduction to Databases
  2. Database Management Systems
  3. Introduction to SQL
  4. Introduction to PHP

Object-relational databases and MediaWiki are advanced related topics under develpment. You might want to take a peek.

Activities[edit]

  1. Install MySQL Server, you can follow b:MySQL_Practical_Guide
  2. Tune MySQL Server using mysqltuner perl script[1]

Learning materials[edit]

Wikiversity lessons:

Other:

Resources[edit]

Documentation:

Other:

  • https://github.com/major/MySQLTuner-perl