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
2answers
406 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
2k 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
4k 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
3answers
2k views

Increasing Postfix Performance for Outbound Mail

We're trying to optimize a Dell PowerEdge 1850, Dual 3GHz procs, 3072MB RAM, running Postfix 2.8.4 and signing mail with OpenDKIM 2.4.1. iostat -x output is: avg-cpu: %user %nice %system %iowait ...
1
vote
2answers
196 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
161 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
459 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
681 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
352 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
1k 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
512 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
150 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
565 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
396 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
510 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
3k 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

Slow performance due to txg_sync for ZFS 0.6.3 on Ubuntu 14.04

I am using native ZFS with "ZFS on Linux" installed from the PPA here. Setup was not a problem and I am using it in mirrored configuration with two WD 4TB Red HDDs. Unfortunately I am having ...
1
vote
1answer
1k views

Apache Start Servers, Min/Max Spare Servers Ram Consumption Influence

I have a 1gb ram VPS. If I stop apache I have 400 mb ram free. So the max clients should be (total ram - used ram) / max_service_ram_consumption = 400 / 31. So MaxClients should be 13. These are the ...
1
vote
1answer
700 views

Why is GlusterFS so slow here?

We've set up a mirroring pair of GlusterFS servers. No special tuning, whatever came "out of the box" with GlusterFS-3.5.1 in the official RHEL6 RPM, that's what we have. The cluster works, but the ...
1
vote
3answers
3k views

NFS Over OpenVPN: Top Performance Boosters

I have two VPS's - One is running 2008 Server R2 and the other is a Ubuntu 12.04 installation. I am using the Windows VPS for RD sessions for Quickbooks and a couple other apps and using the Ubuntu ...
1
vote
2answers
1k 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
1answer
1k views

How do change the max IO request size on Windows Server 2008 R2

As I understand it Windows Server 2008 R2 has the ability to send IO requests to the storage subsystem of up to 1MB in size. Back in the Server 2003 era (and before) this used to be limited to 64KB. ...
1
vote
3answers
3k 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
849 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
2k 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
848 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
982 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
6k views

How to see actual size of tcp send and receive buffers?

we are on a debian system and are trying to tune the tcp/ip stack to our needs. We all know that you can set the maximum tcp buffer size with some kernel parameters like this: net.ipv4.tcp_wmem = ...
1
vote
2answers
1k 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 ...
1
vote
2answers
2k views

Further Performance Tuning on Medium SharePoint Farm?

I figured I would post this here, since it may be related more to the server configuration than the SharePoint configuration or a combination of both? I'm open for ideas to try, or even feedback on ...
1
vote
2answers
185 views

mysql settings - using the available resources

I've got a lot of processing work I need to run on a mysql server. I've installed mysql 5.1.45-community on a Win 2008 64bit. Its running on a Xeon, 3ghz 6 processors with 8 gig ram. It doesn't ...
1
vote
2answers
392 views

Is there any way to exclude specific files / directories from SuperFetch?

Overall, I love the SuperFetch feature in Vista and believe it results in hugely noticeable gains in the launch time and overall "snappiness" of the system. However, sometimes it apparently gets ...
1
vote
0answers
18 views

Persist statistics data from Postgres' stats_temp_directory on demand

We are investigating I/O load in one of our VMs and possibilities to optimize it and it showed that most of the load is generated by the stats collector of PostgreSQL. It jumps between 3,5 and 6,5 ...
1
vote
0answers
30 views

mod_pagespeed css shown render blocking?

I've already found this topic concerning my problem and figured out Google is about to discuss a fix of the blocking js. However, could somebody please check out my client's site squarecard.de with ...
1
vote
0answers
44 views

How to track down bad performance on an api-server

If my api-server shows bad performance, such as high cpu - can this be blamed on the service or on the server? If a regular app-server shows bad performance, all I can do is track down the methods ...
1
vote
0answers
43 views

Maximum Network throughput for SWIFT storage

I have a SWIFT cluster deployed as part of Openstack which is currently giving me a max throughput of 95 MBS(Megabytes per second). There are 6 proxy servers and 6 storage nodes with replication ...
1
vote
0answers
129 views

Advice Tuning my server

as many others I Learn many info from you in the past and now I manage to run server independently , now I am new to sql tuning and I been searching around the web a while now and tuning seems to be a ...
1
vote
2answers
215 views

PHP5-FPM pm.max_children affect RAM or CPU+RAM?

Recently inherited a Nginx+PHP5-FPM server, and I'm learning and trying to optimize PHP5-FPM settings. Server info: 4 CPUs (8 threads) 7.5 GiB RAM PHP5-FPM info: pm.max_children = 5 ...
1
vote
0answers
153 views

Performance issues with cross-drive NTFS junctions

I have the following setup: Windows 8.1 32-bit Drive 0: system drive, SSD, NTFS, mounted at C:\ Drive 1: data drive, magnetic HDD, NTFS, mounted at C:\Users\Database User\Documents and Z:\ ...
1
vote
0answers
99 views

Multipath tcp application level performance measurement

I am working on a project related to Multipath tcp and I want to measure the goodput and the RTT at the application level. I don't want to use a traditional tool(netperf, iperf, ...) and I want to ...
1
vote
0answers
74 views

IRQ not handled by all CPUs

I have a problem about balancing irq. I took irq numbers from /etc/interrupts and assigned each irq to each of 24 CPUs as this tutorial says for i in {143..166};do cat /proc/irq/${i}/smp_affinity; ...
1
vote
1answer
414 views

KVM Slow performance on XP Guest

The system is very slow to do anything, even browse a local folder, and CPU sits at 100% frequently. Guest is XP 32 bit. Host is Scientific Linux 6.2, Libvirt 0.10, Guest XP OS shows ACPI ...
1
vote
1answer
340 views

TCP RWIN, MSS and MTU [closed]

I have been doing some reading into TCP Receive Window (RWIN), Maximum Segment Size (MSS) and Maximum Transmission Unit (MTU). Right off the bat I have some questions and I need a power user's help! ...
1
vote
1answer
467 views

Copying cause big iowait

I have dedicated server with 3 HDD. System disk, backup disk (same as system disk) and data disk. When I copy lot of data with cp (say, between backup disk and data disk) load average goes sky high. ...
1
vote
0answers
96 views

Getting the virtual memory address for (major) page faults

On a Linux (Cent OS 5) system, I have a process that accesses a large amount of memory mapped files. The process is generating a large amount of page faults because the aggregated size of the mapped ...
1
vote
0answers
268 views

Can I tune my Debian KVM server to benefit my Windows guest?

Debian Squeeze KVM server with Win2k8 server guest. The server has 16GBs of RAM and the guest only runs MS SQL, with a 15GB database on it. I am wondering if there is anything I can tune from the ...
1
vote
1answer
1k views

NGinx vs Varnish as a reverse proxy in front of Apache w/php [closed]

I am using apache with mod_php to serve content. Mostly the content is fetched form memcache over the network. All of my images, css and js are already on a cdn What are the pros and cons of putting ...