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
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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)$">...
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 ...
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 ...
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
...
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 ...
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/...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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
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. ...
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 / ...
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
-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, ...
-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 - ...