Tag: performance

Feed: What's New. CloudFormation has added support for the following new resources:AWS::SecretsManager::ResourcePolicyUse the AWS::SecretsManager::ResourcePolicy resource to define a resource-based policy and attach it to a secret that's stored in Secrets Manager.AWS::SecretsManager::RotationScheduleUse the AWS::SecretsManager::RotationSchedule resource to configure rotation for a secret.AWS::SecretsManager::SecretUse the AWS::SecretsManager::Secret resource to create a secret and stores it in Secrets Manager.AWS::SecretsManager::SecretTargetAttachmentUse the AWS::SecretsManager::SecretTargetAttachmentresource to complete the final link between a Secrets Manager secret and its associated database. AWS::DLM::LifecyclePolicyUse the AWS::DLM::LifecyclePolicy resource to create a lifecycle policy for Amazon Data Lifecycle Manager. Secrets Manager Dynamic reference:Use the secretsmanager dynamic reference to retrieve entire secrets or secret values that are ... Read More

Feed: Planet MySQL; Author: Jesper Krogh; The other day, I was reading a blog by Magnus Hagander about tracking foreign keys throughout a schema in PostgreSQL. I thought it was a good idea, so I decided to look at how you can track foreign key in MySQL. The way I decided to do it was to start out with a table, then find all tables referencing the table by a foreign key. From this basic (and simple as it will be shown) query, it is possible to create a chain of relations. The key table for the queries is information_schema.KEY_COLUMN_USAGE ... Read More

Feed: Planet MySQL; Author: Dave Stokes; JSON has proven to be a very import data format with immense popularity. A good part of my time for the last two or so years has been dedicated to this area and I even wrote a book on the subject.  This is a comparison of the implementations of handling JSON data in MySQL and MariaDB. I had requests from the community and customers for this evaluation. JSON Data Types Are Not All Equal MySQL added a JSON data type in version 5.7 and it has proven to be very popular.  MariaDB has  JSON ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Bill Vorhies of Data Science Central and Rick Negrin of MemSQL recently delivered a webinar on data lakes and the use of Hadoop in the age of operational machine learning (ML) and artificial intelligence (AI). In this blog post, we summarize some of the key points from the webinar, as a preview for the webinar. You can also view the recorded webinar at any point. Businesses need flexible access to their data to make the best decisions. Unfortunately, the systems in use today impose complexity and structural delays. MemSQL, a fast, fully scalable relational ... Read More

Feed: Blog. Author: CraigSMullins; Application developers must code efficient SQL and understand how to optimize SQL in order to develop efficient applications. But it is not just the programmer, but also the DBA who must understand SQL optimization. It is a joint responsibility and frequently requires robust tools to help code, modify, and optimize SQL effectively.The relational optimizer is at the heart of the DBMS. It is an inference engine responsible for determining the best possible database navigation strategy for any given SQL request. The developer specifies what data is needed by coding the SQL statements, the DBMS accesses metadata ... Read More

Feed: Planet PostgreSQL. PostgreSQL 11 has been officially released and it's packed with exciting changes.Native declarative partitioning is more robust, parallelism is now allowing moreoperations to work in parallel, transactions are now supported in stored procedures and just in time compilation for expressions are just some of the new features. With every major version, Postgres is getting better, providing more and more tools to developers and better quality of life to the DBAs, making it harder to resist an upgrade.That said, while new major versions come with all these exciting improvements, they also come with internal system changes, making the ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.7.23-24 on November 12, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.23, including all the bug fixes in it. Percona Server for MySQL 5.7.23-24 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and free. This release introduces InnoDB encryption improvements and merges upstream MyRocks changes. Also, we’ve improved the usage of column families in MyRocks. The InnoDB encryption improvements are in Alpha quality and we don’t recommend ... Read More

Feed: Planet big data. Author: Faith Adams. Yesterday, SAP announced that it is acquiring Qualtrics for a hefty $8 billion in cash. For SAP, this does make some sense. SAP is often perceived as being a legacy provider that struggles to play in the consumer space, and this acquisition may help it make a larger data play. It may also enable SAP to close the loop when it comes to some of the VoC gaps in its C/4HANA CX suite that was announced earlier this year. But all of this is to be determined. For Qualtrics, the benefits are more ... Read More

Feed: All Oracle Press Releases. Oracle today announced availability of new bare metal Oracle Cloud Infrastructure compute instances to help enterprises run various performance sensitive workloads, such as artificial intelligence (AI) or engineering simulations, in the cloud. These new instances are part of Oracle’s new “Clustered Network,” which gives customers access to a low latency and high bandwidth RDMA network. Oracle now provides large organizations with a complete set of solutions for any high performance computing (HPC) workload, enabling businesses to capitalize on the benefits of modern cloud computing while enjoying performance comparable to on-premises compute clusters at a cost ... Read More

Feed: Microsoft Azure Blog. Author: Tara Jana. This post is co-authored by Anil Kumble, Founder, Spektacom Technologies. While Cricket is an old sport with a dedicated following of fans across the globe, the game has been revolutionized in the 21st century with the advent of Twenty20 format resulting in a massive growth of interest in the game and fan following worldwide. This has led to an increase in competition as well as a desire among professionals and amateurs likewise, to improve the quality of their game. As the popularity of the game increased, innovative methods of improving batting techniques evolved ... Read More