Alexander Rubin Archives - Percona Database Performance Blog

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

Alexander Rubin | August 24, 2015 | Posted In: MySQL, Technical Webinars

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:

mysql> explain extended select id, site_id from test_index_id where site_id=1
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: test_index_id
         type: ref
possible_keys: key_site_id
          key: key_site_id
      key_len: 5
          ref: const
         rows: 1
     filtered: 100.00
        Extra: Using where; Using index

mysql> explain extended select id, site_id from test_index_id where site_id=1

*************************** 1. row ***************************

id: 1

select_type: SIMPLE

table: test_index_id

type: ref

possible_keys: key_site_id

key: key_site_id

key_len: 5

ref: const

rows: 1

filtered: 100.00

Extra: Using where; Using index

why is site_id a covered index for […]

Peter Zaitsev hits the road for East Coast MySQL Meetup tour

Tom Diederich | May 6, 2015 | Posted In: Events and Announcements, MySQL

Percona CEO Peter Zaitsev and Big Data guru Alexander Rubin will be speaking at Meetups along the East Coast next week with stops in Boston (May 11), New York City (May 12), Philadelphia (May 13) and Baltimore (May 14). Dubbed the “MySQL Whistle-Stop Tour” since they’ll be traveling city to city via Amtrak, Peter will […]

Generated (Virtual) Columns in MySQL 5.7 (labs)

Alexander Rubin | April 29, 2015 | Posted In: MySQL

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

`FlightDate` date

1	`FlightDate` date

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

Using MySQL Event Scheduler and how to prevent contention

Alexander Rubin | February 25, 2015 | Posted In: Insight for DBAs, MySQL

MySQL introduced the Event Scheduler in version 5.1.6. The Event Scheduler is a MySQL-level “cron job”, which will run events inside MySQL. Up until now, this was not a very popular feature, however, it has gotten more popular since the adoption of Amazon RDS – as well as similar MySQL database as a service offerings […]

Sneak peek at the Percona Live MySQL Conference & Expo 2015

Tom Diederich | December 4, 2014 | Posted In: Events and Announcements, MySQL, 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 […]

Looking forward to Oracle OpenWorld 2014; visit us at Booth 2413!

Peter Zaitsev | September 25, 2014 | Posted In: Events and Announcements, MySQL

I’m excited to once again be heading to San Francisco next week for Oracle OpenWorld, and also very pleased to have a booth there this year along with some great speakers from Percona. The scope of Oracle OpenWorld 2014, which runs Sept. 28-Oct. 2, is enormous and there are several keynotes and sessions I’m looking […]

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

Alexander Rubin | August 4, 2014 | Posted In: Insight for DBAs, MySQL, Technical Webinars

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 […]

Using UDFs for geo-distance search in MySQL

Alexander Rubin | 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 […]

Measure the impact of MySQL configuration changes with Percona Cloud Tools

Alexander Rubin | 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 […]

MySQL Audit Plugin now available in Percona Server 5.5 and 5.6

Alexander Rubin | 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 […]

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

Peter Zaitsev hits the road for East Coast MySQL Meetup tour

Generated (Virtual) Columns in MySQL 5.7 (labs)

Using MySQL Event Scheduler and how to prevent contention

Sneak peek at the Percona Live MySQL Conference & Expo 2015

Looking forward to Oracle OpenWorld 2014; visit us at Booth 2413!

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

Using UDFs for geo-distance search in MySQL

Measure the impact of MySQL configuration changes with Percona Cloud Tools

MySQL Audit Plugin now available in Percona Server 5.5 and 5.6

Upcoming Webinars

PERCONA

SERVICES

SOFTWARE

RESOURCES

CONTACT US

COMMUNITY

CONFERENCES

ABOUT