hi
i am using mysql ver 5.0 , one table is crahsing frequently
i need to know why .. is it becoz of the query iam running
or i have some problem with db ..
what i have done is given below :
1. created a table with a primary key and having one long text field
with max _rows and avg_row_length so as to increase the
4 GB limit of MyISAM. - CREATE TABLE IF NOT EXISTS smsc_inb ( c1 varchar(20) NOT NULL DEFAULT '' , c2 varchar(50) DEFAULT '0000-00-00 00:00:00' , c3 int(10) unsigned DEFAULT '0' , c4 longtext , c5 tinyint(3) unsigned NOT NULL DEFAULT '0' , c6 tinyint(3) unsigned NOT NULL DEFAULT '0' , c7 varchar(15) , c8 tinyint(3) unsigned NOT NULL DEFAULT '0' , c9 tinyint(3) unsigned NOT NULL DEFAULT '0' , c10 varchar(15) , c11 tinyint(3) unsigned NOT NULL DEFAULT '0' , c12 varchar(15) NOT NULL DEFAULT '' , c13 int(5) unsigned DEFAULT '0' , c14 int(5) unsigned DEFAULT '0' , c15 decimal(12,5) NOT NULL DEFAULT '0.00000' , c16 varchar(15) NOT NULL DEFAULT '' , c17 varchar(15) , c18 char(1) DEFAULT 'F' , PRIMARY KEY (c1))ENGINE=MyISAM AVG_ROW_LENGTH=134 MAX_ROWS=110000000 DEFAULT CHARSET=latin1 ;
2. inserted data in the table using the query
INSERT INTO table_name (c1, c2, c3, c4, c7, c10, c12, c16, c17) VALUES ('"+v1+"', '"+v2+"','"+v3+ "','"+v4+"','"+ v5+"','"+v6+"', '"+v7+"','"+v8+ "','"+v9+"' ,)";
what is happening now is as the data grows above 20 to 30 million or the size reaches near 4 GB the table crashes some time above 4 GB it goes but crashes even if i run a simple select query. say - select count( * ) from table;
after repairing , the table crashed more
how to know what is going wrong ...
any suggestions please...
3  1694 
what do you mean by table crashes ?
is it taking too long to fetch rows or your system hangs ?
what do you mean by table crashes ?
is it taking too long to fetch rows or your system hangs ?
Dada , By table crashes i mean that i got the error
The table is marked as crash.. and still i am facing the problem, not very frequently but still i need a solution for that....
actually nobody replied for a long time so i didnt opened this forum
today i saw atleast one response ... thanks for it...
please pass more infor about the exact nature of the error with error message.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Java and Swing |
last post by:
static PyObject *wrap_doStuff(PyObject *self, PyObject *args) {
// this will store the result in a Python object
PyObject *finalResult;
// get arguments from Python
char *result = 0;
char *in= 0;
char *aString = 0;
char *bString = 0;
MY_NUM *a;
|
by: pbbriggs |
last post by:
I will try to be as descriptive as possible, but this error has me
stumped and I am not sure what relevant info to include....
I am running Access XP on a Windows XP machine. I initially began
developing an app in Access 2000 but converted it several months ago
to XP. So the app is now Access XP format also.
My app is crashing on a regular basis, with the totally non-descript
Microsoft error (Microsoft Access has encountered a...
|
by: Grant |
last post by:
My C# web application connects to an Access database using the
OleDbConnection and OleDbDataReader.
I have 3 other computers that connect to this server but very frequently I
get an 'Unspecified error' message and the site becomes unusable. I have
customErrors set to 'Off' so I can see what bit of code it is crashing at
and it is always at line 78 below. (If I try and start a debug session - the
server seems to reset itself and goes back...
|
by: Adam Clark |
last post by:
We have an ASP.NET AppPool which crashes frequently. I am more of a systems
guy than a programmer, but I used to program in ASP. Can anyone give me any
clues about how to track down specifically where the error is... like hits
on how to debug. We are getting an error 1011 in the system log.
Thanks
Adam
|
by: jerry.ranch |
last post by:
I've a database that is about 11mb, 117,000 records, about 15 fields.
When I run simple queries on the table, the database crashes
I've never seen anything like this before, any ideas?
This can't be good....
jerry
| | |
by: slimicus |
last post by:
The IDE crashes about every 10-20 minutes for me.. its been doing this
ever since I started this project (The project was a 2003 project but I
recreated it in 2005)
When it crashes, its usually after I close the app I'm testing.. lets
say I'm debugging the app, and I get an exception, and I have to stop
the execution for whatever reason, after that, next time I try to
compile (as in either Build or Build in Run, or even build a setup...
|
by: Laurence |
last post by:
I have a solution that I converted from VS.2003 to VS.2005.
It is written in VB.NET.
When I try to look at a form in the IDE, VS.2005 goes to sleep for about 60 seconds,
before the form is completely shown and the IDE is again responsive.
This solution also takes about 60 seconds to load when I open vs.2005 from scratch.
I have done a clean of the project and solution, I have rebooted my machine.
|
by: BillE |
last post by:
I have the same problem as identified in
http://forums.asp.net/thread/1402420.aspx (Atlas Crashing Visual Studio
2005)
I'm using VS2005, visual basic.
|
by: =?Utf-8?B?bmljb2xh?= |
last post by:
Its been happening ever since the last windows update, the pc just switches
off by itself, on restarting it says that the pc has recoeverd from a serious
error. I manged to get the following error, hope some one can help me!
IRQL_NOT_LESS_OR_EQUAL
0*0000000A (0*8A1CBOO8, 0*000000002, O'S * 1 OV8051 EBBB)
Not that technical with stuff like this, but I dont know what else to try
to stop it from keep crashing.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
