Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 70 of 34570 10 Older Entries
Update on the InnoDB double-write buffer and EXT4 transactions
+1 Vote Up -0Vote Down

In a post, written a few months ago, I found that using EXT4 transactions with the “data=journal” mount option, improves the write performance significantly, by 55%, without putting data at risk. Many people commented on the post mentioning they were not able to reproduce the results and thus, I decided to further investigate in order to find out why my results were different.

So, I ran sysbench benchmarks on a few servers and found when the InnoDB double-write buffer limitations occur and when they …

  [Read more...]
Removal and Deprecation in MySQL 5.7
Employee_Team +1 Vote Up -0Vote Down

With the shipment of the first release candidate (RC) of MySQL 5.7, the next major version of the server is rapidly shaping up. Over the course of the nearly two and a half years that have passed since 5.6 went GA, we have put a lot of work into streamlining the server code in order to ease the burden of developing and maintaining such a large product and codebase.

An important aspect of this work is deprecation and removal. To explain the terms, deprecating a feature means that we signal to the outside world that “this feature is available now, but it will be removed in a future release, so please adjust your use case …

  [Read more...]
Achieving Read-After-Write Semantics With Galera
+0 Vote Up -0Vote Down

Some applications, particularly those written with a single-node database server in mind, attempt to immediately read a value they have just inserted into the database, without making those those operations part of a single transaction. A read/write splitting proxy or a connection pool combined with a load-balancer can direct each operation to a different database node.

Since Galera allows, for performance reasons, a very small amount of “slave lag”, the node that is processing the read may have not yet applied the write. It can return old data, causing an application that did not expect that to misbehave or produce an error.

  [Read more...]
The Strategic Importance of Database Administration
+0 Vote Up -0Vote Down

If you draw a diagram of information flow and interaction amongst teams and processes in IT, you’ll probably find that although some parts of the organization are “leaf” or “edge” nodes, the people who manage the data are not. The DBAs would usually be one of the lavender circles in the chart below, not a blue circle.

DBAs also occupy a central position in the continuum of skills:

• On one hand, they have to understand a lot about how the application code works, because application developers are their customers.

• On the other hand, they need to understand how the application runs in production, because operations staff are …

  [Read more...]
Simple MySQL Key-Value Pair
+0 Vote Up -0Vote Down

Hooray for Data Structures… Where Are They?

The Key-Value Pair is my favorite programming tool. Most SQL type databases lack this feature in it simplest form. Some would argue, “Well that’s because databases don’t need dah-blah-dee-blah-blah…” Well, if they don’t need it I don’t need to write this post. :p

How many times have you found yourself asking “Why isn’t there at least simple array support!?” When you don’t want the overhead of creating a table, or a temporary table, simple data structures really do come in handy (hint, hint, nudge, nudge to all the companies producing database software with stored routine support). …

  [Read more...]
Speed up GROUP BY queries with subselects in MySQL
+0 Vote Up -0Vote Down

We usually try to avoid subselects because sometimes they force the use of a temporary table and limits the use of indexes. But, when is good to use a subselect?

This example was tested over table a (1310723 rows), b, c and d ( 5 rows each) and with MySQL version 5.5 and 5.6.

Let’s suppose we have a query like this:

select a.name,sum(a.count) aSum,avg(a.position) aAVG,b.col1,c.col2,d.col3
from
a join
b on (a.bid = b.id) join
c on (a.cid = c.id) join
d on (a.did = d.id)
group by a.name,b.id,c.id,d.id

What will MySQL do? First it will take the entire data set – this means that will go through each row …

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

The MySQL developer tools team announces 6.3.4 as our GA release for MySQL Workbench 6.3.

For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151

Download MySQL Workbench 6.3.4 GA now, for Windows, Mac OS X 10.7+,
Oracle Linux 6 and 7, Fedora 21 and Fedora 22, Ubuntu 14.04, …








  [Read more...]
MySQL Workbench 6.3.4 GA has been released
Employee_Team +0 Vote Up -1Vote Down

Dear MySQL users,

The MySQL developer tools team announces 6.3.4 as our GA release for
MySQL Workbench 6.3.

For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151

Download MySQL Workbench 6.3.4 GA now, for Windows, Mac OS X 10.7+,
Oracle Linux 6 and 7, Fedora 21 and Fedora 22, Ubuntu 14.04, Ubuntu
14.10 and Ubuntu 15.04 or sources, from:

http://dev.mysql.com/downloads/tools/workbench/

Become a MySQL DBA blog series - Database High Availability
+0 Vote Up -0Vote Down

There are many many approaches to MySQL high availability - from traditional, loosely-coupled database setups based on asynchronous replication to more modern, tightly-coupled architectures based on synchronous replication. These offer varying degrees of protection, and DBAs almost always have to choose a tradeoff between high-availability and cost. 

This is the third installment in the ‘Become a MySQL DBA’ series, and discusses the pros and cons of different approaches to high availability in MySQL. Our previous posts in the DBA series include …

  [Read more...]
Codership Webinar – Galera Cluster The Backbone of Highly Available OpenStack Database Storage – June 23rd 2015
+0 Vote Up -0Vote Down

Relational databases are ubiquitous in OpenStack: practically every OpenStack service stores its critical metadata in a database, and the MySQL family of databases is the de-facto standard for OpenStack relational data storage. The need for high availability for these relational datastores is obvious. Galera is the default multi-master strongly-consistent replication facility for highly-available relational data in OpenStack. In this webinar, we are joined by independent OpenStack expert Florian Haas to illustrate the ins and outs of Galera for OpenStack.

 

Speaker …

  [Read more...]
10 Newer Entries Showing entries 61 to 70 of 34570 10 Older Entries

Planet MySQL © 1995, 2015, 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.