mysql server startup options

MySQL Server Startup Options

In order to properly setup our server we need to know what options are available, what those options do and how to specify them. There are literally hundreds of such…

MySQL Server Configuration

Configuring the mysql server is a very important part of using mysql, but it is generally the responsibly of the data base administrator (they do the mysql server configuration). Still…

database index

Database Index

In This lesion we’ll briefly define the concept and use of an index. An index is an additional feature that we add to a table to help us use that…

Database Design in a Nutshell

Database design is a very extensive subject and I intent to build an entire course on that, but we need to understand at least a few basic things about database…

Tables, Columns and Rows

Tables, Columns and Rows

We can’t get too far in talking about any database management systems without discussing the concept of a table. And the constituent parts of table called columns and rows. So…

Client Server System

In this chapter we will examine client server systems and the relationship between the server and the client programs that give us access to it. First let’s define a bit…

Database Definitions

In order for us to discuss this subject intelligently it helps if we identify and define certain core concepts we’ll encounter in the subject matter. In this chapter and the…

A Brief History of MySQL

The MySQL server is a unique product in a number of ways, some of these differences are beneficial even if we don’t notice them while others can cause us problems…