We are pleased to announce the release of PMM 2 Beta!  PMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance.

• Query Analytics:
  • MySQL and MongoDB – Slow log, PERFORMANCE_SCHEMA, and Profiler data sources
  • Support for large environments – default view all queries from all instances
  • Filtering – display only the results matching filters such as the schema name or the server instance
  • Sorting and more columns – now sort by any column.
  • Modify Columns – Add one or more columns for any field exposed by the data source
  …

In this tutorial I want to share with you simple example of php mysql pagination using angularjs we will use dirPaginationjs as Pagination Directive in angularjs paginate using php mysql databasewe will create step by step very basic example of server side pagination in angularjs pagination i

In this tutorial I want to share with you simple example of php mysql pagination using angularjs we will use dirPaginationjs as Pagination Directive in angularjs paginate using php mysql databasewe will create step by step very basic example of server side pagination in angularjs pagination i

Today we’re happy to announce that we’ll be partnering with Datavail to provide solutions for continuous & highly available MySQL, Percona Server & MariaDB database operations based on Tungsten Clustering & Datavail Database Services.

Datavail is a renowned, tech-enabled data management, applications, business intelligence, and software solutions provider with a team of 700+ DBAs that look after customers’ database environments.

What are we aiming for?

Together we’re looking to continue to drive momentum in supporting rapid MySQL & MariaDB based application deployments as well as highly available and scalable database implementations for existing and future customers.

This new collaboration is …

It’s that time of year again, and we’ve just had the presentations of the MySQL Community Awards at Percona Live. A more fulsome blog post will be written for the Community Blog in the next few days about the worthy winners. Meanwhile, though, here’s a summary.

Committee Co-Secretaries Emily Slocombe of Square, and Agustin Gallego of Percona presented these annual community nominated awards today. In four categories, the awards went to:

• Community Contributor of the Year: Weixiang Zhai
• Community Contributor of the Year: Valerii Kravchuk

Both of these awards were made for bug identification and submission. Valerii was represented by Vicențiu Ciorbaru of MariaDB Foundation who accepted the award on his behalf.

• The Application of the Year award was mad to Dbdeployer, for its incredible usefulness to the …

When Skillz, a leading mobile eSports platform connecting 2.6 billion gamers across the globe, sought Pythian’s help with reducing storage costs, they learned they could not only reduce costs but also gain a more responsive application while providing an improved player experience.

The gaming company collects data to customize player experiences by delivering relevant campaigns, performing fraud and cheater detection, segmenting markets, and providing special offers according to region or interest. However, the Skillz environment was complex, comprising of many layers and very complex code, as well as geographical data, and their existing analytics were costly and slow. “We were running these applications hourly to customize these different features, then finding ourselves wishing we could do that much more quickly,” said Miriam Aguirre, VP Engineering at Skillz.

Skillz wanted to move to an ‘event-driven’ analytics …

During my presentation at Percona Live 2019, I’ll be talking about how Riot Games, the company behind League of Legends, migrated hundreds of millions of player accounts to unlock opportunities for us to delight players. This meant moving ten geographically distributed databases into a single global database replicated into four AWS regions. I’ll talk about some of the technical decisions we made, the expected vs actual outcomes, and lessons we learned along the way.

Migrating hundreds of millions of player records without impacting a player’s ability to manage their account and log in was a daunting task. I’ll shed some light on how we managed to handle this data migration while modifying the database schema. I’ll also go into detail on the backend …

ProxySQL 2.0.4, released by ProxySQL, is now available for download in the Percona Repository along with Percona’s proxysql-admin tool.

ProxySQL is a high-performance proxy, currently for MySQL and database servers in the MySQL ecosystem (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues.

This release includes ProxySQL 2.0.4 which fixes many bugs and introduces a number of features …

(In the previous post, Part 5, we covered Data Reads.)

In this blog post, we continue our series of exploring MyRocks mechanics by looking at the configurable server variables and column family options. In our last post, I explained at a high level how reads occur in MyRocks, concluding the arc of covering how data moves into and out of MyRocks. In this post, we’re going to explore replication with MyRocks, more specifically read-free replication.

Some of you may already be familiar with the concepts of read-free replication as it was a key feature of the TokuDB engine, which leveraged fractal tree indexing. TokuDB was similar to MyRocks in the sense that it had a pseudo log-based storage …

Tweet

The sys schema was created to make it easier to use the Performance Schema. This included several functions, for example to convert the picoseconds used by the Performance Schema into human readable strings. In MySQL 8.0.16, three of these functions have been implemented as native functions in MySQL Server.

Why do away with the sys schema functions? There are two reasons: performance and ease of use. The native functions are written in C++ like the rest of the server whereas the sys schema functions were written as stored functions. Function written in C++ are inherently faster than stored functions. Additionally, that the functions are native means you no longer need to prefix them with sys. to tell MySQL where …