Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 121 to 130 of 935 10 Older Entries

Displaying posts with tag: Uncategorized (reset)

Live from the world of MySQL RE
Employee_Team +0 Vote Up -0Vote Down

Welcome to the official MySQL Release Engineering blog!

Dynamic replication filters — our wheel will be square!
+1 Vote Up -1Vote Down

This is both hilarious and sad. The new MySQL 5.7 milestone release presents a new feature — replication filters are now dynamic. This is a great and long awaited feature, no doubt about it.

In short, for years MySQL slaves could filter the incoming stream of replication events based on the database or table name these events were applicable to. These filters were configured using the my.cnf file (or command-line), in particular with the following variables:

replicate_do_db
 replicate_ignore_db …
  [Read more...]
The MySQL 5.7.3 Milestone Release is available
Employee_Team +11 Vote Up -0Vote Down

The MySQL Development team is happy to announce our 5.7.3 development milestone release, now available for download at dev.mysql.com.  You can find the full list of changes and bug fixes in the 5.7.3 Release Notes.  Here are the highlights. Enjoy!

Over 1 million QPS with InnoDB Memcached Plugin

After reaching 500 thousand QPS in Read-Only on SQL queries in 5.7.2 we now follow up with over 1 million QPS with InnoDB Memcached Plugin. Read more on this at …

  [Read more...]
MySQL Utilities: copy, replicate, show, failover… over and over again.
Employee +3 Vote Up -0Vote Down

So, after installing Workbench 6.0.7 on my pc, and playing around with the MySQL Utilities that are included, I thought I’d do similar to what others have done (Thanks Tony D.) and share my experience on how I’ve used them. If you haven’t installed Workbench before, you might want to check your platform first: …

  [Read more...]
MySQL Utilities: copy, replicate, show, failover… over and over again.
Employee +0 Vote Up -0Vote Down

So, after installing Workbench 6.0.7 on my pc, and playing around with the MySQL Utilities that are included, I thought I’d do similar to what others have done (Thanks Tony D.) and share my experience on how I’ve used them. If you haven’t installed Workbench before, you might want to check your platform first: …

  [Read more...]
Install MySQL Enteprise Monitor (MEM) 3.0 Using Limited Resources
Employee_Team +1 Vote Up -0Vote Down

MySQL Enterprise Monitor (MEM) is the monitoring solution offered as part of MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition. In this blog, I will not go into details of the features of MEM, but rather focus on the case where you want to install MEM 3.0 to try it out on your personal desktop or laptop.

A trial version (the full product, but the can only be used for 30 days) is available from Oracle’s Software Delivery …

  [Read more...]
Pager script for shrinking EXPLAIN output
+1 Vote Up -0Vote Down

Everyone who works with MySQL (or MariaDB) query optimizer has to spend a lot of time looking at EXPLAIN outputs. You typically first look at the tabular form, because it is easier to read. You can immediately see what the join order is, what numbers of records will be read, etc:

MariaDB [dbt3sf1]> explain select * from customer, orders where c_custkey= o_custkey;
+------+-------------+----------+------+---------------+-------------+---------+----------------------------+--------+-------+
| id   | select_type | table    | type | possible_keys | key         | key_len | ref                        | rows   | Extra | …
  [Read more...]
Open Source India 2013
Employee +0 Vote Up -0Vote Down

Oracle MySQL participated at the Open Source India at the NIMHANS convention center on 11-13 Nov 2013 (http://osidays.com/osidays/).

This is the third year we participated and yours truly had the pleasure to deliver the keynote about MySQL. Was also invited to participate in a panel discussion on the importance of certification.

OSI has become the meeting place for all open source professionals at Bangalore. It was a pleasure to meet with old friends who are passionate about open source.

There were a number of interesting talks. Many open source companies had their booths at …

  [Read more...]
Hello World
Employee +2 Vote Up -0Vote Down

So here goes …

While there are already some blog postings from me at Oracle’s MySQL Enterprise Backup (MEB) team blog at https://blogs.oracle.com/mysqlenterprisebackup/, this blog is for my personal views and views outside of MEB.

Why the name with 2c.
The first challenge before you think of blogging is to convice yourself that maybe your views will have some value for a reader. The second is to find a name of the blog. Its not that I am fully convinced of the former but there are some things that need to be written and since the need is mine the fulfillment of the …

  [Read more...]
SHOW EXPLAIN in MariaDB 10.0 vs EXPLAIN FOR CONNECTION in MySQL 5.7
+2 Vote Up -3Vote Down

MariaDB 10.0 has SHOW EXPLAIN feature. It was coded by yours truly and first introduced about a year ago. Last release of MySQL 5.7 introduced EXPLAIN FOR CONNECTION, which looks rather similar to MariaDB’s SHOW EXPLAIN. I was wondering how these two compare.

The basics

The usage scenarios are similar. In both cases, you first need a connection id of a running query. It is typically obtained by running SHOW PROCESSLIST:

MariaDB [(none)]> show processlist;
  [Read more...]
10 Newer Entries Showing entries 121 to 130 of 935 10 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.