article thumbnail

Reducing High CPU on MySQL: a Case Study

Percona

The customer had noticed a linear high CPU usage in one of their MySQL instances and was not able to figure out why as there was no much traffic hitting the app. Disclosure : For security reasons, sensitive information, such as database, table, column names have been modified and graphs recreated to simulate a similar problem.

C++ 98
article thumbnail

Aurora vs RDS: How to Choose the Right AWS Database Solution

Percona

Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? What we should really compare is the MySQL and Aurora database engines provided by Amazon RDS. How do I choose which one to use?

AWS 52
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 Estimate Web Performance Impact Before Making Fixes

Jos

Look, there are many case studies proving a correlation between loading time and business metrics!” ?-?I The reason why Rel mCvR can be a good metric is that it is not influenced by changes in traffic (eg seasonality or promotional campaigns). What is the business opportunity for web performance improvements?

article thumbnail

How Data Inspires Building a Scalable, Resilient and Secure Cloud Infrastructure At Netflix

The Netflix TechBlog

Can we adjust our auto-scaling policies to be more efficiency without risking our availability during traffic spikes? Reliability How can we guarantee that a code change will be safe when rolled out to our production environment? Capacity and Efficiency Which resources (clusters, tables, …) are unused or under-utilized and why?

article thumbnail

How to use Server Timing to get backend transparency from your CDN

Speed Curve

For example, processing of web application firewall (WAF) rules, detecting bots or other malicious traffic though security services, and growing in popularity, edge compute. db = Duration of the request processing spent querying the database. This can include a lot of different service layers, not just serving from cache.

Servers 57
article thumbnail

How We Optimized Performance To Serve A Global Audience

Smashing Magazine

It increases our visibility and enables us to draw a steady stream of organic (or “free”) traffic to our site. While paid marketing strategies like Google Ads play a part in our approach as well, enhancing our organic traffic remains a major priority. The higher our organic traffic, the more profitable we become as a company.

article thumbnail

Probabilistic Data Structures for Web Analytics and Data Mining

Highly Scalable

Frequencies of 100 most frequent elements can be estimated with 4% precision using Count-Min Sketch structure that uses about 48KB (12k integer counters, based on the experimental result), assuming that data is skewed in accordance with Zipfian distribution that models well natural texts, many types of web events and network traffic.

Analytics 191