I am speaking at two sessions at Oracle Open World this week; one tutorial and one hands-on-lab:

• How to Analyze and Tune MySQL Queries for Better Performance
  Monday, Sep 29, 10:15 AM
• MySQL EXPLAIN in Practice 
  Wednesday, Oct 1, 10:15 AM

I can also recommend the other sessions by members of the MySQL Optimizer Team:

• Manyi Lu: MySQL 5.7: What’s New in the Parser and the Optimizer?
  Wednesday, Oct 1, 11:30 AM …

We will be attending and participating in the MySQL Central at Oracle Open World September 30 - October 2. We will be demoing our product at booth 2433.

Baron Schwartz will also be speaking on VividCortex’s MySQL infrastructure. Details are below:

Session ID: CON5105 Session Title: Inside VividCortex’s MySQL Architecture Venue / Room: Moscone South - 262 Date and Time: 10/2/14, 9:30 - 10:15 Summary: VividCortex ingests a lot of data at high velocity and stores it in a cloud-hosted back end based primarily on MySQL. Baron Schwartz will explain how VividCortex uses MySQL and why it’s been the best choice thus far.

Looking forward to seeing you there!

The MySQL Utilities Team is pleased to announce the general availability (GA) release of MySQL Utilities. This release includes a number of improvements for useabilty, stability, and a few enhancements. A complete list of all improvements can be found in our release_notes.
New Enhancements! This release represents a stable release of the product. Along with several defect patches, we also include the following enhancements.

• The mysqlserverclone utility now checks diskspace as a prerequisite to cloning the server.
• The --force option was removed from the mysqlfailover utility to remove confusion on its purpose.
• A warning is issued if the mysqld --skip-innodb option is used because this option is ignored in MySQL 5.7 and later.
• Utilities can correctly parse and display the PROXY …

The MySQL Utilities Team is pleased to announce the alpha release of MySQL Utilities. This release represents a new evolution of the product including the following enhancements.

• The mysqlprocgrep utility now displays the processes and connections killed during a --kill operation. The displayed rows come from the appropriate SHOW PROCESSLIST entries.
• The mysqlbinlogmove utility was added. It relocates binary log files, and moves files based on their sequence number or modified date.
• The mysqlgrants utility was added. It displays grants per object, and produces reports by user, user with grants, and GRANT statement.
• Health reports can now be generated for a list of slaves without a master specified. In this case, "No master specified" appears for connection status for each slave, instead of an error.

 
How Can I Download MySQL Utilities? You can download MySQL …

Are you attending Oracle Open World? Would you like to know more about Oracle DevOps products for managing your MySQL servers? If so, stop by Tuesday, September 30 at 10:15 in the Hotel Nikko - Bay View and join us for a hands on lab (HOL9234) for MySQL Utilities and Connector/Python.

We will present the basics for getting started using Python to manage your MySQL servers. MySQL Utilities includes utilities for a wide variety of operations from displaying GRANT statements to setting up automatic failover for replication.

Check out the abstract for the HOL here.

For a long time, the MySQL development community and many others have wanted a server that worked without FRM files.  The motivation behind removing FRM files, and the design goals around new data dictionary, can be explored in more detail in the blog post by Ståle Deraas “A New Data Dictionary for MySQL”.

And now for the good news! We have a MySQL Labs Release ready with a preview of the new Data Dictionary!

What is in the first MySQL Data Dictionary labs release?

First of all, the FRM files are now gone. The MySQL server no longer creates FRM files, ever. The server stores table meta-data in the data dictionary tables which use the InnoDB storage engine. For more details on the schema definitions of data dictionary tables, see …

You can download webm from github: https://github.com/ylouis83/webm

webm: mysql web key performance monitor

webm is a tool that display key value graph on website and webm was developed by javascript and mysqlmon ( mysql data collection tool wrote by AnySQL)

Environment need:

Linux version 5+ php5 Apache server

You can also run this tool on windows platform (install xampp )

and webo will come soon ( oracle web monitor tools )

login webm system

mysql redo/binlog size per 10 seconds

mysql insert/update (little delete) per 10 seconds
…

For a long time, there have been complaints about deficiencies of the data dictionary of MySQL. Many have expressed a lack of love for FRM files, see Morgan’s blog post and Stewart Smith’s post MySQL Architecture.

We are now designing and implementing a new and improved data dictionary for MySQL, and some key design goals are:

• Store dictionary information in transactional storage. We will first focus on InnoDB, but other storage engines might follow
• Consolidate distributed dictionary information for the server into a unified dictionary
• Store all dictionary information in a uniform way, with uniform APIs for all dictionary objects
• Get rid of filesystem-property induced …

Would you like to win a free pass to MySQL Central and Oracle Open World this week? We’re giving away two full passes to the entire event, including tickets to the Appreciation event (concerts and food) on Wednesday night!

We’ll announce the contest on our Twitter account. Just follow us there, and retweet to enter. May the best retweeter win! Make sure you follow us; we’ll DM you to let you know if you’re one of the two lucky winners. DMs can only be sent to followers.

Photo credit: https://www.flickr.com/photos/kptripathi/6922527665/

It is official: MySQL listens to HTTP and speaks JSON. MySQL got a new plugin that lets HTTP clients and JavaScript users connect to MySQL using HTTP. The development preview brings three APIs: key-document for nested JSON documents, CRUD for JSON mapped SQL tables and plain SQL with JSON replies. More so: MySQL 5.7.4 has SQL functions for modifying JSON, for searching documents and new indexing methods! The download and documentation (also here) is on http://labs.mysql.com/, the slides are below:

HTTP Plugin for MySQL! from Ulf Wendel

What a buzzword bingo! The HTTP Plugin is just a HTTP …