MySQL

Category to track posts in PlanetMySQL

Percona Toolkit 3.1.0 Is Now Available

Percona Toolkit

Percona announces the release of from the website or install PT-1696: the new pt-pg-summary tool supports PostgreSQL data collection in a way similar to other PT summary tools. The following is a fragment of the report that the tool produces:

Shell

##### — Database Port and Data_Directory — ####
+———————-+—————————————————-+
| Name […]

Read more

Which Indexes are Cached? Discover with PMM.

Which Indexes are Cached

One of the great things about working at Percona is the constant innovation that occurs as a result of a deep level of technical expertise. A more recent conversation about the Information Schema table: here. The README.md has installation instructions.
Download the queries-mysqld.yml file fromCustom Queries in PMM by Daniel Guzmán Burgos, one of our […]

Read more

Simulating InnoDB Secondary Index Corruption

InnoDB Secondary Index Corruption

Working as a support engineer here at Percona is amazing, as you get a variety of requests, ranging from the most trivial questions to questions that require source code review and understanding of the internals of InnoDB, for example.
In our world where High Availability is a must, everything is about being pro-active, and when […]

Read more

Percona Server for MySQL 5.7.27-30 Is Now Available

Percona Server for MySQL 5.7

Percona announces the release of Percona Server for MySQL 5.7.27-30 on August 22, 2019 (downloads are available here and from the Percona Software Repositories). This release merges changes of #5678.
On a server with two million or more tables using foreign keys and AUTOINC columns, the shutdown may take a measurable length of time. Bug fixed #95895).
If large pages […]

Read more