MySQL Tutorials - Herong's Tutorial Examples - v4.46, by Herong Yang
Connection, Performance and Second Instance on Linux
This chapter provides introductions and tutorial examples about more advanced topics on running MySQL server on CentOS systems, including MySQL socket and TCP/IP connections; Opening firewall for MySQL connections; testing performance on INSERT statements; creating second server instance; moving databases.
These sections are omitted from this Web preview version. To view the full content, see information on how to obtain the full version this book.
MySQL Server Socket Connection on CentOS
MySQL Server TCP/IP Connection on CentOS
Open Firewall for MySQL Server on CentOS
"Server sent charset unknown to the client" Error
Second MySQL Server Instance on Linux
Second MySQL Server Instance with SELinux
Move Database between MySQL Servers
Takeaways:
Table of Contents
MySQL Introduction and Installation
Introduction of MySQL Programs
Perl Programs and MySQL Servers
Java Programs and MySQL Servers
Character Strings and Bit Strings
Table Column Types for Different Types of Values
Using DDL to Create Tables and Indexes
Using DML to Insert, Update and Delete Records
Using SELECT to Query Database
Window Functions for Statistical Analysis
Use Index for Better Performance
Transaction Management and Isolation Levels
Defining and Calling Stored Procedures
Variables, Loops and Cursors Used in Stored Procedures
System, User-Defined and Stored Procedure Variables
Storage Engines in MySQL Server
InnoDB Storage Engine - Primary and Secondary Indexes
Performance Tuning and Optimization
Installing MySQL Server on Linux