Partition an InnoDB table in MySQL (C#, VB and ASP.NET) | Free template

Here you can download a free template with instructions and code (C# and VB) to partition a table (InnoDB) in a MySQL database in order to divide a large table into several smaller parts.

You can partition tables in a MySQL database to improve performance when you for example have a very large table in you database or a database server computer that does not have enough RAM in relation to the size of the data for the indexes in the database.

It is possible to partition a table in a database in many different ways and it is therefore useful to distinguish between the concepts. A table may be partitioned horizontally or vertically and individual partitions can be stored on a single computer (database server) or on different computers (database servers). Horizontal partitioning means that each partition contains all the columns but only a certain number of rows and a vertical partition means that each partition contains all rows but only a certain number of columns.

In MySQL Community Server is there functionality to partition tables horizontally by RANGE, LIST, HASH and KEY. This built-in functionality to partition tables means that MySQL Community Server keeps track of the partitions for you, but you can not place individual partitions on different database servers. If you want to place different partitions of a table on different database servers ("sharding"), you must create a database on each server, divide data between databases and then ensure that requests to the database are redirected to the correct database server.

In this template with instructions and code (C# and VB) to partition a table (InnoDB) in a MySQL database have we used the built-in functionality of MySQL Community Server to horizontally partition a table by RANGE. In this template there is a text file that describes the partitioning and configuration of InnoDB in MySQL and code files with code to create and reorganize partitions in MySQL. The code files in our ASP.NET web site includes SQL statements to create a database, create a table, add data to the table, create partitions and reorganize the partitions. Updated: 01/01/2015 | Created by All-templates.biz

Download Partition an InnoDB table in MySQL (C#, VB and ASP.NET) | Free template »

Tags: sql database code