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 中文
Showing entries 1 to 30 of 274 Next 30 Older Entries

Displaying posts with tag: News (reset)

Webinar – Monitoring MySQL and MariaDB databases with MONyog. Register now
+0 Vote Up -0Vote Down

Monitoring MySQL and MariaDB databases without a powerful tool like MONyog can be challenging. However, if you already use MONyog you might not be using it to it’s full potential. In this webinar, we will introduce you to the entire feature set of MONyog followed by a Q&A session.

You’ll also be delighted to know that one lucky winner gets MONyog Ultimate worth $399 for free. So, make sure you book your spot.

Date: Tuesday, July 8, 2014
Time: 10:00 am PT
Presenter: Rohit Nadhani (CEO, Webyog)
Register your spot for free




  [Read more...]
SQLyog – Introducing Session Restore
+0 Vote Up -0Vote Down

Ever had this nightmare of your system crashing, or you accidentally closing SQLyog and losing all your open tabs and queries? Don’t worry, we have you covered!

Introducing Session Restore. You can now restore your previous session along with all queries and history tab the way you left it. Here’s a quick video:

Session Restore is available for all SQLyog users. Existing customers can download the latest build from Customer Portal. To evaluate SQLyog, please download a 30-day trial.

We are very excited about this release, and hope that you will like it.

  [Read more...]
They’re Here: Official MySQL Repos for Debian and Ubuntu
Employee_Team +9 Vote Up -0Vote Down
As we’ve hinted at for some time now, we have been busy preparing some good stuff for our Debian and Ubuntu users. And today we’re delighted to launch our own official MySQL apt repos for Debian and Ubuntu. After working closely with the Debian and Ubuntu communities to make sure that the native MySQL packages […]
MySQL Workbench 6.1.6 GA has been released
Employee_Team +0 Vote Up -0Vote Down

The MySQL developer tools team announces 6.1.6 as our GA release for
MySQL Workbench 6.1.

MySQL Workbench 6.1.6 is a maintenance release and contains over 30
fixes and minor enhancements made since the original GA release.

MySQL Workbench 6.1

Introducing over 30 new features, this version has many significant
enhancements focusing on real-time performance assessment and analysis
from the SQL statement level to server internals and file IO. You can
see this from additions to the SQL Editor as well as new dashboard
visualization and reporting that take advantage of MySQL Server 5.6
and 5.7 Performance Schema, and enhancements to the MySQL Explain Plans.

Additionally Workbench 6.1 is leveraging work from various teammates in
MySQL Engineering by introducing a schema








  [Read more...]
New SQLyog and MONyog coming – please upgrade soon!
+1 Vote Up -0Vote Down

We are about to release upgrades to both SQLyog and MONyog with an important fix: linked libraries possibly vulnerable to the ‘Heartbleed’ OpenSSL bug have been upgraded to non-affected versions (the new MONyog release will have a few more fixes as well).

Since this security issue became known a few days ago, media and Internet have swollen with information about vulnerable systems. There is probably both a lot of facts and fiction circulating.

A good summary appeared in the Percona blog. It mostly focuses on server-side vulnerabilities. However

  [Read more...]
What’s New in MySQL Workbench 6.1
Employee_Team +3 Vote Up -0Vote Down

The recently released MySQL Workbench 6.1 continues expanding the capabilities of the tool. This version focuses on performance analysis features for MySQL server workload and queries, taking advantage of performance_schema improvements introduced in MySQL 5.6 and 5.7 DMR.

This is a overview of the new features we’ve added. Some of them are covered in more detail in separate posts.

New Navigator PERFORMANCE Section

The new PERFORMANCE section includes Dashboard, Performance Reports, andPerformance Schema Setup pages. Generally, this new performance reporting feature provides a graphical representation of key statistics from the MySQL server status, and provides an overview of the MySQL server subsystems.

Dashboard

View server performance statistics in a graphical

  [Read more...]
The MySQL 5.7.4 Milestone Release is available
Employee_Team +7 Vote Up -0Vote Down

The MySQL Development team is happy to announce our 5.7.4 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.4 Release Notes.  Here are the highlights. Enjoy!

Error Logging

Use of error logging API in InnoDB (WL#6755) This work by Anil Toshniwal completes the integration of the new error log formatting in 5.7. It was done for the server layer in 5.7.2 and now it has been done for InnoDB. There is one common API for all error logging. Messages to the error log now have the same format with connection ID and UTC timestamp with microsecond resolution.  The user is

  [Read more...]
MySQL Workbench 6.1.4 GA has been released
Employee_Team +0 Vote Up -0Vote Down

The MySQL developer tools team announces 6.1.4  as our GA release for MySQL Workbench 6.1.

MySQL Workbench 6.1 is an upcoming major update for the official MySQL graphical development tool.
Introducing over 30 new features, this version has many significant enhancements focusing on real-time performance assessment and analysis from the SQL statement level to server internals and file IO. You can see this in additions to the SQL Editor as well as new dashboard visualization and reporting that take advantage of MySQL Server 5.6 and 5.7 Performance Schema, and enhancements to the MySQL Explain Plans.

Additionally Workbench 6.1 is leveraging work from various teammates in MySQL Engineering by introducing a schema called “SYS” that provides simplified views on Performance Schema, Information Schema, and other areas. Special


  [Read more...]
SSH tunnel rewritten, table partitions and more
+0 Vote Up -0Vote Down
The previous integration of plink.exe into HeidiSQL's SSH tunnel connection lacked a message dialog which asked for caching a non-existing host key. This includes some more (error-)messages which can only be seen on the command line. HeidiSQL never displayed these messages, as it did not yet watch the stdInput, stdOutput and stdError pipes of the plink.exe process.

Now, with a completely rewritten interface to plink.exe, HeidiSQL displays all messages from the different I/O pipes on the Plink process. Even it creates cancelable confirmation dialogs out of various prompts on the Plink command line.



Bind parameters
Not yet finished but usable: Bind parameters for SQL queries. When your SQL query






  [Read more...]
Open Source Enigma Project
+0 Vote Up -0Vote Down

The wild and crazy guys over at S&T Geotronics, James Sanderson and Marc Tessier, have decided to go full tilt with a Kickstarter version of their DIY Open Enigma Project.  For those who missed the fanfare last year, they were featured on Instructables showing how to build an Arduino-based encryption machine that works exactly like a WWII era Enigma.  You know, the thing that

  [Read more...]
Repos and Distros: Upstream and Downstream
Employee_Team +6 Vote Up -0Vote Down
When we launched the official MySQL repos back in October, we wanted to achieve a number of things: First, we closed a gaping hole in our distribution on Linux. Some Linux distros do not ship all the MySQL products, and not everyone is able to or always wants to use the distro packages. And the […]
Hot Off The Press: MySQL February Newsletter
Employee_Team +6 Vote Up -1Vote Down

The MySQL February Newsletter is available! Find out the latest news on MySQL products and MySQL Connect 2014, and read the technical tips written by MySQL experts at Oracle and in the community. Below are the highlights in this edition:

  • Start Preparing for MySQL Connect 2014 Call for Papers
  • New GA Release: MySQL for Visual Studio
  • Blog: State of the UNION
  • Blog: New MySQL Web Installer -- Have You Tried It Yet?
  • Blog: MySQL Workbench: Frequent Crashes on Mac OS X? This Might Be The Fix
  • Event: MySQL Seminars Are Coming to a City Near You

You can read it online or

  [Read more...]
MySQL Workbench 6.1: Query Result Enhancements
Employee_Team +2 Vote Up -0Vote Down

The SQL Editor in MySQL Workbench 6.1 adds a new interface for query results.  This addition offers 4 new views to your query results, 2 for the result data itself and 2 for meta-information about the query that was executed.

Query Result Set Grid

The traditional result set grid. Run a SELECT query on a table with a primary key and you can edit the data. You must click the Edit button to enter edit mode.

Note: Until Workbench 6.1.1, the check was being done automatically for every SELECT query, but since that requires extra queries to MySQL, the check is now done on demand.

 

 

Result Set Form Editor

The new form

  [Read more...]
Giving Red Hat 7 Users a Choice
Employee_Team +5 Vote Up -0Vote Down
Red Hat recently released a beta of what will become the next version of their Enterprise Linux. As many people have noticed, Red Hat opted for a forked version of MySQL 5.5 (which GA’d 3 years ago). MySQL has come a long way in those three years, and MySQL 5.6 was released just under a […]
Amazon’s Big Data Suite – Part 2
+0 Vote Up -0Vote Down

 

In Part 1 we started our study of Amazon Services and looked at Amazon EC2. In this part, we will look at other Amazon services like EMR, DynamoDB and RDS.

 

  • 1.      Amazon Elastic Map Reduce
  • Amazon EMR is a web service which makes cloud computing very easy. Amazon’s EMR cluster comes preconfigured with Hadoop, which as mentioned earlier is a data processing and storage framework. This preconfiguration makes it very easy to start analysing your data in no time. Amazon EMR has applications in machine learning, financial analysis, bioinformatics etc.

     

    Just like EC2, you can launch any number of EMR instances as you need and you will only be charged for the computing power you have used.

      [Read more...]
    MySQL Repo News
    Employee_Team +4 Vote Up -0Vote Down
    What’s new in the MySQL Yum repositories A little over a month ago we launched the official MySQL Yum repository. An official repo was a long standing request from the community, and we’ve had it on our list of todos for a long time. We finally got it done, and in the process we modernized […]
    Introducing SeaLion – Linux Monitoring Tool
    +1 Vote Up -0Vote Down

    What is SeaLion?

    SeaLion is a Linux monitoring tool, built from the ground up for troubleshooting hundreds of servers.

    Why did we create SeaLion?

    We’ve another product line - CloudMagic which is a search centric email app. We manage petabytes of indexed user data spread across hundreds of servers. This data is hosted on AWS. Being a search centric email app, the search speed is critical. We take pride in being known for blazing fast search speeds. When a search query takes more than the threshold value, we get an alert and we debug.

    Typically, it’s important at this point to determine if the issue was with the hosting provider or in our

      [Read more...]
    Thanksgiving Offer – 20% off on all products
    +0 Vote Up -0Vote Down

    Thanksgiving is almost here. We would like to take this opportunity to thank all our users, customers, corporate clients and fans of SQLyog, MONyog for all the support over the years.

    We thought we’d get the festivities started a little early by offering a 20% flat discount on all Webyog products. Offer expires on November 27, 2013 at 23:59 PST. Grab the offer before it’s gone.

    Head right away to the Online Shop and apply

      [Read more...]
    Big Data Tools that You Need to Know About – Hadoop & NoSQL – Part 2
    +0 Vote Up -0Vote Down

     

    In the previous article we introduced Hadoop as the most popular Big Data toolset on the market today. We had just started talking about MapReduce as the major framework that makes Hadoop distinctive. So let’s continue the discussion where we left off.

     

    MapReduce is really the key to understanding Hadoop’s parallel processing functionality as it enables data in various formats (XML, text, binary, log, SQL, ect) to be divided up and mapped out to many computers nodes and then recombined back to produce a final data set.

     

      [Read more...]
    MySQL Workbench 6.0.8 Released
    Employee_Team +1 Vote Up -0Vote Down

    Dear MySQL users,

    The MySQL developer tools team at Oracle is excited to announce the availability of MySQL Workbench 6.0.8.

    MySQL Workbench 6.0 is the new version the GUI Development and Administration tool for MySQL. This maintenance release contains over 50 bug fixes since version 6.0.7

    Improvements in MySQL Workbench 6.0:

    • a new redesigned Home screen
    • the SQL Editor and Server Administration UIs were merged into a single connection specific interface, allowing for quick access to administration features while simplifying the location of specific features
    • improved model Synchronization, lets you compare and update your EER model or database with ALTER scripts and properly handle corner cases involving objects renamed externally or sync schemas with different names
    • improved support for model printing to PDF
      [Read more...]
    Big Data – What is it and Why is it Important – Part 4
    +0 Vote Up -0Vote Down

     

    In Part 3 of this series we found out that Big Data is a huge revenue generator for business that is expected to drive $232 billion in spending through 2016. In this installment we’ll continue to explore why Big Data must become a critical part of any business strategy in the 21st century.

     

    First, the Bad News

     

    Okay, so we get the notion of what Big Data is and why it’s important for business. So what can be done about it? The first point is to recognize your business strategy and needs as well as the limitations in your current infrastructure. Traditional organizational data warehouses are based on structured, well-organized data sets. Think Oracle,

      [Read more...]
    Missed Any of our Changes Over The Last Three Months?
    +0 Vote Up -0Vote Down

    Here at Monitis, we’re on a mission to not only build the best product but also, at the same time, make it more user-friendly. We listen to your feedback and suggestions and take various steps to improve our services, tools and features to make YOUR life easier. In any given week, you can see a new feature or update in your Monitis dashboard. Here’s some of the stuff we’ve added since our last newsletter, three months ago. Stay-up-to-date and see all that we have to offer by reading about all our changes below:

    (more…)

    MySQL Workbench 6.0.4 BETA 3 released
    Employee_Team +0 Vote Up -0Vote Down
    The MySQL Developer Tools team is pleased to announce the availability of the third beta release of MySQL Workbench 6.0. MySQL Workbench 6.0 is the new major update of the Development and Administration tool for MySQL. This release includes almost 200 bug fixes (~40 since 6.0.3), 30 new features and a new redesigned UI. As a beta, this release is not suitable for production use.  Please test and file your bug reports at http://bugs.mysql.com

    As always, MySQL Workbench is natively available on Windows, Mac, Linux.

    Improvements in MySQL Workbench 6.0:

    • a new redesigned Home screen
    • the SQL Editor and Server Administration UIs were merged into a single connection specific interface, allowing for quick access to administration features while simplifying the location of specific features
    • improved model
      [Read more...]
    MySQL Workbench 6.0: What’s New
    Employee_Team +0 Vote Up -0Vote Down

    With the first beta of MySQL Workbench 6.0 just released, we’ll go through the list of improvements we’ve made since 5.2.47

    New Home Screen

    The Home screen went through a renovation and now has a modernized look. As part of the SQL Editor and Administration GUI unification, there’s now a single list for MySQL connections. Recently opened model files and other major features are also accessible from it.

    You can organize different connections into “folders” by right clicking on a connection and selecting “Move to Group…” in the context menu.

    New server connections can be added by clicking the + button next to the MySQL Connections heading. By clicking the Configure Remote Management… button in the

      [Read more...]
    MySQL Workbench 6.0.2 BETA 1 released
    Employee_Team +1 Vote Up -0Vote Down
    The MySQL Developer Tools team is pleased to announce the availability of the first beta release of MySQL Workbench 6.0. MySQL Workbench 6.0 is the new major update of the Development and Administration tool for MySQL. This release includes over 100 bug fixes, 30 new features and a new redesigned UI. As a beta, this release is not suitable for production use.  Please test and file your bug reports at http://bugs.mysql.com

    As always, MySQL Workbench is natively available on Windows, Mac, Linux.

    Improvements in MySQL Workbench 6.0:

    • a new redesigned Home screen
    • the SQL Editor and Server Administration UIs were merged into a single connection specific interface, allowing for quick access to administration features while simplifying the location of specific features
    • improved model Synchronization, lets
      [Read more...]
    New feature: Display UNIX timestamps as date/time values
    +0 Vote Up -0Vote Down
    One of the best new ideas in my eyes came from quelbs. Using an integer column for storing UNIX timestamp values is a wide spread approach in the world of web development. For example in a Typo3 database, all date/time handling is done with UNIX timestamps. Unfortunately, for MySQL this is of course a normal integer value, with no meaning of being a date/time value.

    Now, HeidiSQL allows the user to explicitly set a column to "This is a UNIX timestamp" via right click menu. Once activated, integers are internally converted to and displayed as human readable date/time values. Editing such values also uses the inplace editor for date values.

    New feature: Display UNIX timestamps as date/time values
    +0 Vote Up -0Vote Down
    One of the best new ideas in my eyes came from quelbs. Using an integer column for storing UNIX timestamp values is a wide spread approach in the world of web development. For example in a Typo3 database, all date/time handling is done with UNIX timestamps. Unfortunately, for MySQL this is of course a normal integer value, with no meaning of being a date/time value.

    Now, HeidiSQL allows the user to explicitly set a column to "This is a UNIX timestamp" via right click menu. Once activated, integers are internally converted to and displayed as human readable date/time values. Editing such values also uses the inplace editor for date values.

    MySQL Workbench 6.0 – A Sneak Preview
    Employee_Team +1 Vote Up -0Vote Down

    The MySQL Workbench team has been a little quiet for the past few months, but that’s because we’ve been busy working on an exciting new version. Read more about it in Tomas’ blog

    Excluding queries from statistics
    +0 Vote Up -0Vote Down
    The latest update (v 3.0.9) includes a feature for excluding queries from statistics. To make Jet Profiler ignore certain queries, you need to edit the original query in the application code.

    Start the query with /*jp-ignore*/ (no spaces), for example "/*jp-ignore*/ SELECT ... FROM ..."

    This will prevent the query from showing up in Top Queries and the other tabs. The query will, however, still affect general preset statistics (such as number of threads running and threads busy). Also make sure that your mysql client library preserves comments - some libraries including the mysql command line client removes comments by default.


    Comments
    Jet Profiler 3 updates
    +0 Vote Up -0Vote Down
    New updates in Jet Profiler 3 include the following improvements:

    • Improved multiple instance handling.
    • Faster data retrieval.
    • New, more efficient MySQL JDBC driver from SkySQL / MariaDB.
    • Top Schemas is now available in the free version by default.
    • Faster startup time.
    • Bug fixes.

    To read the full changelog, click here.


    Comments
    Showing entries 1 to 30 of 274 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.