All Blogs / Technology / Programming / Database Development / Popular


Percona Live Europe Featured Talks: Automatic Database Management System Tuning Through Large-Scale Machine Learning with Dana Van Aken

Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog post is with Dana Van Aken, […]

ProxySQL Improves MySQL SSL Connections

In this blog post, we’ll look at how ProxySQL improves MySQL SSL connection performance. When deploying MySQL with SSL, the main concern is that the initial handshake causes significant overhead if you are not using connection pools (i.e., mysqlnd-mux with PHP, mysql.connector.pooling in Python, etc.). Closing and making new connections over and over can greatly impact […]

Webinar Tuesday, September 19, 2017: A Percona Support Engineer Walkthrough for pt-stalk

Join Percona’s, Principal Support Engineer, Markus Albe as he presents A Percona Support Engineer Walkthrough for pt-stalk on Tuesday, September 19, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Register Now As a support engineer, I get dozens of pt-stalk captures from our customers containing samples of iostat, vmstat, top, ps, SHOW ENGINE […]

Percona Live Europe Featured Talks: Debugging with Logs (and Other Events) Featuring Charity Majors

Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog post is with Charity Majors, CEO/Cofounder […]

Evolution of data structures in Yandex.Metrica

Yandex.Metrica is the world's second largest web analytics system. Metrica takes in a stream of data representing events that took place on sites or on apps. Our task is to process this data and present it in an analyzable form. Processing the data in itself is not a problem. Show More Summary

Percona Blog Poll Results: What Database Engine Are You Using to Store Time Series Data?

In this blog post, we talk about the results of Percona’s time series database poll “What Database Engine Are You Using to Store Time Series Data?” Time series data is some of the most actionable data available when it comes to analyzing trends and making predictions. Simply put, time series data is data that is […]

The MySQL High Availability Landscape in 2017 (the Babies)

This post is the third of a series focusing on the MySQL high availability solutions available in 2017. The first post looked at the elders, the technologies that have been around for more than ten years. The second post talked about the adults, the more recent and mature technologies. In this post, we will look […]

This Week in Data with Colin Charles #6: Open Source Summit and Percona Live Europe

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. What a long, packed week! Spent most of it at Open Source Summit North America, while still enjoying the myriad phone calls and meetings you have as a Perconian. In addition to two talks, I […]

Stuff The Internet Says On Scalability For September 15th, 2017

Hey, it's HighScalability time: Earth received Cassini’s final signal at 7:55am ET. Let's bid a fond farewell. After a 13-year tour of duty, job well done! If you like this sort of Stuff then please support me on Patreon. 12.9 million:...Show More Summary

Lock, Stock and MySQL Backups: Data Guaranteed Webinar Follow Up Questions

Hello again! On August 16, we delivered a webinar on MySQL backups. As always, we’ve had a number of interesting questions. Some of them we’ve answered on the webinar, but we’d like to share some of them here in writing. What is the best way to maintain daily full backups, but selective restores omitting certain […]

Percona Live Europe Featured Talks: Monitoring Open Source Databases with Icinga with Bernd Erk

Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog post is with Bernd Erk, CEO […]

Percona Server for MongoDB 3.4.7-1.8 is Now Available

Percona announces the release of Percona Server for MongoDB 3.4.7-1.8 on September 14, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, openShow More Summary

Percona Live Europe Featured Talks: Visualize Your Data with Grafana Featuring Daniel Lee

Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog post is with Daniel Lee, a […]

Have you noticed there's a lot more collaboration going on these days? Why?

Thanks to zero marginal cost digital production methods, we're seeing content markets—for the first time—develop in conditions free from supply and price constraints. In the process we've learned something: consumers have an unquenchable...Show More Summary

Massive Parallel Log Processing with ClickHouse

In this blog, I’ll look at how to use ClickHouse for parallel log processing. Percona is seen primarily for our expertise in MySQL and MongoDB (at this time), but neither is quite suitable to perform heavy analytical workloads. There is a need to analyze data sets, and a very popular task is crunching log files. Below […]

cscope: Searching Code Efficiently

In this post, we will discuss how to search code with the help of cscope. Let’s begin by checking its description and capabilities (quoting directly from http://cscope.sourceforge.net/): Cscope is a developer’s tool for browsing source code. Allows searching code for: all references to a symbol global definitions functions called by a function functions calling a […]

Upcoming Webinar September 14, 2017: Supercharge Your Analytics with ClickHouse

Join Percona’s CTO Vadim Tkachenko @VadimTk and Altinity’s Co-Founder, Alexander Zaitsev as they present Supercharge Your Analytics with ClickHouse on Thursday, September 14, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Reserve Your Spot   ClickHouse is a real-time analytical database system. Even though they’re only celebrating one year as open source software, it has […]

Updating InnoDB Table Statistics Manually

In this post, we will discuss how to fix cardinality for InnoDB tables manually. As a support engineer, I often see situations when the cardinality of a table is not correct. When InnoDB calculates the cardinality of an index, it does not scan the full table by default. Instead it looks at random pages, as determined […]

Upcoming Webinar Tuesday September 12: Differences between MariaDB and MySQL

Join Percona’s Chief Evangelist, Colin Charles (@bytebot) as he presents Differences Between MariaDB and MySQL on Tuesday, September 12, 2017, at 7:00 am PDT / 10:00 am EDT (UTC-7). Reserve Your Spot   Are they syntactically similar? Where do these two query languages differ? Why would I use one over the other? MariaDB is on the […]

Percona Live Europe Featured Talks: MongoDB – Sharded Cluster Tutorial with Jason Terpko and Antonios Giannopoulos

Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog post is with Jason Terpko and […]

Copyright © 2015 Regator, LLC