Questions tagged [optimization]

Optimization is the process of modifying a system to make some aspect of it work more efficiently or use fewer resources.

A system may be optimized so that it executes more rapidly, or is capable of operating with less memory storage or other resources, or draw less power. The optimized system will typically only be optimal in one application or for one audience. For example, one might reduce the amount of time a task takes to perform at the price of making it consume more memory.

339 questions
1
vote
1 answer

How to reduce MySQL Server CPU usage or load?

How to reduce MySQL Server CPU usage or load ? Here is my.cnf…
linuxpro
  • 11
  • 1
1
vote
0 answers

Wordpress UPDATE queries on MySQL database stuck

I have an Amazon 24XL server 96 Cores 378 GB RAM Database size 5.7G Debian GNU/Linux 9 (stretch) PHP 7.3.16 mysql Ver 15.1 Distrib 10.3.22-MariaDB I have only one WordPress site where users read articles, there are 4-5 small plugins One plugins…
Naqi
  • 21
  • 3
0
votes
1 answer

Where is my bottleneck: RAM, CPU or disk?

I have a 32 core, 64 thread, 128GB RAM system with internal SSD. I'm running 64 data mining/simulation jobs in parallel that each load 1GB from disk and run for about 5-10 minutes . I want to know if I'm bottlenecked by CPU, disk or RAM. I have the…
0
votes
3 answers

Fastest possible configuration for a local MySQL database, no security needed?

We have a local Optiplex PC setup to run our shared MySQL MariaDB database with no way to access it from the outside world. It doesn't have any critical data that needs to be protected. Basically, no security, encryption or administration needed.…
Ben
  • 105
  • 4
0
votes
1 answer

Mysql Tuner output : Need help analyzing

-------- Performance Metrics ----------------------------------------------------------------------- [--] Up for: 75d 21h 28m 49s (441M q [67.390 qps], 1M conn, TX: 5795G, RX: 281G) [--] Reads / Writes: 44% / 56% [--] Binary logging is enabled…
0
votes
2 answers

mySQL Database Performing Extremely Poor on INSERT, DESTROY, but fine on FIND and UPDATE

I believe I've encountered a database scaling issue. I have a table with nearly a million rows in it now and our rails application appears to be hanging whenever we try to create a new instance. I notice this also happens when we destroy a record as…
Jim Jeffers
  • 133
  • 3
0
votes
0 answers

CloudFront HTTP/2 slower (high TTFB) than HTTP/1.1

My site was running on HTTP/1.1 with CloudFront at front, Webpagetest reports the load time usually at 2 seconds. Yesterday I enabled HTTP/2 (and SSL) on CloudFront, expecting to see an improvement. The result is, on the opposite, it becomes…
Edward
  • 101
  • 3
0
votes
1 answer

Which parameters and setting affect network throughput when connecting two machines together without a switch?

I have a situation where I need best possible throughput (TCP/IP sockets & SMB3) between two Windows Server 2016 connect with a 1m patch cable. I have to use existing hardware. When you connect two Windows Server 2016 machines together directly,…
0
votes
0 answers

Should I worry about TTFB?

I have read differing opinions on the subject, but Im also wondering how much of this is affected by server location. I have a VPS in NY, USA and im an Australian developer, VPS' are pretty pricey where I live so I use this as a playground/self…
Cacoon
  • 133
  • 5
0
votes
0 answers

Optimizing nginx with SSL for bot traffic without sessions

The service I run, cronitor.io, has a telemetry collection API that sees bursts of traffic around 1000rps. (overall baseline is much lower, call it 100rps) Most of our requests come from things like curl and the most popular HTTP libraries in each…
Encoderer
  • 267
  • 1
  • 2
  • 11
0
votes
1 answer

Oracle hardware requirements and optimization

I'm an application developer. We have some reporting solution for our client on Oracle database 10g. They would like to speed up execution of some calculation stored procedures. Ok, I know about query plans & optimizations, but also I need to give…
Dmitry
0
votes
1 answer

How to simplify my nginx reverse proxy config

I have finally gotten around to setting up a Nginx reverse proxy to handle the multiple websites I host at my house since I only have one external IP address and everything is working, but what I want to know is if there is a way I can simplify the…
0
votes
2 answers

How to optimize my.cnf and httpd.conf for speed on a powerful dedicated server?

I have a dedicated server that has 12GB of RAM and Dual Nahalem Quad Core processors. My site usually only has about 50-100 users online at a time (though once I get the server optimized I plan on advertising and estimate the number to be closer to…
James Simpson
  • 1,651
  • 2
  • 15
  • 31
0
votes
1 answer

What is star query optimization?

I found in a features table for SQL Server 2005 a row named "Star query optimization" but it is not explained anywhere. Could this be a feature that optimizes a query like : SELECT * FROM Table
Andrei Rînea
  • 310
  • 5
  • 17
0
votes
0 answers

Optimize webserver to handle huge load spikes

Our application is growing fast so now we need to scale the infrastructure to don't slow down the entire website without worrying on how many users we have The backend system is based on many curl calls lasting 1-10 seconds and they need to be…
lorigio
  • 11
  • 2