Sponsored Content
Top Forums UNIX for Advanced & Expert Users Server showing high Sys% CPU usage Post 303037857 by Neo on Thursday 15th of August 2019 05:38:29 AM
Old 08-15-2019
Maybe consider a book or online resource tutorial optimizing postgres, for example:

PostgreSQL 9.6 High Performance: Optimize your database with configuration tuning, routine maintenance, monitoring tools, query optimization and more

Note: I'm not recommending the book above, it is just an example of an "optimize your postgres db" book .....

I've not used Postgres in ages and am still using MySQL, generally speaking and only have experience tuning MySQL for the past ten years or so,

Last edited by hicksd8; 08-15-2019 at 10:04 AM..
This User Gave Thanks to Neo For This Post:
 

10 More Discussions You Might Find Interesting

1. Linux

Help pinpointing high HTTPD CPU usage in TOP

Hi, new here and need some help. Sometimes my site is extremely slow, if when there aren't too many people on, whereas when there are over 300 online members the site may be very fast. We use CentOS, PHP 5.26. The server has 4GB and Plesk usually shows about 2 or 3 GB free. I believe I can see... (4 Replies)
Discussion started by: pspace
4 Replies

2. AIX

How to monitor the IBM AIX server for I/O usage,memory usage,CPU usage,network..?

How to monitor the IBM AIX server for I/O usage, memory usage, CPU usage, network usage, storage usage? (3 Replies)
Discussion started by: laknar
3 Replies

3. Ubuntu

High System CPU Usage

I am running a Dell PE R815 with 4 x AMD 12 core CPUs with 128GB of RAM and a RAID 5 array of 6 SAS disks. This is an HPC application and is definitely CPU bound, however once I run 16 of these processes (thus pinning 16 cores) the work performed slows down dramatically, to maybe 5 or 10% of what... (2 Replies)
Discussion started by: mowmentous
2 Replies

4. AIX

Script to identify high CPU usage processes

Hi Guys, I need to write a script capable of identifying when a high cpu utilitzation process. It sounds simple but we are on a AIX 5.3 environment with Virtual CPU's (VP's) and logical CPU's. Please any ideas or tips would be highly appreciated. Thanks. Harby. (6 Replies)
Discussion started by: arizah
6 Replies

5. AIX

HELP!!! high CPU usage with ITM kuxagent

ibm tivoli monitor's kuxagent is taking up a lot of cpu usage. anybody has any idea? i attatched a screenshot. (3 Replies)
Discussion started by: curtis911
3 Replies

6. Linux

System Went panic after CPU usage high

Hi All, Yesterday my Linux server went panic and even a small command took a lot of time to run. When i monitored pl find the below output Cpu(s): 0.1%us, 98.4%sy, 0.0%ni, 1.5%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st the time spent on kernel mode is 98 % and also idle time is around 1.5 %...... (4 Replies)
Discussion started by: jegaraman
4 Replies

7. AIX

Wait time shows high CPU usage

Hi, I can't seem to make sense of this. My wait time is showing really high but vmstat's and topas are showing normal usage. ps aux USER PID %CPU %MEM SZ RSS TTY STAT STIME TIME COMMAND root 9961810 5680.7 0.0 448 384 - A Dec 16 6703072:12 wait ... (2 Replies)
Discussion started by: techy1
2 Replies

8. AIX

High CPU Usage , users affected

Dear All, One production Server is affected by high usage. Application is slow now. Please guide me how to solve it? NMON Report shows full cpu usage. Here im posting some server details. bash-3.2# lparstat -i Node Name : ********* Partition Name ... (6 Replies)
Discussion started by: Thala
6 Replies

9. Shell Programming and Scripting

High cpu usage

I have created one script and i have added it into cron to run after 10 mins. However I have noted that whenever that script runs, It causes CPU utilization of server to increase about 10-20 % I have rechecked script and there is no way i can make changes, Script contain only 2-3 commands. So... (4 Replies)
Discussion started by: Nakul_sh
4 Replies

10. Solaris

How can i restrict user high cpu usage?

HI In my M5000 , one of domain is having SAp installed. from today onwards we are facing some stange issue. when we start SAP application, that particular user is taking 95 % of system CP and renaming 5 % is taken by system . because of this reason application is slow. i have 4 CPU(32... (4 Replies)
Discussion started by: bentech4u
4 Replies
books(3)							       Coin								  books(3)

NAME
books - Books Related to Open Inventor / Coin Here is a list of some of the better books for people that invested in software development with Open Inventor. If you have suggestions for additional books that ought to go on this list, please feel free to tell us about it. The Inventor Mentor (subtitle 'Programming Object-Oriented 3D Graphics with Open Inventor') This is an excellently written, detailed, tutorial-style introductory book for Open Inventor that takes you through all the fundamental design principles applied in the Open Inventor API, richly illustrated and with numerous, well documented code examples. The Inventor Mentor is getting a bit old, but do not let that put you off. It is as valid today as it was the day it was written, and we heartily recommend this book for anyone learning to use Open Inventor. ISBN 0-201-62495-8. You might also be able to find this book as a pdf file online, but we recommend having it in print. The Inventor Toolmaker This book explains how Open Inventor was designed for being extended by the users, and walks you through how to develop your own components that work with all aspects of Coin. ISBN 0-201-62493-1. You might also be able to find this book as a pdf file online, but we recommend having it in print. The Annotated VRML2.0 Reference Manual This book covers the VRML97 (aka VRML 2.0) standard, which Coin has implemented with its Inventor/VRMLnodes/* classes, which is an extension made beyond the Open Inventor V2.1 API. The VRML97 format has some significant differences from the Inventor and VRML1 formats, so it is a useful book if you want to use that part of Coin. ISBN 0-201-41974-2. You will find the specification documents for VRML97 online at http://www.web3d.org/. The Open GL Programming Manual This is the bible when it comes to OpenGL programming and is relevant for Open Inventor extenders that develop new nodes that implement or affect Open Inventor OpenGL rendering. There are many editions of this book since it is updated whenever new versions of OpenGL are standardized and comes out, so check that you have identified the latest edition if you order one. The Open Inventor C++ Reference Manual Although this book is directly relevant for Open Inventor, it does only cover the Open Inventor 2.1 API. This information is more or less also covered in the online doxygen doc for Coin, where you have it hyperlinked, and can also be generated offline from the Coin sources to have locally, so we do not think this book is very useful to have in print. We mention it anyway since it is an official documentation book for Open Inventor. ISBN 0-201-62491-5. Version 3.1.3 Wed May 23 2012 books(3)
All times are GMT -4. The time now is 01:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy