Tag: column

Feed: R-bloggers. Author: Keith Goldfeld. I was recently contacted to see if simstudy can create a data set of correlated outcomes that are measured over time, but at different intervals for each individual. The quick answer is there is no specific function to do this. However, if you are willing to assume an “exchangeable” correlation structure, where measurements far apart in time are just as correlated as measurements taken close together, then you could just generate individual-level random effects (intercepts and/or slopes) and pretty much call it a day. Unfortunately, the researcher had something more challenging in mind: he wanted ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; The newest release of MySQL 8.0.14 includes the ability to control the number and location of UNDO tablespaces using SQL. Users can now manage UNDO tablespaces using SQL from the MySQL client. Background More undo tablespaces help busy systems handle a larger number of read-write concurrent transactions by having more rollback segments available to provide undo logs to those transactions.  Users can now create up to  127 UNDO tablespaces and the minimum number of UNDO tablespaces required for MySQL 8.0 is 2. UNDO logs are no longer stored in the InnoDB system ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST A common challenge with continuously deployed applications is that new and modified SQL queries are constantly being introduced to the application. Many companies choose to use a database monitoring system (such as PMM) to identify those slow queries. But identifying slow queries is only the start – what about actually optimizing them? In this post we’ll demonstrate a new way to both identify and optimize slow queries, by utilizing the recent integration of Percona Monitoring and Management with EverSQL Query Optimizer via Chrome browser extension. This integration allows you to identify ... Read More

Feed: AWS Big Data Blog. In this post, we talk about designing a cloud-native data warehouse as a replacement for our legacy data warehouse built on a relational database.At the beginning of the design process, the simplest solution appeared to be a straightforward lift-and-shift migration from one relational database to another. However, we decided to step back and focus first on what we really needed out of a data warehouse. We started looking at how we could decouple our legacy Oracle database into smaller microservices, using the right tool for the right job. Our process wasn’t just about using the ... Read More

Feed: Planet MySQL; Author: Jesper Krogh; The MySQL X DevAPI is the new API that provides a uniform API across the supported programming languages. It has from the beginning supported that you can specify a default schema, when you connect. Originally it was not used for SQL statements. Starting with MySQL 8.0.14 the feature has been extended, so SQL statements take the default schema into consideration as well. This blog will explore how this works using MySQL Connector/Python. If you use a different programming language, the change will work in a similar way. In order to explore the feature, a ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; The MySQL Development team is proud to announce a new version of the MySQL Shell which includes the following features: Support for importing BSON data. Ability to show column type information when executing SQL. Addition of command line options to lower the verbosity when the shell starts. Improved InnoDB Cluster support by enhancing the Admin API to support new features provided by Group Replication. For additional details look at MySQL InnoDB Cluster – What’s new in the 8.0.14 (GA) release. Improved the Upgrade Checker utility to: Support upgrades to MySQL 8.0.14. Provide instructions ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Shell 8.0.14 is a maintenance release of MySQL Shell 8.0 Series(a component of the MySQL Server). The MySQL Shell is provided under Oracle’s dual-license. MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Shell 8.0.14. MySQL Shell is an interactive JavaScript, Python and SQL console interface, supporting development and administration for the MySQL Server. It provides APIs implemented in JavaScript and Python that enable you to work with MySQL InnoDB cluster and use MySQL as a document store. The AdminAPI enables you ... Read More

Feed: Planet MySQL; Author: Geir Hoydalsvik; The MySQL Development team is very happy to announce that MySQL 8.0.14 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release.  Please download 8.0.14 from dev.mysql.com or from the MySQL  Yum,  APT, or SUSE repositories. The source code is available at GitHub. You can find the full list of changes and bug fixes in the 8.0.14 Release Notes. Here are the highlights. Enjoy! SQL Lateral derived tables  (WL#8652)  This work by Guilhem Bichot adds support for SQL:99 feature T491 “lateral derived ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/J Version 8.0.14 is the GA release of the 8.0branch of MySQL Connector/J. It is suitable for use with MySQL Serverversions 8.0, 5.7, 5.6, and 5.5. It supports the Java DatabaseConnectivity (JDBC) 4.2 API, and implements the X DevAPI. This release includes the following new features and changes, alsodescribed in more detail on https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-14.html As always, we recommend that you check the “CHANGES” file in thedownload archive to be aware of changes in behavior that might affectyour application. To download MySQL Connector/J 8.0.14 GA, see the “Generally Available(GA) Releases” tab at ... Read More

Feed: Liquid Web. Author: Curtis McHale; On December 6th, 2018 the controversial new editor experience for WordPress dropped and it’s called Gutenberg. While many are concerned about how it was rolled out I don’t think that anyone can deny that Gutenberg is the future of WordPress. That also means that Gutenberg is the future of WooCommerce, so let’s dive in and see what Gutenberg has to offer WooCommerce currently.What Gutenberg Blocks are Available for WooCommerce?By default there are no blocks bundled with WooCommerce as of WooCommerce 3.5.1 so you’ll need to head over to the WooCommerce site to get WooCommerce ... Read More