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

-1
votes
0answers
13 views

A test fixture database to experiment on performance tuning? [on hold]

I would like to learn the basics of database performance tuning, and for myself I learn things faster if I can do hands-on to practise the learning materials. For the performance tuning, it seems ...
3
votes
4answers
199 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. ...
3
votes
4answers
139 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 ...
-1
votes
1answer
38 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 ...
2
votes
2answers
223 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 ...
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, ...
2
votes
2answers
167 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
3answers
605 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
1k 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, ...
2
votes
2answers
583 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
90 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 ...
0
votes
1answer
376 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 ...
0
votes
1answer
126 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
157 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
38 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?
0
votes
0answers
145 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
356 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
317 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 ...
8
votes
3answers
6k 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
153 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
233 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
279 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 ...
0
votes
2answers
94 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 ...
0
votes
1answer
91 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 ...
-3
votes
1answer
49 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
469 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
508 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 ...
0
votes
2answers
191 views

Centos 6 webserver - best use of spare memory [closed]

Just after any quick easy suggestions about where I should try tweaking my web server to use some of the spare memory and reduce CPU usage. Sorry if I'm a bit vague, but this isn't really my area. I ...
2
votes
1answer
4k 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 ...
3
votes
2answers
4k views

PHP + Apache long wait time

I've run into a bit of a brick wall with troubleshooting my dedicated websever. Recently, my website spiked with the amount of request/per second and it crashed. The box original had 8GB of RAM, 8 ...
2
votes
4answers
668 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 ...
2
votes
1answer
71 views

Linux Kernel setup: is it good idea to enable everything in Cryptographic API?

There are several implementations for some algorithms, which use CPU instructions which may or may not be available on current system. Is it good idea to just enable (in kernel, not as modules) all of ...
0
votes
1answer
161 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 ...
1
vote
1answer
155 views

Drop caches in Linux

I have an embedded Geode-based application server with 512MB RAM and I'm about to try to maximize free memory during applications workload, which uses MySQL database 5.5 with InnoDB quite ...
0
votes
1answer
156 views

Apache performance is really heavy [duplicate]

My company runs a heavy traffic site, about 150k daily. Each time after apache restarted, site load is very fast. The problem always comes after a couple of hours. Server config : Intel Core ...
2
votes
0answers
444 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 http://imgur.com/a/bCmwo I would uploaded images here but it ...
1
vote
1answer
173 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
175 views

Can postgres go faster? [closed]

My question is simply: have i missed any configuration settings that might make postgres achieve better read throughput? Background I'm modeling a very simple twitter program. My schema has only 3 ...
-1
votes
1answer
124 views

What will be the best mysql settings for 3gb server? [duplicate]

I have a 3GB server with the below settings. The issue I am facing is when I pull some records through the admin panel of my site, sometimes it works well, but most of the times it process very slow. ...
-4
votes
4answers
676 views

What is the *optimal* virtual memory configuration for this server? [closed]

I am maintaining a Small Business Server 2003 (x86) server, that was originally installed and configured by someone else in early 2009. Recently, although we have never had any obvious memory-related ...
3
votes
2answers
206 views

What's the optimal server configuration for fastest inserting in a MySql database in this scenario? [closed]

I have a MyISAM table partitioned by range with 90 partitions representing the last 90 days. I expect this table to receive somewhere between 500 million to 1 billion records before i start rotating ...
-1
votes
1answer
197 views

Server optimization for long running script [duplicate]

I have a system running on a remote VPS whose main feature is a long running script (it could run for about 10 hours, depending on the user input). The following are some of its features: Database ...
1
vote
1answer
1k views

MySQL MyISAM multi-core optimization

I've noticed that our app does not respond to requests when a demanding request is in execution. Running top seems to identify the source of the problem: top - 13:54:25 up 1 day, 13:43, 2 users, ...
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
69 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
935 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
448 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
332 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?