MySQL Ramp Up

MYSQL:

Add Column to Existing Table and Make it Auto Increment and Add Primary Key Constraint

Link : Alter Table and Add Column

Query Plan and Query Profile for Executed Queries

TimeOut Error from MySQL WorkBench: Error Code: 2013. Lost connection to MySQL server during query 600.510 sec

MySQL: Currently Running Querires
ProcessList

BulkLoad : Bulk Load CSV Into MySQL
LOAD DATA INFILE

BulkLoad through SQLImport : Bulk Load CSV Into MySQL
MySQLImport

MySQL: List of Tables in a Database

MySQL: Set Transaction Isolation Level

MySQL: Simple WHILE Statment

MySQL: Converting Strings into Uniquely Identifying Integers

STRING Functions

MySQL: Build JSON From MySQL Select Statments

MySQL: INNODB Status

Output:

MySQL:SQL Server: WAIT / SLEEP Time Options

MySQL : Export Data through mysqldump

MySQL : Export Schema without Data through mysqldump

MySQL : Thread STATES
MySQL Thread States

When you see different states like SYSTEM LOCK , READING FROM NET , etc.

Setup MySQL Server as Linked Server in SQL Server/span>

Download MySQL ODBC Driver.
http://dev.mysql.com/downloads/file.php?id=453005

MySQL ODBC DataSource Setup

MySQL ODBC DataSource Setup

Good Article on Setting up MySQL Linked Server
SELECT * FROM OPENQUERY(LINKEDSERVERNAME, ‘SELECT * FROM MySQLSchemaName.MySQLTableName LIMIT 10’)

MySQL : HostName with Processes Count

MySQL : Open Tables and UNLOCK Tables

MySQL : Troubleshoot Lock wait timeout Issues

Creates a DB parameter group.
A DB parameter group is initially created with the default parameters for the database engine used by the DB instance. To provide custom values for any of the parameters, you must modify the group after creating it using rds-modify-db-parameter-group. Once you’ve created a DB parameter group, you need to associate it with your DB instance using rds-modify-db-instance. When you associate a new DB parameter group with a running DB instance, you need to reboot the DB instance for the new DB parameter group and associated settings to take effect.

http://docs.aws.amazon.com/AmazonRDS/latest/CommandLineReference/CLIReference-cmd-CreateDBParameterGroup.html

MySQL : Running SQL File from Command Line/span>
https://dev.mysql.com/doc/refman/5.7/en/mysql-batch-commands.html

MySQL : Alter Table Column Name and Default Value

MySQL : EXPLAIN with and without UnIndexed Column

MySQL : Quickly Change Transaction Isolation Level
http://dev.mysql.com/doc/refman/5.6/en/set-transaction.html

MySQL :Query General Query Log and Configs

MySQL : Number of Rows in Table

MySQL Create Login and Grant Permissions

One comment on “MySQL Ramp Up
  1. Raju Venkataraman says:

    SELECT SUBSTRING_INDEX(host, ‘:’, 1) AS HostName,
    GROUP_CONCAT(DISTINCT USER) AS UserName,
    COUNT(*) as Nbr_Processes
    FROM information_schema.processlist
    GROUP BY HostName
    ORDER BY COUNT(*),
    HostName;

Leave a Reply

Your email address will not be published. Required fields are marked *

*