Tag: SQL

Feed: Planet MySQL; Author: Kristian Köhntopp; We observe a large number of messages of the kind The table '../tmp/#sql…' is full In older Versions of MySQL, implied temporary tables are being created, whenever your EXPLAIN contained the phrase using temporary. In this case, MySQL would create an in-memory temporary table to materialize an intermediate query result, and then continue to process the data from there. If that temporary table was larger than some configurable limit, the temporary table would instead be converted to a MyISAM table on disk, streamed out, and then work would continue with this. This has a ... Read More

Feed: Recent Announcements. Amazon RDS for SQL Server now supports MSDTC JDBC XA transactions. With MSDTC you can either execute the transaction using SQL Server as the Transaction manager using linked servers, or you can promote MSDTC running on the same host as the Client application to the role of Transaction manager. With this announcement, customers that are using SQL Server 2017 CU16+ and SQL Server 2019 can now enable XA option setting to start distributed transactions from JDBC ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . For documentation about the mariadb-tzinfo-to-sql utility, see mysql_tzinfo_to_sql. This page is about running it using Ansible. Installing or Upgrading the Package First, we should install mariadb-tzinfo-to-sql if it is available on our system. For example, to install it on Ubuntu, we can use this task. For other systems, use the proper module and package name. - name: Update timezone info tags: [ timezone-update ] apt: name: tzdata state: latest install_recommends: no register: timezone_info This task installs the latest version of the tzdata, unless it is already installed and up to date. We ... Read More

Feed: Recent Announcements. Now you can easily setup monitoring, alarms and dashboards for your Microsoft SQL Server Failover Cluster Instances (FCI) running on AWS and for applications using FSx managed storage with CloudWatch Application Insights. CloudWatch Application Insights is a capability that helps customers monitor and troubleshoot their enterprise applications running on AWS resources. The new feature adds automatic discovery of the database and managed storage, the FCI configuration and the underlying resources along with setting up the metrics, telemetry and logs for monitoring its health and wellness.  With the addition of SQL Server FCI, customers now have an easy ... Read More

Feed: Planet PostgreSQL. Hmm, let's think. The DELETE statement is able to return data to us as if it were a SELECT statement via the RETURNING clause, however DELETE lacks a LIMIT clause, nor can we take row locks on it explicitly. That said, we can use the USING clause to join to itself and get both limits and row locks. This gives us a final query as follows: DELETE FROMqueue_tableUSING (SELECT * FROM queue_table LIMIT 10 FOR UPDATE SKIP LOCKED) qWHERE q.id = queue_table.id RETURNING queue_table.*; We are using the self-join method of deletion here with a subquery to both lock the underlying rows being returned, as well as deleting the rows and returning all ... Read More

Feed: O'Reilly Media, Inc. Upcoming Titles. Author: O'Reilly Media, Inc.. Learning by doing is the best way to grasp new technologies With interactive learning, teams get hands-on experience with tech like Kubernetes, Python, Docker, Java, and more—in safe live dev environments. So they’re more comfortable putting it to work in real-world situations ... Read More

Feed: AWS Big Data Blog. Increasingly, a business’s success depends on its agility in transforming data into actionable insights, which requires efficient and automated data processes. In the previous post – Build a SQL-based ETL pipeline with Apache Spark on Amazon EKS, we described a common productivity issue in a modern data architecture. To address the challenge, we demonstrated how to utilize a declarative approach as the key enabler to improve efficiency, which resulted in a faster time to value for businesses. Generally speaking, managing applications declaratively in Kubernetes is a widely adopted best practice. You can use the same ... Read More

Feed: R-bloggers. Author: tomaztsql. [This article was first published on R – TomazTsql, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. From the previous two blog posts: We have looked into the installation process of Node.js, setup of Microsoft SQL Server and made couple of examples on reading the data from database through REST API and how to insert data back to database. In this post, we will be looking the R predictions ... Read More

Feed: Recent Announcements. Amazon RDS for SQL Server now includes enhancements to the Auto Minor Version Upgrade feature for Amazon RDS for SQL Server database instances. Auto Minor Version Upgrade is a feature that you can enable to have your database automatically upgraded when a new minor database engine version is available. You can now easily see when a minor version upgrade is scheduled to be applied to your database instance in the AWS Console or through the DescribePendingMaintenanceActions API. You can also choose to apply an available minor version upgrade immediately with a few clicks or via the ApplyPendingMaintenanceAction ... Read More

Feed: AWS Architecture Blog. This blog post was co-written by Sudhir Amin, Sr. Solution Architect, AWS, and David Bermingham, Senior Technical Evangelist, SIOS Technology, Inc. To ensure high availability (HA) of Microsoft SQL Server in Amazon Elastic Compute Cloud (Amazon EC2), there are two options: Always On Failover Cluster Instance (FCI) and Always On availability groups. With a wide range of networking solutions such as VPN and AWS Direct Connect, you have options to further extend your HA architecture to another AWS Region to also meet your disaster recovery (DR) objectives. You can also run asynchronous replication between Regions, or ... Read More