Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 840 Next 30 Older Entries

Displaying posts with tag: Uncategorized (reset)

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: http://www.mysql.com/support/supportedplatforms/workbench.html (http://www.mysql.com/support/supportedplatforms/workbench.html).

So, even if you’re not using any of the recent versions and editions of Workbench (Utilities comes with all of them, Tools menu -> “Start Shell for MySQL Utilities“) you can

  [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: http://www.mysql.com/support/supportedplatforms/workbench.html (http://www.mysql.com/support/supportedplatforms/workbench.html).

So, even if you’re not using any of the recent versions and editions of Workbench (Utilities comes with all of them, Tools menu -> “Start Shell for MySQL Utilities“) you can

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

MySQL Enterprise Monitor (MEM) (https://www.mysql.com/products/enterprise/monitor.html" target="_blank) is the monitoring solution offered as part of MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition (https://www.mysql.com/products/" target="_blank). 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 Cloud. If you are a MySQL customer, it is recommended that you download MEM from My Oracle Support (MOS).

Once you have downloaded and extracted the installation binaries, you can start the installation. You have the choice between using a GUI,

  [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 |
+------+-------------+----------+------+---------------+-------------+---------+----------------------------+--------+-------+
|    1 | SIMPLE      | customer | ALL  | PRIMARY       | NULL        | NULL    | NULL                       | 150303 |       |
|    1 | SIMPLE      | orders   | ref  |
  [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 the exhibition center and all seemed to be buzzing with activity.

We were informally informed that there were about 800 attendees on Day 1.

We received many positive comments about the panel discussion on the importance of

  [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 need should also come from me.

The name is to ensure to keep my words humble and respect views which may differ from mine; maybe conflicting and still right. Different people have differing views and this blog is just one view as seen


  [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;
+----+------+-----------+----------+---------+------+--------------+-----------------------------+----------+
| Id | User | Host      | db       | Command | Time | State        | Info                        | Progress |
  [Read more...]
Mixing databases usually not optimal
+0 Vote Up -0Vote Down

Dan McKinley (Etsy) wrote an [IMHO] insightful article Why MongoDB Never Worked at Etsy.

First off, it’s important to realise that it’s not a snipe at MongoDB – it’s a fine tool.

The lessons are related to mixing multiple databases in a deployment (administration and monitoring overhead) and the acknowledgement that issues of schema design, scalability and maintenance need attention regardless of which brand or technology you pick for your database. That comes back to the old insight that migrations are rarely worth it (regardless of what you migrate to what).

I think these are indeed important considerations as they have a major impact on the ongoing costs of your entire environment (production as well as development and testing) – these days we

  [Read more...]
Colorado MySQL Meetup Group November 11th
Employee +2 Vote Up -0Vote Down

The Colorado MySQL meetup is getting together on November 11th.

Location: Oracle 500 Eldorado Boulevard, Broomfield, CO

All MySQL users and interested parties are invited to participate and attend the following activities! 

Monday, November 11, 2013

From 6:00PM to 8:30PM

  • Oracle Broomfield Office
    Building 1 – Demo 1127 Conference Room
    500 Eldorado Blvd
    Broomfield, CO 80021

    Schedule:
    6PM Meet, Greet, and Eat
    6:30-45 – Intro’s/Updates
    6:45-7:30 – Session 1 – MySQL 5.6 and Cluster Update – Lee Stigile, Oracle
    7:30-8:15 – Session 2 – MySQL and Hadoop Integration – Dave Smelker, ADURANT Technologies
    8:15-8:30 – Closing
    For further information, please contact:
    George Trujillo
    Email: [masked]
    Cell: [masked]













  [Read more...]
A chance for Cassandra Storage Engine
+2 Vote Up -1Vote Down

Short version: It looks like DataStax has released an official C++ driver for their new CQL native protocol. This makes it possible to update MariaDB’s Cassandra Storage Engine to work with all column families in Cassandra 1.2 and up.

Long version: In case the above didn’t make any sense to you, here’s some background:

  • Cassandra Storage Engine was developed against Cassandra 1.1
  • Cassandra 1.1 had a client-server protocol based on Thrift API. It had a number of limitations, the most important was lack of support for streaming. These translated into limitations in Cassandra storage engine, for example, I could not support secondary indexes.
  • Cassandra 1.2 was released in February, and it had
  [Read more...]
Luxbet, MariaDB and Melbourne Cup
+0 Vote Up -0Vote Down

Yesterday was Melbourne Cup day in Australia – the biggest annual horse race event in the country, and in the state of Victoria it’s even a public holiday.

Open Query does work for Luxbet (part of Tabcorp), and Melbourne Cup day is by far their biggest day of the year in terms of traffic. It’s not just a big spike, there’s orders of magnitude difference so you can really say that the rest of the year is downright quiet (in relative terms). So, a very interesting load pattern.

Since last year Luxbet has upgraded from stock MySQL to MariaDB, and with our input made some other infrastructure modifications including moving to a pure solid state storage (FusionIO) solution as a SAN just won’t deliver the resilience and performance required. This

  [Read more...]
MySQL yum repositories
Employee_Team +14 Vote Up -0Vote Down

I think most people will agree that downloading RPMs from a website is kind of old fashioned when there are yum repos. After a number of user requests, we have now launched the official yum repos for MySQL.

Can’t wait? Neither can I. On a fresh install:

  • Download a setup package for your distribution from http://dev.mysql.com/downloads/repo
  • yum localinstall mysql-community-release-distro-release.noarch.rpm
  • yum update
  • yum install mysql-community-server
  • This works for fresh installs. If you’re upgrading from an older version, read about upgrading first.

    What’s in the repo?


      [Read more...]
    MySQL 5.6: no testcases for non-crashing bugs, either (and an incomplete bugfix)
    +5 Vote Up -2Vote Down

    I normally don’t write such posts, but this time I’ll do a little whining. I was looking at MySQL’s Bug#69581, which was also filed against MariaDB as MDEV-5102. With some effort (little for this particular bug), one can find out that Bug#69581’s counterpart in Oracle’s internal bug database is Bug#16862316, and the fix is in revision 5366 in MySQL 5.6.14.

    There are two problems, though:

    • The fix doesn’t include a testcase. We know, Oracle doesn’t publish testcases for crashing bugs, with a justification that it’s for security reasons. However, this bug is not a crashing
      [Read more...]
    Studying for the New MySQL 5.6 DBA Exam
    Employee +1 Vote Up -0Vote Down

    I have have been receiving a lot of questions about the new MySQL 5.6 DBA exam. Sadly I can not answer a lot of the questions until after my exam in early November. However I do know some good things about the new exams.

    First — No True or False questions. Oracle has set the standards on that policy and I had to update the ol’ 5.0 exams to make certain there the T/F questions were removed. Why is this important? Don’t you have a fifty/fifty chance on T/F questions? The trouble is that some of these questions were a wee bit tricky and needed parsing plus a full understanding of the subject to get them right. For fairness, it is easy to do without the T/F questions.

    Second — No more pick up to N answers. Once again, for fairness.

    Third — One exam for the certification. In the past the

      [Read more...]
    EXPLAIN UPDATE/DELETE/INSERT in MySQL and MariaDB
    +1 Vote Up -0Vote Down

    MySQL 5.6 added support for EXPLAIN INSERT/UPDATE/DELETE. MySQL 5.7 made some improvements to EXPLAIN code. Also, 5.7 added support for EXPLAIN FOR CONNECTION, which looks very similar to MariaDB’s SHOW EXPLAIN. I was working on putting EXPLAIN INSERT/UPDATE/DELETE into MariaDB 10.0, so I’ve dug up some details and thought I’d share them:

    EXPLAIN UPDATE/DELETE

    EXPLAIN UPDATE looks like regular EXPLAIN SELECT:

    MySQL [dbt3sf1]> explain update orders set o_orderpriority='1-URGENT' where o_orderDATE='1998-07-21';
    +----+-------------+--------+-------+---------------+---------------+---------+-------+------+-------------+
    | id | select_type | table  | type  | possible_keys | key           | key_len | ref   | rows | Extra       |
    +----+-------------+--------+-------+---------------+---------------+---------+-------+------+-------------+
    |  1 | SIMPLE      | orders | range |
      [Read more...]
    MEM 3.0: Getting started
    Employee +1 Vote Up -0Vote Down

    Time to install MEM 3.0, and get its built-in agent working.

    [ If you want some tips on What's New, have a look here. ]

    I’ve downloaded the Monitor Server and the agent zipped s/w for Linux & Win from http://edelivery.oracle.com:

    mysqlmonitor-3.0.0.2887-linux-x86-installer.bin
    mysqlmonitoragent-3.0.0.2887-linux-glibc2.3-x86-32bit-installer.bin
    mysqlmonitoragent-3.0.0.2887-windows-installer.exe
    

    The Monitor install

    So, on my Oracle Linux machine:

    ./mysqlmonitor-3.0.0.2887-linux-x86-installer.bin

    It all installs fine. No issues, if you’re used to MEM 2.3.

    Double check your configuration_report.txt :

    MySQL
      [Read more...]
    MEM 3.0: Getting started
    Employee +0 Vote Up -0Vote Down

    Time to install MEM 3.0, and get its built-in agent working.

    [ If you want some tips on What's New, have a look here. ]

    I’ve downloaded the Monitor Server and the agent zipped s/w for Linux & Win from http://edelivery.oracle.com:

    mysqlmonitor-3.0.0.2887-linux-x86-installer.bin
    mysqlmonitoragent-3.0.0.2887-linux-glibc2.3-x86-32bit-installer.bin
    mysqlmonitoragent-3.0.0.2887-windows-installer.exe
    

    The Monitor install

    So, on my Oracle Linux machine:

    ./mysqlmonitor-3.0.0.2887-linux-x86-installer.bin

    It all installs fine. No issues, if you’re used to MEM 2.3.

    Double check your configuration_report.txt :

    MySQL
      [Read more...]
    MySQL Tech Tour @Barcelona, 7th Nov.
    Employee +0 Vote Up -0Vote Down

    We’re on the move again. Come and join us on the 7th of November at the Oracle office in Barcelona. Find out more details about what was announced at MySQL Connect, as well as what’s next…

    For more information about this event please visit the link below:

    http://www.oracle.com/us/dm/29173-emeafm13045970mpp010-oem-2020763-es.html


    MySQL Tech Tour @Barcelona, 7th Nov.
    Employee +0 Vote Up -0Vote Down

    We’re on the move again. Come and join us on the 7th of November at the Oracle office in Barcelona. Find out more details about what was announced at MySQL Connect, as well as what’s next…

    For more information about this event please visit the link below:

    http://www.oracle.com/us/dm/29173-emeafm13045970mpp010-oem-2020763-es.html


    MySQL Connect 2013: ps_tools
    Employee_Team +2 Vote Up -0Vote Down

    During my talk and hands on labs at MySQL Connect 2013 I used several views, functions, and procedures from ps_helper and ps_tools.

    The slides from the two talks can be downloaded from Thanks For Attending MySQL Connect or from the MySQL Connect 2013 Content Catalogue.

    You can read more about ps_helper on Mark Leith’s blog and you can download ps_helper from github.

    To get ps_tools, download

      [Read more...]
    Zendcon
    Employee +0 Vote Up -0Vote Down

    Zendcon is a difficult conference if you work in an exhibit hall booth. At other shows, attendees ask general questions about MySql or how Oracle is guiding products. Zendcon is much more pointed. When is 5.7 multisource relication going to be available? How does Visual Explain work? How can I make sure replication goes back to semi-sync after going async? It is a great show but the level of questions are a notch or two higher than most other shows.



      [Read more...]
    Webinar recording: MariaDB Query Optimizer - Improving query performance
    +1 Vote Up -0Vote Down

    Last week, we at SkySQL had a webinar titled MariaDB Query Optimizer - Improving Query Performance with yours truly as the author and presenter. The recording is now available online at the above link.

    The webinar is an overview of all important parts of the MySQL/MariaDB query optimizer. Special attention is given to the new optimizer features and differences between MySQL and MariaDB.

    MySQL Connect slides
    Employee_Team +2 Vote Up -0Vote Down

    Thank you for attending MySQL Connect 2013.

    The Saturday session 50 Tips for Boosting MySQL Performance [CON2655] was sold out. It shows the interest in practical recipes to solve performance problems. Maybe the topic of a book as suggested by the audience ?

    On Monday, the tutorial Enhancing Productivity with MySQL 5.6 New Features [TUT8131] was less crowded due to MySQL 5.6 Replication Tips and Tricks [TUT8133]  happening at the same time, again tips and tricks are more popular

      [Read more...]
    Deep Dive Technical Buffet on last day of MySql Connect
    Employee +0 Vote Up -0Vote Down

    Proving this it is the show for in-depth technical information, MySql Connect finished with a bang. Six different two hour plus deep dive tutorials were offered and all had very good attendence. Many of the attendee were seasoned Oracle DBAs eager to gorge at this buffet of technical knowledge.

    The crowd for Ligaya Trumele’s Getting Started
    with MySql
    was packed with
    Oracle DBAs who were amazed at the simplicity of the MySql architecture once they figured out the concept of multiple storage engines.

    Luis Soares had a tutorial that was everything you ever wanted to know about 5.6 replication plus a look multi source that will be in 5.7. His discussion on how and when binlogs are written and the impact if that timing on replication was intense, detailed, and worth the price of the show itself.



      [Read more...]
    OL 4 MySQL: Extending my VM’s root f/s online
    Employee +0 Vote Up -0Vote Down

    Ok, so after all the things that have been announced @MySQLConnect, I’ve got to play around with them. First stop: space (no.. not ‘the final frontier’).

    I need more space on my f/s to get installing. I was a bit of a scrooge when I created my Oracle Linux virtual machine, so now I’m paying the price.

    Filesystem            Size  Used Avail Use% Mounted on
    /dev/mapper/vg_ol63uek01-LogVol01
                          7.1G  5.7G  1.1G  85% /

    As I’m using Virtual Box, I’ve added a new SATA Controller vmdk of 10G, SATA Port 1 and then start it up.

    fdisk -l

    Will be able to identify the new & unused partition:

    [root@ol63uek01 ~]# fdisk -l
    Disk /dev/sda: 8589 MB, 8589934592 bytes
     255 heads, 63 sectors/track, 1044 cylinders
     Units = cylinders of
      [Read more...]
    OL 4 MySQL: Extending my VM’s root f/s online
    Employee +0 Vote Up -0Vote Down

    Ok, so after all the things that have been announced @MySQLConnect, I’ve got to play around with them. First stop: space (no.. not ‘the final frontier’).

    I need more space on my f/s to get installing. I was a bit of a scrooge when I created my Oracle Linux virtual machine, so now I’m paying the price.

    Filesystem            Size  Used Avail Use% Mounted on
    /dev/mapper/vg_ol63uek01-LogVol01
                          7.1G  5.7G  1.1G  85% /

    As I’m using Virtual Box, I’ve added a new SATA Controller vmdk of 10G, SATA Port 1 and then start it up.

    fdisk -l

    Will be able to identify the new & unused partition:

    [root@ol63uek01 ~]# fdisk -l
    Disk /dev/sda: 8589 MB, 8589934592 bytes
     255 heads, 63 sectors/track, 1044 cylinders
     Units = cylinders of
      [Read more...]
    MySQL Tech Tour – Coming to a town near you.. probably..
    Employee +0 Vote Up -0Vote Down

    http://www.oracle.com/us/dm/29127-emeafm13045970mpp014-oem-2019447.html

    Come hear me talk about whats new with MySQL and loads of other interesting things.. come see the raspberry pi project in the flesh

    Sign up today!

     

     

     

     


    Data Analytics at NBCUniversal. Interview with Matthew Eric Bassett.
    +0 Vote Up -0Vote Down
    “The most valuable thing I’ve learned in this role is that judicious use of a little bit of knowledge can go a long way. I’ve seen colleagues and other companies get caught up in the “Big Data” craze by spend hundreds of thousands of pounds sterling on a Hadoop cluster that sees a few megabytes [...]
    MySQL Fabric Presentation
    Employee +0 Vote Up -0Vote Down

    MySQL Fabric Presentation

    http://www.slideshare.net/nixnutz/mysql-57-fabric-high-availability-and-sharding#!

     

    Excellent presentation by Ulf Wendel 


    MySQL 5.7 Fabric: any good?
    Employee +0 Vote Up -0Vote Down

    MySQL 5.7 has sharding built-in through MySQL Fabric (Lab Release). And, MySQL has scaled the marketing team to handle 500.000 customer requests/s – or, was it MySQL 5.7 query throughput? Whatever. MySQL Fabric frees you from implementing sharding yourself. MySQL Fabric simplifies the management of MySQL Replication clusters of any size.

    Is it any good? Yes, but MySQL must not stop here. This is not enough. MySQL is still a little too much behind trend setters.

    MySQL 5.7 Fabric: High Availability and Sharding from Ulf Wendel

      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 840 Next 30 Older Entries

    Planet MySQL © 1995, 2014, 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.