Long delay on database reload - where should I start looking for problems?
I was requested to make a dump of our main database and load it onto one of our test boxes yesterday. The reload attempt began around midmorning. However when I left, around nine hours later, it had not yet finished the run. Additionally, when viewing the results of a ps ax command, the time (which I am assuming is the time it has actually run) at a few minutes before I left was listed as 29:something, which leads me to believe that, over the course of nine hours of run, the database load process only actually received 29-30 minutes of processor time.
What might be causing that? Given that the database load was, to my knoweldge, the only thing running on the server in question other than background processes, what are the likeliest suspects, and how do I modify them so as to prevent something like this from happening in the future?
|