Insight for Developers

Column Histograms on Percona Server and MySQL 8.0

MySQL Column HIstorgrams

From time to time you may have experienced that MySQL was not able to find the best execution plan for a query. You felt the query should have been faster. You felt that something didn’t work, but you didn’t realize exactly what.
Maybe some of you did tests and discovered there was a better execution […]

Read more

MongoDB: Impact-free Index Builds using Detached ReplicaSet Nodes

MongoDB Impact-free Index Builds

Creating an index on a MongoDB collection is simple; just run the command CreateIndex and that’s all there is to it. There are several index types available, and in a previous post, you can find the more important index types: MongoDB index types and explain().
The command is quite simple, but for MongoDB, building an […]

Read more

Upcoming Webinar 7/23: 10 Common Mistakes Java Developers Make when Writing SQL

Mistakes Java Developers Make when Writing SQL

Please join Percona’s Senior Support Engineer Charly Batista as he presents “10 Common Mistakes (Java) Developers Make when Writing SQL” on Tuesday, July 23rd, 2019 at 8:00 AM EDT (UTC-4).
Register Now
It’s easy for Java developers (and users of other OO languages) to mix object-oriented thinking and imperative thinking. But when it comes to writing […]

Read more

How to Report Bugs, Improvements, New Feature Requests for Percona Products

report bugs

Clear and structured bug, improvement, and new feature request reports are always helpful for validating and fixing issues. In a few cases, we have received these reports with incomplete information which can cause a delay in the verification of issues. The most effective method to avoid this situation is to ensure complete information about […]

Read more