Percona

OCTOBER 10, 2023

Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates. Type 'c' to clear the current input statement. mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 Type 'c' to clear the current input statement. drop_triggers:10000:0.25,copy_rows:10000:0.25,swap_tables:10000:0.25,update_foreign_keys:10000:0.25,analyze_table:10000:0.25

Database 114

Database Performance C++ Engineering 114

CSS Wizardry

NOVEMBER 3, 2020

I can see from the screenshot above that TTFB is my most stable metrics—no one page appears to have particularly expensive database queries or API calls on the back-end. Given that render blocking resources reside in the head of the document, this implies differing head tags on that page.

Speed 328

Speed Ecommerce Metrics Analytics 328

Scalegrid

JUNE 18, 2019

In this blog, we’ll show you how to connect to a MongoDB server configured with self-signed certificates for SSL using both the Ruby MongoDB driver and the popular Object-Document-Mapper (ODM) mongoid. The connection options available for the driver are documented here , and the options we will need are: :ssl. ssl_verify.

C++ 100

C++ Servers Database Testing 100

Percona

MARCH 8, 2023

Over the years of being a DBA, I had to deal with all kinds of problems in the database. Still, the users keep falling into this trap, maybe because of a poorly configured database, a change in the application components, or just because of a sudden increase of connections in the application. A lot has been written about this error.

C++ 114

C++ Database Servers Open Source 114

SQL Performance

OCTOBER 9, 2019

The relevance to T-SQL is that sometimes we assume that we know everything there is to know about certain T-SQL features, and don't always bother checking the documentation to see if there's more to them. In my examples I'll use a sample database called TSQLV5. EOMONTH has a second parameter.

C++ 111

C++ Database Servers Code 111

SQL Performance

AUGUST 12, 2020

In my examples I’ll use a sample database called TSQLV5. So it could be that the term originated in one of the database products and later adopted by some of the other database vendors. So it could be that the term originated in one of the database products and later adopted by some of the other database vendors.

C++ 140

C++ Code Design Database 140

Percona

JULY 5, 2023

Long database service downtime Some queries become slow Applications stop working due to incompatibilities Data loss This is what can happen if MySQL’s major upgrade to 8.0 You cannot load a dump of the MySQL system database from MySQL 8.0 Default database: 'test'. EOL is set for the end of October 2023. and restore to 5.7

C++ 136

C++ Database Servers Testing 136

Scalegrid

JANUARY 19, 2024

For example, memory-resident databases without persistent disks, such as Redis cluster setups or Apache Spark installations, rely on stand-alone machines. To traditional relational databases, where rollbacks are less likely to cause data loss, MongoDB differs significantly.

Database 130

Database Network Servers Monitoring 130

Percona

DECEMBER 7, 2023

For additional details on how to run an instance in a Docker environment, refer to this section in Percona Documentation : sudo docker run --name percona-server-8.1 -v Add data to the database Let’s add some data to the Percona Server database. Create a test database and add a table t1 inside with five rows.

C++ 111

C++ Servers Open Source Database 111

Percona

DECEMBER 29, 2022

While working as a DBA, we perform many regular tasks, and one of them is upgrading our database systems. There are some techniques to perform a PostgreSQL database upgrade, such as data dump and import, logical replication, or in-site upgrade using pg_upgrade. for lib in $(psql -qtA pgbench -c"select extname||'.so'

C++ 84

C++ Open Source Database Programming 84

Percona

OCTOBER 17, 2023

When multiple operations, such as reads and writes, attempt to access the database concurrently, WiredTiger uses tickets to ensure these operations do not conflict in a way that would compromise data integrity or performance. Stricter downgrade policy The upstream documentation highlights the following: Starting in MongoDB 7.0,

Metrics 120

Metrics C++ Database Storage 120

HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. HammerDB has always used stored procedures as a design decision because the original benchmark was implemented as close as possible to the example workload in the TPC-C specification that uses stored procedures. What is a stored procedure?

Benchmarking 63

Benchmarking Database Network C++ 63

Highly Scalable

JUNE 5, 2012

Intersection of sorted lists is a cornerstone operation in many applications including search engines and databases because indexes are often implemented using different types of sorted structures. Performance of this procedure both in C and Java will be evaluated in the last section.

C++ 102

C++ Java Performance Testing Efficiency 102

Percona

JULY 19, 2023

Well, “easy” if you know just a tiny bit of C++. Our function will implement a ULID generator using a C++ library from ChrisBove/ulid. 132:39: warning: unused parameter ‘initid’ [-Wunused-parameter] extern "C" void ulid_deinit(UDF_INIT *initid) {} ~~~~~~~~~~^~~~~~ [100%] Linking CXX shared module././plugin_output_directory/ulid.so

C++ 98

C++ Servers Benchmarking Best Practices 98

Percona

DECEMBER 29, 2023

Not everything can be addressed on the database side. Human factor: In an ideal case, there must be stringent restrictions and enforcement on what load and number of connections can be onboarded to the Database. App-Dev often demands unrestricted, uncontrolled access to the database. However, gatekeeping is not an easy job.

Servers 107

Servers Database C++ Airlines 107

Percona

SEPTEMBER 28, 2023

Therefore, disabling Transparent Huge Pages for database servers is advisable to avoid this situation. If you haven’t, please install it ( Percona Toolkit documentation ). This process can result in a significant amount of IO usage, which can be particularly problematic when running a database on that mount point.

Servers 128

Servers Best Practices Database Open Source 128

Percona

JUNE 7, 2023

Triggers on Data Definition Language (DDL) events are a powerful feature of PostgreSQL that allows you to perform additional actions in response to changes to the database schema. DDL events include operations such as CREATE, ALTER, and DROP statements on tables, indexes, and other database objects.

Database 109

Database Best Practices Open Source Testing 109

O'Reilly

DECEMBER 12, 2023

RAG takes your prompt, loads documents in your company’s archive that are relevant, packages everything together, and sends the prompt to the model. They make it possible to search for relevant or similar documents.) It relies on the model for language and grammar, but derives the content from the documents included in the prompt.

Artificial Intelligence 134

Artificial Intelligence Google Media Processing 134

Percona

AUGUST 18, 2023

Why not just create another database on the same instance? We split databases by function/team to give each team full autonomy over their schema, And if someone screws up, it breaks their cluster, not all databases. So you put multiple MySQL servers on a single machine instead of multiple databases inside one MySQL instance.

Programming 98

Programming Servers Database Open Source 98

Percona

AUGUST 30, 2023

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. Database level setting All options discussed so far have a global scope. But there could be reasons why a PostgreSQL user wants to change that at a specific database level.

Database 120

Database Servers Open Source Tuning 120

Percona

APRIL 17, 2023

Still, as DBA, you want to use Percona Monitoring and Management (PMM) for better database insights and maintain a common policy of Datadog as a standard alerting or high-level observability tool. We’ll use here “up” metrics for different databases to reflect database status. 1 Complete!

Monitoring 98

Monitoring Metrics Database Open Source 98

HammerDB

DECEMBER 5, 2020

compared to previous releases is that the workload names have changed from TPC-C and TPC-H to TPROC-C and TPROC-H respectively and therefore a key question is how are the v4.0 The simple answer is nothing, the workloads are exactly the same workloads derived from the TPC-C and TPC-H specifications and HammerDB v4.0

C++ 40

C++ Benchmarking Virtualization Open Source 40

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

Brendan Gregg

AUGUST 26, 2021

I spend many hours documenting advanced debugging stories for books, talks, and blog posts, but many things I never have time to share. usr/share/apport/apport %p %s %c %d %P # mkdir /var/cores. Hit Ctrl-C to end. ^C config/Slack/Service Worker/Database/000004.log It usually happened when locking and unlocking the screen.

Storage 141

Storage C++ Processing Database 141

Percona

NOVEMBER 9, 2023

For generating load, we used pgbench with the following commands: shell> pgbench -i -s 100 sbtest shell> pgbench -c 8 -j 3 -T $((60*60*4)) -N -S -P 1 sbtest Creating a custom query collector Note: This step will not be needed with soon-to-come postgresql_exporter PMM versions! Let us know if you have any comments on it.

Monitoring 125

Monitoring Tuning Metrics Servers 125

Percona

OCTOBER 12, 2023

The documentation mentions that the supported languages to profile are Go, Java (any JVM-based language), Python, Ruby, and NodeJS. MySQL is not written in NodeJS, but we specify –lang node to launch the perf profiler, which is compatible with C/C++. Then, the pod is deleted. Try Percona Distribution for MySQL today!

Code 124

Code Tuning C++ Benchmarking 124

Percona

AUGUST 21, 2023

The environment The Proof Of Concept described in this document consists of a single stand-alone server: Linux OS, Ubuntu 18.04 A self-signed Certificate Authority, CA, exists on the host and has signed the aforementioned Postgres and LDAP certificates. Host name: my-ldap PostgreSQL version 14 OpenLDAP version 2.4.45

C++ 98

C++ Servers Open Source Testing 98

SQL Performance

AUGUST 1, 2022

I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here. 75 Test XYZ Student C 55 Test XYZ 77.5 According to the documentation, the error margin is 1.33% (based on ranks not values) within a 99% confidence. The Distinct Predicate.

Servers 142

Servers Testing C++ Code 142

SQL Performance

DECEMBER 11, 2019

Even among people who do have a good grasp of relational theory and SQL, you will hear very strong opinions both in favor and against using NULLs in your database. 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.

Best Practices 117

Best Practices C++ Database Code 117

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 63

Benchmarking Open Source C++ Cache 63

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. All the databases that HammerDB tests implement a form of MVCC (multi-version concurrency control). On high-performance multi-core systems all the supported databases can return performance in the many millions of transactions per minute.

Programming 68

Programming Benchmarking Virtualization C++ 68

SQL Performance

OCTOBER 29, 2019

In order to use Query Store and Extended Events, you have to configure them in advance – either enabling Query Store for your database(s), or setting up an XE session and starting it. CustomerID , c. Customers c JOIN Sales. CustomerTransactions ct ON c. GROUP BY c. CustomerID , c. CustomerID = ct.

C++ 74

C++ Database Servers Tuning 74

Scalegrid

FEBRUARY 15, 2024

In a world where data security is essential, enabling MongoDB SSL is critical in fortifying your database. Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections.

Servers 130

Servers Best Practices Government Network 130

HammerDB

NOVEMBER 22, 2021

HammerDB included a graphical performance metrics view for the Oracle database only. HammerDB includes the same functionality for PostgreSQL enabling the user to drill down on database metrics in real time. usr/bin/install -c -m 644./pg_stat_statements--1.4.sql./pg_stat_statements--1.8--1.9.sql./pg_stat_statements--1.7--1.8.sql./pg_stat_statements--1.6--1.7.sql./pg_stat_statements--1.5--1.6.sql./pg_stat_statements--1.4--1.5.sql.

Metrics 63

Metrics Benchmarking C++ Database 63

HammerDB

OCTOBER 17, 2018

This is a very typical FAQ and although detailed in the documentation some extra details may help in sizing and configuration. The official TPC-C test has a fixed number of users per warehouse and uses keying and thinking time so that the workload generated by each user is not intensive.

C++ 40

C++ Testing Virtualization Cache 40

Percona

JANUARY 28, 2019

Let’s look at the original query: SELECT p.title FROM so.posts p INNER JOIN so.comments c ON p.id = c.postid WHERE c.score > 2 GROUP BY p.id As MySQL’s documentation states: “In some cases, MySQL cannot use indexes to resolve the ORDER BY, although it may still use indexes to find the rows that match the WHERE clause.

Monitoring 62

Monitoring C++ Tuning Analytics 62

SQL Performance

JULY 1, 2021

Let's create a simple database with a few tables: CREATE DATABASE BadIdeas ; GO. name , [ Column ] = c. name , [ Data Type ] = TYPE_NAME ( c. system_type_id <> c. THEN N' (' + TYPE_NAME ( c. columns AS c INNER JOIN sys. objects AS o ON c. [ USE BadIdeas ; GO.

C++ 58

C++ Database Servers Performance 58