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

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 configured the right user/group. I found out that the…
flero
  • 21
  • 7
0
votes
1 answer

nginx: configuration file test failed

I using DirectAdmin and Nginx installed, i have huge clients at the moment and i see "Nginx 503 Error" sometimes, and i have 3Gb ram with 790 used ram... And now i want increase Worker Connections, but in this File i have no this item: nano…
antonio
  • 1
  • 1
  • 1
0
votes
0 answers

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 contribute most to the bandwidth. Understand if…
0
votes
1 answer

nginx time to first byte

I running several project on one machine, below with all the info. on nginx config if PHP project use fastcgi cache, Node.js project use proxy_pass , and all project use gzip. I'm new to maintain the server, my problem is all project running test…
user1775888
  • 147
  • 1
  • 4
  • 13
0
votes
3 answers

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, not a huge burden but it'd be nice not to have…
0
votes
0 answers

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 requests with my browser and I'm kind of puzzled by the…
0
votes
1 answer

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 running on localhost that is a web scraper. The flow…
Jascination
  • 101
  • 4
0
votes
0 answers

ExpressJS + MongoDB: Better to make one API call with 10,000 objects, or 10,000 individual API calls?

I'm building an app that relies on a web scraper built in Node/Express, which operating on the same localhost as my front-facing Node/Express app. I'm trying to optimise as much as possible and I'm completely new to all of this so please forgive if…
Jascination
  • 101
  • 4
0
votes
1 answer

Optimizing mysql and apache ovh vps

My website is 100% mysql php so it gets slowdown and sometimes server shutdown. I'm using VPS Classic: The best cheap VPS - $2.99/month - OVH (VPS Classic 4 - 4 vCores and 8GB RAM). I want some mysql and apache optimisation for my website so it will…
0
votes
1 answer

whats the best practice to do a long query like deletion of big chunks in mysql

On production servers I need sometime to delete a few 100,000s of rows . The query is optimized but deleting at once will cause servers freeze so I do it manually in chunks deleting for example 5000 rows each time. To allow the server to clear…
Niro
  • 1,401
  • 4
  • 20
  • 36
0
votes
1 answer

NGINX and failed (12: Cannot allocate memory)

could someone be so nice and explain me how to solve this problem? in log nginx print: 2015/06/24 11:12:19 [alert] 2151#0: mmap(MAP_ANON|MAP_SHARED, 33554432) failed (12: Cannot allocate memory) nginx.conf user developer; worker_processes auto; pid…
kbu
  • 255
  • 4
  • 14
0
votes
2 answers

Can I safely stop running Update Statistics on my SQL Server 2005 instance?

I've got a SQL 2005 database which has some maintenance plans on it set up by someone else. One runs Update Statistics on all databases early in the morning. It seems this is causing tempdb to fill up and hence breaking some other maintenance tasks…
Robin
  • 817
  • 3
  • 11
  • 20
0
votes
0 answers

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, peak 1,200 per hour). The VPS also hosts a number…
0
votes
1 answer

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 server that coded with node.js.) VPS : 4GB Memory,…
Lazy
  • 101
  • 4
0
votes
0 answers

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 configured PHP-FPM as shown in the answer, the problem is…
robue-a7119895
  • 167
  • 1
  • 8