MySQL fails :(
Moderator: General Moderators
MySQL fails :(
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?
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.
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.
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;