Linux, programming and more
InfluxDB is a time series database designed to handle high write and query loads.
It is an integral component of the TICK or TIG stacks.
TIG: Telegraf + InfluxDB + Grafana
TICK: Telegraf + InfluxDB + Chronograf + Kapacitor
Basically its one of the best stacks on the marktet for capacity and vitality monitoring with huge potential to be extended to your needs.
We are talking here around the TIG-stack.
[Read more…]
CentOS 8 has PostgreSQL within the default repositories but its’ a bit outdated – currently during writing of this post, it’s the version: 10.6.
The currently official version of PostgreSQL is version: 12.1
So this instruction was written to install the current actual version of PostgreSQL 12.1 on CentoOS 8 system.
Let’s get started!
[Read more…]
1 | mysqladmin -u root -p -i 1 processlist |
-u username
-p you will be promted for a password
-i 1 interval one second
Output will see like this one:
1 2 3 4 5 6 7 8 9 | +--------+------+-------------------+-----+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +--------+------+-------------------+-----+---------+------+-------+------------------+ | 424111 | db4 | 192.168.2.1:58431 | db4 | Sleep | 15 | | | | 424195 | db4 | 192.168.2.1:50531 | db4 | Sleep | 1 | | | | 424483 | db3 | 192.168.2.1:41503 | db3 | Sleep | 464 | | | | 424490 | db3 | 192.168.2.1:41513 | db3 | Sleep | 443 | | | | 424551 | root | localhost | | Query | 0 | | show processlist | +--------+------+-------------------+-----+---------+------+-------+------------------+ |
Some basic postgre commands:
\d [NAME] describe table, index, sequence, or view \d{t|i|s|v|S} [PATTERN] (add "+" for more detail) list tables/indexes/sequences/views/system tables \da [PATTERN] list aggregate functions \db [PATTERN] list tablespaces (add "+" for more detail) \dc [PATTERN] list conversions \dC list casts \dd [PATTERN] show comment for object \dD [PATTERN] list domains \df [PATTERN] list functions (add "+" for more detail) \dg [PATTERN] list groups \dn [PATTERN] list schemas (add "+" for more detail) \do [NAME] list operators \dl list large objects, same as \lo_list \dp [PATTERN] list table, view, and sequence access privileges \dT [PATTERN] list data types (add "+" for more detail) \du [PATTERN] list users \l list all databases (add "+" for more detail)