Percona
MAY 1, 2023
The innodb_io_capacity_max parameter was set to 2000, so the hardware should be able to deliver that many IOPS without major issues. Results in CloudWatch show we were right: The reduction during the last couple of weeks is more than 50% of IOPS, which is pretty decent now, and we haven’t changed the hardware at all.
Percona
MARCH 27, 2023
The percentage in degradation will vary depending on many factors {hardware, workload, number of tables, configuration, etc.}. Disclaimer : This blog post is meant to show a less-known problem but is not meant to be a serious benchmark. Setup The setup consists of creating 10K tables with sysbench and adding 20 FKs to 20 tables.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Percona
JANUARY 19, 2023
With hardware being more powerful and cheaper, and the technology evolving, now it is easier than ever to manage large tables in MySQL. 1 mysql mysql 592K Dec 30 02:48 tb1.ibd ibd -rw-r --. 1 mysql mysql 464K Dec 30 02:48 tb2.ibd ibd -rw-r --. 1 mysql mysql 464K Dec 30 02:48 tb3.ibd ibd -rw-r --. 1 mysql mysql 464K Dec 30 02:48 tb4.ibd
PDC
NOVEMBER 9, 2018
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. Table 1: Strong scaling for Julia set generator code. Table 2: Weak scaling for Julia set generator code.
SQL Server According to Bob
JANUARY 11, 2020
Books Online (BOL) References: All BOL references cited in this paper are taken from the Microsoft SQL Server 2000 Books Online site (updated to include SP3 functionality), which can be found at: [link] Click the Product Documentation link. SQL Server 2000/7.0 data pages are 8 KB in size.
The Agile Manager
APRIL 30, 2020
Both the financial and real economies have suffered quite a few shocks in the last 20 years: the dot-com bubble bursting (2000); September 11 (2001); the Great Recession (2008); and today in 2020 the COVID-19 crisis is wreaking economic havoc. The tech economy suffered greatly in the wake of the dot-com bubble bursting in 2000.
SQL Server According to Bob
JUNE 3, 2016
On the same hardware/machine repeat steps 1 thru 3 using an instance of SQL Server 2016 CTP 3.0 iID int NOT NULL IDENTITY(1,1) PRIMARY KEY CLUSTERED, strData nvarchar(2000) NOT NULL. ). insert into tblDBCC (strData) values ( replicate(N’X’, 2000) ). Paste the script below in a new query window. or newer release.
Expert insights. Personalized for you.
118 
Let's personalize your content