Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 34186 10 Older Entries
Paramiko Update Tutorial
Employee_Team +0 Vote Up -0Vote Down

There are situations when you need to update the python-paramiko library that is bundled with MySQL Workbench. This may be because you prefer
using the latest cutting edge versions, are just curious, or you can’t wait for a new Workbench version.

To update, first download the latest python-paramiko release from https://github.com/paramiko/paramiko/releases. After downloading and extracting the archive, you’ll see a paramiko folder inside of the extracted folder. This folder needs to be copied into the appropriate MySQL Workbench folder on the system.

* …


  [Read more...]
FoundationDB is acquired by Apple: My thoughts
+0 Vote Up -0Vote Down

TechCrunch reported yesterday that Apple has acquired FoundationDB. And while I didn’t see any mention if this news on the FoundationDB website, they do have an announcement saying: “We have made the decision to evolve our company mission and, as of today, we will no longer offer downloads.”

This is an unfortunate development – I have been watching FoundationDB technology for years and was always impressed in terms of its performance and …

  [Read more...]
Command line prompt
Employee +0 Vote Up -0Vote Down

The mysql> command-line prompt is iconic, shown in countless documentation pages, forum posts, tutorials and manuals. It’s immediately identifiable – one look, and you immediately know the context in which commands are being executed. So it’s only with good reason that we would consider changing the prompt value to something else, and Daniël van Eeden provided a compelling suggestion to modify this to provide user, host and database context. Because the mysql prompt is user-configurable, this is easy to do dynamically: …

  [Read more...]
Translated books in Chinese
+1 Vote Up -0Vote Down

I have just received copies of my Effective MySQL series that are available in Chinese. The picture speaks more than words.




SQL, ANSI Standards, PostgreSQL and MySQL
+1 Vote Up -0Vote Down

I have recently been working with the Donors Choose Open Data Set which happens to be in PostgreSQL. Easy enough to install and load the data in PostgreSQL, however as I live and breath MySQL, lets load the data into MySQL.

And here is where start our discussion, first some history.

SQL History

SQL – Structure Query Language is a well known common language for communicating with …

  [Read more...]
How to Manage the World’s Top Open Source Databases: ClusterControl 1.2.9 Features Webinar Replay
+0 Vote Up -0Vote Down

Thanks to everyone who attended and participated in this week’s webinar on 'New Features - ClusterControl 1.2.9 Release'. If you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.

Our speaker this time was Johan Andersson, CTO, Severalnines.

Watch the replay

Introducing the new ClusterControl 1.2.9 - with live demo from

  [Read more...]
InnoDB全文索引:N-gram Parser
Employee_Team +0 Vote Up -0Vote Down

InnoDB默认的全文索引parser非常合适于Latin,因为Latin是通过空格来分词的。但对于像中文,日文和韩文来说,没有这样的分隔符。一个词可以由多个字来组成,所以我们需要用不同的方式来处理。在MySQL 5.7.6中我们能使用一个新的全文索引插件来处理它们:n-gram parser.

  [Read more...]
A few interesting findings on MariaDB and MySQL scalability, multi-table OLTP RO
+0 Vote Up -0Vote Down

It’s been almost a year since I benchmarked MariaDB and MySQL on our good old 4 CPU / 32 Cores / 64 Threads Sandy Bridge server. There seem to be a few interesting things happened since that time.

  • MySQL 5.6.23 peak throughput dropped by ~8% compared to 5.6.14. Looks like this regression appeared in MySQL 5.6.21.
  • 10.0.18 (git snapshot) peak threads increased by ~20% compared to 10.0.9 and reached parity with 5.6.23 (not with 5.6.20 though).
  • 10.1.4 (git snapshot) and 5.7.5 are …
  [Read more...]
MariaDB: The Differences, Expectations, and Future
+0 Vote Up -0Vote Down

Thu, 2015-03-26 07:48russelljtdyer

For my new book, Learning MySQL and MariaDB, Monty Widenius, one of the founders of MySQL and MariaDB, graciously contributed a Foreword. It's about six pages long and an interesting read for those who are familiar with MySQL and MariaDB. Of particular interest to newcomers to MariaDB, is the excerpt below on his perspective of MariaDB and his vision for its future, as well as MySQL.

Excerpt from Foreword of …

  [Read more...]
Save 20% on Percona Live and Hear Baron Speak
+0 Vote Up -0Vote Down

Percona Live is the premier event for the MySQL ecosystem. It is being held in Santa Clara this year, April 13 - 16. If you are not already registered, use the code Vividcortex20 to receive a 20% discount.

We will be exhibiting, and Baron Schwartz will be speaking on Encrypting Data in MySQL with Go on April 16th at 12:50.

We look forward to seeing you!

Showing entries 1 to 10 of 34186 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.