Support For Table Partitioning

[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