Performance tuning is the process of modifying a system to improve its efficiency. This is also known as optimizing.

learn more… | top users | synonyms

1
vote
5answers
4k views

VPS hosting is very slow. What's the bottleneck?

I've setup a new VPS hosting, to run a Drupal website but it is extremely slow. It is Ubuntu 10, Apache, php5.2 I've enabled Multi-Processing Module (MPM) module and configured it as follows: ...
1
vote
3answers
93 views

SQL Server Tuning Resources

I want to learn more about tuning SQL Server instances (2005/2008), does anyone have any good resources they can point me at? Dave NB: I'm talking about the hardware/instance configuration side of ...
1
vote
5answers
682 views

Trouble shooting wireless signal performance

I just performed a wireless network scan and my primary wireless route broadcasts a consist 70 DBm signal. I added a range extender that increases or decreases the signal 65 DB (Not sure how the DB m ...
1
vote
2answers
189 views

Visualize overloaded nic in linux (kernel time)?

I have a linux server that keeps getting its NIC overloaded and I need to visualize how and why this is occurring based on connections and CPU utilization. How do I do this? For example; for me to ...
1
vote
1answer
2k views

Lot of FIN_WAIT2, CLOSE_WAIT , LAST_ACK and TIME_WAIT in Haproxy

We are running haproxy in production for around 10k+ concurrent users. But we are seeing lot of FIN_WAIT2, CLOSE_WAIT , LAST_ACK and TIME_WAIT in the netstat output. This output is on a 8G ...
1
vote
3answers
1k views

Filesystem/Options for intensive random I/O

I'm planning to (privately) deploy a server that will be hammered with random I/Os in files ranging from 100MB to 50GB. The requests will range from 128 KB to 4MB. The profile will be 50:50 concerning ...
1
vote
3answers
3k views

How-to manage a MySQL table with over 2 million records

I have an InnoDB table running on MySQL 5.0.45 in CentOS. To make matters worse it is all running in a virtual machine. There are multiple tables that have the probability of exceeding 2 million ...
1
vote
2answers
3k views

Interpretation of non-zero vmstat “bi/bo” values

What are useful rule-of-thumbs with regard to interpreting non-zero vmstat "bi/bo" values? When are the values "okay" and when are they an indication of that the system is under heavy stress? The ...
1
vote
2answers
537 views

How well does Windows 7 Handle High Bandwidth-Delay Product Networks

As WAN bandwidths increase default network settings in older operating systems are less and less able to efficiently use the network. A description of the problem with high bandwidth-delay product ...
1
vote
5answers
200 views

Network Monitoring and Filtering [closed]

As the IT administrator for my company I have been tasked with deciding what traffic to filter, shape, and othewise monitor on our network. What protocols, applications, and other network traffic do ...
1
vote
1answer
202 views

difference between taskset and cpuset

I'm trying to reduce the latency of my linux network application. I've learned that there are two tools for "binding" a program to particular CPU core: taskset and cpuset. Which one should I prefer? ...
1
vote
1answer
500 views

Optimize Apache for EC2 micro instance

I'm running apache2 on a EC2 micro instance with ~600 mb RAM. The instance was running for almost a year without problems, but in the last weeks it just keeps crashing, because the server reached ...
1
vote
1answer
500 views

VM Tuning to enhance performance

vm.bdflush = 100 1200 128 512 15 5000 500 1884 2 vm.dirty_ratio = 20 vm.dirty_background_ratio = 10 vm.swappiness = 10 vm.min_free_kbytes = 300000 That means that the MOST dirty data that can be in ...
1
vote
2answers
251 views

I'm seeing performance problems with postfix accepting mail when the queue is already large, any suggestions?

I use postfix to do final delivery for a mail system I've written. So this postfix installation only accepts mail from me, and bounces. When the postfix queue is empty, it can accept a piece of mail ...
1
vote
3answers
674 views

How to measure req/sec by analyzing apache logs

I want to measure the justify stress-test result on production env. How to measure req/sec by analyzing apache logs? apache2.2 LogFormat "%v:%p %h %l %u %t \"%r\" %>s %O \"%{Referer}i\" ...
1
vote
1answer
750 views

performance wise htaccess

hese's the my htaccess template, i wonder if anything could be added to increase website performance.. # Defaults AddDefaultCharset UTF-8 DefaultLanguage en-US ServerSignature Off FileETag None ...
1
vote
2answers
1k views

Good VPS In London? [duplicate]

Possible Duplicate: Who is your favorite VPS Provider? I'm looking to rent a Windows VPS in (or near) London, England. I want to be able to do performance testing of our North American web ...
1
vote
3answers
846 views

On Windows it's possible to monitor the hard faults for each process?

I'm tuning a production server that runs Windows Server 2003 SP2. I want to monitor the hard faults (read an write separately) for each process. Is it possible?
1
vote
1answer
752 views

Virtual server freeze (apache ?)

I rent a small virtual server at 1und1.de. (Link, but German only) (2GB RAM dynamic, 512MB at least, 20 GB HDD) I choose to run a Ubuntu 8.04 LTS as operating system (64 Bit). I installed apache2 + ...
1
vote
2answers
42 views

How to exclude requests from unwanted sources

Scenario: Client buys our analytics services and includes our analytics SDK in his mobile app. Users who download the app will start sending us lots of data. When the client stops paying for our ...
1
vote
6answers
2k views

How to know if my nginx is in good health?

I am running a nginx on EC2 (m1.small) for SSL termination. I am using 2 workers on Ubuntu, with latest nginx (stable), the network throughput is around 2Mbps and system load average is around 2 to ...
1
vote
1answer
2k views

JVM tuning in JBOSS AS 7

Can anyone explain as to where and how do I configure the following JVM parameters to tune JBOSS. I am using the latest JBOSS AS 7. I am using openJDK-6 on Linux. The following are the parameters ...
1
vote
1answer
235 views

RRAS (Routing and Remote Access) change process priority to “realtime”?

I have a windows server 2012 running RRAS and some other services. Beacause of that I guess I have experience some slowdowns and dropout of package. My question is how to find, and change the ...
1
vote
1answer
403 views

Doubled up RAM to 32 GB - now how to speed up a “LAPP” server?

I run a small Facebook game at a CentOS 6.3 quad core machine with PostgreSQL 8.4.3 + few PHP scripts (doing mostly select queries) + 1 Perl daemon and even though the server worked ok, I've suggested ...
1
vote
2answers
376 views

Apache2 on linux - how to track down performance trouble

I am stuck on this topic for a while now: How can I get more details on where response time burns. My Problem is the extreme variance in response times. Sometimes it takes the server 5 or 10 seconds ...
1
vote
5answers
1k views

Windows Server 2008 R2 poor CPU performance

We have two identical servers with the following specs: 4 sockets containing AMD Opteron 6172 at 2.10 GHz each of which have 12 cores 64 GB RAM One runs Windows Server 2008 R2 Standard, which ...
1
vote
1answer
3k views

Memcached Cluster - better to have 3 smaller instances or 2 mediums ones?

Currently I have 2 small servers in an memcached cluster. We are approaching out limits with them and need to grow. What are the pros/cons or going adding another small instance compared with having 2 ...
1
vote
2answers
169 views

SQL performance, how to exactly measure bottlenecks

Yesterday me (programmer) and one of my coworkers from our Hosting department started series of tests to address performance issues with our websites. We are running a server with Windows Server 2008 ...
1
vote
2answers
142 views

How to connect an Oracle server between two countries and maintain high speeds for read & write

Our company has two branches, one in Malaysia and the other one in India. The problems occur when we try to share one of our Oracle environments to our branch in India; the connection is very slow, ...
1
vote
2answers
451 views

Troubling AB benchmarking result?

I'm a real noob when it comes to sys admin. I'm running an app on an EC2 MicroInstance. Before I launch publicly, I want to make sure that I hit a minimum level of performance. I'm trying out some ...
1
vote
1answer
580 views

COM+/Desktop Heap errors in IIS affecting sites at random?

We have a Win2K3 server that is hosting 30+ sites. Each site is configured to have its own unique application pool -- so that we can manually recycle specific sites if needed and not kill sessions ...
1
vote
3answers
340 views

Config MySQL to maximum speed and memory

I have a server, 8 cores, 12 GB RAM. This server is only used to run MySQL. So, help me config /etc/my.cnf to maximum speed, memory for MySQL.
1
vote
1answer
941 views

MySQL's innodb_file_per_table and “too many tables”

I'm running MySQL (5.0 but I don't think it matters for anything after 4.1) and I've seen advice about using the innodb_file_per_table configuration option for InnoDB tables. This is usually done so ...
1
vote
3answers
1k views

How to make SSRS 2005 run fast in general?

Are there any general rules/tips which we can use to run Sql Server Reporting Services 2005 reports faster? I have been tuning the Tsql behind the reports but does there exist any SSRS specific ...
1
vote
1answer
456 views

Specific apache + mysql settings for a light-weight site

I have a small website with a Joomla and a Moodle set up. It seems that both of these are very slow. The server (CentOS release 5.5 (Final)) is a virtual dedicated server with about 2GB of ram. I ...
1
vote
2answers
123 views

Simple queries occasionally running very slowly

I have some very simple queries that occasionally run very slowly. The table viewed_sites has about 10 - 20 rows. Running EXPLAIN ANALYZE always gives a runtime of less than 3 milliseconds. When ...
1
vote
4answers
559 views

Optimizing MySQL server

I need help in optimizing my my.cnf configuration file. I have two servers connected directly through LAN network (1 GBit/s). The first server is an Apache web server and the second one is a MySQL ...
1
vote
2answers
1k views

How to preserve sysprep from changing Default User settings

I'm having diffculties configuring 20 new Dell Vostro minis here. I set up one of them with my preferred OS, applications and settings, especially the Visual Effects Settings of Windows XP. I set them ...
1
vote
2answers
328 views

How do I objectively measure an application's load on a server

All, I'm not even sure where to begin looking for resources to answer my question, and I realize that speculation about this kind of thing is highly subjective. I need help determining what class of ...
1
vote
1answer
465 views

postgresql - cache preferences per table/db

i'm curious if there is any way to hint postgresql which data should be more likely cached in memory. in my scenario the server would be handling mostly read traffic, whole data-set is much larger ...
1
vote
4answers
2k views

Lower Maximum Possible Memory Usage

I've been using MySQLTuner to optimize my database, and the only problem I am having is: [!!] Maximum possible memory usage: 14.8G (126% of installed RAM) I'm not sure what I should be ...
1
vote
1answer
2k views

How to change the SWAP file disk in Mac OS X?

I have moved my system on andexternal Raid 1 enclosure attachet to my iMac through Firewire 800 (the best an iMac can do ;-( ) ... I'd like to move the swap on the internal disk in order to increase ...
1
vote
1answer
3k views

How do I increase UDP Recv-Q

I have a gigabit connection that is not fully utilized but I am getting packet receiving loss. When I do netstat, it shows the Recv-Q sometimes maxes out at 262656 during heavy traffic. Proto Recv-Q ...
1
vote
2answers
796 views

Troubleshooting poor disk IO performance

Note that while this question is a little Redis-specific, the main problem is generic: a process takes so much HDD IO write bandwidth that other processes can't write anything. We've got an Ubuntu VM ...
1
vote
3answers
1k 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 ...
1
vote
1answer
692 views

How Do I Troubleshoot Exim Mail Retry Issues?

My server is encountering high CPU load (like almost pegged at 100%) so much that the Apache service can't run and we get Apache 500 errors. We used a script to catch this and this is where we ...
1
vote
1answer
1k views

Windows Server 2008 File Server Performance Tuning

I am running a Microsoft Windows Server 2008 R2 File Server on our network. It seems that there are many times where accessing the data from the server is really slow, sluggish, or non-responsive. ...
1
vote
2answers
672 views

Establish a performance baseline for terminal server windows machines

I need to establish a performace basline for our Terminal Server machines. i plan to use perfmon , and will have a SCOM server on the site very soon. The terminals are used as a desktop environment ...
1
vote
2answers
812 views

How to tune down the Hyperic built-in postgresql database for a small setup

We are testing out Hyperic 4.5.1 in a quite small environment for now. Currently there are just 1-5 agents and there probably won't be any more than 10-15. When I run ps ax there are 20(!) postgres ...
1
vote
2answers
996 views

Apache Config for High Page View, Long Session Users - KeepAlive and MaxRequest variables

I am currently running a web app that sees several (~15) users logging in once each day, and then leaving the web app open where it automatically refreshes with new content every 5 minutes. Each user ...