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

Displaying posts with tag: mysql (reset)

VLDB & MySQL in China
+2 Vote Up -0Vote Down
I am at VLDB in Hangzhou, China and spoke with clever people from academia, industrial research labs, industry and even web scale companies. A co-worker setup meetings with people who make MySQL better including Zhejiang University, Alibaba, Taobao & NetEase. We had another meeting with expert DBAs in Shanghai. These were interesting meetings.

There is a lot of great work done to make MySQL better at these companies. While I have been aware of this, I missed the extent of the effort -- both improvements made to MySQL and the complexity of the workload. I hope we can do more to engage these web-scale MySQL teams in the community. We all benefit by making MySQL better -- adding features, fixing bugs faster, explaining best practices. Engagement can mean speaking at conferences, blogging and sharing code (github, launchpad). Everyone

  [Read more...]
MySQL Workbench 6.2.2 RC has been released
Employee +1 Vote Up -0Vote Down

The MySQL developer tools team announces 6.2.2 RC – the final release candidate for MySQL Workbench 6.2.

MySQL Workbench 6.2 is the upcoming major update for the official MySQL 
graphical development tool .

MySQL Workbench 6.2 focuses on support for innovations released in MySQL 5.6  and MySQL 5.7
DMR (Development Release) as well as MySQL Fabric 1.5, with features such as:

  • A new spatial data viewer, allowing graphical views of result sets containing GEOMETRY data and
     taking advantage of the new GIS capabilities in MySQL 5.7.
  • Support for new MySQL 5.7.4 SQL syntax and configuration options.
  • Metadata Locks View shows the locks connections are blocked or waiting on.
  • MySQL Fabric cluster



  [Read more...]
Percona XtraDB Cluster 5.5.39-25.11 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the new release of Percona XtraDB Cluster 5.5 on September 5th 2014. Binaries are available from downloads area or from our software repositories.

Based on Percona Server 5.5.39-36.0 including all the bug fixes in it, Galera Replicator

  [Read more...]
Using MySQL 5.6 Global Transaction IDs (GTIDs) in production: Q&A
+1 Vote Up -0Vote Down

Thank you to all of you who attended my webinar last week about Global Transaction IDs (GTIDs), which were introduced in MySQL 5.6 to make the reconfiguration of replication straightforward. If you missed my webinar, you can still listen to the recording and download the sides (free). We had a lot of questions during the webinar, so let me try to answer them here. Please let me know in the comments if additional

  [Read more...]
Better Performance for JOINs Not Using Indexes
Employee_Team +1 Vote Up -0Vote Down

In some cases it is not possible to use an index to optimize a JOIN. This may for example happen when you query the Performance Schema. As a result these kind of queries can be very slow; however in MySQL 5.6 and later you can use a trick to improve the performance considerably.

As a working example in this post, I will use the schema_table_statistics view in the sys schema. Since the view involves the schema, I will create a reasonable large number of databases and tables for the test:

shell$ for ((i=0; i<100; i++)); do
>    echo "Database ${i}"
>    mysql -e "CREATE DATABASE db${i}"
>    for ((j=0; j<100; j++)); do
>        mysql -e "CREATE TABLE
  [Read more...]
Tracing down a problem, finding sloppy code
+0 Vote Up -0Vote Down

Daniel was tracking down what appeared to be a networking problem….

  • server reported 113 (No route to host)
  • However, an strace did not reveal the networking stack ever returning that.
  • On the other side, IP packets were actually received.
  • When confronted with mysteries like this, I get suspicious – mainly of (fellow) programmers.
  • I suggested a grep through the source code, which revealed  return -EHOSTUNREACH;
  • Mystery solved, which allowed us to find what was actually going on.

Lessons:

  • Don’t just believe or presume the supposed origin of an error.
  • Programmers often take shortcuts that cause grief later. I fully appreciate how the above code came about, but I still think it was wrong. Mapping a
  •   [Read more...]
    Replicating from MySQL to Amazon Redshift
    +0 Vote Up -1Vote Down
    Continuent is delighted to announce an exciting Continuent Tungsten feature addition for MySQL users: replication in real-time from MySQL into Amazon RedShift.   In this webinar-on-demand we survey Continuent Tungsten capabilities for data warehouse loading, then zero in on practical details of setting up replication from MySQL into RedShift.  We cover: Introduction to real-time movement
    Optimistic Backup
    Employee +2 Vote Up -0Vote Down
    Introduction 

    MySQL Enterprise Backup (MEB) is a highly efficient tool for taking backups of your MySQL databases. In the 3.11.0 release we are taking that one step further by introducing a new concept called "optimistic" backup. Optimistic backup leverages the patterns we saw frequently especially as related to very large databases.

    For backups the goals are:
    1 - Quality and Consistency - the backup and more importantly the restore just "works"
    2 - Size, time, and overhead - like in the game of golf - low score wins - for backups and for
         restores.
    3 - Flexibility – It’s not always one size fits all - whether how the backup is run, where it goes,
         how it is recovered.

    With optimistic backup - we look







      [Read more...]
    MySQL sys version 1.1.0 released
    Employee +2 Vote Up -0Vote Down

    I’ve just released the 1.1.0 version of the MySQL sys schema.

    This release is hugely pleasing to me, in that I actually didn’t have to do too much work on it myself! There were a significant number of contributions from Jesper Wisborg Krogh and Arnaud Adant, both MySQL Support Engineers (at the time at least, Arnaud has moved on to pastures new now), as well as again from Joe Grasse.

    Thank you all for your contributions!

    Here’s a summary of the changes:

    Improvements

    • Added host summary views, which have the same structure as the user summary views, but aggregated by host instead (Contributed by Arnaud Adant)
        [Read more...]
      MySQL 101: Monitor Disk I/O with pt-diskstats
      +1 Vote Up -0Vote Down

      Here on the Percona Support team we often ask customers to retrieve disk stats to monitor disk IO and to measure block devices iops and latency. There are a number of tools available to monitor IO on Linux. iostat is one of the popular tools and Percona Toolkit, which is free, contains the pt-diskstats tool for this purpose. The pt-diskstats tool is similar to iostat but

        [Read more...]
      10 Newer Entries Showing entries 31 to 40 of 16308 10 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.