We are pleased to announce that MySQL Enterprise Monitor 3.0.14 is now available for download on the My Oracle Support (MOS) web site. It will also be available via the Oracle Software Delivery Cloud in a few weeks. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log.

You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet.

You will also find the binaries on the Oracle Software Delivery Cloud in a few weeks. Choose "MySQL Database" as the Product Pack and you will …

MySQL Enterprise Backup team is glad to announce the new release of MySQL Enterprise Backup (MEB) 3.11.0.

Overview

MEB 3.11.0 focuses on enhancing backup/recovery performance and adding new features that would help database administrators.

This release addresses some of the challenges customers face today while taking backups of very large databases(in terrabytes). This release also provides more complete backup with all the necessary logs required to clone a server. We have also added online restore of tables in 3.11.0 to help DBAs fix corrupted tables in the server from existing backups.

MEB 3.11.0 also brings in cloud support for backup and restore. To meet the growing trend of cloud storage, we released this feature in July '14 as part of  MEB 3.10.2 release.

Please refer to this blog on …

Given the recent excitement & interest around OpenStack I wanted to make sure I was ready to conduct appropriate evaluations of system performance.  I generally turn to sysbench since it comes with a variety of different tests (accessed via –test= option interface), including:

• fileio – File I/O test
• cpu – CPU performance test
• memory – Memory functions speed test
• threads – Threads subsystem performance test
• mutex – Mutex performance test

As you can see, sysbench lets you stress many of the fundamental components of your hardware and infrastructure, such as your disk subsystem, along with your CPUs and memory. An additional option exists that is designed to perform synthetic stress testing of MySQL, and I was surprised when I didn’t see it in the above list on version 0.5, as it used to show up as “oltp – OLTP test”. What happened to –test=oltp …

Tue, 2014-09-02 12:00svetoslavsavov

When you need a fast and reliable hosting solution, you should consider which web server and database system to use. Many sites find the combination of nginx (pronounced "engine x") and MariaDB to be an optimal solution. Let's see how to install and configure the applications to work together.

Nginx is a stable, lightweight, and fast open source web server. Nowadays it is the second most popular web server overall, after Apache. More and more system architects are installing it on their servers to support heavy resource demands and efficiently handle the traffic volume at popular web sites. Nginx can also serve as a reverse proxy service in front of Apache, and handle load-balancing.

For its part, MariaDB is a fast and a reliable database engine. Though it is a binary drop-in replacement …

很久之前看过这个帖子,当时没有细究,这几天看了下mysql相关的internal 突然想起这个问题,跟三四个朋友讨论了下 想把这个问题展开讲一讲。

源帖子内容见：https://community.oracle.com/thread/1087650?start=0&tstart=0

这个帖子的内容为一个老外问oracle如何避免partial write的,也就是大家所说的半个IO问题,IO 在写到一半的时候发生断裂,（瞬间断线,瞬间crash瞬间存储或者机器故障等） 虽然这个情况极少发生,但是在非常规恢复的时候也是经常遇到的,例如某个block内部出现不一致,也就是我们所谓的逻辑坏块。
我仔细的又过了一遍帖子,发现下面的几个回答完全不准确,或者有点张冠李戴的意思。

首先我们看看什么是mysql 的double write:

—–引自 …

#DBHangOps 09/04/14 -- R-Tree Indexes, DBAs and Networking, and more!

All set for this week. Check out the recording below:

Hello everybody!

Join in #DBHangOps this Thursday, September, 04, 2014 at 11:00am pacific (18:00 GMT), to participate in the discussion about:

• R-Tree index overview from Matt Lord
• Index Fragmentation (requested by Shlomi)
• What should a DBA know about networking?

Be sure to check out the #DBHangOps twitter search, the @DBHangOps twitter feed, or this blog post to get a link for the google hangout on Thursday!

See all of you on Thursday!

Show notes

Index Fragmentation

• How do you handle index fragmentation? Should it handled …

As MySQL 5.6 now enables the SQL Mode STRICT_TRANS_TABLES for new installations, I have been running into users who have been upgrading from previous versions, and not quite sure how to test their application for compatibility with this new default.

For some applications converting warnings to errors presents an unknown-unknown, in that the operators of the system can not easily detect what may break. Certainly many deployments will have QA environments, but there is always some fear production queries are just a little bit different.

Since sql_mode is configurable on a per-session basis, there are some strategies that I have been recommending to ease transition:

• Whitelist: Have all new application components enable strict mode by default. For example, if you are building a set of cron jobs to rebuild caches of data …

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

Based on Percona Server 5.6.20-68.0 including all the bug fixes in it, Galera Replicator 3.7, and on …

Recently we faced an issue when Nagios reported significant amount of “Locked” queries.
To investigate and debug the issue we needed to get more insight about the state of MySQL and the OS at the time the locks occurred.
This is how we got the much needed information:


wget http://bit.ly/1ltoZtk -O pt-stalk
chmod +x pt-stalk
mkdir -p /tmp/pt-stalk
sudo pt-stalk --daemonize --notify-by-email <EMAIL> --log /tmp/pt-stalk/pt-stalk.log --user root --dest /tmp/pt-stalk --function processlist --variable State --match Locked --threshold 20 --cycles=10 --sleep=15 --run-time=15


In this case we are running pt-stalk utility in background and trying to catch the case when there are 20+ Locked queries in processlist. When a match occurs, pt-stalk will collect a lot of OS and MySQL info and notify us by email.