Why my sql table crash

Databases
1

i m facing some problem from 2 days my table which has round about 1 million colums and 10 rows using mysql
go crash i repaired it but after 1 day it go again crash to again have fix that but what’s the real problem that how can i know how can i stop that from being crashed :confused:

2

Crash is quite a word. Maybe you should explain what’s happening!

3

1 million columns? no wonder it crashed :smiley: :smiley:

4

I wonder how the INSERT query looks like :wink:

5

don’t understand what’s the solution if it do next time

6

Like I asked before, can you explain what is happening. Is it happening when you query the database? Or what??

7

ohh sorry little wrong statement :smiley:
1 million rows not colums 10 colums

8

Can you post the show create table and the query this is happening with

Edit: sorry had the post still open and didn’t see Rudi’s reply

9

well in mysql_error i got statment ur table crashed repair that when i repair that work

10

… but when. Where is this happening. On your website while doing a search? or? The information you provide is very little to do something with.

11

well during inserting some data as i already describe in 10 rows data is not much big

12

could we clear something up please?

realcoder, please do a SHOW CREATE TABLE for your table

13

it’s structure look like

CREATE TABLE posts (
id int(11) NOT NULL AUTO_INCREMENT,
aid int(11) NOT NULL,
name varchar(250) NOT NULL,
email varchar(250) NOT NULL,
subject varchar(250) NOT NULL,
message mediumtext NOT NULL,
cap varchar(250) NOT NULL,
ip varchar(250) NOT NULL,
date varchar(250) NOT NULL,
time varchar(250) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=latin1

14

i’ve seen worse :wink:

how about the query that’s causing the crash?

15

Is this the real table or a test table? I only see AUTO_INCREMENT=57 while you were talking about 1.000,000 rows.

Off Topic:

I couldn’t help but notice the use of MyISAM. Where INNODB would be more appropriate, unless you use fulltext search

16

its real one that was from my local host

CREATE TABLE `posts` (
 `id` int(11) NOT NULL auto_increment,
 `aid` int(11) NOT NULL,
 `name` varchar(250) NOT NULL,
 `email` varchar(250) NOT NULL,
 `subject` varchar(250) NOT NULL,
 `message` mediumtext NOT NULL,
 `cap` varchar(250) NOT NULL,
 `ip` varchar(250) NOT NULL,
 `date` varchar(250) NOT NULL,
 `time` varchar(250) NOT NULL,
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1021679 DEFAULT CHARSET=latin1

and it’s query


INSERT INTO posts (aid,name,email,subject,message,cap,ip,date,time) VALUES ('$id','$name','$email','$subject','$message','$cap','$ip','$date','$time')
17

getting id of some form

18

What is happening with the aid?

`aid` int(11) NOT NULL,
19

But you’re not inserting it? You really need to be more specific please. Try to supply all details not just half.

20

inserting as u can see $id
and there is not any problem related to query execute problem is table crashed not all time
Why that Crashed?