Questions tagged [optimization]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
22 views

Tightvnc Server using only 1 core?

I have a server setup with 8 cores and 32gb of RAM. I am using it to launch as many java applications as I can and hope to make the most efficient use of my resources. Upon launching I notice the ...
0
votes
1answer
17 views

Is there any advantage to using Object Caching (Redis) for DB table caching with a full static caching CDN

I am trying to optimize a small web application(PHP/MySQL), I have been using Redis as a cache for my DB, and I've gotten to the point of preparing to launch for testing. I've been working through an ...
0
votes
0answers
62 views

How to configure K8s cluster to utilize spare CPU capacity for ML training jobs (or other low-priority CPU-intensive work)

I'd like to use spare CPU capacity in our Kubernetes cluster for low-priority jobs -- specifically, ML training using Tensorflow in this case -- without depriving higher-priority services on our ...
0
votes
1answer
55 views

product import is broke behind cloudflare

Im having trouble to resolve my database errors and how to optimize it. Coz of the slowness of my server (mostly querries i believe), my imports turns with a cloudflare error code. (Cloudflare blocks ...
0
votes
0answers
92 views

Apache 2.4 Timeout configuration

I need to know how works the timeout configuration of Apache 2.2 or 2.4 I always use Timeout 900 I have a php script that is a proxy to shoutcast and then the connection can last for hours. If I set ...
1
vote
0answers
47 views

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 ...
0
votes
2answers
706 views

MariaDB 10.3 per thread memory usage and low CPU utilization

I am a bit unsure why we are seeing these memory numbers while the cpu usage is actually very low. -------- Storage Engine Statistics ----------------------------------------------------------------- ...
0
votes
1answer
60 views

mysql thread and tomcat thread should be the same for a better perfoming?

my tomcat instance on ubuntu server running with mysql and only the application has access to mysql (only the service-user tomcat). I have small experience level with optimizing with mysql and tomcat. ...
0
votes
1answer
71 views

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 ...
0
votes
3answers
125 views

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 ...
0
votes
1answer
187 views

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 / ...
3
votes
2answers
3k views

XFS with No Barrier Mount option deprecated

I tried to perform SQL Server database restore with xfs filesystem and barrier=0 in Azure cloud environment. It performs restore of some 15GB data in around 8 minutes. I heard this option is getting ...
3
votes
1answer
393 views

Debugging and fine-tuning the linux process scheduler

When debugging sporadic web application slowdowns, I've found that all the processes have quite high maximum scheduling delay. # perf sched record -- sleep 10 && perf sched latency --sort max ...
1
vote
1answer
648 views

How to convert swap partition from RAID1 to RAID0 using mdadm

How to convert linux SWAP memory from RAID1 to RAID0? Start with:2 exact size swap formatted partitions (/dev/sdc5 and /dev/sdd5) on 2 physically separate disks that are used via Software RAID(named ...
2
votes
4answers
5k views

Joins performed without indexes: 5568

I was trying to do mysql optimization. Yesterday the CPU usage was 100%. I am trying to optimize with mysqltuner but this time I gave a mysqltuner warning. I have a high-traffic db. 500-600 ...

15 30 50 per page
1
2 3 4 5
23