April 2025
M T W T F S S
 123456
78910111213
14151617181920
21222324252627
282930  

Categories

April 2025
M T W T F S S
 123456
78910111213
14151617181920
21222324252627
282930  

MySQL 5.5

TABLE OF CONTENTS (HIDE)

1. Introduction1.1 Relational Database and Structure Query Language (SQL)1.2 SQL By Examples1.3 MySQL Relational Database Management System (RDBMS)2. How to Install MySQL 5.5 and Get Started2.1 Step 1: Download and Install MySQL2.2 Step 2: Create the Configuration File2.3 Step 3: Start the Server2.4 Step 4: Start a Client2.5 Step 5: Set […]

Mysql Performance Tuning

Mysql Performance Tuning MySQL Performance tuning [my.cnf file parameters + description]

[mysqld]

# Maximum allowed number of connections to the MySQL Server max_connections = 1500

# The key buffer is a variable that is shared amongst all MySQL clients on the server. A large setting is recomended, particularly helpful with tables that have unique keys. […]

Learn MySQL

Learn MySQL How To Connect MySQL Database Tutorial Example

Open your MySQL Client tools then copy & paste the below code to Connect to MySQL database server

— mysql.exe location: c:\xampp\mysql\bin\mysql.exe — host: localhost — username: root — password: *** — modify your host location, username, password accordingly. — i am using dos prompt as […]

MYSQL Back On Unix

MYSQL Back On Unix

Shell script is a script where we are writing different types of commands and executing those commands from a single file. We can execute that command manually, by entering command one by one. But if we use shell script we have to write those commands into a text file for […]