All Blogs / Technology / Programming / Database Development / New


ICP Counters in information_schema.INNODB_METRICS

In this blog, we’ll look at ICP counters in the information_schema.INNODB_METRICS. This is part two of the Index Condition Pushdown (ICP) counters blog post series.  As mentioned in the previous post, in this blog we will look at how to check on ICP counters on MySQL and Percona Server for MySQL. This also applies to […]

Webinar May 23, 2017: MongoDB Monitoring and Performance for the Savvy DBA

Join Percona’s Senior Technical Services Engineer Bimal Kharel on Tuesday, May 23, 2017, as he presents a webinar on MongoDB monitoring called How to Help Your DBA’s Sleep Better at Night at 10:00 am PDT / 1:00 pm EDT (UTC-7). Register Now Are you trying to stay on top of your database before things turn ugly? Between […]

Stuff The Internet Says On Scalability For May 19th, 2017

Hey, it's HighScalability time: Who wouldn't want to tour the Garden of Mathematical Sciences with Plato as their guide? If you like this sort of Stuff then please support me on Patreon. 2 billion: Android users; 1,000: cloud TPUs freely...Show More Summary

Percona Toolkit 3.0.3 is Now Available

Percona announces the release of Percona Toolkit 3.0.3 on May 19, 2017. Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL and MongoDB server and system tasks too difficult or complex for DBAs to perform manually. Percona Toolkit, like all Percona software, is free and open source. You download Percona Toolkit packages from the […]

MongoDB Authentication and Roles: Creating Your First Personalized Role

In this blog post, we’ll walk through the native MongoDB authentication and roles, and learn how to create personalized roles. It is a continuation of Securing MongoDB instances. As said before, MongoDB features a few authentication methods and built-in roles that offer great control of both who is connecting to the database and what they are allowed […]

Percona Live Open Source Database Conference 2017 Slides and Videos Available

The slides and videos from the Percona Live Open Source Database Conference 2017 are available for viewing and download. The videos and slides cover the keynotes, breakout sessions and MySQL and MongoDB 101 sessions. To view slides, go to the Percona Live agenda, and select the talk you want slides for from the schedule, and […]

Percona Server for MongoDB 3.2.13-3.3 is Now Available

Percona announces the release of Percona Server for MongoDB 3.2.13-3.3 on May 15, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open-source,...Show More Summary

Is Serverless the New Visual Basic?

With Serverless hiring less experienced developers can work out better than hiring experienced cloud developers. That's an interesting point I haven't heard before and it was made by Paul Johnston, CTO of movivo, in The ServerlessCast...Show More Summary

Percona Server for MySQL 5.7.18-14 is Now Available

Percona announces the GA release of Percona Server for MySQL 5.7.18-14 on May 12, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based on MySQL 5.7.18, including all the bug fixes in it, Percona Server for MySQL […]

Stuff The Internet Says On Scalability For May 12th, 2017

Hey, it's HighScalability time: Earth's surface is covered with accidental hidden letters. Can you find them? (ABC: The Alphabet from the Sky) If you like this sort of Stuff then please support me on Patreon. 1 million: cord cuttersShow More Summary

MyRocks and LOCK IN SHARE MODE

In this blog post, we’ll look at MyRocks and the [crayon-5914cfbfc0be8990845684-i/]. Those who attended the March 30th webinar “MyRocks Troubleshooting” might remember our discussion with Yoshinori on [crayon-5914cfbfc0bee152014290-i/]. Show More Summary

Percona Server for MySQL 5.5.55-38.8 is Now Available

Percona announces the release of Percona Server for MySQL 5.5.55-38.8 on May 10, 2017. Based on MySQL 5.5.55, including all the bug fixes in it, Percona Server for MySQL 5.5.55-38.8 is now the current stable release in the 5.5 series. Percona Server for MySQL is open-source and free. You can find release details in the 5.5.55-38.8 milestone […]

Percona-Lab/mongodb_consistent_backup: 1.0 Release Explained

In this blog post, I will cover the Percona-Lab/mongodb_consistent_backup tool and the improvements in the 1.0.1 release of the tool. Percona-Lab/mongodb_consistent_backup mongodb_consistent_backup is a tool for performing cluster consistent backups on MongoDB clusters or single-replica sets. Show More Summary

MariaDB Handler_icp_% Counters: What They Are, and How To Use Them

In this post we’ll see how MariaDB’s Handler_icp_% counters status counters (Handler_icp_attempts and Handler_icp_matches) measure ICP-related work done by the server and storage engine layers, and how to see if our queries are getting any gains by using them. These counters (as seen in SHOW STATUS output) are MariaDB-specific. In a later post, we will see […]

Percona Server for MongoDB 3.4.4-1.4 is Now Available

Percona announces the release of Percona Server for MongoDB 3.4.4-1.4 on May 9, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source,...Show More Summary

Chasing a Hung MySQL Transaction: InnoDB History Length Strikes Back

In this blog post, I’ll review how the InnoDB history length can affect a hung MySQL transaction. Recently I was helping a customer discover why SELECT queries were running slower and slower until the server restarts (which got things back to normal). It took some time to get from that symptom to a final diagnosis. […]

Privacy: Bartering Data for Services

Data is the new currency. A phrase we’ve heard frequently in the wake of the story of Unroll.me selling user data to Uber. Two keys to that story: Users didn’t realize their data was being sold. Free services can be considered a sophisticated form of phishing attack. In both cases prevention requires user awareness. Show More Summary

Getting to know MySQL InnoDB cluster, the new kid in the block

InnoDB Cluster was released as GA a few weeks ago. I remember the initial announcement of the product at OOW 2016, promising a seamless solution for replication and high availability with great ease of use. I was a bit disappointed to...Show More Summary

Stuff The Internet Says On Scalability For May 5th, 2017

Hey, it's HighScalability time: GPUs and CPUs run hot hot hot. See them in action with thermal imaging. (Tested) If you like this sort of Stuff then please support me on Patreon. 25ms: SpaceX satellite latency; 17 million: tax returns...Show More Summary

How much disk space should I allocate for Percona Monitoring and Management?

I heard a frequent question at last week’s Percona Live conference regarding Percona Monitoring and Management (PMM): How much disk space should I allocate for PMM Server? First, let’s review the three components of Percona Monitoring and Management that consume non-negligible disk space: Prometheus data source for the time series metrics Query Analytics (QAN) which […]

Copyright © 2015 Regator, LLC