MySQL Performance: How To Leverage MySQL Database Indexing

Bit Ninja


In this video, we demonstrate how to do leverage MySQL database indexing.

Commands used:
‘show index from’ tablename

CREATE TABLE tableName (
ID int,
LName varchar(255),
FName varchar(255),
DOB varchar(255),
LOC varchar(255),
INDEX ( ID )
);

CREATE TABLE tableName (
ID int,
LName varchar(255),
FName varchar(255),
DOB varchar(255),
LOC varchar(255),
PRIMARY KEY (ID),
UNIQUE INDEX ( ID )
);

CREATE INDEX indexName ON tableName (ID, LName, FName, LOC);

CREATE UNIQUE INDEX indexName ON tableName (ID, LName, FName, LOC);

DROP INDEX indexName ON tableName;

The related article for this video can be found here: https://www.liquidweb.com/kb/mysql-optimization-how-to-leverage-mysql-database-indexing/

For more information about this and other topics, visit us at https://www.liquidweb.com/kb/ or for more information on our line of dedicated servers, visit: https://www.liquidweb.com/products/dedicated/

Video by: Justin Palmer


Duration: 00:01:52
Publisher: Liquid Web
You can watch this video also at the source.