Optimizing MySQL: Configuration Directives
This tutorial is the first part of MySQL optimization mini series and guides you thru the configuration directives which have direct influence on MySQL performance.

---

Optimizing MySQL: Performance Tuning Script
Performance Tuning Primer Script is the shell script which gets performance related information from MySQL engine and produce some recommendations for tuning of MySQL server variables. It’s easy to use and offers valuable output for MySQL performance optimization.

---

Optimizing MySQL, Hardware and the Mysqld Variables
Like a grand prix driver starting at the back of the track, if you don't do things well from the beginning, and prepare hard for the race, it doesn't matter how well you do once the race has started. You're at the back and are never going to win. So, with MySQL, it's extremely important to start off on the right foot, and that means compiling MySQL properly. The specific options you use depends on your setup of course, but here are some pointers to get you started.

---

Optimizing MySQL: Log Slow Queries
This tutorial is the second part of the MySQL Optimization mini series and introduces the Slow Query Log as well as describes its setup and output.

---

SQL SELECT Statements with JOIN and Subqueries
A collection of 16 FAQs on MySQL SELECT statements with JOIN and subqueries. Clear answers are provided with tutorial exercises on joining multiple tables with inner and outer joins; using subqueries with IN, EXISTS, and FROM clauses; using UNION operations.

---

Creating Users and Setting Permissions in MySQL
MySQL is an extremely powerful database, but in order to properly maximize its potential you may need to learn how to set up users and their respective permissions. In this article take a look at using the MySQL console application to create users and grant permissions to them. We also shows us how to grant permissions from remote hosts, how to reduce user privledges and more. MySQL is an extremely powerful database, but in order to properly maximize its potential, you may need to learn how to set up users and their respective permissions.

---

Optimizing MySQL Queries and Indexes
Learn how to optimize queries and indexes, and potentially speed up your application many times over.The database is just too slow. Queries are queuing up, backlogs growing, users being refused connection. Management is ready to spend millions on "upgrading" to some other system, when the problem is really that MySQL is simply not being used properly. Badly defined or non-existent indexes are one of the primary reasons for poor performance, and fixing these can often lead to phenomenal improvements.

---

Introduction to MySQL
MySQL is the most popular open source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers.

---

Optimizing for Query Speed
Optimzing your queries can help them run more efficiently, which can save a significant amount of time. This article covers index optimization and index usage and discusses general principles that are useful for optimizing queries to run more efficiently.

---

MySQL Basics
This MySQL tutorial is a guide for new MySQL users, providing a reference of very basic, step by step, instructions on how to get started. This MySQL help page also gives more advanced users assistance in upgrading and running multiple versions of MySQL on a computer at the same time.

---

MySQL Made Easy With MySQL Front
MySQL Front allows anyone to easily create and manage their MySQL databases. In this tutorial see how to get up and running with MySQL Front.

---

Mysql Sub Queries, introduction
Mysql icon Mysql now offers sub queries/sub selects. They can help you write faster and shorter code. You don't need to do that much programming in PHP, just let mysql do the work :-)

---

Understanding Various MySQL Executable Files
Learn how to the execute mysql file. MySQL Provide the executable file and uses the MySQL Client interactive file by this command "shell> mysql db_name ".

---

MySQL System Architecture
In this article, we're going to take a look at MySQL internals. It will be a fun, informative examination of how all the different pieces and parts of the MySQL server operate together.

---

Installing MySQL on Windows
In this section you will learn how to install MySQL 5.0 on windows system. The MySQL 3.21 was the first version for the windows. Windows installer of MySQL includes auto installer with Configuration Wizard that support for easy installation.

---

Introducing the MySQL Librarian
The MySQL Librarian is a collection of community-generated and cross referenced content related to MySQL. It's a place where the community, collaboratively, builds and maintains MySQL content.

---

MySQL 5.4: Up To 90% Faster Response
Sun Microsystems, Inc. today announced MySQL 5.4, a new version of the world's most popular open source database, designed to deliver significant performance and scalability improvements to MySQL applications.

---

MySQL and SQL
In this tutorial, we cover the following topics:A short introduction to relational databases and relational modeling, A quick start guide to the winestore database and its full entity-relationship model, The MySQL command interpreter and the basic features of MySQL, Using SQL to create and modify databases, tables, and indexes, Using SQL to insert, delete, and update data, The SQL SELECT statement for querying, with examples of simple and advanced queries, Functions and operators in SQL and MySQL, Advanced features, including managing indexes and keys, tuning the MySQL DBMS, security, and the limitations of MySQL.

---

Sub queries
Mysql now offers sub queries/sub selects. They can help you write faster and shorter code. You dont need to do that much programming in PHP, just let mysql do the work A new thing in MySql 5 is the possibility to use something called "sql subqueries". It can be a very powerful new tool..

---

Using a MySQL database with PHP
It's time to add some dynamic content to your website. The best choice for ease-of-use, price and support is the combination of PHP and MySQL. This article introduces the beginner to using MySQL with PHP.

---

MySQL User Account Management
The MySQL access control system enables you to create MySQL accounts and define what each account can do. Several types of privileges can be assigned to an account. They should be granted according to how the account is to be used.

---

Basic SQL optimization for MySql
It's important to know how to write your queries fast. And there are also ways to do your queries faster Inside mysql, called Indexes. They help mysql do the work faster, but you need to tell how...

---

Optimize MySQL tables for speed
MySQL logo Just like you need to defrag and check your file system, it's important to do the same thing with MySQL tables. If you don't, you might end up with slow and corrupted database tables. Follow this easy tutorial to set up an automatic optimization for your db.

---

Developing Database Applications Using MySQL Connector/C++
This tutorial will show you the essential steps to build and install MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database.

---

Optimize MySQL tables simple
Just like you need to defrag and check your file system, it's important to do the same thing with MySQL tables. If you don't, you might end up with slow and corrupted database tables. Follow this easy tutorial to set up an automatic optimization for your db. Speed in MySQL is all about how fast the...

---

MySQL System Architecture
We are going to take a look at MySQL internals. It will be a fun, informative examination of how all the different pieces and parts of the MySQL server operate together. MySQL's implementation is a fascinating mix of technology that is truly a remarkable achievement - an achievement born from the sweat and inspiration of numerous developers overmany years.

---

Using mysql in Batch Mode
In the previous sections, you used mysql interactively to enter queries and view the results. You can also run mysql in batch mode.

---

MySQL Configuration
In this lesson you will read about the configuration of MySQL. The MySQL server configuration normally started during installation process.

---

MySQL Database Instructions
You can create up to 4 MySQL databases using the "Add MySQL Database" function of your Control Panel.

---

A Quick Look at MySQL 5.4
There are other enhancements in MySQL 5.4 as well such as the introduction of DTrace support for MySQL on the Solaris platform, and a replication heartbeat, which helps ensure that master/slave topologies are up and running. All in all, the 5.4 release focuses quite a lot on transparent performance improvements and extra diagnostic and error handling capabilities, which are things normally always welcomed by developers and DBAs.

---

Open Tools for MySQL Administrators
The MySQL distribution provides several tools for database developers and administrators, but they don't always work everywhere. Fortunately, the worldwide MySQL community has produced plenty of useful tools.

---

How to Upgrade from MySQL v 3.x to MySQL 4.x
This tutorial will walk you through step by step to upgrade your MySQL database to version 4.x on a Windows Machine. We are going to assume to that you already have MySQL version 3.x or earlier installed on your Windows machine.

---

Advanced MySQL Replication Techniques
MySQL Cluster is a powerful peering system to add high availability and replication across multiple database servers. It's not perfect, though. Using features of MySQL 5.0 and 5.1, it's possible to build a master/slave replication system with fail-over.

---

Basic sql optimization for MySql
It’s important to know how to write your queries fast. And there are also ways to do your queries faster Inside mysql, called Indexes. They help mysql do the work faster, but you need to tell how: When you start getting large tables you can sometimes end up with slow running queries.

---

MySQL Command Line Help
We tend to use MySQL from the interactive command line shell quite a bit (SSH to your db server and type the command mysql to start). We noticed today that there is a pretty extensive built in help system in this command.

---

How To Back Up MySQL Databases Without Interrupting MySQL
This article describes how you can back up MySQL databases without interrupting the MySQL service.

---

MySQL DELAY_KEY_WRITE Option
Another performance option in MySQL is the DELAY_KEY_WRITE option. According to the MySQL documentation the option makes index updates faster because they are not flushed to disk until the table is closed.

---

MySQL Basic
This mysql tutorial covers the basic stuff that you can do with MySQL.

---

Backing Up Your MySQL Databases With MySQLDump
MySQL includes several ways to backup your important data. In this article learn how to backup our databases using the mysqldump utility that comes with MySQL.

---

Getting to Grips with mySQL
This tutorial will show you how to create and query a database using SQL and the mySQL command terminal.

---