Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. PostgreSQL supports multiple concurrent users and can handle complex database operations without downtime or data loss. What is PostgreSQL used for?

Open Source 77

Open Source Healthcare Social Media Database 77

SQL Performance

MARCH 17, 2020

This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. Test Environment. I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time.

Servers 86

Servers Tuning Database Efficiency 86

Adrian Cockcroft

MARCH 21, 2020

AB Testing?—?So The first thing I found was that every user visible change we made went through an A/B test. An oft-quoted study by Microsoft Bing found that of the changes they test, one-third prove effective, one-third have neutral results, and one-third have negative results. You need an “abtest” database service.

Testing 52

Testing Tuning Database Cache 52

HammerDB

JULY 17, 2019

From the previous post we now have source and binary copies of HammerDB for modification and test. The next step is to see if there is an Issue already created for the database we want to add or whether we should create one. You can now begin modifying the source to add your database. <? . <mariadb> xml version="1.0"

Database 40

Database C++ Testing Metrics 40

Dynatrace

JANUARY 20, 2020

Having released this functionality in a Preview Release back in October 2019, we’re now happy to announce the General Availability of our SAP ABAP real user monitoring. Was it the server, the network, or the database that caused the degraded response time? You can test-drive both extensions today! Dynatrace news.

Monitoring 152

Monitoring Performance Infrastructure Network 152

Percona

MARCH 7, 2019

2019-02-22T18:26:25 Creating triggers. 2019-02-22T18:27:14 Created triggers OK. 2019-02-22T18:27:14 Copying approximately 4924071 rows. clients`: 94% 00:24 remain 2019-02-22T18:34:15 Copied rows OK. 2019-02-22T18:34:15 Analyzing new table. 2019-02-22T18:34:15 Swapping tables. Have realistic load tests.

C++ 99

C++ Traffic Servers Monitoring 99

SQL Performance

MARCH 29, 2022

For the time being, let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14. Database compatibility is set to 150, and the cost threshold for parallelism is set to 50 to avoid parallelism for now: ALTER DATABASE SCOPED CONFIGURATION. [ text ] LIKE '%SomeValue%Test%'.

Cache 90

Cache Servers Database Testing 90

The Netflix TechBlog

OCTOBER 19, 2020

In 2019 our stunning colleagues in the Cloud Database Engineering (CDE) team benchmarked EBS performance for our use case and migrated existing clusters to use EBS Elastic volumes. This allowed us to increase total storage capacity without adding a new Cassandra node to the existing cluster. What’s next?

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

Scalegrid

SEPTEMBER 16, 2019

PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. PostgreSQL is the fourth most popular database management system in the world, and heavily used in all sizes of applications from small to large. Why Use a GUI Tool? pgAdmin Cost: Free (open source).

Open Source 262

Open Source Database Azure Cloud 262

Apica

MAY 10, 2019

2019 will go down as the year when giants collided over who is streaming the right content to win the growing market demand and dollars. Whatever size of company you are, performance monitoring and testing is a critical part of the success you will have. million Netflix users as of Q3 2018. Apica’s scale is enterprise-grade.

Testing 40

Testing Performance Social Media Wireless 40

SQL Performance

JUNE 14, 2019

In my examples I’ll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. In this article I focus on four classic common bugs: COUNT(*) in outer joins, double-dipping aggregates, ON-WHERE contradiction and OUTER-INNER join contradiction. custid , C.

Best Practices 93

Best Practices C++ Database Processing 93

SQL Performance

AUGUST 27, 2021

The instance-wide versioning timestamp is incremented whenever a new statement or batch begins, or a new version of a record is created, in any database where either form of snapshot isolation is enabled. I haven’t tested this, but it’s exactly the same mechanism I’ve described above, so it seems likely.

Database 56

Database Storage Availability Servers 56

SQL Performance

APRIL 13, 2022

It’s based on a question from a public database forum. To test the performance of your solution, you’ll need to populate the table with larger volumes of sample data. numgroups AS INT = 1000 , @rowspergroup AS INT = 10000 , -- test with 1000 to 10000 here. In my performance test, it took this solution 3.68

C++ 136

C++ Strategy Testing Servers 136

SQL Performance

DECEMBER 9, 2020

In a comment to my article, Marcos Kirchner mentioned that he tested my solution with varying table value constructor cardinalities, and got different execution times for the different cardinalities. Testing different base table cardinalities is just one dimension to try. You can create supporting tables in the user database if needed.

C++ 114

C++ Servers Testing Processing 114

O'Reilly

MAY 25, 2021

There have also been colorful conversations about whether GPT-3 can pass the Turing test, or whether it has achieved a notional understanding of consciousness, even amongst AI scientists who know the technical mechanics. Note that the dataset on which GPT-3 trained terminated around October 2019. Among other things.

Social Media 138

Social Media Media Internet Internet 138

Scalegrid

NOVEMBER 25, 2019

ScyllaDB is an open-source distributed NoSQL data store, reimplemented from the popular Apache Cassandra database. We’ve heard a lot about this rising database from the DBA community and our users, and decided to become a sponsor for this years Scylla Summit to learn more about the deployment trends from its users.

Big Data 187

Big Data Database Open Source Azure 187

Smashing Magazine

OCTOBER 29, 2018

2019-04-29T18:34:58+00:00. For a typical site, that might involve routing the request to the correct part of the application, authenticating the request, making multiple calls to backend systems such as databases and so on. Measuring Performance With Server Timing. Measuring Performance With Server Timing. Drew McLellan.

Servers 87

Servers Performance Metrics Database 87

SQL Performance

MAY 11, 2022

In my examples, I’ll use the sample database PerformanceV5. You can download the source code to create and populate this database here. I ran all the examples on SQL Server ® 2019 Developer, where batch-mode on rowstore is available. Environment for Demos. I’ll remind you at the end.

C++ 133

C++ Database Servers Code 133

HammerDB

JULY 8, 2019

HammerDB already has 2 interfaces with which to interface with the commands to build and test databases using the GUI interface or CLI. The following test script shows how this interaction can be done also including deliberate errors to demonstrate error handling. From HammerDB version 3.2 hammerdbws HammerDB Web Service v3.2

Benchmarking 40

Benchmarking Virtualization C++ Database 40

SQL Performance

DECEMBER 9, 2020

In a comment to my article, Marcos Kirchner mentioned that he tested my solution with varying table value constructor cardinalities, and got different execution times for the different cardinalities. Testing different base table cardinalities is just one dimension to try. You can create supporting tables in the user database if needed.

C++ 61

C++ Servers Testing Processing 61

KeyCDN

MARCH 14, 2019

Here is a roundup of front end web development trends to keep an eye on in 2019. Frontend Frameworks If you’re not using a frontend framework like React, Vue.js, or Angular to help build your projects, then 2019 is a good year to start. IBM, Microsoft, and Amazon are all exploring new ways to use blockchains in 2019.

Development 101

Development Blockchain Serverless Social Media 101

Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 73

Open Source Database Storage Scalability 73

Alex Russell

JUNE 22, 2022

Defenders of Apple's monopoly offer hard-to-test claims, but many boil down to the idea that Apple's product is inferior by necessity. This will, in turn, cause developers to skimp on testing for Safari, making it inevitable that browsers based on WebKit and other minority engines cannot compete. Or so the theory goes.

Engineering 110

Engineering Traffic Government Google 110

Percona

JULY 15, 2023

One very common problem when trying to optimize a database environment is index usage. Introduction to MySQL Indexes Indexes in MySQL are database structures used to optimize data retrieval speed and efficiency. Need help managing complex database environments? This structure makes for faster data access.

Virtualization 76

Virtualization Speed Database Efficiency 76

Scalegrid

JULY 17, 2020

Why should a relational database even care about unstructured data? JSON database in 9.2 It is useful to validate incoming JSON and store in the database. Wave 3: PostgreSQL 12 (2019) added support for SQL/JSON standard and JSONPATH queries. JSONB Patterns & Antipatterns. JSONB Data Structures. JSONB Indexes.

Storage 321

Storage Database Efficiency Processing 321

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. Then, you will probably want to continue reading this section and test the code that I use as I revisit key unnesting examples that I previously demonstrated with derived tables and convert them to use CTEs. Figure 5: Execution plan for Query 5.

C++ 140

C++ Servers Code Efficiency 140

Scalegrid

AUGUST 15, 2019

In this article, we are going to compare 6 of the top MongoDB Graphical User Interfaces that help developers increase their productivity and manage their database. Read on to find out which is the best MongoDB GUI for you, updated for 2019, that contain these key features: A good visual editor to write and edit queries faster.

Database 40

Database Servers Monitoring Availability 40

Dynatrace

SEPTEMBER 23, 2021

In 2019, Gartner reported that 30% of organizations worldwide were running containerized applications. Four types of tools are commonly used to detect software vulnerabilities: Source-code tests that are used in development environments. Source code tests. Run source code tests. Dynatrace news. Manage secrets.

Open Source 243

Open Source Benchmarking Best Practices Network 243

Testsigma

NOVEMBER 16, 2021

We shall also see how decisions are made in an enterprise and why cross-browser testing is the most important thing in 2021 to sustain a healthy business. In the summer of 2019, British Airways faced a technical issue on its website. Throughout this post, we shall see how enterprises behave and what makes them an “ enterprise ”.

Testing 52

Testing Website Small Business Internet 52

Percona

SEPTEMBER 1, 2023

This blog was originally published in February 2019 and was updated in September 2023. Web applications rely on databases to run the internet, powering everything from e-commerce platforms to social media networks to streaming services. This affects the type and range of characters that can be inserted into the column.

Performance 52

Performance Storage Social Media Database 52

The Morning Paper

JULY 11, 2019

View-centric performance optimization for database-backed web applications Yang et al., To associate costs with the queries Panorama can use dynamic profiling if a suitable test suite is available. you are doing the count in the database, right?). cant portion of the page load time. (In

Database 47

Database Performance Speed Servers 47

The Netflix TechBlog

MAY 14, 2021

Once you finally find useful identifiers, you may begin writing SQL queries against your production database to find out what went wrong. Early prototypes and load tests validated that the offering could meet our needs. However, they are scattered across multiple systems, and there isn’t an easy way to tie related messages together.

Traffic 160

Traffic Latency Java Google 160

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking. The HammerDB name.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. Microsoft SQL Server Database Engine Input/Output Requirements. Val and Dylan performing power outage durability testing and adding new tests. The Back Story. 4 Socket, TPCC.

Servers 90

Servers Media Cache Storage 90

Smashing Magazine

JULY 16, 2019

2019-07-16T14:30:59+02:00. 2019-07-16T14:35:52+00:00. Web scraping is a way to grab data from websites without needing access to APIs or the website’s database. You should see an output like this: 2019-05-02 14:39:31 [scrapy.utils.log] INFO: Scrapy 1.6.0 The Ultimate Guide To Building Scalable Web Scrapers With Scrapy.

Scalability 87

Scalability Website C++ Servers 87

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 82

Availability Open Source Architecture Database 82

SQL Performance

MAY 20, 2022

As in previous parts, most code examples use the Stack Overflow 2010 database on SQL Server 2019 CU 16 with the following additional nonclustered index: CREATE INDEX [ IX dbo. Names of tables and columns haven’t been resolved to database objects yet, and no type information is available. EXECUTE sys. sp_configure.

Cache 55

Cache Database Servers Testing 55