Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 17611 10 Older Entries

Displaying posts with tag: mysql (reset)

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...]
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

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.

My endeavour to build MySQL on Windows
Employee +0 Vote Up -0Vote Down

I recently worked a lot on getting my local Windows box to compile Windows.
I got a lot of help from the below link that took me a few steps towards the
solution.
http://www.chriscalender.com/resolving-the-bison-exe-m4-invalid-argument-error-when-building-mysqlmariadbxtradb-on-windows/

I had to save away my bison installation, uninstall it and then also
go into a registry editor and remove the various links to the Start Menu referring to







  [Read more...]
When simple SQL can be complex
+1 Vote Up -0Vote Down

I think SQL is a very simple language, but ofcourse I'm biased.

But even a simple statement might have more complexity to it than you might think.

Do you know what the result is of this statement?

SELECT FALSE = FALSE = TRUE;

scroll down for the answer.



























The answer is: it depends.

You might expect it to return false because the 3 items …


































  [Read more...]
Using SYS.SESSION as an alternative to SHOW PROCESSLIST
Employee_Team +3 Vote Up -0Vote Down

A modern MySQL server contains a lot of useful meta-data in information_schema and performance_schema, which can help bring visibility into what is happening inside of your database server. However, sometimes this data is quite fine grained and needs finessing in order to get to that point

MySQL 5.7 includes a new SYS schema installed by default.…

MySQL in docker or native – performance benchmarks
+1 Vote Up -0Vote Down

Back in October I have write about possible ways of running multiple MySQL instances on the same hardware. As the months passing by, the project of splitting our database schemas into standalone instances is closing in, so I started to check the different ways. I started with docker, because we’ll use containers anyway with the applications, and […]

10 Newer Entries Showing entries 31 to 40 of 17611 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.