Questions tagged [optimization]
Optimization is the process of modifying a system to make some aspect of it work more efficiently or use fewer resources.
339
questions
2
votes
1
answer
1k
views
optimizing PHP-FPM and Apache conf - how much RAM is actually used by each process?
I am preparing a new server (v5) to replace one that I currently have in production (v4). These machines run Ubuntu. The v5 server has PHP-FPM 8.2 and Apache 2.4.52 in mpm_event mode. I recall from ...
- 585
1
vote
1
answer
33
views
What is the fastest method of getting a small amount of data from whitelisted servers?
I have a bunch of servers which build various different programs for various different systems.
Once a build has completed, it gets archived into a single file and compressed, then an md5sum is ...
- 984
1
vote
1
answer
354
views
How to reduce MySQL Server CPU usage or load?
How to reduce MySQL Server CPU usage or load ?
Here is my.cnf :
skip-name-resolve
disable_log_bin
innodb_buffer_pool_size=200GB
innodb_log_file_size=25GB
innodb_log_buffer_size=8M
...
- 11
0
votes
1
answer
418
views
optimize Mysql 8.0 performance for millions of small tables
my data structure is around 0.2 million Innodb tables. each table is not longer than 300 rows. And the number grows by ~3000 tables per day. I'm afraid that this may bottleneck my I/O operations ...
0
votes
0
answers
2k
views
What is the ideal value for threads on thread_pool in nginx config?
I have a machine with 2x CPU 24 Cores, 48 Threads
Total: 48 Cores, 96 Threads.
My nginx default configuration came configured with threads=32
thread_pool pool_name threads=32 max_queue=0;
Should i ...
- 1
2
votes
1
answer
301
views
NGINX Redirect to Cached File in Subfolder
I have a program that creates optimized versions of pictures that are uploaded to the /images/ folder on the web server. It traverses subfolders and in each one, creates a .optimized folder that holds ...
6
votes
3
answers
2k
views
Very slow write speed (NVME drive) on 10G network
Setting up an experimental lab cluster, the write speed for data received via 10G fiber connection is 10% of the local write speeds.
Testing transfer speed between two identical machines; iperf3 shows ...
- 191
0
votes
1
answer
249
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 ...
- 131
0
votes
1
answer
127
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 ...
- 3
1
vote
0
answers
119
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 ...
- 21
0
votes
2
answers
2k
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
1
answer
77
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. ...
- 67
0
votes
1
answer
1k
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
3
answers
675
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 ...
- 105
0
votes
1
answer
586
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 / ...
