Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2007
    Posts
    197

    Smile Unanswered: help for large tables

    Hi ,
    I have database which has some tables that contain huge records
    upto 8 Million due to this even making indexes queries excution timing
    will be too high

    Please provide solution for this what step we can take ?
    Last edited by ankur02018; 07-04-09 at 06:14.

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Quote Originally Posted by ankur02018
    80 lacks
    is that the same as
    .
    =
    ()
    ()
    ()
    ()
    ()
    (obviously I'm using the ancient Mayan numbering system here).

    Mike

  3. #3
    Join Date
    Jun 2007
    Posts
    197
    Quote Originally Posted by mike_bike_kite
    is that the same as
    .
    =
    ()
    ()
    ()
    ()
    ()
    (obviously I'm using the ancient Mayan numbering system here).
    Mike
    8 million records

  4. #4
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Quote Originally Posted by ankur02018
    8 million records
    I was correct then.

    I guess you mean that some tables contain 80m records rather than each record is 80m char long?
    Can you give the table definition + indexes?
    Can you give some example SQL that's running slowly?
    How slow is slow (in seconds)?

    I don't see how 80m records will even slightly affect MySQL - that is only a moderate table in database terms.

    Mike

  5. #5
    Join Date
    Jun 2007
    Posts
    197

    Smile

    Quote Originally Posted by mike_bike_kite
    I was correct then.

    I guess you mean that some tables contain 80m records rather than each record is 80m char long?
    Can you give the table definition + indexes?
    Can you give some example SQL that's running slowly?
    How slow is slow (in seconds)?

    I don't see how 80m records will even slightly affect MySQL - that is only a moderate table in database terms.

    Mike
    One table tablename transaction is growing in such a way withen 6 month
    6 million records entry is done so even making indexes query fired takes
    much time
    can we do database partitioning for single table
    does MyQL 5.0.47 support database partitioning

    or is there option to do something else

  6. #6
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Quote Originally Posted by ankur02018
    or is there option to do something else
    Yes but we need to know the following:
    • Can you give the table definition + indexes?
    • Can you give some example SQL that's running slowly?
    • How slow is slow (in seconds)?
    • Do you rebuild your indexes at all?

Posting Permissions

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