Remove c
article thumbnail

Transparent Huge Pages Refresher

Percona

While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we will explore THP, its impact on database servers, and how to disable it for optimal performance and stability. The concept of HugePages in Linux has existed for many years, first introduced in 2007.

article thumbnail

How To Measure the Working Set Size on Linux

Brendan Gregg

It is used for capacity planning and scalability analysis. Here is a MySQL database server (mysqld), PID 423, and measuring its working set size for 0.1 The tool also has a cumulative mode (-C), which resets the referenced flags once then takes continuous measurements. wss.pl -C `pgrep -n mysqld` 1. 102.36. [.].

Cache 71
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

How To Measure the Working Set Size on Linux

Brendan Gregg

It is used for capacity planning and scalability analysis. Here is a MySQL database server (mysqld), PID 423, and measuring its working set size for 0.1 The tool also has a cumulative mode (-C), which resets the referenced flags once then takes continuous measurements. wss.pl -C `pgrep -n mysqld` 1. 102.36. [.].

Cache 40
article thumbnail

Data Mining Problems in Retail

Highly Scalable

To a certain extent, such a high diversity of recommendation techniques is attributed to several implementation challenges like a sparsity of customer ratings, computational scalability, and lack of information on new items and customers. Heckerman, and C. DG12] How Companies Learn Your Secrets, C. Kleinberg, C.

Retail 152
article thumbnail

Egnyte Architecture: Lessons learned in building and scaling a multi petabyte content platform

High Scalability

Egnyte is a secure Content Collaboration and Data Governance platform, founded in 2007 when Google drive wasn't born and AWS S3 was cost-prohibitive. In 2007, businesses had started to become more distributed; customers were using multiple devices to access their files and there was a need to make this experience as smooth as possible.

article thumbnail

Should You Use ClickHouse as a Main Operational Database?

Percona

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. However, ClickHouse is super efficient for timeseries and provides “sharding” out of the box (scalability beyond one node).