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

3
votes
4answers
179 views

What is a core, and will purchasing more cores for my VPS speed up page load times?

I recently purchased a premium WordPres plugin called Hide my WP. I planned on using this plugin for my nonprofit organization's website, which is a multisite WordPress installation with an SSL. ...
2
votes
4answers
97 views

MySQL taking too much CPU

Below is my .cnf file and if I see my CPU consumption 99.99% of it my the mysqld commands. The MySQL server is connected from remote machines that update data in it frequently, but I make sure that ...
4
votes
1answer
925 views

Speed up MySQL inserts with partitions on MyISAM with unique key

I have a large MyISAM table (~30M rows). At some point I've switched it to fixed row format, so now table takes ~40Gb on disk and 2Gb for indexes. Table has a unique index and there are 100 'insert on ...
-1
votes
1answer
29 views

Tracking the slow - how to list all processes related to web-server?

I wanted to ask people in this community about administration of the Debian based web server - its a dedicated server, hosting a single website. From time to time the web site is slowing down, on ...
1
vote
3answers
1k 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 ...
20
votes
3answers
44k views

Optimal values for ServerLimit, MaxClients, MaxRequestsPerChild directives

I'm running a traffic intense site plenty of dynamic content, mostly user-generated. The server is a dedicated one and has a total of 4 Intel(R) Xeon(R) CPU X3210 @ 2.13GHz proccesors. I need to know ...
1
vote
2answers
988 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 ...
2
votes
2answers
3k views

Optimize php-fpm and varnish for a powerfull 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 ...
-3
votes
0answers
16 views

Reducing query cache for mostly INSERT-heavy database? [migrated]

What sort of MySQL query cache should I choose considering the following... Large, rapidly growing database (I got 500,000 rows). UPDATEs practically never happen. SELECTs are rare, but when they do ...
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 ...
5
votes
4answers
6k views

Profiling Apache+Mysql+Php server - which is the bottleneck?

How do I profile an Linux + Apache + Mysql + Php server for speed? I have a server with a heavily modified MediaWiki instance running on Ubuntu 8.04. It's a bit sluggish - I haven't done anything to ...
2
votes
2answers
115 views

RAID 10 Stripe Size for XenServer

Below is our current server configuration. In a few weeks I will be simulating a disaster recovery by installing 5 new disks (1 hot spare) and restoring all VMs from the backups. Will I gain anything ...
7
votes
1answer
3k views

How to disable keys in MySQL InnoDB tables?

Is it possible to disable keys in InnoDB tables? If yes, how? If not, why?
1
vote
1answer
108 views

SQL Server 2008 Optimization

I've learned today, if you append to your query OPTION (MAXDOP 0) your query will run on multiple processors and if it's huge query, query will perform faster. I know general guidelines on query ...
0
votes
4answers
87 views

What's the best way to debug and enhance the speed of your server?

My server has been running slightly slower than normal. I was wondering what strategies I could do to evaluate the speed of my server, and enhance it This question covers database interaction, I/O, ...
0
votes
1answer
324 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
2answers
163 views

Would software RAID0'ing SSDs help or hinder maximization of useful CPU work throughput?

My question is in the title... here is some background: [OS is Linux.] [UPDATE: The contents of this RAID0 is redundant (sync'd from SCM). I am not worried about the increased risk of data loss.] ...
0
votes
0answers
13 views

Setup Server for Optimization [duplicate]

I've got my first Dedicated server and I would like some help with the Optimization of it. I am thinking of going a bit different than the regular setup and I'd like your feedback. Before we start, ...
5
votes
2answers
658 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 ...
3
votes
1answer
2k views

Config NGINX to GZip Font Files? ( Different gzip_types for different directories)

SOLUTION: It turns out it is not my config / NGINX faults - my DNS provider, cloudflare, is preventing the fonts from being GZipped for some reason I'm using NGINX with GZIP_Static module installed. ...
1
vote
2answers
813 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 ...
0
votes
3answers
412 views

Evaluating the CPU I/O wait on Linux

Doing a top to check the io wait, I get these figures: Cpu(s): 6.7%us, 1.4%sy, 1.2%ni, 85.5%id, 5.0%wa, 0.0%hi, 0.3%si, 0.0%st Looking at these figures (%us ~= %wa), do they mean that: ...
0
votes
0answers
935 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, ...
5
votes
2answers
3k views

Optimizing MySQL for small VPS

I'm trying to optimize my MySQL config for a verrry small VPS. The VPS is also running NGINX/PHP-FPM and Magento; all with a limit of 250MB of RAM. This is an output of MySQL Tuner... -------- ...
2
votes
2answers
510 views

Possibility of WAN Optimization for SSH traffic

While I do understand that SSH by itself is a very low bandwidth utilizing protocol, it is sometimes choking up bandwidth during peak hours in our office environment. I want to know if at all it is ...
1
vote
0answers
86 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 ...
26
votes
8answers
20k views

Why rsync is faster than NFS?

Few days ago I noticed something rather odd (at least for me). I ran rsync copying the same data and deleting it afterwards to NFS mount, called /nfs_mount/TEST. This /nfs_mount/TEST is ...
15
votes
2answers
13k views

How to determine the best byte size for the dd command

I know that doing a dd if=/dev/hda of=/dev/hdb does a deep hard drive copy. I've heard that people have been able to speed up the process by increasing the number of bytes that are read and written at ...
3
votes
1answer
839 views

XDEBUG/PHP doesn't dump profile even when set up properly?

I installed xdebug from source, but also tried my package manager (separately) and they both are loaded correctly (verified by restarting Apache and seeing the xdebug copyright info in phpinfo()) but ...
0
votes
1answer
122 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 ...
1
vote
2answers
149 views

My Vps is too Fragile

I am using digitalocean $5 plan. 1 cpu , 512mb ram , mysql + apache , nginx + centos 6.5 + cpanel installed. 2 wordpress site on that. But if I reload page of one of my sites, cpu usage increasing ...
0
votes
0answers
35 views

Will pfctl -sr show ordered rules when using -o profile?

When I enable the -o profile option with pf will pfctl -sr show me the new order of the rules?
2
votes
1answer
3k views

Nginx “ssl_stapling” ignored, no OCSP responder URL in the certificate

I'm trying to setup OCSP stapling on Nginx because I ran a test and it suggested the idea and well, you know. https://sslcheck.globalsign.com/en_GB/sslcheck?host=aj2jewellers.co.uk#176.58.103.165 ...
0
votes
0answers
139 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 ...
1
vote
3answers
333 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 ...
2
votes
1answer
298 views

Slow disks but lots of RAM - optimization tips?

I have a Windows Server 2012 with rather slow hard-drives BUT with a lot of RAM and I can't change that (it's an Amazon EC2 actually). What can I do to optimize performance? I have 16 GB of physical ...
7
votes
3answers
5k views

Maximizing rsync performance and throughput - directly-connected gigabit servers

I have two Dell R515 servers running CentOS 6.5, with one of the broadcom NICs in each directly attached to the other. I use the direct link to push backups from the main server in the pair to the ...
0
votes
1answer
149 views

How to speed up Outlook 2007 / Exchange 2003 mail searches?

Our current setup is the Outlook 2007 client connected to an Exchange 2003 server. We run the client on 2K3 terminal servers and have disabled PST files. There is quite a large volume of emails stored ...
0
votes
0answers
226 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
2answers
269 views

Optimize images on CentOS server [closed]

I have a huge directory of images on a CentOS server (~65gb). The images are predominantly jpeg's but theres some png's and a couple of gif's. Here's the annoying and weird part - the images are all ...
1
vote
2answers
544 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 ...
2
votes
4answers
643 views

Network Latency over WAN

Let me take a minute to explain the background of the challenge I am facing. My company has offices in US and Asia. The users work on large CAD files. The office in US has NAS (Network Attached ...
14
votes
6answers
503 views

First days online : how not to kill your site

Suppose you have this fancy new site, with lots of data (like big images), and you're about to put it online. If you do "too much" publicity, during the first days, the site will be overwhelmed with ...
0
votes
2answers
93 views

MySql table optimization causing more problems than it solves

I have a heavily accessed table corresponding to user's private messages, with over 10 M rows. When I run the user deletion process, obsolete messages are deleted from the table, typically more than ...
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 ...
0
votes
1answer
84 views

Remotely automate optimization of mysql database

I am not a mysql or sql expert by any means, and not too savy on FreeBSD, either. We have a server that regularly needs one table to have data deleted < a time frame that leaves only 1 month of ...
1
vote
1answer
169 views

MySQL occasional non-responsive only on one database

I have an issue that occasionally (once or twice a week, not necessarily during peak hours) that queries on a certain db (the db of the largest of my sites) suddenly stop responding for about an hour. ...
-3
votes
1answer
48 views

Choosing between which HTTP, DB, Optimization tools on a VPS server [closed]

I am finally moving from a Shared hosting to a VPS hosting on Digital Ocean. Since now I have control of what I can install, I would like to know which of these are preferred to install. Web Server ...
1
vote
1answer
448 views

Directadmin Apache server finetuning advice

I currently have a dedicated server from which I provide shared hosting for some clients of mine. Server specs AMD Athlon(tm) 64 X2 Dual Core Processor 4000+ 4GB DDR RAM 1x Seagate ...
1
vote
2answers
485 views

mysql configurations for best performance

I have a huge magazine on dedicated server(1 website only on the server), all time the server have big load, "top" tool show me that the user "mysql" make this load: PID USER PR NI VIRT ...