Tag - insight for DBAs

MySQL 8.0.22: SHOW PROCESSLIST Version 2 – Now Available From PERFORMANCE_SCHEMA

SHOW PROCESSLIST Version 2

The “SHOW PROCESSLIST” command is very famous and very useful for MySQL DBAs. It will help you to understand the ongoing thread activities and their current states. By default, the “show processlist” output details will be collected from the thread manager, and it needs the global mutex. From MySQL 8.0.22, we have an alternative […]

Read more

Thinking About Deploying MongoDB? Read This First.

Deploying MongoDB

Are you thinking about deploying MongoDB? Is it the right choice for you?
Choosing a database is an important step when designing an application. A wrong choice can have a negative impact on your organization in terms of development and maintenance. Also, the wrong choice can lead to poor performance.
Generally speaking, any kind of database […]

Read more

MySQL Backup and Recovery Best Practices

MySQL Backup and Recovery Best Practices

In this blog, we will review all the backup and restore strategies for MySQL, the cornerstones of any application. There are a few options, depending on your topology, MySQL versions, etc. And based on that, there are some questions we need to ask ourselves to make sure we make the right choices.
How many backups […]

Read more

A Snippet of Features: Reviewing PostgreSQL Version 13

Reviewing PostgreSQL Version 13

This latest and greatest version of PostgreSQL, version 13, has been here since last summer and continues the tradition of gains in performance, administration, application development, and security enhancements.
Of the many new features and enhancements that have been made, some of the more notable ones include:

Space savings and performance gains from de-duplication of B-tree […]

Read more

Streaming MySQL Backups with Percona XtraBackup – Another Alternative

Today we are going to present you with another way to make a database copy between servers using our Percona XtraBackup utility.  What is the difference with many others existing on the web?  Not many, but they are interesting in terms of performance and availability.
We will combine the xbstream utility with the power of […]

Read more