Category: MySQL & MariaDB

Feed: Planet MySQL; Author: MariaDB; The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.57. This is a stable (GA) release. See the release notes and changelog for details. Download MariaDB 5.5.57 Release Notes Changelog What is MariaDB 5.5? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB! ... Read More

Feed: Planet MySQL; Author: Scott Noyes; 1. Watch the parentheses. It's: ST_GeomFromText('POLYGON((outerRing), (innerRing), (innerRing), ...)') The inner rings are optional. If you have just the outer ring, then it's still: ST_GeomFromText('POLYGON((outerRing))') and not: ST_GeomFromText('POLYGON(outerRing)') 2. Polygons have to start and end at the same point. 3. Watch the commas. Rings are comma-delimited sets of of whitespace-delimited coordinate pairs: x1 y1, x2 y2, x3 y3, x4 y4 not:x1 y1 x2 y2 x3 y3x1, y1, x2, y2, x3, y3, x4, y4(x1, y1), (x2, y2), (x3, y3)or other variations on that theme. Share this: ... Read More

Feed: Planet MySQL; Author: Dave Stokes; I am starting a series of videos on the MySQL Document Store. The Document Store allows those who do not know Structured Query Language (SQL) to use a database without having to know the basics of relational databases, set theory, or data normalization. The goal is to have sort 2-3 minute episodes on the various facets of the Document Store including the basics, using various programming languages (Node.JS, PHP, Python), and materializing free form schemaless, NoSQL data into columns for use with SQL. The first Episode, Introduction, can be found here. Please provide feedback ... Read More

Feed: Planet MySQL; Author: MariaDB; The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.7. This is a stable (GA) release. See the release notes and changelog for details. Download MariaDB 10.2.7 Release Notes Changelog What is MariaDB 10.2? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB! ... Read More

Feed: Planet MySQL; Author: The Pythian Group; This Log Buffer Edition covers Oracle, SQL Server and MySQL.Oracle:12.2 New Feature: the FLEX ASM disk group part 2Oracle ASM in Azure corruption – follow upSet-based processingADF 12c BC Proxy User DB Connection and Save Point ErrorEnabling A Modern Analytics PlatformSQL Server:Batch SSIS pkg execution from Business Intelligence Development StudioFind Database Connection Leaks in Your ApplicationTroubleshooting CPU Performance on VMwareSQLskills Wait Types Library now shows SentryOne dataPowerShell Tool Time: The Tool FrameworkMySQL:Installing Zabbix into Azure using a MySQL PaaSStreaming Global Cyber Attack Analytics with Tableau and PythonThread Statistics and High Memory UsageOn slave_parallel_workers ... Read More

Feed: Planet MySQL; Author: Baron Schwartz (xaprb); Mon, Jul 10, 2017 in Databases Humor The removal of the query cache in MySQL 8.0 improves user experience and has been celebrated by many members of the MySQL community. With this good news, obviously, Hitler isn’t happy. (Parody Video). I'm Baron Schwartz, the founder and CEO of VividCortex. I am the author of High Performance MySQL and lots of open-source software for performance analysis, monitoring, and system administration. I contribute to various database communities such as Oracle, PostgreSQL, Redis and MongoDB. More about me. Comments ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; 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 sitrepositories. 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 ... Read More

Feed: Percona Database Performance Blog. Author: Krunal Bauskar. Krunal Bauskar  | July 21, 2017 |  Posted In: MySQL, Percona XtraDB Cluster PREVIOUS POST 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 ... Read More

Feed: Planet MySQL; Author: The Pythian Group; This Log Buffer Edition covers Oracle, SQL Server and MySQL.Oracle:Protecting Financial Data with Oracle WebCenter and Adobe LiveCycleOracle Forms 12c oracle.security.jps.JpsException Error after Database changeThe Future of Content Management: Oracle Content & Experience CloudToday Oracle released a very large „monster“ Upgrade. This July 2017 Update includes the first time the new RU „Release Upgrade“ and RUR „Release Update Revision“ Patches.Cloud Ward: Who Will Win the Battle for IT’s Future?SQL Server:SQL Server Management Studio add-insResolve Network Binding Order Warning in failover clusterQueries to inventory your SQL Server Agent JobsSQL Server 2016 ColumnStore Index String ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; More than 3 months after 5.7.18 we' ve got MySQL 5.7.19 released recently. This is my quick review of the release notes with interesting fixed bug (reported in public) highlighted in the areas I am usually interested in.Let's start with InnoDB. The following bug fixes attracted my attention:Bug #85043 is still private. You know how much I hate those. At least we can see it was about the fact that "The server allocated memory unnecessarily for an operation that rebuilt the table." Let's hope this is no longer the case. Bug #84038 - "Errors when ... Read More