Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006
    Posts
    34

    Unanswered: MYSQL Performance

    Hi All,
    Im using MYISAM mysql version 4.0.1 and i have a problem , one of my table will grow in our application daily.Suppose if a person running our application for one year he will have 20 million rows in the table.Is there a way to optimize it meaning can we split this table, or can we write the data to a file and while reading we will red it from the file.

    my table will look like this,

    ID,ATTRIBUTEID,Starttime,Endtime,MinValue,MaxValue ,TotalValue,RESOURCEID

    Kindly give your valuable feedback

    Thanks n Advance
    Arunkumar.P

  2. #2
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    I'm not 100% sure if this will work with 4.0.1 (mainly because i can't be bothered to look at documentaton) but MyISAM tables can be split (striped) using the following syntax :

    ALTER TABLE `<table>` RAID_TYPE = STRIPED
    RAID_CHUNKS = 2
    RAID_CHUNKSIZE = 64;

    What sort of application is it and what does it do? How often is data being written/read ?
    You could create a history sql script which you run periodically to cull the information in your table and pop it into a secondary (history) table.

Posting Permissions

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