I'm running RedHat 7.3 distro with 2.4.18-4smp #1 SMP The table in questions is
-rw-r----- 1 mysql mysql 8.9k Jul 26 00:23 hasit.frm -rw-r----- 1 mysql mysql 994M Sep 10 09:59 hasit.MYD -rw-r----- 1 mysql mysql 681M Sep 10 09:59 hasit.MYI my my.cnf option [mysqld] skip-innodb skip-bdb skip-name-resolve skip-locking port=3306 socket=/var/lib/mysql/mysql.sock datadir=/var/lib/mysql # Helps inserts happen much faster set-variable = key_buffer=512M # keep allot more tables in memory set-variable = table_cache=1024 #Increase this value for faster ORDER BY or GROUP BY operations set-variable = sort_buffer=64M #If you do many sequential scans, you may want to increase this value set-variable = record_buffer=16M #use for when mysql is doing a check or repair set-variable = myisam_sort_buffer_size=64M set-variable = max_allowed_packet=16M set-variable = thread_cache=8 # Try number of CPU's*2 for thread_concurrency (Might only be used for Solaris) set-variable = thread_concurrency=8 set-variable = tmp_table_size=512 set-variable = max_connections=450 set-variable = back_log=20 set-variable = max_connect_errors=400 set-variable = wait_timeout=10 This is a RAID-5 with 128MB ICP Raid Card with 4GB of memory -->-----Original Message----- -->From: Richard Gabriel [mailto:[EMAIL PROTECTED] -->Sent: Wednesday, September 10, 2003 10:32 AM -->To: Dathan Vance Pattishall; [EMAIL PROTECTED] -->Subject: Re: "ERROR 1030: Got error 127 from table handler" --> -->What kernel are you running? --> -->Also, try increasing the max open tables. That might help. --> -->Richard Gabriel -->Director of Technology, -->CoreSense Inc. -->(518) 306-3043 x3951 --> -->----- Original Message ----- -->From: "Dathan Vance Pattishall" <[EMAIL PROTECTED]> -->To: "'Tom Roos'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> -->Sent: Wednesday, September 10, 2003 1:28 PM -->Subject: RE: "ERROR 1030: Got error 127 from table handler" --> --> -->> Filesystem Size Used Avail Use% Mounted on -->> /dev/sda5 97G 9.0G 82G 10% -->> -->> Plenty of disk space. -->> -->> -->-----Original Message----- -->> -->From: Tom Roos [mailto:[EMAIL PROTECTED] -->> -->Sent: Wednesday, September 10, 2003 10:23 AM -->> -->To: Dathan Vance Pattishall; [EMAIL PROTECTED] -->> -->Subject: RE: "ERROR 1030: Got error 127 from table handler" -->> --> -->> -->hows u're disk space? -->> --> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
