Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 121 to 130 of 35708 10 Older Entries
MySQL RDS Point-in-time restore
+1 Vote Up -0Vote Down

RDS for MySQL on AWS allows you to restore to any point in time for your backup retention period, minus the last 5 minutes or so. Restoration creates a new instance, it does not overwrite whatever instance you’re restoring. AWS’s use of the word restore is a bit confusing because restore often means “take your production database server and overwrite it with data from a backup”. As far as I can tell, Amazon never means this. When you restore, AWS creates another database server and writes all the data to the new instance, both when you’re using restoring to a point-in-time or from a DB snapshot. If you needed to switch servers, you’d have to point your database to …

  [Read more...]
Using Connector/J with Python
+1 Vote Up -0Vote Down

With Python you would normally use MySQL Connector/Python or the older MySQLdb to connect from Python to MySQL, but there are more options.

There are also multiple Python implementations: CPython (the main implementation), PyPy, Jython and IronPython. PyPy tries to be faster than CPython by using a Just-in-Time compiler. Jython runs on the JVM and IronPython runs on the .NET CLR.

Connector/Python by default (Without the C …

  [Read more...]
"I'm Winston Wolf, I solve problems."
+1 Vote Up -0Vote Down

My (few) readers are probably somewhat tired of boring topics of metadata locks and gdb breakpoints that I discuss a lot this year, so for this weekend I decided to concentrate on something less technical but still important to me - the way I prefer to follow while providing support for MySQL.

Before I continue, it's time to add the …

  [Read more...]
ordering_operation: EXPLAIN FORMAT=JSON knows everything about ORDER BY processing
+1 Vote Up -0Vote Down

We’ve already discussed using the ORDER BY clause with subqueries. You can also, however, use the 

ORDER BY

 clause with sorting results of one of the columns. Actually, this is most common way to use this clause.

Sometimes such queries require using temporary tables or filesort, and a regular

EXPLAIN

  clause provides this information. But it …

  [Read more...]
SQL qualified names
+1 Vote Up -0Vote Down

Bewilderedly behold this SQL statement:
SELECT * FROM a.b.c;
Nobody can know the meaning of "a.b.c" without knowing the terminology, the context, and the varying intents of various DBMS implementors.

The terminology

It's pretty clear that a.b.c is a name, that is, a unique reference to an SQL object, which in this case is a table.

The name happens to be qualified -- it has three parts separated by periods. A generalist would say that each part is a container, with the first part referring to the outermost container a, which contains b, which contains c. Analogies would be: a directory with a subdirectory and a sub-subdirectory, …



  [Read more...]
MariaDB JSON text indexing
+2 Vote Up -0Vote Down

It is not new that we can store a JSON content in a normal table text field. This has always been the case in the past. But two key features were missing : filtering based on JSON content attributes and indexing of the JSON content. With MariaDB 10.1 CONNECT storage Engine we offer support for [...]

MySQL 5.7 Multi-Source Replication – Automatically Combining Data From Multiple Databases Into One
Employee_Team +1 Vote Up -0Vote Down

MySQL’s multi-source replication allows you to replicate data from multiple databases into one database in parallel (at the same time). This post will explain and show you how to set up multi-source replication. (WARNING: This is a very long and detailed post.…

MySQL 5.7 multi-source replication – automatically combining data from multiple databases into one
+1 Vote Up -0Vote Down

MySQL’s multi-source replication allows you to replicate data from multiple databases into one database in parallel (at the same time). This post will explain and show you how to set up multi-source replication. (WARNING: This is a very long and detailed post. You might want to grab a sandwich and a drink.)

In most replication environments, you have one master database and one or more slave databases. This topology is used for high-availability scenarios, where the reads and …

  [Read more...]
OOM killer vs. MySQL 5.7.10 epic results with over-allocating memory
+0 Vote Up -0Vote Down

Recently i have figured out that we can over-allocate InnoDB buffer pool size as I have already reported:

#79850

So as a result I can start MySQL with 300GB buffer pool size in my 16G laptop.

Config:

innodb_buffer_pool_size=300G
innodb_buffer_pool_instances=64

Started as:

2016-01-05 15:23:58 16211 [Note] InnoDB: Initializing buffer pool, size = 300.0G
2016-01-05 15:24:31 16211 [Note] InnoDB: Completed initialization of buffer pool

If you think …



  [Read more...]
Partner Program
+1 Vote Up -0Vote Down

Hortonworks went to use the lessons to create a fresh database, partnering program, which has become called PostgreSQL. InfiniDB’s paper was likewise read and Hortonworks SQL was designed in the mid-2000s at Uppsala University. In 2010, this job was combined into an independent business. InfiniDB introduced trade management in programs, a notion which was later […]

10 Newer Entries Showing entries 121 to 130 of 35708 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.