Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    30

    Unanswered: Tables Keep Crashing!!!!

    MySQL 4.0.13 on Win2K server w/ SP3

    Please help. I'm having problems with tables that keep crashing for apparently no reason. I'll repair the table(s) with myisamchk and they'll work for a short while and then I'll need to repair them again. This has only recently been happening.

    If I do a show table status, for the crashed tables everything shows up as null except the comment will be "Can't open file 'table.MYI' (errno: 130)'

    After I repair the table

    +----------------------------------+--------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------------------------------------------------------+
    | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment |
    +----------------------------------+--------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------------------------------------------------------+
    | dfhis | MyISAM | Fixed | 26181205 | 172 | 4503167260 | 738734374911 | 1295857664 | 0 | [NULL] | 2003-10-27 06:01:35 | 2003-10-31 09:28:21 | 2003-10-31 09:28:21 | | |
    +----------------------------------+--------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------------------------------------------------------+




    MY.INI

    [WinMySQLAdmin]
    Server=F:/mysql/bin/mysqld-max-nt.exe
    [mysqld]
    set-variable = key_buffer=768M
    set-variable = max_allowed_packet=1M
    set-variable = table_cache=1024
    set-variable = sort_buffer=2M
    set-variable = record_buffer=2M
    set-variable = thread_cache=8
    # Try number of CPU's*2 for thread_concurrency
    set-variable = thread_concurrency=4
    set-variable = myisam_sort_buffer_size=64M
    server-id = 1
    basedir=F:/mysql/
    datadir=F:/mysql/data/
    tmpdir=F:/temp
    [myisamchk]
    set-variable = key_buffer=256M
    set-variable = sort_buffer=256M
    set-variable = read_buffer=2M
    set-variable = write_buffer=2M

    I have 3GB RAM, Dual 1.13 GH, Win2000 server w/ SP3

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

    Re: Tables Keep Crashing!!!!

    Originally posted by gnet
    MySQL 4.0.13 on Win2K server w/ SP3

    Please help. I'm having problems with tables that keep crashing for apparently no reason. I'll repair the table(s) with myisamchk and they'll work for a short while and then I'll need to repair them again. This has only recently been happening.

    If I do a show table status, for the crashed tables everything shows up as null except the comment will be "Can't open file 'table.MYI' (errno: 130)'

    After I repair the table

    +----------------------------------+--------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------------------------------------------------------+
    | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment |
    +----------------------------------+--------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------------------------------------------------------+
    | dfhis | MyISAM | Fixed | 26181205 | 172 | 4503167260 | 738734374911 | 1295857664 | 0 | [NULL] | 2003-10-27 06:01:35 | 2003-10-31 09:28:21 | 2003-10-31 09:28:21 | | |
    +----------------------------------+--------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------------------------------------------------------+




    MY.INI

    [WinMySQLAdmin]
    Server=F:/mysql/bin/mysqld-max-nt.exe
    [mysqld]
    set-variable = key_buffer=768M
    set-variable = max_allowed_packet=1M
    set-variable = table_cache=1024
    set-variable = sort_buffer=2M
    set-variable = record_buffer=2M
    set-variable = thread_cache=8
    # Try number of CPU's*2 for thread_concurrency
    set-variable = thread_concurrency=4
    set-variable = myisam_sort_buffer_size=64M
    server-id = 1
    basedir=F:/mysql/
    datadir=F:/mysql/data/
    tmpdir=F:/temp
    [myisamchk]
    set-variable = key_buffer=256M
    set-variable = sort_buffer=256M
    set-variable = read_buffer=2M
    set-variable = write_buffer=2M

    I have 3GB RAM, Dual 1.13 GH, Win2000 server w/ SP3
    Did you try an EXTENDED REPAIR ?

    http://www.mysql.com/doc/en/REPAIR_TABLE.html
    http://www.mysql.com/doc/en/Repair.html

  3. #3
    Join Date
    Jul 2003
    Posts
    30
    yeah ... but it would complain and tell me I needed to use safe repair (the -o option)

Posting Permissions

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