What is mean by mysql partitioning ?

By | December 4, 2014

#splits large database into smaller and manageable ones.
#partitioning large database into numberof rows or number of columns.
# bewlow command will provide whether the mysql support parition

SHOW VARIABLES LIKE ‘%partition%’;– it will show yes
SHOW PLUGINS;– it will show partition active

# following are the different type of partitioning

. Range Prtitioning
. List Partitioning
. Hash Partitioning
. Key Partitioning


select * from tbl_students where student_code >55 and student_code <57 in this case we need to search only in the partitions p1.