EmergencyEMERGENCY? Get 24/7 Help Now!

Advanced Query Tuning in MySQL 5.6 and MySQL 5.7 Webinar: Q&A

 | August 24, 2015 |  Posted In: MySQL, MySQL 5.7, MySQL Webinars, query tuning

Thank you for attending my July 22 webinar titled “Advanced Query Tuning in MySQL 5.6 and 5.7” (my slides and a replay available here). As promised here is the list of questions and my answers (thank you for your great questions). Q: Here is the explain example:

why is site_id a covered index for […]

Read More

Generated (Virtual) Columns in MySQL 5.7 (labs)

 | April 29, 2015 |  Posted In: MySQL, MySQL 5.7

About 2 weeks ago Oracle published the MySQL 5.7.7-labs-json version which includes a very interesting feature called “Generated columns” (also know as Virtual or Computed columns). MariaDB has a similar feature as well: Virtual (Computed) Columns. The idea is very simple: if we store a column

in our table we may want to filter or group […]

Read More

Sneak peek at the Percona Live MySQL Conference & Expo 2015

 | December 4, 2014 |  Posted In: Events and Announcements, MySQL, OpenStack Live, Percona Live

You know you’ll be there so why not save some $$ by registering now for the Percona Live MySQL Conference & Expo 2015 (April 13-16 in Santa Clara, Calif.). Super Saver registration discounts are available through Dec. 14 at 11:30 p.m. PST. (That’s just 10 days away!) What to expect this year? The Percona Live […]

Read More

Advanced MySQL Query Tuning (Aug. 6) and MySQL 5.6 Performance Schema (Aug. 13) webinars

 | August 4, 2014 |  Posted In: Insight for DBAs, MySQL, MySQL Webinars, query tuning

I will be presenting two webinars in August: Aug 6, 10 a.m. PDT: Advanced Query Tuning in MySQL 5.6 and Beyond Aug 13, 10 a.m. PDT:  Using Performance Schema to Monitor and Troubleshoot MySQL 5.6 This Wednesday’s webinar on advanced MySQL query tuning will be focused on tuning the “usual suspects”: queries with “Group By”, “Order […]

Read More

Using UDFs for geo-distance search in MySQL

 | June 19, 2014 |  Posted In: geo search, GIS, 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

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

MySQL Audit Plugin now available in Percona Server 5.5 and 5.6

 | May 7, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Server, Percona Software

The new Percona Server 5.5.37-35.0 and Percona Server 5.6.17-65.0-56, announced yesterday (May 6), both include the open source version of the MySQL Audit Plugin. The MySQL Audit Plugin is used to log all queries or connections (“audit” MySQL usage). Until yesterday’s release, the MySQL Audit Plugin was only available in MySQL Enterprise. EDIT:  Just to be clear, this implementation […]

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.