LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > CentOS
User Name
Password
CentOS This forum is for the discussion of CentOS Linux. Note: This forum does not have any official participation.

Notices


Reply
  Search this Thread
Old 11-09-2016, 01:48 PM   #1
EnderX
Member
 
Registered: Nov 2006
Posts: 66

Rep: Reputation: 15
Attempting to determine reason for slowdown of database software between CentOS 6.2 and CentOS 7.2 - Request assistance


I am not that familiar with Linux - if this belongs in the 'Newbies' section, or anywhere else on this site, please move it there. I chose to post here because I am dealing with an issue between two versions of CentOS.

Recently, my boss has had me trying to build a new machine to use as a replacement device for our main system. I haven't had any problems installing anything, but on attempting to run an update against our database, we ran into a major slowdown relative to our other machine. (As in: A nightly update file, which normally takes ~20-30 minutes, takes between six and seven hours on the new machine when using the same upload process.) I am looking into the differences in the two versions of the database software, but given that I've tuned their config files as close to identically as possible I'm also trying to figure out where else the slowdown might be coming from, and am hoping that those here might be able to assist me in figuring out at least where to look next.

Old server:
Actual desktop device within our office.
Being loaded from Windows machine within our office.
'cat /etc/*-release' shows 'CentOS release 6.2 (Final)
Database software is Postgresql 8.4.9.
free results:
Code:
             total       used       free     shared    buffers     cached
Mem:      32586484   13285288   19301196          0     312600   11874580
-/+ buffers/cache:    1098108   31488376
Swap:     10010616          0   10010616
New server:
Virtual machine located in an offsite office.
Being loaded from Windows machine sitting in same offsite office.
'cat /etc/*-release' shows 'CentOS Linux release 7.2.1511 (Core)'
Database software is Postgresql 9.2.15
free results:
Code:
              total        used        free      shared  buff/cache   available
Mem:       32781448      377436     5725172       71660    26678840    31935344
Swap:      16515068         480    16514588
Again, I am not familiar with the inner workings of Linux. What are the best places to start looking for the source of this slowdown, and what do I need to be looking for when I get there to track the source of this problem down?
 
Old 11-09-2016, 06:06 PM   #2
smallpond
Senior Member
 
Registered: Feb 2011
Location: Massachusetts, USA
Distribution: CentOS 6 & 7
Posts: 3,087

Rep: Reputation: 826Reputation: 826Reputation: 826Reputation: 826Reputation: 826Reputation: 826Reputation: 826
Your three areas to look at are network speed, storage speed and CPU speed. You will want to compare what you are seeing on the VM to your old system.

Network: upload a large file from Windows to /tmp using WinSCP. Since tmpfs is in memory, this eliminates disk speed issues.

Storage speed: Same test but go to disk and include the time to do 'sync' at the end.

CPU: dmesg |grep Bogo
 
Old 11-09-2016, 07:32 PM   #3
Doug G
Member
 
Registered: Jul 2013
Posts: 749

Rep: Reputation: Disabled
Verify DNS resolving works properly on the db server.
 
Old 11-10-2016, 11:29 PM   #4
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.10, Centos 7.5
Posts: 17,602

Rep: Reputation: 2445Reputation: 2445Reputation: 2445Reputation: 2445Reputation: 2445Reputation: 2445Reputation: 2445Reputation: 2445Reputation: 2445Reputation: 2445Reputation: 2445
Are you absolutely sure the DB structures etc are identical eg if someone added/removed an index from the old DB, but that change never made it into the official schema version that you used to construct the new one, that could make a difference.
Did you define the initial disk space (inside the DB) to be the same or bigger when originally building the new one? Maybe its having to do space extensions on the fly?
 
  


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
How to determine whether my CentOS 6.6 has support USB 3.0 or not? lq_win Linux - Newbie 1 09-27-2016 02:13 AM
Assistance ldap kerberos auth against AD 2008 centos 5.8 shiden Linux - General 0 06-16-2013 09:12 PM
CentOS 5 - Need assistance with disabling logging to console split917 Linux - General 1 12-31-2008 06:47 AM
Assistance with SNMP on Redhat/CentOS stuaz Linux - Newbie 2 12-11-2008 10:46 AM
How does my CentOS box determine its name servers? Will they change? sneakyimp Linux - Newbie 2 10-23-2007 03:14 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > CentOS

All times are GMT -5. The time now is 02:43 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration