Category: MySQL


How to Configure Full-Text Stopwords & Stoplist in MySQL

By: Sunil Kumar |  In: MySQL  |  Last Updated: 2018/06/06

How to Configure Full-Text Stopwords & Stoplist in MySQL

Mysql stopwords is a list of most commonly used English language words like some, about, by, from, by… and much more. These stopwords do not match if they are present in the search string. These stopwords are ignored in full-text search because these words are more likely to present in almost every string and it's […]

Continue Reading...


A Step-by-Step Guide to Create Partitions on MySQL table

By: Sunil Kumar |  In: MySQL  |  Last Updated: 2018/06/10

A Step-by-Step Guide to Create Partitions on MySQL table

1.What is partitioning? Partitioning is a database design technique which is used to improves performance, manageability, simplifies maintenance and reduce the cost of storing large amounts of data. Partitioning can be achieved without splitting your MySQL tables by physically putting tables on individual disk drives. Partitioning allows tables, indexes, and index-organized tables to be subdivided […]

Continue Reading...


Difference Between InnoDb and MyISAM

By: Sunil Kumar |  In: MySQL  |  Last Updated: 2018/06/10

MyISAM and InnoDB are the most commonly used storage engine in MySQL whereas both storage engine types have advantages and disadvantages depending on the specific application. However, MyISAM is the default storage engine chosen by MySQL database, when creating a new table. The major differences between MyISAM and InnoDB storage engines are : 1. Referential […]

Continue Reading...


How To Import and Export Databases (MySQL or MariaDB)

By: Sunil Kumar |  In: MySQL  |  Last Updated: 2018/06/10

How To Import and Export Databases (MySQL or MariaDB)

If you are a web developer you must be aware of some basic database operations. Importing and exporting database is an important skill to have. Most of the time you have to make a backup of the database and restore the database from a backup. Working with database dumps in MySQL and MariaDB is straightforward. […]

Continue Reading...


Subscribe to our mailing list