MySQL Forums
Forum List  »  Partitioning

Why Partition a table on a SAN
Posted by: doug valdez
Date: December 16, 2019 05:08PM

How does the engine benefit if I partition a table on a SAN.

Assuming i currently have 1 drive letter on a LUN across multiple drives.

I then ask my SAN admin for 3 more drives with an effort to break up my table into 4 drives.

He proceeds to add 3 more luns/Disk across the same set of disks how does it benefit the table?

It seems of the End user adds a where clause on the date it would be the same as not breaking up the table? what am I missing.

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Why Partition a table on a SAN
1055
December 16, 2019 05:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.