article thumbnail

Scalability: strong and weak scaling

PDC

In such scenarios, scalability or scaling is widely used to indicate the ability of hardware and software to deliver greater computational power when the amount of resources is increased. In this post we focus on software scalability and discuss two common types of scaling. speedup = t 1 / t N. Some key points are summarized below.

article thumbnail

Fixing Misplaced Rows in a Partitioned Table

Percona

mysql> SELECT * FROM salaries where emp_no=10001 and from_date='1999-06-23'; + --+ --+ + + | emp_no | salary | from_date | to_date | + --+ --+ + + | 10001 | 84917 | 1999-06-23 | 2000-06-22 | + --+ --+ + + 1 row in set (0.00 sec) But once the data is misplaced, it does not return any rows. Try Percona Distribution for MySQL today!

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

In-product guidance accelerates Service Level Objectives (SLO) setup for confident deployments

Dynatrace

The flip side of speeding up delivery, however, is that each software release comes with the risk of impacting your goals of availability, performance, or any business KPIs. Dynatrace offers more than 2000 different metrics that are ready for use as dedicated SLIs. Choose from a range of ready-to-use SLO use cases.

Metrics 151
article thumbnail

Powering the Web: Two Decades of Open Source Publishing With WordPress and MySQL

Percona

MySQL was founded in 1995 and went open source in 2000. MySQL was the database for phpWebLog, for example, way back in 2000. Two great tastes that go great together MySQL was around long before WordPress, and WordPress wasn’t the first CMS to use MySQL. But WordPress brought MySQL and open source to the masses.

article thumbnail

Dealing With “Too Many Connections” Error in MySQL 8

Percona

21 Percona Server (GPL), Release 21, Revision c59f87d2854 Copyright (c) 2009-2022 Percona LLC and/or its affiliates Copyright (c) 2000, 2022, Oracle and/or its affiliates. 21 Percona Server (GPL), Release 21, Revision c59f87d2854 Copyright (c) 2009-2022 Percona LLC and/or its affiliates Copyright (c) 2000, 2022, Oracle and/or its affiliates.

C++ 89
article thumbnail

Impact of Querying Table Information From information_schema

Percona

Percona Distribution for MySQL is the most complete, stable, scalable, and secure open-source MySQL solution available, delivering enterprise-grade database environments for your most critical business applications… and it’s free to use! While you are on 5.7, Try Percona Distribution for MySQL today!

Cache 97
article thumbnail

Purging Data When the Table Is Big and Has Children Tables

Percona

Still, my friend, the most important thing is the availability of the data, integrity, and good response times. Finally, remove the data from the originally required table. This process may take longer than a simple and traditional DELETE. sql.gz | mysql -h 192.168.0.70 test -A [percona@PS8_Replica Backup]$ zcat test.exceptions.00000.sql.gz

Testing 94