Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 36076 10 Older Entries
My slides about MySQL Performance from #PerconaLive Apr.2016 US
Employee +0 Vote Up -0Vote Down

As promised, here are my slides from Percona Live Conference in US, Apr.2016 :

  • MySQL 5.7 Performance & Scalability Benchmarks (PDF)
  • MySQL 5.7 Demystified Tuning (PDF)


Feel free to ask any questions or details you're needing, etc..

Also, not really related to MySQL, but as I was asked so many …


  [Read more...]
Best Practices for Configuring Optimal MySQL Memory Usage
+1 Vote Up -0Vote Down

In this blog post, we’ll discuss some of the best practices for configuring optimal MySQL memory usage.

Correctly configuring the use of available memory resources is one of the most important things you have to get right with MySQL for optimal performance and stability. As of MySQL 5.7, the default configuration uses a very limited amount of memory – leaving defaults is one of the worst things you can do. But configuring it incorrectly can result in even worse performance (or even crashes). …

  [Read more...]
MariaDB Security at the Open Source Conference in Rome
+0 Vote Up -0Vote Down

Tue, 2016-05-03 12:35maria-luisaraviol

At the 2016 Open Source Conference in Rome, held a few weeks ago, MariaDB was present along with many of the most relevant players in the Open Source community. This included the Italian Public Administration. They are required by law to give preference to free software and open source software. The goal of the Italian Open Source Observatory is to promote the use of open source software in Italian public administrations. They monitor and collect information on cases of open source adoption and best practices related to open technology usage within institutions.

Our focus at the conference this year was in …

  [Read more...]
Solving the Facebook-OSC non-atomic table swap problem
+0 Vote Up -0Vote Down

We present a way to use an atomic, blocking table swap in the Facebook Online-Schema-Change solution, as well as in a rumored, other Online-Schema-rumored-Change solution.

Quick recap (really quick)

pt-online-schema-change and facebook-osc are two popular online-schema-change solutions for MySQL. They both use triggers, but in different ways. While the Percona tool uses synchronous table …

  [Read more...]
MySQL 5.7 using vagrant
+1 Vote Up -0Vote Down

  [Read more...]
MySQL 5.7 utilizando vagrant
+1 Vote Up -0Vote Down

  [Read more...]
Reserved words usage in MySQL
+0 Vote Up -0Vote Down

It is not uncommon to come across MySQL databases where reserved words are in use as identifiers for any kind of database objects.

Perhaps when the application schema was implemented, the words were not reserved yet, and they became reserved later on a subsequent MySQL release.

It is a good practice to check reserved words usage prior to doing any database upgrades, as any newly reserved keywords will cause syntax errors on the new version.

This is usually not a problem if proper quoting is used for referencing the objects, as described on the official  …

  [Read more...]
Taking the MySQL document store for a spin
+1 Vote Up -0Vote Down

This is not a comprehensive review, nor an user guide. It's a step-by-step account of my initial impressions while trying the new MySQL XProtocol and the document store capabilities. In fact, I am barely scratching the surface here: more articles will come as time allows.

MySQL 5.7 has been GA for several months, as it was released in October 2015. Among the many features and improvements, I was surprised to see the MySQL team emphasizing the JSON data type. While it is an interesting feature per se, I failed to see the reason why so many articles and …

  [Read more...]
Modelling databases in a web browser
+1 Vote Up -0Vote Down

Mon, 2016-05-02 13:50colin

When folk in the MariaDB world think about a GUI front-end, they tend to think of HeidiSQL, which has been shipping as part of MariaDB Server since 5.2.7. If one has a MariaDB Enterprise subscription, you get the Visual Query Editor which is SQLyog by Webyog. In fact the Knowledge Base lists a fairly lengthy list of …

  [Read more...]
MariaDB in Google Summer of Code 2016
+0 Vote Up -0Vote Down

And for the fourth year in a row, MariaDB Foundation participates in the Google Summer of Code! The MariaDB Organization in GSoC is an umbrella organization for all projects that belongs to the MariaDB ecosystem, be it MariaDB Server, MariaDB Connectors, or MariaDB MaxScale. The complete list of our suggested project ideas is in MariaDB […]

The post MariaDB in Google Summer of Code 2016 appeared first on MariaDB.org.

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