Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unanswered: MyIsam Table corruption

    Hello,
    I am using MySQL Server 3.23.56 on Redhat Linux 7.2 and having the following problem: When the tables of type MyIsam are copied, and I run a query on the tables created by copy – it takes awfully long as compared to when run on the original tables.

    When we run the command “check table” and “repair table”, it takes around 10-15 seconds on some of the tables although “check table” returns everything ok. But after “repair table” is run on those tables, the query gets faster.

    There’s one table that has 10 indexes and 10,000 rows and the other table has 3 indexes and 500 rows. The query that gets slow has lot of left joins on these tables. I am not sure what’s causing the problem and how to fix it. Could anybody please help me.

    Thanks,
    Hitesh

  2. #2
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Re: MyIsam Table corruption

    Originally posted by hthemnan
    Hello,
    I am using MySQL Server 3.23.56 on Redhat Linux 7.2 and having the following problem: When the tables of type MyIsam are copied, and I run a query on the tables created by copy – it takes awfully long as compared to when run on the original tables.

    When we run the command “check table” and “repair table”, it takes around 10-15 seconds on some of the tables although “check table” returns everything ok. But after “repair table” is run on those tables, the query gets faster.

    There’s one table that has 10 indexes and 10,000 rows and the other table has 3 indexes and 500 rows. The query that gets slow has lot of left joins on these tables. I am not sure what’s causing the problem and how to fix it. Could anybody please help me.

    Thanks,
    Hitesh
    Well, your original table probably has probably a lot of the index keys and records buffered... The fact that your "copy" tables becomes fast *after* a repair table is most likely a sign that the repair itself buffered a lot of your data...

    Have you tried shutting down your server and performing the same test on your original table right after the server is brought up?

  3. #3
    Join Date
    Nov 2003
    Posts
    2
    thanks for your reply, bstjean. I will perform the test that you mentioned and will let you know how it goes.

    Thanks again,
    hitesh

Posting Permissions

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