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

learn more… | top users | synonyms

0
votes
1answer
358 views

IIS 7.0 - responses throttled to 500ms blocks?

Scenario: ASP.NET MVC wep app sitting on my local machine (Vista Ultimate, IIS 7.0), nothing going on except one user (me) logged in and viewing an index page. The page includes 9 dynamic images drawn ...
4
votes
2answers
2k views

How can I tell which page is creating a high-CPU-load httpd process?

I have a LAMP server (CentOS-based MediaTemple (DV) Extreme with 2GB RAM) running a customized Wordpress+bbPress combination . At about 30k pageviews per day the server is starting to groan. It ...
2
votes
5answers
989 views

Figuring out what's causing a server to slow down

I have a potential client that has a php site that performs fine most of the time. However, every week or so, it will experience lag (slow page loading). I am sure there are a myriad of things that ...
2
votes
1answer
376 views

Do IIS App Pools using Network Service account share memory?

We're trying to tune our IIS farm, and I'm trying to get my head around how Windows allocates resources in our current setup. We have a pretty standard layout. We host 30+ ASP/ASP.NET sites on our ...
0
votes
5answers
3k views

Very low performance of raid6

I noticed that writing to raid-6 is very low, but when I make tests with hdparm the speed is reasonable: dd if=/dev/zero of=/store/01/test.tmp bs=1M count=10000 Gives: 50Mb/s or even less. The ...
2
votes
5answers
433 views

Does Overclocking Anything Shorten It's Life? [closed]

From a business standpoint... If intel could take a 3.0 GHz CPU, and overclock it to 4.0 GHz - whilst still covering their warranty they would do so. It's absolutely free and makes the chip perceived ...
1
vote
1answer
706 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
0answers
461 views

server benchmarking with apache benchmark

We are testing one of our production server with ab and what we found is apr_socket_recv: Connection timed out (110) Total of 176 requests completed after some time above output.That means the ...
1
vote
2answers
642 views

Solaris: Increase TCP's Initial Congestion Window to 10 segments (tcp slow-start)

How can the Initial Congestion Window be increased to 10? It seems it can be done with TCP_INIT_CWND, but I don't know how to do that.
2
votes
3answers
2k 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 ...
2
votes
2answers
344 views

dedicated apache httpd server configuration and performance tuning

I have the following dedicated box that I only install apache httpd server on, what parameters in httpd.conf should I tune to achieve max performance? cat /proc/cpuinfo shows 8 processors(only ...
0
votes
1answer
4k views

What is bottleneck of my Apache server?

$netstat -anp | grep :80 | grep TIME_WAIT | wc -l 840 $netstat -anp |grep :80 | grep ESTABLISHED | wc -l 50 memory usage : 850MB / 1000MB apache2.conf contains.. <IfModule ...
3
votes
3answers
2k views

Linux's best filesystem to work with 10000's of files without overloading the system I/O

It is known that certain AMD64 Linuxes are subject of being unresponsive under heavy disk I/O (see Gentoo forums: AMD64 system slow/unresponsive during disk access (Part 2)), unfortunately have such ...
4
votes
1answer
2k views

PostgreSQL - count() performance and how to tweak it?

I've done some reading in google and the only thing I did was get myself confused. Some of the people say that count() is slower with many records, others say you can cache the number or even use ...
0
votes
3answers
680 views

Extreme fine tuning MySQL performance wise on a Linux server

I would like to know all of the key points where MySQL can be fine tuned performance wise on a Linux server through my.cnf or through other methods, libraries and tools. Tips and tricks and shady ...
0
votes
0answers
130 views

Where to start fixing an IO Bottle neck in SQL Server?

I recently came across an interesting article that went over using IO statistics to identify the causes of performance issues. After examining my statistics i came to the determination that i had a "...
11
votes
5answers
13k views

Performance Tuning a High-Load Apache Server

I am looking to understand some server performance problems I am seeing with a (for us) heavily loaded web server. The environment is as follows: Debian Lenny (all stable packages + patched to ...
0
votes
2answers
184 views

How do I calculate the amount of tuning needed for my server?

I have a server which is running a few discrete Python, Java application which most of the time imports data into a PostGreSQL database. I would like to know from people out there who have experience ...
1
vote
3answers
913 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\" \"%{...
0
votes
1answer
845 views

File Control Bytes / Sec in Server 2003 is sometimes VERY high - is this a problem?

We are trying to track down performance problems on our server, and when running SPA or the performance monitor the counter for "File Control Bytes / Sec" sometimes skyrockets, typically about once ...
1
vote
1answer
843 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 ...
3
votes
3answers
2k views

Database I/O acceleration using solid state drives

What is the experience improving database performance using solid-state drives (particularly for PostgreSQL databases) such as HP's IO Accelerator? Did you see any marked improvements?
3
votes
6answers
1k views

MySQL performance tuning

I'm looking for a succinct list of common pitfalls and optimizations for tuning a MySQL server as used for mid-size websites. In general, the type of advice I'm looking for here is information that ...
2
votes
2answers
8k views

switching to worker mpm for apache 2 on ubuntu

How to switch from prefork mpm to worker mpm on ubuntu server? how to roll back if there is any problem? root@myserver:~# apache2ctl -l Compiled in modules: core.c mod_log_config.c mod_logio.c ...
0
votes
1answer
47 views

Why did my newly added index show up as a 'statistic'?

We are attempting to tune our SQL Server 2005 database as we frankly have no indexing on our tables and our CPU usage is starting to max out at 100%. We have ran SQL Server profiler for a 3 hour ...
1
vote
5answers
5k 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
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
3answers
5k 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 ...
3
votes
1answer
328 views

What are some current and relevant benchmark tools for Linux?

I'm specifically interested in benchmarks that approximate or target real in the wild usage scenarios. My main areas of focus are latency, network performance (incoming data over sockets). ...
0
votes
2answers
158 views

What to seek/avoid in a hosted server monitoring service?

I'm looking for hosted monitoring solution (CPU, memory, disk, loads, mysql, replication network etc..) for a group of servers on Amazon EC2 /Scalr (app, mysql, load balancer). So far I found http:/...
1
vote
2answers
7k 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 = ...
3
votes
2answers
3k views

How to make setting of kern.ipc.somaxconn persistent?

Want to rise value of kern.ipc.somaxconn With sysctl works ok $ sudo sysctl kern.ipc.somaxconn=2048 $ kern.ipc.somaxconn: 128 -> 2048 check it: $ sysctl -a|grep somaxconn kern.ipc.somaxconn:...
0
votes
1answer
157 views

Need help tuning Mysql and linux server

We have multi-user application (like MailChimp,Constant Contact) . Each of our customers has it's own contact's list (from 5 to 100.000 contacts). Everything is stored in one BIG database (currently ...
5
votes
8answers
8k views

Hard Drive Speed: RPM vs. Cache

When trying to choose a SATA magnetic hard drive (not SSD) for high performance for both random and linear access, which should be the primary factor? For example: would a 10k RPM drive with 16MB ...
2
votes
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 ...
5
votes
1answer
6k views

What is the best TCP congest algorithm to use for a mobile device?

Given the multitude of TCP algorithms available now and the rise of Linux based mobile devices, what are ideal algorithm(s) to consider? From reading of the various implementations, Veno and Westwood+...
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 ...
0
votes
2answers
252 views

How do I increas MySQL Performance by throwing Memory at it?

I have a machine with 1 GB of RAM and have set apache to use STARTSERVER OF 150, and MAXCLIENTS of 150, only half is used so I still have about 500 MB more of spare RAM. I want MySQL to use this up as ...
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
3answers
1k 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
530 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 don'...
1
vote
2answers
163 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
1answer
3k views

AIX network parameters to close TCP sockets of unplugged devices

We have an AIX box, running what we call in banking "ATM Switch" not the ATM networking switch, but the bank ATM driver. where we have some ATM machines connected to two server processes. The problem ...
0
votes
3answers
4k views

Oracle tuning optimizer index cost adj and optimizer index caching

What is the correct way to set the optimizer index cost adj parameter for Oracle. As a developer I have observed huge performance improvements as this parameter is lowered. Common queries are ...
2
votes
2answers
1k views

SQL Server 2005 standard filegroups / files for performance on SAN

I submitted this to stack overflow (here) but realised it should really be on serverfault. so apologies for the incorrect and duplicate posting: Ok so I've just been on a SQL Server course and we ...
0
votes
2answers
2k views

Webalizer causing high CPU load

We use webalizer to generate reports on our Apache access logs - it is useful in conjunction with Google Analytics. The problem is that webalizer uses ALOT of CPU when running. If I run top I can see ...
1
vote
1answer
694 views

Webserver: Performance impact when storing session files on /dev/shm

I have a website runing on a typical setup: Linux, Apache, PHP, MySQL. However, what's not typical about it, is that it's getting tons of traffic (400,000+ visits a day) and so, efficiency is becoming ...
2
votes
2answers
651 views

perf tuning for ESX vmfs3 on RAID

looking for recommendations on ESX4 OS - VMFS version3: RAID-5 : matching the stripe size with VMFS block size? (64K, 128K etc) RAID controller options: "adaptive read ahead, write-back" on PERC 6i ...
0
votes
2answers
518 views

DB2 insert performance - How to measure

[From stackoverflow] Im trying to find a way to speedup my inserts to a DB2 9.7.1 (ubuntu linux) Im watching vmstat and trying to gather some statistics via the db2 get snapshot commands but im not ...