article thumbnail

Percona Toolkit – A Quick Introduction to Summary

Percona

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. pt-summary --user=root [?2004l# virtual = 2.2G

Cache 96
article thumbnail

Tune Linux Kernel Parameters For PostgreSQL Optimization

Percona

Poorly configured OS kernel parameters can cause degradation in database server performance. Therefore, it is imperative that these parameters are configured according to the database server and its workload. SHMMAX / SHMALL. The PostgreSQL documentation contains more information about shared memory configuration.

Tuning 54
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40