EmergencyEMERGENCY? Get 24/7 Help Now!

Using UDFs for geo-distance search in MySQL

 | June 19, 2014 |  Posted In: MySQL

In my previous post about geo-spatial search in MySQL I described (along with other things) how to use geo-distance functions. In this post I will describe the geo-spatial distance functions in more details. If you need to calculate an exact distance between 2 points on Earth in MySQL (very common for geo-enabled applications) you have at […]

Read More

Announcing TokuMX v1.5

 | June 18, 2014 |  Posted In: Tokutek, TokuView

Tokutek is pleased to announce today’s release of TokuMX v1.5. Also worth noting is that TokuMX is exactly 1 year old tomorrow. But enough about birthdays, and more about features! This release brings with it the ability to partition a collection in unsharded TokuMX deployments. Zardosht Kasheff, one of Tokutek’s engineers, did an excellent job […]

Read More

“How to monitor MySQL performance” with Percona Cloud Tools: June 25 webinar

 | June 18, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Cloud Tools, Technical Webinars

We recently released a new version of Percona Cloud Tools with MySQL monitoring capabilities. Join me June 25 and learn the details about all of the great new features inside Percona Cloud Tools – which is now free in beta. The webinar is titled “Monitoring All (Yes, All!) MySQL Metrics with Percona Cloud Tools” and begins at […]

Read More

MySQL Backup Service from Percona

 | June 17, 2014 |  Posted In: MySQL, Percona Backup Service, Percona Managed Services, Percona XtraBackup, Percona XtraDB Cluster

The Percona Backup Service managed service launched today. It ensures properly configured backups run successfully as scheduled on customer provided backup storage – whether on premise, in the cloud, or a hybrid. Backup issues or production data recovery are efficiently handled by Percona Managed Services technicians with deep knowledge of MySQL. As we state in […]

Read More

Best Practices for Partitioned Collections and Tables in TokuDB and TokuMX

 | June 13, 2014 |  Posted In: Tokutek, TokuView

In my last post, I gave a technical explanation of the performance characteristics of partitioned collections in TokuMX 1.5 (which is right around the corner) and partitioned tables in relational databases. Given those performance characteristics, in this post, I will present some best practices when using this feature in TokuMX or TokuDB. Note that these […]

Read More

mydumper [less] locking

 | June 13, 2014 |  Posted In: Insight for DBAs, MySQL

In this post I would like to review how my dumper for MySQL works from the point of view of locks. Since 0.6 serie we have different options, so I will try to explain how they work As you may know mydumper is multithreaded and this adds a lot of complexity compared with other logical […]

Read More

Announcing Percona XtraBackup 2.2.3 GA

 | June 12, 2014 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraBackup

Percona is glad to announce the release of Percona XtraBackup 2.2.3 on June 12th 2014. Downloads are available from our download site here and Percona Software Repositories. Percona XtraBackup enables backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered […]

Read More

Percona Server 5.6.17-66.0 is now available

 | June 11, 2014 |  Posted In: Events and Announcements, MySQL, Percona Server, Percona Software

  Percona is glad to announce the release of Percona Server 5.6.17-66.0 on June 11, 2014. Downloads are available here and from the Percona Software Repositories. Based on MySQL 5.6.17, including all the bug fixes in it, Percona Server 5.6.17-66.0 is the current GA release in the Percona Server 5.6 series. All of Percona’s software […]

Read More

Measure the impact of MySQL configuration changes with Percona Cloud Tools

 | June 11, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Cloud Tools

When you make a change to your MySQL configuration in production it would be great to know the impact (a “before and after” type of picture). Some changes are obvious. For many variables proper values can be determined beforehand, i.e. innodb_buffer_pool_size or innodb_log_file_size. However, there is 1 configuration variable which is much less obvious for many people […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.