1
vote
3answers
123 views

What is the Ideal value for Worker Processes in Nginx Config?

I have 31GB RAM 8 Core Web Server with current load of 3k per min. Currently worker_processes parameter in nginx config is 4 which as per my understanding means only 4 cores would be used. But when I ...
0
votes
1answer
188 views

Configuring nginx and PHP5-FPM

I have a VPS with 1 CPU Core, when I was searching around for some nice documentation on configuring nginx and php5-fpm I constantly came across stuff like "I have a dual core CPU so I will limit this ...
2
votes
1answer
107 views

How would you configure a dedicated static media HTTP server?

Now that more websites are switching to a set-up with nginx in the front and Apache in the back (or a different webserver doing a better job at serving static media than Apache), I was wondering the ...
2
votes
1answer
131 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
1answer
4k views

MySQL config and optimization

Here is the info for my server Giga Dedicated 6-Core: Intel Core i7 (6 x 3,20GHz) 24 GB RAM 160 GB SSD + 2000 GB HDD I have CentOS 5.6 (64bit) installed and Plesk Panel 10 Apache version is 2.2.19 ...
2
votes
1answer
8k views

How to set query_cache_size and join_buffer_size in my.cnf file?

I have been monitoring my server the past two days and realised that 60% of my temp tables are stored on the hhd instead of memory. Also I ran MySQL Performance Tuning Primer script that adviced me to ...