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 65 Next 30 Older Entries

Displaying posts with tag: update (reset)

mylvmbackup 0.14 has been released
Employee +2 Vote Up -0Vote Down

It's my great pleasure to announce the release of mylvmbackup version 0.14.

This release includes a large number of improvements, code cleanups, and new functionality.

I would like to thank Ask Bjørn Hansen, Ben Bonnel, Norbert Tretkowski, Neil Wilson, Klaus Ethgen and Alexandre Anriot for their feedback and contributions to this release.

The release is available as a source tarball and generic RPM package. Packages for other distributions are available from the openSUSE Build Service.

Some notable highlights from the ChangeLog

  [Read more...]
May 2nd Webinar: Introduction to TokuDB v7 Community & Enterprise Editions
+0 Vote Up -0Vote Down

With this version, the source code is now freely available under the GPL License v2. For more details, see our blog here. Open source pioneer Mozilla has been using TokuDB to manage its MySQL-driven Datazilla Data cluster, an open-source system for managing and visualizing performance data.

Date: May 2nd
Time: 2 PM EST / 11 AM PST

In the past TokuDB has been free for evaluation; the new TokuDB Community Edition extends free use to deployed environments. With this release Tokutek is also planning on making available a TokuDB Enterprise Edition, which includes technical support,

  [Read more...]
Fast Updates with TokuDB
+4 Vote Up -0Vote Down

With TokuDB v6.6 out now, I’m excited to present one of my favorite enhancements: fast updates with TokuDB. Update intensive applications can have their throughput limited by the random read capacity of the storage system. The cause of the throughput limit is the read-modify-write algorithm that MySQL uses when processing update statements. MySQL reads a row from the storage engine, applies the updates to it, and then writes the new row to the storage engine. To address this throughput limit, TokuDB uses a different update algorithm that simply encodes the update expressions of the SQL statement into tiny programs that are stored in an update Fractal Tree® message. This update message is

  [Read more...]
The Results Are In!
+1 Vote Up -0Vote Down

We wanted to take a moment to say thanks to all of our customers and to the wider MySQL and MariaDB community. Today we announced a doubling of our customer base for the year ending December 31, 2012. Significant milestones over the last year included new technology and service partnerships, several awards, rapid hiring, as well as three upgrades to TokuDB®. We even dabbled in some MongoDB benchmarks. And to fuel continued growth in 2013, we secured additional venture capital funding last November.

Did You Hear? NASA Uses TokuDB for Big Data with MySQL!

To read the full press release and learn more,

  [Read more...]
TokuDB v6.0: Download Available
+2 Vote Up -0Vote Down

TokuDB v6.0 is full of great improvements, like getting rid of slave lag, better compression, improved checkpointing, and support for XA.

I’m happy to announce that TokuDB v6.0 is now generally available and can be downloaded here.

Sysbench Performance

I wanted to take this time to talk about one more under-the-hood goody we’ve added to v6.0. In

  [Read more...]
TokuDB v6.0: Frequent Checkpoints with No Performance Hit
+0 Vote Up -0Vote Down

Checkpointing — which involves periodically writing out dirty pages from memory — is central to the design of crash recovery for both TokuDB and InnoDB. A key issue in designing a checkpointing system is how often to checkpoint, and TokuDB takes a very different approach from InnoDB. How often and how much InnoDB checkpoints is complicated, but under certain workloads it can be relatively infrequent. In contrast, TokuDB runs a complete checkpoint starting one minute after the last one ended.

Frequent checkpoints make for fast recovery. Once MySQL crashes, the storage engine needs to replay the log to get back to a correct state. The length of the log is a function of the time since the last checkpoint for TokuDB and a more complicated function of the workload for InnoDB. And replaying the log is single threaded. So

  [Read more...]
TokuDB v6.0: Even Better Compression
+1 Vote Up -0Vote Down

A key feature of our new TokuDB v6.0 release, which I have been blogging about this week, is compression. Compression is always on in TokuDB, and the compression we’ve achieved in the past has been quite good. See a previous post on the 18x compression achieved by TokuDB v5.0 on one benchmark. In our latest release, we’ve updated the way compression works and got 50% improvement on compression.

I decided to present numbers on the same set of data as the old post, so see that post for experimental details.

But first, what are the changes? TokuDB compresses large blocks

  [Read more...]
Evidenzia Upgrades to TokuDB v5.2 to Address Storage Growth and Scale Performance
+2 Vote Up -0Vote Down

Ensuring sufficient disk I/O to catch copyright violations at network speed.

Evidenzia GmbH & Co. KG

Issues addressed:

  • Storage growth, including maxed-out disk I/O utilization
  • Performance issues and business impact due to slow selects
  • Inability to revise data schema on the fly

The Company: Evidenzia GmbH & Co. KG is one of the leading partners of the software, movie and music industry when it comes to tracing copyright infringements

  [Read more...]
1 Billion Insertions – The Wait is Over!
+4 Vote Up -0Vote Down

iiBench measures the rate at which a database can insert new rows while maintaining several secondary indexes. We ran this for 1 billion rows with TokuDB and InnoDB starting last week, right after we launched TokuDB v5.2. While TokuDB completed it in 15 hours, InnoDB took 7 days.

The results are shown below. At the end of the test, TokuDB’s insertion rate remained at 17,028 inserts/second whereas InnoDB had dropped to 1,050 inserts/second. That is a difference of over 16x. Our complete set of benchmarks for TokuDB v5.2 can be found here.

  [Read more...]
Upgrading Tungsten Replicator: as easy as ...
+3 Vote Up -0Vote Down
When I talked about the usability improvements of Tungsten Replicator, I did not mention the procedure for upgrading. I was reminded about it by a question in the TR mailing list, and since the question was very relevant, I updated the Tungsten Cookbook with some quick upgrading instructions. A quick upgrading procedure is as important as the installer. Since we release software quite often, either because we have scheduled features to release or because of bug fixes, users want to apply a new release to an existing installation without much fuss. You can do the upgrade with a very quick and painless procedure. Let's suppose that you have installed one Tungsten Replicator cluster using this command:

# using

  [Read more...]
Dude, Where’s my Fractal Tree?
+2 Vote Up -1Vote Down

Unless you are Ashton Kutcher (@aplusk), or one of his Hollywood buddies, you don’t need to read any further. Allow me to explain…

Over the weekend, we launched our new website. This type of announcement used to be interesting in the high-tech world. I heard Kara Swisher of the WSJ’s All things D speak at a MassTLC event in May.  She admitted back in the 1990s, when the web was just getting into high gear, that a new website from an interesting company might actually get some coverage. Not anymore.

I’ve also been told at all the SEO classes I’ve taken

  [Read more...]
Pitfalls of monitoring MySQL table activity with stored routines
+3 Vote Up -0Vote Down
A friend of mine needed a quick method to monitor a table that was frequently updated. There were several procedures writing to the table several times per second. He needed a quick way of determining how many updates per second the table was getting.
The table has only one row, which includes a counter that is increased at each operation. Therefore, the simple plan was:
  • Let's get the counter from the table;
  • Allow N seconds to pass;
  • Get the counter again;
  • The difference between the second counter and the first counter, divided by the number of seconds gives the updates per second.
  • The plan makes sense, and if you run the above

      [Read more...]
    Updated Drupal 7 appliances to version 7.0 final
    Employee +4 Vote Up -0Vote Down

    Congratulations to the Drupal community for getting version 7.0 released! This is a major mile stone and an excellent reason to celebrate!

    If you want to give Drupal 7 a try without having to install anything, I've now updated my Drupal 7 appliances on SuSE Studio to the latest release. The appliance is based on openSUSE Linux 11.3 and is available in two variants:

    • A text-mode only appliance to which you connect using your local web browser via the network.
    • A GUI version that starts

      [Read more...]
    MySQL 5.5: CMake replaces autoconf/automake on all platforms, support for autotools has now been removed
    Employee +6 Vote Up -0Vote Down

    There has been a lot of buzz about the MySQL 5.5 GA release and its new features and other user-visible improvements. In this blog post, I'd like to touch on a less noticeable, but still important change.

    CMake has already been used to build the MySQL Server on Windows for a long time, while the GNU autotools were used on all other platforms. Since MySQL 5.5, all builds on all platforms are now performed using the same tool chain. With the latest release of MySQL 5.5, we've made

      [Read more...]
    Update on “A Tale Of a Bug”
    +1 Vote Up -0Vote Down

    The bug I talked about a little while ago has now also had the fix I wrote committed to the mysql-trunk 5.5.6-m3 repository.

      [Read more...]
    OpenSQL Camp Europe: Time to cast your votes!
    Employee +2 Vote Up -0Vote Down

    If you wonder why there hasn't been an update from me for quite a while — I just returned from two months of paternal leave, in which I actually managed to stay away from the PC most of the time. In the meanwhile, I've officially become an Oracle employee and there is a lot of administrative things to take care of... But it feels good to be back!

    During my absence, Giuseppe and Felix kicked off the Call for Papers for this year's European OpenSQL Camp, which will again take place in parallel to FrOSCon in St. Augustin (Germany) on August

      [Read more...]
    Making “Replace Into” Fast, by Avoiding Disk Seeks
    +0 Vote Up -1Vote Down

    In this post two weeks ago, I explained why the semantics of normal ad-hoc insertions with a primary key are expensive because they require disk seeks on large data sets. Towards the end of the post, I claimed that it would be better to use “replace into” or “insert ignore” over normal inserts, because the semantics of these statements do NOT require disk seeks. In this post, I explain how the command “replace into” can be fast with fractal trees.

    The semantics of “replace into” are as follows:

    • if the primary (or unique) key does not exist, insert the new row
    • if the primary (or unique) key does exist, overwrite the existing row with the new row

    The slow, expensive way

      [Read more...]
    Making Updates Fast, by Avoiding Disk Seeks
    +1 Vote Up -0Vote Down

    The analysis that shows how to make deletions really fast by using clustering keys and TokuDB’s fractal tree based engine also applies to make updates really fast. (I left it out of the last post to keep the story simple). As a quick example, let’s look at the following statement:

    update foo set price=price+1 where product=toy;

    Executing this statement has two steps:

    • a query to find where product=toy
    • a combination of insertions and deletions to change old rows to new rows

    The analysis is identical to that for deletions. Just like for

      [Read more...]
    Install MariaDB on RedHat 5.4
    +0 Vote Up -0Vote Down


    Is MariaDB really a drop in replacement for MySQL?   I’m running CentOS 5.4.  What happens if…

  • Use “mysqldump –all-databases > FullBackup.sql” to make a full backup. (Better safe then sorry)
  • Go to http://askmonty.org/wiki/MariaDB:Download and download the CentOS 5 packages.
  • Stop msql “service mysqld stop”
  • Pull MySQL out by the roots with “rpm -e mysql-server mysql –nodeps”
  • Install Maria with “rpm -i Maria-*”
  • And the install start mysql up again.  Wow.  That’s “Drop in”.

    If your

      [Read more...]
    More MySQL releases
    Employee +5 Vote Up -0Vote Down

    Shortly after I posted my last summary of MySQL releases, our son Mats was born and I went on a 2.5-week vacation. Our developers did not rest in the meanwhile and I'd like to give you a quick update of what's new since then:

    MySQL Connector/Net 6.3.0

    • Visual Studio 2010 RC support
    • Nested transaction scope support

    MySQL Workbench 5.2.16 Beta 6

    • Fixed 67 bugs
    • Saving your profile/connection passwords in OSX keychain, gnome-keyring or in an encrypted password-vault-file.
    • New rapid development features for generating complete SQL
      [Read more...]
    A new MySQL Milestone Release (5.5.0-M2) has been published
    Employee_Team +8 Vote Up -0Vote Down

    Following our new Milestone-based release model, we've now published MySQL 5.5.0-M2. Please see the "What's New in MySQL 5.5" section of the reference manual for a summary of the most notable changes. The MySQL 5.5.0 Changelog provides a much more detailed list of changes, bug fixes and improvements.

    Highlights in this release include:

    The InnoDB plugin (currently at version 1.0.5) replaces the built-in InnoDB storage engine. This version includes a number of important performance improvements,

      [Read more...]
    mylvmbackup 0.13 has been released
    Employee +4 Vote Up -0Vote Down

    I am happy to announce that mylvmbackup version 0.13 has now been released. This release includes a fix for a nasty bug in on of the recently added Perl hooks (precleanup.pm) and some added functionality (better support for remote rsync backups).

    From the ChangeLog: 

    • Deleted sample precleanup.pm hook as it has potential to cause harm and is too specialized on a particular use case (BUG#394668)
    • Added support for rsync via SSH (BUG#392462)
    • Fixed InnoDB recovery in case a relative path to the MySQL data directory is defined (BUG#38337), improved the documentation of relpath in the man page.


    More MySQL connectors
    Employee +1 Vote Up -0Vote Down

    Some time ago I posted a compilation of applications and programming languages that provide an API to connect to the MySQL Server (http://mysql.com/). As it turned out, I forgot a few that I would like to mention here:

    • Apache DBD API: a MySQL driver for mod_apr_dbd is not included in the official distribution, but can be obtained seperately from here. Some distributions (e.g. openSUSE) actually provide installable packages of this driver module.
    • GRASS MySQL driver
      [Read more...]
    Updated MySQL 5.1.35-GIS snapshot binaries are now available
    Employee +5 Vote Up -0Vote Down

    We've now published a new set of binary packages including the extended GIS functionality from the mysql-5.1-wl1326 source tree.

    This release is based on the MySQL 5.1.35 code base and fixes the bugs mentioned below. It includes some improvements to the GIS functionality as well, so please use these packages for future testing of the MySQL GIS functionality.

    The following GIS-related bugs were fixed in this version:

    • Bug#31753: Buffer/area functions only return first row of set
    • Bug#32032: Contains() does not work on MultiPolygons, may force a disconnect and/or result in extremely long query times.
    • Bug#32100: contains,

      [Read more...]
    Embedded InnoDB RPM packages
    Employee +1 Vote Up -0Vote Down

    Shortly after I created the initial packages of embedded InnoDB on the OpenSUSE Build Service, Oracle/Innobase released an updated version ( In addition to many improvements and bug fixes, they slightly changed the versioning scheme to better indicate what version of the InnodDB plugin their code is based on (see Vasil's posting on the InnoDB Forums for more information).

    I've now updated my InnoDB packages on the Build Service to this version as well - please note that the naming scheme of the shared library

      [Read more...]
    mylvmbackup-0.12 has been released
    Employee +2 Vote Up -0Vote Down

    After a long hiatus, I am happy to announce that mylvmbackup version 0.12 has now been released. This release includes a large number of improvements, minor code cleanups, as well as some new functionality. In particular, I would like to thank Matthew Boehm, Tim Stoop, Baron Schwartz, Ville Skyttä and Ronald Bradford for their contributions.

    Some notable highlights from the ChangeLog:

    • Removed the absolute path names to external tools (make sure $PATH is correct)
    • Added --log-err to the startup options of the recovery instance to avoid cluttering the server's error log
    • Added support for hooks written as Perl Modules. (Matthew Boehm)
    • Added support for date/time-formatted path names for backupdir and mountdir (Matthew Boehm)

      [Read more...]
    xtrabackup 0.7 RPMs available on the openSUSE Build Service
    Employee +1 Vote Up -0Vote Down

    XtraBackup is an Open Source online (non-blockable) backup solution for the InnoDB and XtraDB storage engines. It works with both MySQL 5.0 and 5.1 (and possibly 5.4 as well) and is distributed under the GPLv2.

    Some weeks ago Vadim announced the availability of xtrabackup-0.7, stating that they consider it stable enough now to label this version a "Release Candidate". I've been maintaining RPM packages of xtrabackup on the fine openSUSE Build Service for quite some time now, RPMs of 0.7 for a number of distributions are now

      [Read more...]
    MySQL University session about the new MySQL release model
    Employee +1 Vote Up -0Vote Down

    As you may have heard, we're switching to a new release model with the upcoming MySQL 5.4 release.

    If you are curious to learn more about what will change in the way in which future versions MySQL will be developed and released, make sure to attend our next MySQL University session about The New MySQL Release Model on Thursday, 11th of June, 14:00 UTC. Tomas Ulin, our director of MySQL server development will go through the planned changes and would also like to get

      [Read more...]
    [MySQL] Deleting/Updating Rows Common To 2 Tables – Speed And Slave Lag Considerations
    +1 Vote Up -0Vote Down


    A question I recently saw on Stack Overflow titled Faster way to delete matching [database] rows? prompted me to organize my thoughts and observations on the subject and quickly jot them down here.

    Here is the brief description of the task: say, you have 2 MySQL tables a and b. The tables contain the same type of data, for example log entries. Now you want to delete all or a subset of the entries in table a that exist in table b.

    Solutions Suggested By Others

    DELETE a FROM a INNER JOIN b on a.id=b.id;

    The Problem With  [Read more...]

    New alpha release of MySQL Connector/C++
    Employee +0 Vote Up -0Vote Down

    Version 1.0.3-alpha of the MySQL Connector/C++ has just been announced by Lawrin Novitsky and is now available for download. This driver is licensed under the GPL and is a new implementation of the MySQL Client/Server protocol. Instead of wrapping the C API calls in C++ methods, the implementation mimics the JDBC API, which hopefully feels much more "native" to a seasoned C++ developer.

    The driver has been ported to a wide range of platforms and is about to hit the beta test phase. So if you're writing a C++ application that needs to connect to a MySQL Server, give it a try! The developers are always looking for

      [Read more...]
    Showing entries 1 to 30 of 65 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.