November 2024
M T W T F S S
 123
45678910
11121314151617
18192021222324
252627282930  

Categories

November 2024
M T W T F S S
 123
45678910
11121314151617
18192021222324
252627282930  

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 […]