SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    May 2008
    Posts
    20
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MyISAM supports Partitioning ?

    Hi,

    I want to know that MyISAM storage engine supports partitioning ? and how is the performance meausre of partitioning on MyISAM engine. I want to use partitioning
    on MyISAM table because it's size is 12GB right now and it's growing day by day. Can anyone prefer me anyother solution for that ? We are facing performance related issues.

    Regards,
    Muhammad Irfan

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    yes, myisam supports partitioning, but only on mysql 5.1 or newer. you should carefully read the partitioning chapter in the mysql manual so that you pick the partitioning scheme that will have the greatest performance improvement for your application.
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •