LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 09-16-2008, 08:49 AM   #1
EnderX
Member
 
Registered: Nov 2006
Posts: 66

Rep: Reputation: 15
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?
 
Old 09-16-2008, 09:39 PM   #2
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 7.7 (?), Centos 8.1
Posts: 17,818

Rep: Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558
What distro? What DB (inc ver)?
Have you checked what other progs are running? Are you sure they're not causing the problem.

A common problem that causes slow reloads is not disabling indexes. For every rec inserted, it re-calcs the index list...
for a fast reload:
1. disable all indexes
2. load data
3. enable indexes.
you also get a 'better' index layout.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
battery monitor long delay maginotjr Slackware 0 07-27-2005 05:35 PM
unable to reload database of dns configuration vijaysh Debian 1 12-28-2004 05:57 AM
long delay dummyagain Programming 1 10-28-2003 05:49 AM
lilo long delay??? comtronics Debian 2 10-22-2003 04:59 AM
takes a long delay to resolve name Kocil Linux - Networking 2 03-11-2003 10:09 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 06:14 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration