Support For Table Partitioning

[BeanTownHost.com]

As of MySQL 5.1 there is a new feature called Table Partitioning, other database servers have offered this for quite some time, but this is the first that MySQL has included support for it. Table partitioning comes in handy when you have really large tables and you want to split them up into multiple files for better performance.

For example: If you had a large table of user data, you could split the single large table into table partitions and have one partition for each letter of the alphabet. So all the users with the letter “a” as the first character of their username would go into the Users table, partition “a”.

The process for creating the table partitions has endless possibilities on how you want to partition your data and it would be nice if SQLYog had a GUI for creating/managing/updating Table Partitions. Is there anyone else who would be interested? WebYog said I should post here to see who else would be interested.

[navyashree.r]

Hi,

Thanks for your valuable request which is a valid one. We have already in our roadmap about this “Table Partitions” support in our GUI. Please go through our FAQ link,

http://webyog.com/faq/content/33/20/en/plans-for-future-versions-of-sqlyog.html?highlight=future

We have added your request in our issue tracker,

http://code.google.com/p/sqlyog/issues/detail?id=1224

We haven't decided with the priority as we have planned activities for the next 3 to 4 months. Once done we will prioritize accordingly.

Regards,

Navya

[frankf]

This is a huge priority for us, as we are running into performance issues with large tables.

'navyashree.r' wrote:

Hi,

Thanks for your valuable request which is a valid one. We have already in our roadmap about this “Table Partitions” support in our GUI. Please go through our FAQ link,

http://webyog.com/faq/content/33/20/en/plans-for-future-versions-of-sqlyog.html?highlight=future

We have added your request in our issue tracker,

http://code.google.com/p/sqlyog/issues/detail?id=1224

We haven't decided with the priority as we have planned activities for the next 3 to 4 months. Once done we will prioritize accordingly.

Regards,

Navya

[peterlaursen]

SQLyog can create partioned tables if you type the CREATE TABLE syntax in the editor. It also works fine with data manipulations with partioned tables.

1) But we don't have and GUI for creating partitioned tables. We know we are lagging behind here (as it was introduced in MySQL 5.1), but it is a huge task to support every partitioning algorithm as they will each need a GUI of its own. 2) Schema Sync will also not handle partitions. Both issue are recorded in our issue tracker.

But till now this has been considered lower priorty because of a cost/benefit consideration. Personally I think we should support partitions in Schema Sync first.

[Author]

Posts