Professional Web Applications Themes

Index corruption in MyISAM tables - MySQL

Hi,...

  1. #1

    Default Index corruption in MyISAM tables

    Hi,

    Provost Guest

  2. #2

    Default Re: Index corruption in MyISAM tables

    Sorry,my bad. The posting got away before I could post further
    details. I use MySQL version 4.1.21 and have a few tables using the
    MyISAM engine that are under very heavy contention. I'll refer to them
    as tables 1,2 and 3. Table 1 has about 100k records, table 2 has
    between 300k-400k records and Table 3 has about between 1.5 million to
    2 million records at any point of time. Data is being added into these
    tables via inserts , updated periodically and then deleted. About
    twice a week, with no particular periodicity I notice that either 1 or
    all of these tables get corrupted. There are no joins being performed
    between these tables, if that helps.
    Provost Zakharov wrote: 

    Provost Guest

  3. #3

    Default Re: Index corruption in MyISAM tables

    Provost Zakharov wrote: 
    >[/ref]
    you need to explain more. tell us all the cirstances regarding the
    corrupt tables for example any error codes. also what os is mysql
    running under and how it's being access. it would help if you can look
    into the mysql error logs to see if you can find any information in
    there as well.
    lark Guest

Similar Threads

  1. mix myisam and innodb tables
    By Sjef in forum MySQL
    Replies: 4
    Last Post: June 20th, 11:54 AM
  2. SQL Index corruption
    By Merlyn MM in forum Coldfusion Database Access
    Replies: 3
    Last Post: August 24th, 03:05 PM
  3. Index-organized tables
    By Pavel in forum Oracle Server
    Replies: 0
    Last Post: August 29th, 08:29 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139