Tag: Cache

Feed: Redis Labs. Author: Kyle Davis. Lua scripting is a hugely powerful feature of Redis. At the same time, though, Lua scripting can be tricky to “get right.”  There are many ways to run a script that works most of the time, which can also be articulated as a script that fails some of the time. Let’s take a look at a Lua scripting corner case in Python with RedisPy where your script can fail despite doing what looks correct. Of course, at the end, we’ll show you the bullet-proof way to do it when you need everything to always ... Read More

Feed: Planet PostgreSQL. The PostgreSQL caching system has always been a bit of a miracle to many people and many have asked me during consulting or training sessions: How can I figure out what the PostgreSQL I/O cache really contains? What is in shared buffers and how can one figure out? This post will answer this kind of question and we will dive into the PostgreSQL cache.Creating a simple sample databaseBefore we can inspect shared buffers we have to create a little database. Without data the stuff we are going to do is not too useful: [email protected] ~ % createdb ... Read More

Feed: R-bloggers. Author: Data Enthusiast's Blog. [This article was first published on Data Enthusiast's Blog, 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. Back to Working with Statistics Canada Data in R, Part 3. What is cancensus In the Introduction to the “Working with Statistics Canada Data in R” series, I discussed the three main types of data available from Statistics Canada. It is now time to move on to the second of ... Read More

Feed: Sander Knape on Sander Knape. Table of Contents Hosting static websites is great. As they only contain static assets to be downloaded by the visitor's browser - think HTML, CSS, Javascript, Fonts, images - no server-side code such as Java or PHP needs to be run. They're therefore typically faster to load than dynamic websites, they have a smaller attack surface, and are easier to cache for even better performance. That is why some time ago I moved this blog from a Wordpress installation hosted on EC2 to a static website. As I was already in AWS, and I ... Read More

Feed: SAS Blogs. Author: Gerry Nelson. Administrators like to be able to keep track of resource usage and who is using what in a system. When an administrator has this capability, they can look out for issues of high resource usage that may have an impact on overall system performance. In Viya, data is accessed in caslibs. In this post, I will show you how an administrator can track and control resource usage of personal caslibs. A Caslib is an in-memory space to hold tables, access control lists, and data source information. In GEL enablement classes as we have discussed ... Read More

Feed: Planet PostgreSQL. As hardware and software evolve, the bottlenecks in a database system also shift. Many old problems might disappear and new types of problems pop-up.Old LimitationsThere were days when CPU and Memory was a limitation. More than a decade back, servers with 4 cores were “High End” and as a DBA, my biggest worry was managing the available resources. And for an old DBA like me, Oracle’s attempt to pool CPU and Memory from multiple host machines for a single database using RAC architecture was a great attempt to solve it.Then came the days of storage speed limitations ... Read More

Feed: R-bloggers. Author: R by R(yo). [This article was first published on R by R(yo), 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. RStudio::Conference 2020 was held in San Francisco, California and kickstarted a new decade for the R community with a bang! Following somegreat workshops on a wide variety of topics such as JavaScript forShiny Users toDesigning the Data ScienceClassroomthere were two days full of great talks as well as the Tidyverse ... Read More

Feed: Clustrix Blog. Author: Anders Karlsson. The MariaDB Server Query CacheThe Server Query Cache (QC) is a well-known feature of MariaDB Server–it caches SQL statements and the corresponding result sets. If a subsequent query then matches a cached SQL statement, the query can reuse the result set. The Query Cache also knows to invalidate the Query Cache if a table corresponding to a cached query is modified, for example by an UPDATE. For more information, see Query Cache in the MariaDB Knowledge Base. In previous decades, amounts of RAM were limited, disks were slow, and CPUs had one core and ... Read More

Feed: Recent Announcements. This release adds the PLProfiler extension, which allows you to create performance profiles of PL/pgSQL functions and stored procedures, and upgrades pgTap to version 1.1.0. This release also allows pg_prewarm in shared_preload_libraries for PostgreSQL 11 to automatically warm up the cache at startup of the database. Amazon RDS for PostgreSQL makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud. Learn more about upgrading your database instances from the Amazon RDS User Guide. See Amazon RDS for PostgreSQL Pricing for pricing details and regional availability ... Read More

Feed: AWS Compute Blog. Author: Eric Johnson. This is the final installment of a three-part series on building a serverless URL shortener without using AWS Lambda. This series highlights the power of Amazon API Gateway and its ability to directly integrate with services like Amazon DynamoDB. The result is a low latency, highly available application that is built with managed services and requires minimal code.In part one of this series, I demonstrate building a serverless URL shortener application without using AWS Lambda. In part two, I walk through implementing application security using Amazon API Gateway settings and Amazon Cognito. In ... Read More