Connection, Performance and Second Instance on Linux
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
Performance of Inserting Integers to MySQL Database
Performance Comparison of Inserting Integers vs. Strings
Second MySQL Server Instance on Linux
Second MySQL Server Instance with SELinux
Move Database between MySQL Servers
- MySQL supports socket connections for client programs on the server host
using "localhost" as the host name.
- MySQL supports TCP/IP connections for remote clients on port 3306.
- MySQL allows a remote user to access only if the user is created with
his/her IP address specified.
- MySQL requires the server and gateway to open firewall for inbound TCP
messages on port 3306.
- "Server sent charset unknown to the client" error is returned
when using older PHP mysqli_connect() function to connect to MySQL 8.0.
- MySQL server is 100 times slower on my CentOS computer than my macOS computer
with default settings.
- New data directory can be created using the "mysqld --no-defaults --initialize" command.
- Second instance can be started with the "mysqld --defaults-file" command
on a new data directory and port.
Table of Contents
About This Book
Introduction of SQL
MySQL Introduction and Installation
Introduction of MySQL Programs
PHP Programs and MySQL Server
Perl Programs and MySQL Servers
Java Programs and MySQL Servers
Datatypes and Data Literals
Operations and Expressions
Character Strings and Bit Strings
Commonly Used Functions
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
Transaction Management and Isolation Levels
Locks Used in MySQL
Defining and Calling Stored Procedures
Variables, Loops and Cursors Used in Stored Procedures
Using Administration Statements
MySQL Server on macOS
Installing MySQL Server on Linux
►Connection, Performance and Second Instance on Linux
Full Version in PDF/EPUB