Remove Case Study Remove Database Remove Metrics Remove Traffic
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. With that we decided to look into MySQL metrics. We needed to reduce the high CPU usage on MySQL. It was running from 500 to 800 QPS (queries per second). Increase QPS by 2x.

C++ 101
article thumbnail

How to Estimate Web Performance Impact Before Making Fixes

Jos

Web Performance is important for user experience and business metrics. Look, there are many case studies proving a correlation between loading time and business metrics!” ?-?I Plotting Business Metrics vs Performance Metrics Think about what you are trying to drive on your existing site.

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

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
article thumbnail

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

Speed Curve

However, that pesky 20% on the back end can have a big impact on downstream metrics like First Contentful Paint (FCP), Largest Contentful Paint (LCP), and any other 'loading' metric you can think of. db = Duration of the request processing spent querying the database. That performance golden rule still holds true today.

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

Fostering a Web Performance Culture

Jos

One could argue this is a metric-driven decision. When they dug into the data, they found that the reason load times had increased was that they got a lot more traffic from Africa after doing the optimizations. How would you architecture a non-trivial size web project (client, server, databases, caching layer)?

article thumbnail

Probabilistic Data Structures for Web Analytics and Data Mining

Highly Scalable

On the other hand, when one is interested only in simple additive metrics like total page views or average price of conversion, it is obvious that raw data can be efficiently summarized, for example, on a daily basis or using simple in-stream counters. This opportunity is leveraged in the following case study. Case Study.

Analytics 191