Page 1 of 1

MySQL fails :(

Posted: Mon Oct 29, 2007 10:49 am
by legend986
I just build a databases having two tables using two large files (one is 150 MB and the other 160 MB)... When I'm trying to either count or display the rows in a table (Limiting to 15) or even sometimes trying to access the databases, its just hanging up and not letting me to do anything... Why is this happening?

Posted: Mon Oct 29, 2007 11:10 am
by feyd
You're going to have to explain the composition of these tables and database more. Particularly how these files translated into the tables.

Posted: Mon Oct 29, 2007 11:14 am
by legend986
Ok I'm sorry about that...

First File -> Database - Table 1
Am able to read this one and count the rows
Using regular expressions in PHP to find an integer and an IP address

Second File -> Database
Not able to read or count. Unable to even delete this table now... It just hangs up...
Using regular expressions in PHP to find IP addresses along with some decimals so basically getting four columns, one for the IP address and three for the other numbers found.

Posted: Mon Oct 29, 2007 11:48 am
by feyd
Have you run CHECK/REPAIR queries on the table?

Posted: Mon Oct 29, 2007 11:55 am
by legend986
How long would it generally take to check a table having 3 million values? I mean, its been quite some time so once I get some output, I'll post here... For now, it just gives me a blank prompt not telling me if its doing someting... I'm using

Code: Select all

CHECK TABLE <tablename> FAST QUICK;

Posted: Mon Oct 29, 2007 11:59 am
by feyd
It takes some time to process large requests, especially on improperly configured tables and servers. I'm not saying your tables or server is improperly set up, just that improper set ups don't help.

Posted: Mon Oct 29, 2007 12:02 pm
by legend986
Oh... Atleast if I'm able to delete this table, I'll build it again but the problem is it isn't allowing me to do that either :(