Questions tagged [optimization]

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

51 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
8 votes
2 answers
1k views

what is the IOPS behavior when partitions of single disk are used in an LVM?

I have an ubuntu 14.04.1 LTS server which have LVM(backed by hardware RAID5) with logical volume and a volume group named "dbstore-lv" and "dbstore-vg" which have sdb1 sdb2 sdb3 created from same sdb ...
sherpaurgen's user avatar
5 votes
0 answers
2k views

`nginx reload` and `nginx -t` very slow - how to investigate

I have a quite small VPS on AWS (EC2 t2.nano) that is running an nginx server. while sometimes a sudo service nginx reload or nginx -t is blazing fast, most of the time it is horribly slow (>60 ...
Tobi's user avatar
  • 257
5 votes
2 answers
6k views

Optimize php-fpm and varnish for a powerful server

My setup is Intel® Core™ i7-2600 and RAM 16 GB DDR3 RAM varnish+nginx+php-fpm+apc for a not very heavy WordPress blog with W3 Total Cache and CDN My problem is that after 55 hits per second ...
Jim's user avatar
  • 410
4 votes
0 answers
1k views

Identifying bottleneck with nginx VPS load testing

I'm trying to optimize a Digital Ocean droplet (512mb), testing using loader.io I'm testing on my homepage, which is HTTPS / PHP. I setup FastCGI page cache, which got me from 100 req/sec to 2,000 ...
jm92's user avatar
  • 41
4 votes
1 answer
4k views

Tuning Apache KeepAlive Timeout for HTTPS

My website forces HTTPS everywhere and has an average first load time of 3-5 seconds. Thanks to caching, repeat load time is 0.8 seconds. The SSL negotiation takes 150-300ms on my server, so I want ...
PF Billing's user avatar
2 votes
1 answer
948 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 ...
S. Imp's user avatar
  • 586
2 votes
1 answer
531 views

Move htaccess rules to apache configuration files

I'm running a website with Joomla on a dedicated server (Debian), and i've read that moving .htaccess rules to apache2 configuration files may result in a good performance improvement (Apache HTTP ...
Zikyi's user avatar
  • 21
2 votes
1 answer
400 views

How to use an origin-pull CDN with external CNAMEs?

I have a particular issue that I'm struggling with regarding setting up a CDN. To describe our situation: We are running an ASP.NET based CMS(DotNetNuke), configured with two different web heads on ...
Justin's user avatar
  • 21
2 votes
0 answers
792 views

High latency on domain with CDN

High latency on domain with CDN I have problems with latency on my server, these are the tests I made with blitz.io Latency album https://i.stack.imgur.com/nKV1r.jpg I would uploaded images here ...
Cokaric's user avatar
  • 21
2 votes
0 answers
165 views

Why does this one file not respect .htaccess' cache-control header?

Testing performance improvements, I added an .htaccess file with the following directives to my /assets folder (where I store a few images of various types). <FilesMatch "\.(jpg|jpeg|png|gif)$">...
msanford's user avatar
  • 1,487
2 votes
1 answer
149 views

how to optimize postgresql81 for a hug query but not a complicated one?

i have a query which execution takes 15s on the server. the server is bi-xeon 5130 (2GHz) with 2GB of RAM and 160GB of scsi hardrive in RAID. Database is PostgreSQL 8.1 on Debian 4 etch. This query ...
Michael REMY's user avatar
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 ...
Ben Holness's user avatar
1 vote
1 answer
292 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 ...
linuxpro's user avatar
1 vote
0 answers
117 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 ...
Naqi's user avatar
  • 21
1 vote
2 answers
2k views

nginx multiple paths (too many)

i got this working nginx config: server { listen 80; server_name mydomain.com; root /var/www/mydomain/wordpress; index index.html index.php; location /customer1 { alias /var/www/...
vladimir prieto's user avatar
1 vote
0 answers
184 views

To which value set ulimit

I'm setting up nginx from what I've understood the worker_connections value must not exceed the maximum number of open file descriptors retruned by ulimit -n. On my fresh 16.04 ubuntu installation ...
Slakk's user avatar
  • 11
1 vote
0 answers
2k views

Extremely slow response when connecting to remote MySQL database (LAMP Server)

I installed a LAMP server and enabled MySQL remote connections but I'm experiencing really bad response times when connecting to the database remotely from a WordPress install. I've been looking ...
Greg Antowski's user avatar
1 vote
0 answers
145 views

Nginx for a site allowing downloads

My friend have a site that allows users to download files.However the moment one guy start downloading server load change from 0.00 to 3.50 in a matter of minutes.Nginx and php-fpm reach D state and ...
Werulz's user avatar
  • 315
1 vote
1 answer
374 views

Check VPS resource consumption of a website

I've got a website (I'd say poorly optimized as it's my own code and I've never optimized a website before) and now that it's getting more visits the server load increases to up to 4-5 when there are ...
Aleix's user avatar
  • 119
1 vote
1 answer
478 views

Apache/PHP Elastic Beanstalk - Track Which Request is CPU Intensive

At certain seemingly random parts of the day, my CPU usage will spike up from ~10% on 1 m1.large to 70% on 4 large servers. This all happens within 20 minutes and stays this way for a few hours and ...
Jack's user avatar
  • 11
1 vote
1 answer
545 views

Addressing slow to connect time issues on NGINX

I intermittently perform 3rd party speed tests using http://tools.pingdom.com on my server. Recently, I have started to see long yellow bars for some of the static content on my sites, like images and ...
Professor Frink's user avatar
1 vote
1 answer
1k views

Random Lag in Apache before serving files

I've been trying to troubleshoot some random lag that happens in less than 3% of requests I'm sending to my server. I wrote a testing script that uses PHP's file_get_contents on a seperate server and ...
Andrew's user avatar
  • 255
1 vote
0 answers
370 views

page loading stops half-way, no server or sql load

i'm running a hostgator vps php/apache/linux/mysql i have a problem that i cannot seem to properly diagnose/fix : sometimes when loading a page, the browser will load have the page, then it hangs ...
Sherif Buzz's user avatar
1 vote
2 answers
560 views

Moving mod_rewrite rules in .htaccess to httpd.conf

I've got a massive set of URL rewriting rules that I am trying to: optimize transition to use within httpd.conf But I'm facing problems in getting the final product to work. Note: There are ...
siliconpi's user avatar
  • 1,817
0 votes
0 answers
79 views

Optimzing Docker Builds with docker-compose.yml when using PostGres DB's, performance, etc

I just have a general about how best to build and manage DB servers when using Docker builds with docker-compose.yml. Historically, I've sometimes bound the Postgres DB's to a bound folder on the ...
SScotti's user avatar
  • 141
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 ...
melk's user avatar
  • 1
0 votes
1 answer
214 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 ...
Plee's user avatar
  • 131
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 ----------------------------------------------------------------- ...
Josua Blirup's user avatar
0 votes
1 answer
75 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. ...
beard black's user avatar
0 votes
1 answer
574 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 / ...
Prudhvi Raju's user avatar
0 votes
0 answers
2k views

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. ...
Edward's user avatar
  • 101
0 votes
0 answers
265 views

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 ...
Cacoon's user avatar
  • 133
0 votes
0 answers
109 views

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 ...
Encoderer's user avatar
  • 267
0 votes
1 answer
493 views

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 ...
Brandan Schmitz's user avatar
0 votes
1 answer
726 views

NGINX + PHP-FPM multidomain optimization

I am trying to optimize the parameters of PHP-FPM on a VPS with multiple domains. Each domain is configured with its own user/group, NGINX uses different PHP-FPM sockets. For each domain I have ...
flero's user avatar
  • 21
0 votes
0 answers
30 views

Way to know what source is reading the most from MySQL Server(RDS)?

I have a mysql server which is registering very large bandwidth usage. I want to know what options I have for: Knowing what source is using the MySQL server most. (server ip?) What tables or queries ...
Safwan Erooth's user avatar
0 votes
0 answers
32 views

Go server response times

I just started playing around with a hosted VPS (running Ubuntu). I let it run the simplest Go server that listens to port 8080 and returns "hello world" on path /hello. Then I started sending ...
splinter123's user avatar
0 votes
1 answer
1k views

How to allocate more resources to Node.JS process?

I'm not a (very good) back-end developer so understanding processes and memory are a little about my pay grade. I'm currently building an app using the MEAN stack. I have a separate Express server ...
Jascination's user avatar
0 votes
0 answers
5k views

Apache Worker MPM / PHP-FPM Tuning

I have a VPS running CentOS 6.5, Apache 2.2, PHP-FPM v5.4 and MySQL 5.5. I take advantage of APC and Memcache. The VPS has 8 cores and 8GB RAM. I'm running a medium volume site (15,000 users / day, ...
Liam's user avatar
  • 164
0 votes
1 answer
1k views

Why this server is so slow?

I hired a VPS in DigitalOcean, it's hosted in Amsterdam, I'm in Turkey. But server is responding slowly and page is freezing/lagging even at ajax POST-GET request.(there is a basic browser game in ...
Lazy's user avatar
  • 101
0 votes
0 answers
299 views

PHP-FPM showing 34 worker process despite adjusting configuration

I recently asked this question and I got an answer about how I should limit php-fpm from running 34 worker process, considering that I get on average 20 visits for one light website. So, I ...
robue-a7119895's user avatar
0 votes
0 answers
647 views

samba over NFS large file

For several months we encounter problems delays : we have a server ( os: ubuntu server 12.04 ) with samba and ldap service . Our clients are on Mac, Windows and Linux client ubuntu . Huwaei NAS ...
user201680's user avatar
0 votes
1 answer
358 views

Centos help optimize Apache and kernel

I am looking for tips/articles on how to optimize CentOS for production use I will have 2 servers 1 web server where haproxy will also running Haproxy will be in front of apache and will be proxying ...
Thomas's user avatar
  • 167
0 votes
1 answer
112 views

Windows 2008 R2 VPS resource footprint reduction

Given a Windows 2008 R2 Standard VM with: 4x vCPU Intel Xeon E5620 1GB RAM 15GB HDD What can I do to reduce the amount of CPU/RAM/HDD utilised by the OS? The VM will be used exclusively as a web ...
Arnold Zokas's user avatar
0 votes
2 answers
1k views

Switching on MySQL query profiler for a website?

I want to "swtich" on the sql query profiler for my php/mysql site and leave it ru nnig for a while. The idea is to capture usage details over a day and then analayze the queries and work out which ...
siliconpi's user avatar
  • 1,817
0 votes
1 answer
175 views

MySQL's Query Optimizer's take on disk access time

I don't have a ton of background with MySQL, and I was wondering of anyone can give me some insight into MySQL's query optimizer and the impact on the cost of disk accesses in determining a query plan ...
user73111's user avatar
0 votes
2 answers
70 views

MySQL stop responsing when modify main tables

It's an InnoDB database. The query cache has 1.2GB in size with 300k queries in the cache. Most of the cached queries are related to 3 major tables (260MB data length plus 600MB index length ...
jack's user avatar
  • 1,725
0 votes
1 answer
599 views

Optimize windows 2008 performance

I have windows server 2008 sp2 installed as virtual machine on my personal laptop. I use it only for source control (visual svn) and continuous integration (teamcity). As the virtual machine resources ...
Giorgi's user avatar
  • 101
-1 votes
3 answers
2k views

Hyper-V failover cluster auto load balancing

We have a 2 unit Hyper-V cluster and I was wondering if there is a way to auto load balance the two? If one unit is restarted then I need to manually reassign some of the VMs to the unused hypervisor, ...
DeadlyWonky's user avatar
-1 votes
1 answer
797 views

Nginx , Apache , Mysql , Memcache with server 4G ram. How optimize to enought memory?

i have 1 dedicated server with Nginx proxy for Apache. Memcache, mysql, 4G Ram. These day, my visitor on my site wasn't increased, but my server get overload always in some specified time. (9AM - ...
TomSawyer's user avatar
  • 101