In recent months, there had been some really exciting news from the MySQL team: (Recursive) Common Table Expressions in MySQL Introducing Window Functions These two SQL standard language features are among the most powerful SQL features that are available from most other databases. I frequently include them in conference talks about SQL (see my article … Continue reading jOOQ 3.10 Supports Exciting MySQL 8.0 Features →
Jul
24
2017
Jul
24
2017
When starting a new project, it is generally recommended to go on the most recent version of MySQL, to take advantage of the latest features but also (mainly?) to be sure to be up to date with the security patches.
This blog post centralizes the various URLs where to download the world's most popular open source database.
Jul
24
2017
One of the goals of the MariaDB Foundation is to help new contributors understand the source code and to lower the barrier for new participants. One way to measure this is to look at the number of pull requests received and accepted, as these mostly reflect community contributions. The figures below are for the main […]
The post Community contributions to MariaDB appeared first on MariaDB.org.
Jul
24
2017
MySQL theoretical limits are known and they can be found in the manual, they include:
MyISAM permits data and index files to grow up to 256 TiB by default, but this limit can be changed up to the maximum permissible size of 65,536 TiB (256^7 − 1 bytes). The maximum tablespace size depends on the InnoDB page size: 64 TiB for 16 KiB pages.(The maximum tablespace size is also the maximum size for a
Jul
23
2017
Queries with LIMITs and OFFSETs are common in application that
require pagination and in some cases might work well for a
while.
In many cases though, they become slow and painful once the
OFFSET has a high value.
Why OFFSET is so slow?
Well, in most cases, low offset queries are not slow. The problem
starts with high OFFSET values.
If your query is using the following limit clause: “LIMIT 50000,
20”, it’s actually requesting the database to go through 50,020
rows and throw away the first 50,000. This action can have a high
cost an impact response time.
You may ask yourself “who the heck is going to skip to page
50,000 in my application?”.
Let’s list few possible use cases:
- Your favorite search engine (Google / Bing / Yahoo / DuckDuckGo / whatever) is about to index your ecommerce website. You have about 100,000 pages in that website. How will your application react when the …
Jul
21
2017
Dear MySQL Users,
MySQL Connector/J 5.1.43, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL.
MySQL Connector Java is available in source and binary form from
the Connector/J download pages at
http://dev.mysql.com/downloads/connector/j/5.1.html and mirror
sit
repositories.
MySQL Connector Java (Commercial) is already available for
download on the My Oracle Support (MOS) website. This release
will be available on eDelivery
(OSDC) in next month’s upload cycle.
As always, we recommend that you check the “CHANGES” file in the download archive to be aware of changes in behavior that might affect your application.
MySQL Connector/J 5.1.43 includes the following general bug fixes
and improvements, also available in more detail on
http://dev.mysql.com/doc/relnotes/connector-j/en
nges in MySQL Connector/J …
Jul
21
2017
This Log Buffer Edition covers Oracle, SQL Server and MySQL.
Oracle:
Protecting Financial Data with Oracle WebCenter and Adobe LiveCycle
Oracle Forms 12c oracle.security.jps.JpsException Error after Database change
The Future of Content Management: Oracle Content & Experience Cloud
Today Oracle released a very large „monster“ Upgrade. This July 2017 Update includes the first time the new RU „Release …
[Read more]
Jul
21
2017
This Log Buffer Edition covers Oracle, SQL Server and MySQL.
Oracle:
Protecting Financial Data with Oracle WebCenter and Adobe LiveCycle
Oracle Forms 12c oracle.security.jps.JpsException Error after Database change
The Future of Content Management: Oracle Content & Experience Cloud
Today Oracle released a very large „monster“ Upgrade. This July 2017 Update includes the first time the new RU „Release …
[Read more]
Jul
21
2017
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
Introduction
Starting in version 5.7.17-29.20 of Percona XtraDB Cluster significantly improved performance. Depending on the workload, the increase in throughput is in the range of 3-10x. (More details here). These optimization fixes also helped improve IST (Incremental State Transfer) performance. This blog is aimed at studying the IST impact.
IST
IST stands for incremental state transfer. When a node of the cluster leaves the cluster for a short period of time and then rejoins the cluster it needs to catch-up with cluster state. As part of this sync …
[Read more]
Jul
20
2017
via GIPHY Amazon releases a new database offering every other day. It sure isn’t easy to keep up. Join 35,000 others and follow Sean Hull on twitter @hullsean. Let’s say you’re hiring a devops & you want to suss out their database knowledge? Or you’re hiring a professional services firm or freelance consultant. Whatever the … Continue reading How to interview an amazon database expert →