Bug Time to Install?

[mrderanged]

Hey Guys,

Just wondering is the install time for this hack based on how large the post table is?

We have over 1.7M posts and importing the xml seems to be taking a while....

Thanks in Advance

 

[Ozzy47]

I am not 100% certain, but I do believe the bigger the post table, the longer it will take.

 

[Fillip H.]

Yeah it will take a very long time to install on such a large database

 

[mrderanged]

okay, thanks. I'll just let it sit there then and pray it doesn't time out Approximately how long do you think? It's going on about 5 or 10 minutes now I believe.....

 

[Fillip H.]

That's impossible to tell due to a very large number of factors, unfortunately.

 

[mrderanged]

not a problem, thanks for the quick answer either way If only my other paid mods gave support this quick..... <sigh>

I'm still not sure why I decided to upgrade from 3.8.7 to 4.1.5. lol

 

[mrderanged]

Is there any way to check progress?

 

[Fillip H.]

Not beyond the output text in the browser.

 

[mrderanged]

damn, that's what I figured. It's still going by the way, should I be worried?

 

[Fillip H.]

No, like I said it will take a very long time on such a large post table.

 

[mrderanged]

Should it still be going?

Sorry to be a PITA

 

[Fillip H.]

I have no further answer other than the previous posts, sorry

 

[mrderanged]

Not a problem at all, just wondering when I should start to get worried....

 

[Fillip H.]

That would be never

Unless the browser has stalled and doesn't have a spinning loading circle / "waiting for domainname.com" in the status bar anymore, it's still running

 

[mrderanged]

That would be never

Unless the browser has stalled and doesn't have a spinning loading circle / "waiting for domainname.com" in the status bar anymore, it's still running

Glad to hear that, as it still has both of those. It's just that I'm trying to get everything ready for our grand reopening tomorrow and I'm kinda in the dead zone waiting for this to complete....

 

[mrderanged]

My problem now is that everything else on the server seems to have come to a halt, can't access any other sites...... But the circle is still spinning and it's still waiting for domainname.com....

 

[Fillip H.]

That's because your MySQL server is using up all your CPU cycles trying to modify the database table.

Please simply wait until the process is done.

 

[mrderanged]

Okay, here's the problem. I was just told by my host that the db partition ran our of space. How much data does this add to the db? I was told that the db doubled in size. What I wound up seeing on my screen can be seen in the attachment. I'm not sure if the installation finished or not. How do you suggest that I proceed?



Regards

 

[Ozzy47]

Only thing I can think of maybe when it re writes the tables, it makes a copy of the original tables, and writes those, then overwrites the original ones.

I may be way off here, but Fillip H. will have the answer for sure.

 

[Fillip H.]

I don't know how MySQL alters its database tables, but I do know that it adds x amount of bytes per row to store the contents of the new column.