How to know from the Linux command line what kind of processor I have

central-processing-unitcommand-line-interface

How can I tell from the Linux command line what kind of processor my machine has? E.g. AMD Opteron or Intel Core 2 Duo.

uname -a just tells me it's x86_64 but that isn't enough information.

Best Answer

dmidecode

or preferably

cat /proc/cpuinfo

dmidecode will give you a lot more info than just what processor, thou /proc/cpuinfo provides more info about the processor itself

Related Solutions

Windows – Does Windows Have a Built-in ZIP Command for Command Line?

It's not built into Windows, but it's in the Resource Kit Tools as COMPRESS,

C:\>compress /?

Syntax:

COMPRESS [-R] [-D] [-S] [ -Z | -ZX ] Source Destination
COMPRESS -R [-D] [-S] [ -Z | -ZX ] Source [Destination]

Description:
Compresses one or more files.

Parameter List:
-R Rename compressed files.

-D Update compressed files only if out of date.

-S Suppress copyright information.

-ZX LZX compression. This is default compression.

-Z MS-ZIP compression.

Source Source file specification. Wildcards may be
used.

Destination Destination file | path specification.
Destination may be a directory. If Source is
multiple files and -r is not specified,
Destination must be a directory.

Examples:

COMPRESS temp.txt compressed.txt
COMPRESS -R *.*
COMPRESS -R *.exe *.dll compressed_dir

Postgresql – How to Best Manage High PostgreSQL CPU Use

The question is impossible to answer, we have no idea what is going on. You're talking about 12-15 connections, that's next to nothing. But, when executing very complex queries, or using a bad database schema, lack of indexes, etc. cpu usage can go up any time.

Version 8.0.9 is serious problem, 8.0 is EOL as of october 2010 and the lastest fix is version 8.0.26 (4 years of bugfixes after 8.0.9). You should at least update to this version, to fix many bugs in 8.0.

Start logging the queries, use EXPLAIN to see the queryplan, take a look at VACUUM and you might need a REINDEX as well. Your hardware looks fine for now, you first have to find the source of the problems.

Consider to hire a PostgreSQL dba for a couple of days.

Best Answer

Related Solutions

Windows – Does Windows Have a Built-in ZIP Command for Command Line?

Postgresql – How to Best Manage High PostgreSQL CPU Use

Related Topic