When looking at Percona live Santa Clara 2015 agenda I saw two intriguing conferences : - JSON support in MySQL 5.7 – Docstore: document database for MySQL at Facebook
Both conference are talking about supporting a native JSON type in MySQL ! This sounds really great. I have never seen any blog post or github [...]
The MySQL Utilities Team is pleased to announce a new alpha
release of MySQL Utilities. This release includes a number of
improvements for useabilty, stability, and a few enhancements. A
complete list of all improvements can be found in our release notes.
New Enhancements!
This release represents a stable release of the product. Along
with several defect patches, we also include the following
enhancements.
Improved support for MySQL 5.7 early releases
Improved output for mysqldbcompare
Improved SSL support
New Utilities!
This release also has three new utilities for you to try
out:
mysqlslavetrx - skip transactions on one or more slaves to solve
errant transactions and consistency errors - …
The MySQL Utilities Team is pleased to announce the general
availability (GA) release of MySQL Utilities. This release
includes a number of improvements for useabilty, stability, and a
few enhancements. A complete list of all improvements can be
found in our release notes.
New Enhancements! This release represents a stable release
of the product. Along with several defect patches, we also
include the following enhancements.
How Can I Download MySQL Utilities?
You can download MySQL Utilities 1.5.2 GA from the following link
using one of the pre-built installation repositories including a
source download.
…
In the MySQL team, we are planning to remove sql-bench from the MySQL 5.7 sources.
As the README file denotes, SQL Bench is a benchmark utility that supports MySQL 3.20 and 3.21, PostgreSQL 6.#, mSQL 2.# and Solid Server 2.2. It has not been well maintained for recent versions, and we are no longer using it internally as part of our testing process.
Our aim in making this change is to:
The source code to sql-bench will remain in the …
[Read more]As the systemd integration keeps on getting forward. It is hardly to be ignored by us MySQL folks :)
Lets have a look into a simple problem, you are not going to solve like you used to solve it. (At least on Centos7 installing the MariaDB package)
Increasing table_open_cache was only a configuration
issue. As mysqld was started as root and then
switching to the unix user mysql. On Centos7 this
was not working anymore. As MariaDB/MySQL ist startet with a
service file starting the process as user mysql:
[Service]
Type=simple
User=mysql
Group=mysql
..
As not root (having the right capability) it will be not able to change the open files limit. In the error log you are going to find something like:
150303 11:57:02 [Warning] Changed limits: max_open_files: 1024
max_connections: 214 table_cache: 400
Reading the …
[Read more]
I've completed a new release of the Connector/Arduino! The new
release contains some minor improvements as follows.
Enjoy!
Wed, 2015-03-04 10:26stephanevaroqui
Every organization needs a good database back-up plan, to include plans for data restoration. Such a plan should include, of course making proper back-ups and doing in a way that won't disturb user traffic. It should also include making sure that you're ready to restore back-ups quickly, so that your organization can operate with minimal downtime and without loss of data when a problem occurs. There are many things such as these to consider for developing a good back-up and restoration plan.
Full Back-Ups
It's strongly recommended to make a back-up of all of the databases in the same dump. This will allow for a consistent view of the global state of the databases. Plus, a full back-up can be used for provisioning a new replication when needed. A full back-up will save the system tables and stay consistent with multiple database queries and transactions. There are …
[Read more]
In MySQL Cluster 7.4 we have worked on improving the speed of
restarts.
In addition we have made it easier to track how fast the restarts
are
proceeding and to see which phases of the restart take a long
time.
For this purpose we have added a new Ndbinfo table in MySQL
Cluster 7.4.
I will try to explain the restart phases in a series of blogs and
how they map
to the columns in this Ndbinfo table.
First some short intro to concepts in MySQL Cluster. LCP stands
for local
checkpoints and this is where the main memory content of tables
are
written to disk at regular intervals. There is also a GCP, global
checkpoint,
this is a protocol to synchronise the REDO log writes and thus
about
durability of transactions. LDM stands for Local Data Manager and
is
the thread that runs all the code that maintains the actual data
in MySQL
Cluster. This includes row …
Last week I had to update several million rows in a single MySQL
table. Rather that executing the update directly in the database,
I decided to use common_schema's split() function.
There are two reasons I chose to use common_schema for this task:
Chunking
Chunking breaks a single update statement into multiple
statements, each updating at most a certain specified
number of rows. The default chunk size is 1000, and I changed it
to 2000 by setting the size parameter.
Throttling
…[Read more]The Practical Guide to Query Optimization for MySQL and PostgreSQL is a must read for any DBA or developer who wants to maximize resources, ship code faster, and do more to delight users.
Abstract
Profiling is the science of categorizing, sorting, and ranking system work to determine where time, money, and resources are spent within the system. Profiling database workload is an essential skill for any database administrator or developer and is the first step to optimizing performance. This book is the first in a series. It teaches you the tools and techniques you’ll need to profile one or many MySQL or PostgreSQL databases. Further books will explain how to speed up the queries that you select for optimization as a result of profiling.
Check out the table of contents and download the full edition …
[Read more]