Author - Carlos Salguero

Insert Random Data into Tables Using mysql_random_data_load

Insert Random Data into Tables

In this short blogpost, we’ll show you how to use the mysql_random_data_load tool to insert random data into tables. This is a great aide in testing when you have empty tables and need them to be populated with data. We’ve all done it manually (the INSERT INTO … VALUES … way), but that is surely […]

Read more

Using Percona Toolkit pt-mongodb-summary

Percona Toolkit

This blog post is another in the series on the Percona Server for MongoDB 3.4 bundle release. In this blog post, we’ll look at the
pt-mongodb-summary tool in Percona Toolkit.
The
pt-mongodb-summary tool from Percona Toolkit provides a quick at-a-glance overview of MongoDB and Percona Server for MongoDB instances. It is equivalent to
pt-mysql-summary for MySQL. 

pt-mongodb-summary also collects information about […]

Read more

Using Percona Toolkit pt-mongodb-query-digest

Percona Toolkit

This blog post is another in the series on the Percona Server for MongoDB 3.4 bundle release. In this blog post, we’ll look at how to use the
pt-mongodb-query-digest tool in Percona Toolkit 3.0.
Percona’s
pt-query-digest is one of our most popular Percona Toolkit MySQL tools. It is used on a daily basis by DBAs and […]

Read more

Changing the Tablespace Directory with pt-online-schema-change

MariaDB ColumnStore

In this blog, we’ll discuss changing the tablespace directory using pt-online-schema-change.
One of the most annoying situations in the life of a DBA is realizing that the disk where the datadir resides is running out of space. If you’re lucky enough to run over an LVM volume or a RAID (depending on the level, though), it […]

Read more