Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Arrow Unanswered: table with parttions

    Is it possible to build table with patition like in oracle in mysql database?
    how I can do it?


  2. #2
    Join Date
    May 2004

    Although you can't partition a table based on column values, you might look into the RAID syntax of the CREATE TABLE statement. It's primarily used for manually striping the data across multiple files, instead of placing all data instead of a single file. Sort of table-level round-robin partitioning/striping...

    Another option I use is to physically partition the table based on a primary key. I've broken up a single table into ten separate tables that have the same schema. When an incoming sql request comes in the integer primary key value used in the sql statement is evaluated using modulus. If the remainder of the modulus of 10 for example is 4, go to table 4 for the data.
    Keith Brownlow
    ServerMetrics DB Monitoring (

Posting Permissions

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