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

learn more… | top users | synonyms

0
votes
1answer
1k views

Why is hash join slow in postgresql 9.1?

I transfered my DB from Postgresql 8.4 to new server with Postgresql 9.1. Size of DB is 9.9GB Data directory is situated on ssd 60GB disk. And server has 16GB RAM and 16 proccessor cores. But today ...
1
vote
2answers
70 views

Can my mysql server be fully tweaked? [closed]

I'm on a quadcore CENTOS 5.9 i686 standard running WHM 11.36.0. It's a dedicated LAMP server with lots of websites, most of which are using databases. I'm monitoring the server using Munin and notice ...
2
votes
1answer
2k views

Tuning MySQL of 1.3 G DB, 8GB Ram, High IO Wait

I am having MySQL database of size 1.3 GB on 8 core virtual machine, 8 GB of memory and I am having troubles optimizing the configuration. There is a lot of small rows and lot of joins going on. I've ...
1
vote
1answer
2k views

MySql turning - “Select full join” is too high - How to identify the queries causing this

We're trying to manage and tune our MySql. One alert we're getting in phpMyAdmin is this: Select full joinDocumentation 421 The number of joins that do not use indexes. If this value is not 0, ...
0
votes
2answers
1k views

virtual memory optimization on exchange server 2010

Hi I did some Google searching but came up blank I know mycomputer/computer > Properties > advance System settings > Advance[tab] > Settings[Performance] > Advance [Tab] > Change > customsige ...
0
votes
1answer
482 views

mysql database config optimization

Have a heavily trafficed database running mostly innodb and would like to better optimize the mysql config. Server has 32Gb ram and the biggest tables are ~18Gb innodb. I think I have done all the ...
0
votes
2answers
361 views

Would moving images to a CDN significantly reduce my CPU/memory load?

I am trying to reduce the cpu/memory load on my web server, and I am wondering if I should host my images on a CDN instead of my webserver. Does serving these images take up much CPU/memory?
-1
votes
1answer
179 views

Recommended resources for server tuning and security checklist for production Linux server deployment [closed]

There are many questions on server tuning and security checklist are being closed. So, I am not asking for the exact detail. Please point me to the resources you find it is helpful (no matter web ...
5
votes
2answers
714 views

How can I handle big traffic spikes on my dedicated server?

I have an E-Commerce site, which gains a sudden peak of very high traffic when I turn on different ads campaigns. From this moment on, my current dedicated server (Hostgator, 4GB Memoray, 100mbps ...
1
vote
3answers
2k views

Centos MySQL optimization 4gb ram

I am using Centos 6 64bit on vps with 4gb ram. 1 wordpress website and 2 wallpapers script websites. Wordrpess have 10k visits daily. Site is slow. My.cnf # Example mysql config file for large ...
5
votes
3answers
2k views

Optimizing VPS Server Memory

WHAT I'M TRYING TO DO The server resource limits sometimes run tight; to help prevent memory exhaustion, I've had to limit server processes. I'm needing a little expert help to know if I'm on the ...
0
votes
1answer
162 views

Nginx as a reverse proxy + Apache or completely cut out Apache? (WordPress Multisite)

I am starting a WordPress multisite network with domain mapping and I am trying to think through my server set up. Right now, I only have one medium sized VPS but hopefully I will need to add more ...
-1
votes
1answer
1k views

How to speed up a MySQL Import [closed]

I posted a related question on askubuntu.com, but this may be a better place and way to ask it. I'm working on a way to speed up a db import. Currently the import is taking a week, give or take a few ...
0
votes
1answer
259 views

php5-fpm spike, wrong configuration?

Recently I've uploaded some changes to my server that increases the amount of AJAX calls made to the server. The application "fastness" has decreased a lot. The web server is nginx with php5-fpm ...
0
votes
2answers
1k views

Optimize Windows file access over network

At my company I frequently need to access shared files over a Windows network. These files are located on the other side of the planet, so I guess the file share goes through some kind of VPN over ...
0
votes
1answer
103 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 ...
3
votes
4answers
505 views

Optimize Apache performance

I'm looking for ways to optimize our current web server hosted in-house. I'm trying to supply as much relevant information below. Please let me know if you would require additional information in ...
1
vote
1answer
1k views

MysqlTunner and query_cache_size dilemma

On a busy mysql server MySQLTuner 1.2.0 always recommends to add query_cache_size no matter how I increase the value (I tried up to 512MB). On the other hand it warns that : Increasing the ...
1
vote
0answers
586 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 ...
0
votes
1answer
196 views

How to delay and queue commands for execution at a later time? [closed]

My site receives numerous uploads and I can't afford to waste cycles and time processing them on the spot (e.g., trimming, optimizing, resizing, etc.). What technologies exist to delay and queue these ...
1
vote
1answer
410 views

Monitoring outgoing bandwidth of application

I currently have a VPS that is consuming a ton of outgoing bandwidth and I am trying to drill down to where this may be coming from. Does anyone know of a logical way to go about finding out which ...
0
votes
1answer
257 views

WAN Optimization for Small Office/Home Office

I have been reading up on WAN optimization for the last while, mostly out of interest of speeding up my own internet connections, but also to speed up the office internet connection. At home, I have 2 ...
1
vote
3answers
557 views

What's the difference of running ab locally and remotely?

I was benchmarking my site with apache ab and I noticed that the response time had big differences when running ab on the server and running ab on a client box remotely. So what's the biggest ...
1
vote
0answers
129 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
3answers
98 views

Lots of files being used by blank web page. What are they?

I am trying to optimise a website and I was using the network waterfall facility in Google Chrome. When I looked at the results there were lots of files which I didnt recognise. I first thought they ...
1
vote
2answers
1k views

How can I lower MySQL single-page reads?

My innodb buffer pool size is 8GB and my database is 6GB in size but I see this: Innodb_buffer_pool_reads 263.5k - The number of logical reads that InnoDB could not satisfy from buffer pool and had ...
1
vote
2answers
913 views

Best way to optimize (loss-less) thousands of jpgs in a windows folder structure?

Using Smush.it or Firebug's built-in image optimizer I realize we can reduce the file size of all of our web jpgs. By quite much actually. As we have hundreds of thousands of images, is there any way ...
2
votes
1answer
73 views

Balancing bandwidth allocation for nfsd

I am using NFS shares to transfer image files using clonezilla onto multiple lab machines, I am currently only imaging one or two machines at a time as a testing protocol but whenever I run more than ...
2
votes
1answer
5k views

Apache prefork optimization - Choosing the right `MaxRequestsPerChild` value

I'm trying to optimize our web servers to handle as much connections as possible. I read a many posts and the Apache notes. I'm trying to understand which value should I choose for ...
1
vote
1answer
2k views

How do i set a cronjob to use less CPU

I'm managing a server witch host several ruby on rails websites. I need a cron job for every website that does : send emails (notifications) create thumbnails Unfortunatly, every time the cron is ...
1
vote
2answers
442 views

Optimize Apache - should I use APC / nginx?

I've read many posts regarding Apache optimization. While reading, two names repeated over and over again, nginx and php-apc. I've tried to understand which of them might be helpful for me, but i ...
0
votes
2answers
14k views

Optimal MySQL my.cnf setting for large Magento site on a dedicated server

Our dedicated server is running a large Magento store with a MySQL database approximately 250MB in size. The server spec is listed as having 5 Xeon 2Ghz processors (4MB cache) and 12GB of memory. ...
1
vote
1answer
387 views

How can I optimize system resource usage for many different gunicorn powered Django sites with low traffic?

My server is a Linode with 768MB of RAM. It is home to around 8 small, low traffic Django sites powered by Nginx, Supervisor, and Gunicorn. Currently, each site has its own Linux user account, with ...
-2
votes
1answer
620 views

What webserver to use for a hentai website? Nginx or Apache? [closed]

I got a Linode VPS with 768MB. On another server (Speedysparrow), also with 768MB, i have Nginx running and it's awesome, as you can see here: http://www.ubuntubrsc.com/. This website, with the setup ...
1
vote
2answers
566 views

gzip compression increases performance, then eventually increases response time from server

Here is my current server scenario. I'm running on a Rackspace Cloud instance (16GB of RAM), using cPanel/WHM on a CentOS 5.5 install. I'm currently running about 10 Magento sites, all varying in ...
25
votes
7answers
6k views

Options to efficiently synchronize 1 million files with remote servers?

At a company I work for we have such a thing called "playlists" which are small files ~100-300 bytes each. There's about a million of them. About 100,000 of them get changed every hour. These ...
-1
votes
1answer
564 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 - ...
1
vote
1answer
159 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 ...
2
votes
2answers
831 views

Is there guidance to optimise W2008R2 threading performance?

I want to make sure that my W2008R2 box has least possible interrupts and context switches on the CPU threads. I have 4 cores / 8 HT threads CPU. I am running a single application which uses only ...
2
votes
0answers
117 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 ...
1
vote
1answer
248 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 ...
0
votes
1answer
209 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
114 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 ...
5
votes
2answers
1k views

How do I optimize TCP stack for HTTP server?

I have a HTTP server that serves only two kinds of page: about 10 KB and about 16 KB (both compressed, other files are from CDN). As the latency is quite high (ping takes more than 300 ms), I want to ...
1
vote
3answers
2k views

Strategy to optimize raid cache

HP SmartArray have "Accelerator Ratio: XX% Read / YY% Write", that configures how much cache ram dedicated for read, and how much for write. Is there way to find best proportion on alive server in ...
4
votes
2answers
2k views

Disk I/O utilization up to 100% after tuning InnoDB-related MySQL configuration

I have added following lines to "my.conf": query_cache_size=128M innodb_buffer_pool_size=512M innodb_flush_method=O_DIRECT After that Disk utilization started raising, reached 100% and holds ...
3
votes
4answers
966 views

Optimizing apache server load

We have an issue with a dedicated server load. We have 16 processors with 4 core @ 2.40GHz, if I understood correctly cat /proc/cpuinfo output. Unfortunately, I don't have access to free -m or ...
2
votes
2answers
537 views

Nginx+apache2 ubuntu server crashed with several hundreds of visitors

I have Linode 768mb RAM server on Linode. And i have Wordpress blog. On my server installed ubuntu, nginx as frontend and apache2 as backend. And i have APC and memcache modules. Sometimes site is ...
9
votes
2answers
2k views

Linux Slow Start: Changing ip route does not have any effect on initial window

I changed the tcp initial window in my machine to 10 as shown below [user@site etc]$ sudo ip route change default via 17.255.209.1 dev eth0 proto static initcwnd 10 And changed ...
2
votes
1answer
1k views

Finding out TCP Initial Window segment size in linux

I run Centos [user ~]$ cat /etc/redhat-release CentOS release 6.2 (Final) With kernel 3.0.4-x86_64-linode21 How do I check the TCP initial window size in my OS? I need to verify that the IW is ...