MySQL Learning | MySQL Facts and Resources | DefaultLogic For Business




MySQL

School:Computer Science -> Topic:Computer Programming -> Topic:Databases -> Topic:MySQL

What is MySQL?

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

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

  1. Install MySQL Server, you can follow b:MySQL_Practical_Guide
  2. Tune MySQL Server using mysqltuner perl script[1]
  3. List available plugins mysql> show plugins;
  4. Show processlist mysql> show processlist;

Learning materials

Wikiversity lessons:

Other:

Resources

Documentation:

Other:

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

  •   This article uses material from the Wikipedia page available here. It is released under the Creative Commons Attribution-Share-Alike License 3.0.

    MySQL
     



     

    Connect with defaultLogic
    What We've Done
    Led Digital Marketing Efforts of Top 500 e-Retailers.
    Worked with Top Brands at Leading Agencies.
    Successfully Managed Over $50 million in Digital Ad Spend.
    Developed Strategies and Processes that Enabled Brands to Grow During an Economic Downturn.
    Taught Advanced Internet Marketing Strategies at the graduate level.


    Manage research, learning and skills at defaultlogic.com. Create an account using LinkedIn to manage and organize your omni-channel knowledge. defaultlogic.com is like a shopping cart for information -- helping you to save, discuss and share.


      Contact Us