Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 151 to 160 of 36186 10 Older Entries
MySQL Query Best Practices
+0 Vote Up -0Vote Down

You can get many returns from a Google search for “MySQL Query Best Practices” or “MySQL Query Optimization.” The drawback is that too many rules can provide confusing or even conflicting advice. After doing some research and tests, I outlined the essential and important ones below:

1) Use proper data types

1.1) Use the smallest data types if possible

MySQL tries to load as much data as possible into memory (innodb-buffer-pool, key-buffer), so a small data type means more rows of data in memory, thus improving performance. Also, small data sizes reduces disk i/o.

1.2) Use Fixed-length …

  [Read more...]
Top database challenges for MariaDB
+0 Vote Up -0Vote Down

Mon, 2016-04-25 11:54janlindstrom

The latest top research identifies a number of big trends and challenges for databases. Jan Lindström, developer at MariaDB, summarises the key issues and challenges and how MariaDB approaches them.

First of all, the opinions expressed in this article are the author's own and do not necessary reflect the view of the MariaDB Corporation. These views are based on the review article by Abadi, et.all.: The Beckman Report on Database Research, Communications of the ACM, Vol. 59, NO. 02, 02/2016. While this meeting with thirty leaders from the database research community met in October 2013, my view is that issues raised in …

  [Read more...]
Webinar tomorrow: Become a MongoDB DBA (if you’re really a MySQL user)
+0 Vote Up -0Vote Down

Join us tomorrow, as we introduce a new webinar series: ‘How to Become a MongoDB DBA’ to answer the question: ‘what does a MongoDB DBA do?’.

This is a series of three webinars during which we will walk you through the most important tasks a MongoDB DBA routinely goes through and provide you with options on how to best complete these tasks.

It is not uncommon for MySQL DBAs, developers, network/system administrators or DevOps folks with general background to find themselves in a situation where they’ve been working with MySQL for a while …

  [Read more...]
AliSQL and some features that have made it into MariaDB Server
+0 Vote Up -0Vote Down

Mon, 2016-04-25 06:42colin

AliSQL is the fork of MySQL (maintained by Alibaba) that powers all of the group from Tmall, Taobao, Alibaba.com, 1688.com, AliExpress, Cainiao and the payment's network Alipay.

AliSQL isn't new - they've had this fork since 2011: AliSQL 5.1 (Bugfixes for DDL, eliminate race conditions), 2012: AliSQL 5.5 (parallel replication, optimize hot SKUs), 2014: AliSQL 5.6 (Enhanced threadpool, SQL firewall). The team have found/reported/fixed over 40+ bugs, added 41 new features, and optimised 27 bottlenecks. All recent releases of MySQL have had AliSQL contributions …

  [Read more...]
Building MariaDB 10.1.x and Galera from Source for Multiple Node Cluster Testing Setup
+0 Vote Up -0Vote Down

My Facebook followers probably noted that I quit from Percona some time ago and work for MariaDB since March 1, 2016. I changed the company, but neither the job role (I am still a Support Engineer), nor the approach to do my job. I still prefer to test everything I suggest to customers and I usually use software I …

  [Read more...]
Best Monitoring Practices, Greatest Hits
+0 Vote Up -0Vote Down

Over the last couple years on the VividCortex blog, we've discussed a huge range of database monitoring concepts. We've examined ideas we're excited about, shared monitoring practices we recommend, and explored some of the principles that shape our own projects and goals. Of these many posts, however, there are a few in particular worth emphasizing and discussing again and again. Generally, these posts explore the math and statistics behind key monitoring practices and they champion why smart database monitoring is so important; they're often our most read articles, the most indicative of what we value, the influences …

  [Read more...]
MySQL Community Awards 2016: the Winners
+2 Vote Up -0Vote Down

The MySQL Community Awards initiative is an effort to acknowledge and thank individuals and corporates for their contributions to the MySQL ecosystem. It is a from-the-community, by-the-community and for-the-community effort. The committee is composed of an independent group of community members of different orientation and opinion, themselves past winners or known contributors to the community.

The 2016 community awards were presented on April 21st, 2016, during the keynotes at the Percona Live conference. The winners are:

MySQL Community Awards: Community Contributor of the year 2016

  • Bill Karwin …
  [Read more...]
The new MySQL X DevAPI Protocol and what it means for PHP
Employee +1 Vote Up -0Vote Down

The relational database world just changed and you didn't notice, did you? Rather than speaking SQL to your data, what if you could talk to it in PHP directly? No longer do you have to struggle to remember arcane structured query language syntax and just grab data with PHP. You can still write bad queries full of N+1 errors and a whole host of other problems. But you are speaking PHP to your data. And this started with MySQL 5.7.12 and its new Document Store Functionality.

The Document Store functionality expands on the new JSON data type in MySQL 5.7 with a new server plugin, a new API, and a suite of new components designed to make …

  [Read more...]
The Perfect Server - Ubuntu 16.04 (Xenial Xerus) with Apache, PHP, MySQL, PureFTPD, BIND, Postfix, Dovecot and ISPConfig 3.1
+0 Vote Up -0Vote Down

This tutorial shows how to install an Ubuntu 16.04 (Xenial Xerus) server (with Apache2, BIND, Dovecot) for the installation of ISPConfig 3.1, and how to install ISPConfig. ISPConfig 3 is a web hosting control panel that allows you to configure the following services through a web browser: Apache or nginx web server, Postfix mail server, Courier or Dovecot IMAP/POP3 server, MySQL, BIND or MyDNS nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. This setup covers the installation of Apache (instead of nginx), BIND (instead of MyDNS), and Dovecot (instead of Courier).

The Perfect Server - Ubuntu 16.04 (Xenial Xerus) with Apache, PHP, MySQL, PureFTPD, BIND, Postfix, Dovecot and ISPConfig 3.1
+0 Vote Up -0Vote Down

This tutorial shows how to install an Ubuntu 16.04 (Xenial Xerus) server (with Apache2, BIND, Dovecot) for the installation of ISPConfig 3.1, and how to install ISPConfig. ISPConfig 3 is a web hosting control panel that allows you to configure the following services through a web browser: Apache or nginx web server, Postfix mail server, Courier or Dovecot IMAP/POP3 server, MySQL, BIND or MyDNS nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. This setup covers the installation of Apache (instead of nginx), BIND (instead of MyDNS), and Dovecot (instead of Courier).

10 Newer Entries Showing entries 151 to 160 of 36186 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.