-
MySQL Full Versus Point-in-Time (Incremental) Recovery
A full recovery restores all data from a full backup. This restores the server instance to the state that it had when the backup was…
//
-
SHOW PROCESSLIST Statement
The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. The SHOW PROCESSLIST statement is one source of…
//
-
Important PS (Power shell) Scripts
$a = get-eventlog -logname system -message *SQL* -newest 1 $a | select-object -property * ————————————————————————————————————- EventID : 7036 MachineName …
//
-
MySQL Uptime
MySQL Uptime SELECT VARIABLE_VALUE AS Uptime_seconds, NOW() AS “Now”, NOW() – INTERVAL VARIABLE_VALUE SECOND AS “Up since”, DATEDIFF(NOW(), NOW() – INTERVAL…
//
-
MySQL join_buffer_size, sort_buffer_size, read_buffer_size and read_rnd_buffer_size
join_buffer_size, sort_buffer_size, read_buffer_size read_rnd_buffer_size These four buffers are allocated per connection. So think twice before alerting. For example, if you set join buffer size=2 M and…
//
-
innodb_change_buffer_max_size
With MySQL 5.6.2, you can set the maximum size of the change buffer as a percentage of the total size of the buffer pool using…
//
-
CPU Components
CPU consists of 6 main components: 1. CU Control unit 2. ALU Arithmetic logic unit 3. Registers 4. Cache 5. Buses 6. Clock All the…
//
-
Cache Memory
Hey guys, In this blog I am going to explain you about Cache Memory Cache is a small amount of high-speed random-access memory (RAM) built…
//
-
PG Basic Commands
========================================= –DB size select pg_database_size(‘databaseName’); /* ?column? | pg_database_size ———-+—————— 48104 | 7840623 */ postgres=# \l+ /* List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges | Size | Tablespace | Description…
//
-
PG Backup Dump
Types of DB backup · Logical BACKUP <pg_dump> · Physical Backup PG SQL Dump Three tasks we are going to do… Restoring…
//
-
pg_switch_wal()
pg_switch_wal() is a system function which forces PostgreSQL to switch to a new WAL file. pg_switch_wal() returns the end LSN + 1 of the old WAL file.…
//
-
pg_restore
pg_restore restores a PostgreSQL database from an archive file created by pg_dump. pg_restore [connection-option…] [option…] [filename] Example: We…
//