Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 70 of 35715 10 Older Entries
EXPLAIN FORMAT=JSON knows everything about UNIONs: union_result and query_specifications
+0 Vote Up -0Vote Down

Ready for another post in the EXPLAIN FORMAT=JSON is Cool series! Great! This post will discuss how to see all the information that is contained in optimized queries with

UNION

 using the

union_result

 and

query_specifications

 commands.

 

When optimizing complicated queries with

UNION

, it is easy to get lost in the regular

EXPLAIN

  output trying to identify which part …

  [Read more...]
MariaDB 10.1.11 now available
+0 Vote Up -0Vote Down

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.11. See the release notes and changelog for details on this release. Download MariaDB 10.1.11 Release Notes Changelog What is MariaDB 10.1? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!

The post MariaDB 10.1.11 now available appeared first on MariaDB.org.

Percona XtraDB Cluster 5.6.28-25.14 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on January 29, 2016. Binaries are available from the downloads area or from our software repositories.

Percona XtraDB Cluster 5.6.28-25.14 is now the current release, based on the …

  [Read more...]
How to lose General Tablespace in MySQL 5.7.10
+1 Vote Up -0Vote Down

If you have not be careful with General Tablespaces in MySQL 5.7.10, you must be at least from now.
I have reported several bugs related to General Tablespaces for eg.:

* #77814 -> Altering table twice,with same tablespace will increase general tablespace size (verfied)

* #77556 -> Segmentation fault while creating general tablespace in disk full Linux (fixed/closed)

* #77830 -> …


  [Read more...]
MyRocks vs InnoDB with Linkbench over 7 days
+1 Vote Up -0Vote Down

After feedback from my previous post on Linkbench I repeated it for 7 days as the previous test ran for 1 day. The results are the same -- MyRocks sustains more QPS, is more IO efficient and provides better compression on IO-bound Linkbench. Ask your MySQL vendor when they will support MyRocks. The summary is:

  • InnoDB writes between 8X and 14X more data to SSD per transaction than RocksDB
  • RocksDB sustains about 1.5X more QPS

  [Read more...]
MySQL Swap Insanity: Solved
+0 Vote Up -0Vote Down

Yes, it has been a while since my last post.  Still in the midst of MySQL ecosystem, and enjoying it tremendously.  I thought I would make this post as it relates to a topic that has some varied results in the online world, and I would like to kick start this blog again.  We'll see how that goes... :)

MySQL has been able to harness the potential of more powerful (CPU) and larger (RAM, disk space

Get all the insight on open source database management and infrastructure operations with Severalnines whitepapers
+0 Vote Up -0Vote Down

Whether you’re looking into ways to automate various aspects of administering your open source databases or to take better control of your data, we have the relevant whitepaper that will help you in your quest and hopefully provide you with good food for thought on how to achieve your database management objectives.

Management and Automation of Open Source Databases

As the adoption of open source databases, such as MySQL / MariaDB, PostgreSQL or MongoDB, …

  [Read more...]
Setup a MongoDB replica/sharding set in seconds
+0 Vote Up -0Vote Down

In the MySQL world, we’re used to playing in the MySQL Sandbox. It allows us to deploy a testing replication environment in seconds, without a great deal of effort or navigating multiple virtual machines. It is a tool that we couldn’t live without in Support.

In this post I am going to walk through the different ways we have to deploy a MongoDB replica/sharding set test in a similar way. It is important to mention that this is not intended …

  [Read more...]
Restricting Connections to Secure Transport
Employee_Team +0 Vote Up -0Vote Down

MySQL 5.7 makes secure connections easier with streamlined key generation for both MySQL Community and MySQL Enterprise, improves security by expanding support for TLSv1.1 and TLSv1.2, and helps administrators assess whether clients are connecting securely or not with …

  [Read more...]
Fosdem MySQL & Friends Devroom – Innotop hackathon
+0 Vote Up -0Vote Down

What about an hackathon to fix several issues in Innotop during this Fosdem 2016 edition ?

As the MySQL & Friends Devroom is on Saturday, Sunday would be the perfect day to find a nice place in the bar and work on resolving the open issues in Innotop to support MariaDB 10.1, MySQL 5.7…

If you are interested just send me a tweet (@lefred) and we can arrange this meeting.

10 Newer Entries Showing entries 61 to 70 of 35715 10 Older Entries

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