Author: MySQL Planet

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: 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: 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

Feed: Planet MySQL. Author: Marco. A story around replication lag and Flow-Control.In the last few months we had 2 main actors in the the MySQL ecosystem, ProxySQL and Group-Replication (with the evolution to InnoDB Cluster). While I had extensively covered the first, my last serious work on GR, goes back to some lab version in the past years. Given the decision Oracle made to declare it GA, and the Percona decision to provide some level of support to GR, I decide it was time for me to take a look at it again.A lot of reviews were already done covering different topics ... Read More

Feed: Planet MySQL. Author: Preetam Jinka. Back in May I wrote about a web service I’m working on that uses local storage and replication with two-phase commit. I pulled out the core of it and created a package that I’m calling the Rig.It’s up on GitHub already: https://github.com/Preetam/rig The goal of the Rig is to take some web service and add a log and replication on top. A service is simply something that accepts operations. type Service interface { Validate(Operation) error Apply(uint64, Operation) error LockResources(Operation) bool UnlockResources(Operation) } Each operation is associated with an entry in a log. type LogPayload ... Read More

Feed: Planet MySQL. Author: VividCortex. For virtually all development teams, testing code is a given: It's one of the most important parts of software development. Whether your organization includes a separate team devoted to QA, or your developers are testing their own code, QA is the primary way your team ensures that your application's logic is working correctly, and it's the best way for you to identify issues as early as possible.As a result, QA is critical for engineering velocity, and it helps shape your users' overall experience when engaging with your product. Nobody likes finding a broken app or ... Read More

Feed: Planet MySQL. Author: Jean-François Gagné. This is old news for MySQL/MariaDB expert but people that are starting using InnoDB do not always know that disk space is not automatically released when deleting data from a table.  To explain and demonstrate that, I will take two real-world examples: table1 and table2. Recently, more than 90% and about 20% of rows were deleted from table1 and table2 (those tables contain real data, I only changed the table names).  Those two tables are quite large (121GiB and 846GiB respectively): # ls -lh table1.ibd table2.ibd -rw-rw---- 1 user group 121G Jul 12 05:43 ... Read More