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 91 to 120 of 32909 Next 30 Older Entries
Q&A: Putting MySQL Fabric to use
+1 Vote Up -0Vote Down

Martin Arrieta and I gave an online presentation last week on “Putting MySQL Fabric To Use.” If you missed it, you can find a recording and the slides here, and the vagrant environment we used plus a transcript of the commands we ran here (be sure to check out the ‘sharding’ branch, as that’s what we used during the webinar).

Thank you all for attending and asking interesting questions. We were unable to answer all of them in the scheduled time, so here are our replies

  [Read more...]
MySQL Fabric/MySQL Utilities 1.4.4 released
Employee +2 Vote Up -0Vote Down

The binary and source versions of MySQL Utilities/MySQL Fabric have now been made available at http://dev.mysql.com/downloads/utilities/.

This release contains bug fixes and minor enhancements – full details can be found in the MySQL Fabric/MySQL Utilities release notes.

Advanced MySQL Query Tuning (Aug. 6) and MySQL 5.6 Performance Schema (Aug. 13) webinars
+0 Vote Up -0Vote Down

I will be presenting two webinars in August:

This Wednesday’s webinar on advanced MySQL query tuning will be focused on tuning the “usual suspects”: queries with “Group By”, “Order By” and subqueries; those query types are usually perform bad in MySQL and add an additional load as MySQL may need to create a temporary table(s) or perform a filesort.

  [Read more...]
Upgrading MySQL 5.1 to MariaDB 10.0 on CentOS 6
+0 Vote Up -0Vote Down
Mon, 2014-08-04 13:00benstillman

Today we're going to cover how to upgrade MySQL 5.1 to MariaDB 10 on Centos 6 in place. This tutorial is a general outline, and the steps were performed on an out-of-the-box install of MySQL 5.1. Do be careful to check your configuration file(s) when completed.

Information on variables and other changes:
http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html
http://dev.mysql.com/doc/refman/5.6/en/upgrading-from-previous-series.html



  [Read more...]
What is HandlerSocket? And why would you use it? Part 1
+0 Vote Up -0Vote Down
HandlerSocket is included with MariaDB and acts like a simple NoSQL interface to InnoDB, XtraDB and Spider and I will describe it a bit more in this and a few upcoming blogs.

So, what is HandlerSocket? Adam Donnison wrote a great blog on how to get started with it, but if you are developing MariaDB applications using C, C++, PHP or Java what good does HandlerSocket do you?

HandlerSocket in itself is a MariaDB plugin, of a type that is not that common as is is a daemon plugin. Adam shows in his blog how to enable it and install it, so I will not cover that here. Instead I will describe what it does, and doesn't do.

A daemon plugin is a process that runs





  [Read more...]
Handling Error Messages and Warnings with MySQL
Employee_Team +1 Vote Up -0Vote Down

To ensure that your MySQL Database works as efficiently as possible, it is important to know how to handle error messages and warnings.

Error messages have three components:

  • A MySQL-specific error code, such as 1146
  • A SQLSTATE error code. These codes are defined by standard SQL and the ODBC standard.
  • A text message that describes the problem

MySQL Server generates a warning when it is not fully able to comply with a request or when an action has possibly unintended side effects. You can display these warnings with the SHOW WARNINGS statement.

To learn about handling error messages and warnings along with other developer topics, consider taking the

  [Read more...]
Recover Corrupt MySQL Database
+2 Vote Up -0Vote Down

The unDROP for InnoDB tool can used to recover corrupt MySQL database. In this post we will show how to repair MySQL database if its files became corrupted and even innodb_force_recovery=6 doesn’t help.

The corruption of InnoDB tablespace may be caused by many reasons. A dying hard drive can write garbage, thus page checksum will be wrong. InnoDB then reports to the error log:

InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 4.

MySQL is well know for poor start-up script. A simple upgrade procedure may end up with two mysqld processes writing

  [Read more...]
Sessions Restore in dbForge Query Builder for MySQL, v3.2!
+0 Vote Up -0Vote Down

We are glad to announce that the range of supported servers in Devart dbForge products continues expanding. Now dbForge Query Builder for MySQL, v3.2 supports Percona server and still gives you great opportunities in building queries visually.

Sessions Restore in dbForge Query Builder for MySQL, v3.2!
+0 Vote Up -0Vote Down

We are glad to announce that the range of supported servers in Devart dbForge products continues expanding. Now dbForge Query Builder for MySQL, v3.2 supports Percona server and still gives you great opportunities in building queries visually.

MariaDB and Stored Procedures: errata & repository
+1 Vote Up -0Vote Down

In the article How MariaDB makes Stored Procedures usable I explained how to use the MariaDB CONNECT Storage Engine to workaround Stored Procedures limitations. Please read that article, if you didn’t, for details.

Since the technique to workaround such limitations is verbose and error-proof, I also proposed a procedure which makes it easy and convenient. Even thought this is a simple country blog, I have immediately received positive feedback after that article. But then, people started to write me: “Hey, doesn’t work!”. The reason is… MariaDB/MySQL bugs. While investigating these problems, I was able to report

  [Read more...]
DBD::mysql 4.028 Released
+1 Vote Up -0Vote Down

Dear Perl and MySQL community,

I'm pleased to announce the release of DBD::mysql 4.028. This release includes several fixes, per change log:

  • Fixed bug in mysql.xs where dbh was being used as error code
  • RT #97570: fix wrong salloc free in mysql_st_internal_execute - (Reini Urban, cPanel)
  • Fix RT #97625 use-after-free in mysql_dr_error, and #86153 - (Reini Urban, cPanel)
  • find mysql.h for MariaDB on Win32 (Graham Ollis)
  • Update mysql.pm to work with ipv6 and ipv4 addresses (katyavoid)

I want to thank Reini Urban, Graham Ollis, and Katyavoid for their pull requests and contributions to DBD::mysql!

Please feel free to visit:

CPAN DBD-mysql-4.028

And as always:

Github repo

Troubleshooting TokuDB Corruption
+1 Vote Up -0Vote Down

I recently ran across some TokuDB table corruption, which was not easily identifiable at first, and the error log entry was not too verbose either, so I wanted to share that experience here.

Basically, TokuDB crashed, and then mysqld had problems restarting afterward. Just for reference, the error log had the following in the stack trace:

/usr/lib64/mysql/plugin/ha_tokudb.so(+0x71c48)[0x7fb25be75c48]
/usr/lib64/mysql/plugin/ha_tokudb.so(+0x71cbd)[0x7fb25be75cbd]
/usr/lib64/mysql/plugin/ha_tokudb.so(_Z29toku_deserialize_bp_from_disk...
/usr/lib64/mysql/plugin/ha_tokudb.so(_Z23toku_ftnode_pf_callback...
/usr/lib64/mysql/plugin/ha_tokudb.so(_Z30toku_cachetable_pf_pinned_pair..
/usr/lib64/mysql/plugin/ha_tokudb.so(_Z24toku_ft_flush_some_child...
/usr/lib64/mysql/plugin/ha_tokudb.so(_Z28toku_ftnode_cleaner_callback...
  [Read more...]
Troubleshooting TokuDB ERROR 1126 – API Version Mismatch or bitmap_free
+1 Vote Up -0Vote Down

When setting up TokuDB, you may encounter error 1126.

I’ve seen 2 recent invocations of it, so I wanted to share them both here in case you run into this issue:

MariaDB [(none)]> install soname 'ha_tokudb';
ERROR 1126 (HY000): Can't open shared library
'/usr/lib/mysql/plugin/ha_tokudb.so' (errno: 2, undefined symbol: bitmap_free)
MariaDB [(none)]> install soname 'ha_tokudb';
ERROR 1126 (HY000): Can't open shared library 'ha_tokudb.so'
(errno: 8, API version for STORAGE ENGINE plugin TokuDB not
supported by this version of the server)

The latter is a bit more descriptive, but the former is fairly cryptic.

Given the latter, as you may have guessed it, if you run into either of these, you have the wrong version of ha_tokudb.so in your plugin directory – that is, it is not the correct version

  [Read more...]
Disabling Transparent Hugepages for TokuDB
+0 Vote Up -0Vote Down

If you want to use TokuDB with MariaDB, MySQL, or Percona Server, you will need to disable support for transparent hugepages in Linux.

Fortunately, this is very easy to check, and to change.

An easy way to check is with:

cat /sys/kernel/mm/transparent_hugepage/enabled

This will return something like:

[always] madvise never

Note the word surrounded by “[]” is what this option is set to. So the above is set to “always”. To disable it, we want it set to “never”.

I’ve found the easiest way to change/set this is to add the below to your /etc/rc.local file (and then reboot your system):

if test -f /sys/kernel/mm/transparent_hugepage/enabled; then
   echo never >
  [Read more...]
Enabling TokuDB in MariaDB is a Breeze
+0 Vote Up -0Vote Down

TokuDB is gaining more and more popularity and many people are finding it very helpful for certain cases.

Using/enabling it in some distributions can be quite a pain, but enabling it in MariaDB is easy as 1-2-…, well, only 1-2, since that’s all there is to it!

1. Ensure you have the correct MariaDB version:

  • MariaDB 5.5.36+
  • MariaDB 10.0.9+
  • Note: Linux 64-bit systems only – specific packages include: Ubuntu, Debian, Fedora, CentOS, Red Hat
  • Note: If using the Linux tarball – it must be the version built with glibc 2.14+

2. Run this command:

INSTALL SONAME 'ha_tokudb';

or update my.cnf file with:

[mysqld]
plugin-load=ha_tokudb

There is one requirement from

  [Read more...]
Upgrade MySQL to a new version with a fresh installation & use shell scripts and mysqldump to reload your data
+0 Vote Up -0Vote Down

There are several ways to upgrade MySQL (http://mysql.com). In this post, we will use a combination of shell scripts and the mysqldump application to export our MySQL (http://mysql.com) data, and then re-import it back into the upgraded version of MySQL (http://mysql.com).

In this example, we will be doing a minor version upgrade. We will be going from 5.6.17 to 5.6.19. This method may not work if you are upgrading from one major release to another – from 5.1 to 5.5, or 5.5 to 5.6. You will want to check each version and review the new features/functions and also what features/functions have been deprecated. We are also assuming that no one will be using the database during the time it takes

  [Read more...]
MySQL 5.5.39 Overview and Highlights
+1 Vote Up -0Vote Down

MySQL 5.5.39 was recently released (it is the latest MySQL 5.5, is GA), and is available for download here:

http://downloads.skysql.com/archive/index/p/mysql/v/5.5.39

This release, similar to the last 5.5 release, is mostly uneventful.

There were two “Functionality Added or Changed” and 24 bugs fixed.

The “Functionality Added or Changed” changes are:

  • CMake support was updated to handle CMake version 3.
  • The timed_mutexes system variable has no effect and is deprecated.

Out of the 24 bugs, most seemed rather minor or obscure, but here are the ones I think are worth noting (crashing, security, wrong results, deadlock):

  • InnoDB: Opening a parent table that has thousands of child tables could
  [Read more...]
New! MySQL Utilities release-1.4.4 GA
Employee_Team +0 Vote Up -0Vote Down

The MySQL Utilities Team is pleased to announce the latest GA release of MySQL Utilities, release-1.4.4. This release includes improvements in terms of usability, stability, security and an overall improvement regarding the comprehensibility of the provided error messages.

Improvements

The following highlights a few of the more significant improvements.

  • mysqlrpladmin errant transactions for switchover have been improved. Note : The errant transactions check requires all servers in the topology to have GTID’s enabled.
  • Failed MySQL server connection error messages now display the actual error returned from the failed connection.
  • Error messages that occur during automatic slave discovery (–discover-slaves-login) have been improved. Now the –verbose option generates specific information for each slave, including their
  [Read more...]
OurSQL Episode 195: Common Schema, part 5
+0 Vote Up -0Vote Down
PodcastsGeneral

This week we complete our series on Common Schema by talking about QueryScript. Special guest co-host Jon Day of SkySQL joins us. Ear Candy is some MySQL security tips and At the Movies is a humorous look at value chain mapping.

MySQL Connector/Python on GitHub
Employee +1 Vote Up -0Vote Down

Last week we released Connector/Python v2.0 (alpha); today we publish the source on GitHub. Yes, we are using Git internally and are now able to push it out on each release. Previous versions are still available through LaunchPad.

Here is the full process to get Connector/Python installed in a virtual environment. You’ll need Git installed of course.

shell> git clone https://github.com/oracle/mysql-connector-python.git cpy
shell> virtualenv ENVCPY
shell> source ENVCPY/bin/activate
(ENVCPY)shell> cd cpy
(ENVCPY)shell> python setup.py install
(ENVCPY)shell> python
>>> import
  [Read more...]
Basic Windows MySQL Installation Without Installer
Employee_Team +2 Vote Up -0Vote Down
It dawned on me that most folks are using the Installer these days.

As I need quick access to every MySQL version,  using an Installer is never an option.
And for folks wanting 100% control over their setups, they may not want an installer doing things.

So this shows how to setup an instance manually.
  • download non-installer .zip version from dev.mysql.com
  • create a directory c:\mysql and c:\mysql\tmp
  • unzip the .zip into c:\mysql
  • move the data directory into c:\mysql for easier future upgrades
  • create a basic my.ini
  • install the service
  • start the service


  • Here I'll show each step with more detail.   I purposely leave out things like post-installation security, to keep it simple.

    1.  Create a directory.

    Decide where you will put the installation and








      [Read more...]
    Paris OpenStack Summit Voting – Percona Submits 16 MySQL Talks
    +1 Vote Up -0Vote Down

    MySQL plays a critical role in OpenStack. It serves as the host database supporting most components such as Nova, Glance, and Keystone and is the most mature guest database in Trove. Many OpenStack operators use Percona open source software including the MySQL drop-in compatible Percona Server and Galera-based Percona XtraDB Cluster as well as tools such as Percona XtraBackup and 

      [Read more...]
    MariaDB: Selective binary logs events
    +0 Vote Up -0Vote Down

    In the first post in a series on MariaDB features we find interesting, we begin with selectively skipping replication of binlog events. This feature is available on MariaDB 5.5 and 10.

    By default when using MySQL’s standard replication, all events are logged in the binary log and those binary log events are replicated to all slaves (it’s possible to filter out some schema). But with this feature, it’s also possible to bypass some events to be replicated on the slave(s) even if they are written in the binary log. Having those event in the binary logs is always useful for point-in-time recovery.

    Indeed, usually when we need to not replicate an

      [Read more...]
    Percona Server 5.1.73-14.12 is now available
    +1 Vote Up -0Vote Down

    Percona Server version 5.1.73-14.12

    Percona is glad to announce the release of Percona Server 5.1.73-14.12 on July 31st, 2014 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.73, including all the bug fixes in it, Percona Server 5.1.73-14.12 is now the current stable release in

      [Read more...]
    Testing MySQL repository packages: how we make sure they work for you
    Employee_Team +2 Vote Up -0Vote Down
    Around nine months ago, we launched the MySQL yum repositories for Enterprise Linux and Fedora, followed by apt repos for Debian and Ubuntu back in May. We’re extremely happy that the repos have proved to be a big hit with the community: the monthly number of downloads hit 100K recently and it is still growing […]
    Testing that all projects need
    +1 Vote Up -0Vote Down

    Today, I was reminded of a Jim Starkey quote on the Random Query Generator:

    “The Colonoscopy of Database Software”
    - Jim Starkey

    If your project does not have something that you can adapt that quote to, odds are your testing is inadequate.

    MySQL Community Server 5.5
    +12 Vote Up -1Vote Down
    MySQL Community Server 5.5 (5.5.39 GA, published on Thursday, 31 Jul 2014)
    MySQL Community Server 5.6
    +17 Vote Up -0Vote Down
    MySQL Community Server 5.6 (5.6.20 GA, published on Thursday, 31 Jul 2014)
    Connector/C++ 1.1
    +2 Vote Up -0Vote Down
    Connector/C++ 1.1 (1.1.4 GA, published on Thursday, 31 Jul 2014)
    MySQL Installer 5.5
    +1 Vote Up -0Vote Down
    MySQL Installer 5.5 (5.5.39 GA, published on Thursday, 31 Jul 2014)
    Previous 30 Newer Entries Showing entries 91 to 120 of 32909 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.