computer performance

How to unlock the maximum TGP for an NVIDIA GPU in Linux. How to enable Dynamic Boost on Linux

Posted by Alex On November 14, 2025

Table of contents Why the GPU doesn’t run at full power on Linux How to unlock the maximum TGP for your GPU on Linux What Dynamic Boost is Why the GPU doesn’t run at full power on Linux In NVIDIA Settings, you can view your GPU’s characteristics. For my laptop GPU, NVIDIA Settings shows: Default TGP: 80 W Max TGP:...

How to cache MySQL / MariaDB query results

Posted by Alex On May 27, 2025

Contents 0. In MySQL, query caching has been completely removed in recent versions, while in MariaDB, on the contrary, it has become enabled by default. 1. How MySQL / MariaDB query caching works 2. When to use MySQL / MariaDB query caching 3. How to enable and configure MySQL / MariaDB query result caching 4. How to check MySQL /...

Should I close MySQL connections with $mysqli->close() in PHP scripts. Should I use $result->free()

Posted by Alex On April 17, 2025

Contents What are $mysqli->close() and $result->free() used for in PHP Is it necessary to close connections to MySQL / MariaDB and clear the result of the SQL query? When using $mysqli->close() and $result->free() will NOT give tangible results When to use $mysqli->close() and $result->free() Is it possible to close the MySQL database connection before completing the processing of query results...

How to list all current connections to MySQL and MariaDB databases

Posted by Alex On April 15, 2025

Contents List of running operations and processes on MySQL and MariaDB server How to view MySQL and MariaDB processes in real time What do the fields in the SHOW PROCESSLIST output mean How to display MySQL and MariaDB process data row by row instead of in a table Alternative syntax for SHOW FULL PROCESSLIST How to display only certain columns...

In-RAM filesystem to speed up file handling and reduce disk load (tmpfs)

Posted by Alex On September 5, 2024

Table of contents 1. What is tmpfs 2. What can tmpfs be used for 3. How to use tmpfs 4. Interface (script) for working with tmpfs (virtual memory filesystem) 4.1 Download the script for working with tmpfs (tmpfs-mounter) 4.2 tmpfs-mounter options 4.3 tmpfs-mounter usage examples Conclusion This guide will tell you about tmpfs: how to create a tmpfs filesystem; this...

SSD is very slow in Linux. How to check and enable TRIM in Linux (SOLVED)

Posted by Alex On August 11, 2024

If your SSD initially showed high performance, but over time it has become noticeably slower to read and write data, or periodically the read and write speed of the SSD drops sharply, then this article can help you. For SSD drives, it is necessary to perform the Trim operation and it is not enabled by default on some Linux distributions...

How to speed up a VirtualBox virtual machine

Posted by Alex On August 15, 2023

What to do to speed up VirtualBox On the same computer, a VirtualBox virtual machine can have different performance and responsiveness. The following are a few ways to speed up the virtual machine. 1. Enable the I/O Caching option Enabling “Use Host I/O Cache” for virtual machine disks can dramatically improve virtual machine performance. See “Terrible VirtualBox disk performance (SOLVED)”...

Terrible VirtualBox disk performance (SOLVED)

Posted by Alex On August 15, 2023

The performance of a virtual machine depends on the resources allocated to it (the number of CPU cores, the amount of RAM) and on the number of running programs in the virtual machine and their resource requirements. This is logical and works about as intuitively expected. But with heavy use of the disk in a virtual machine, its performance drops...

How to move VirtualBox virtual machines to another drive or computer

Posted by Alex On August 15, 2023

Migration of VirtualBox virtual machines VirtualBox virtual machines can be transferred in whole or in part (for example, only virtual disks) within the same computer (for example, to a faster SSD), as well as between computers. This note will tell you how to properly migrate VirtualBox virtual machines without the need for a long setup afterwards. Important: moving virtual machines...

How to increase the swap partition in Linux Mint and Ubuntu. How to create a Swap file in Linux

Posted by Alex On July 2, 2022

In this article, using Linux Mint and Ubuntu as an example, we will learn how to view information on the swap partition, create a swap file, and also increase the space available for swap. The swap file is a specific place on permanent storage (for example, on a hard disk), where data that does not fit in RAM is temporarily...