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
566 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
335 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
656 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
12k 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
846 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
800 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
826 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
7k 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
4k 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
157 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 ...
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 = ...
2
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 ...
0
votes
1answer
155 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 ...
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 ...
3
votes
3answers
918 views

It is possible move a specific file to the beginning of the disk?

It is possible move a specific file to the beginning of the disk? I want to move my virtual machine disk files (virtual disk) to the beginning of the disk to improve disk access performance. I believe ...
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 ...
4
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 ...
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
245 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
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
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
652 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
646 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
486 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 ...
1
vote
2answers
395 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 ...
2
votes
1answer
226 views

Outbound HTTP performance tuning recommendations

I'll detail my exact setup below, but general recommendations for a better web-browsing experience will be useful. A nice checklist of things to try would be great! I have 600 users on a single site ...
7
votes
2answers
2k views

What are the implications of the SHOWPLAN permission on SQL Server 2005?

A user wants the SHOWPLAN permission in order to use Execution Plans to tune a query. What are the implications of this permission. Is it safe to grant a user? I've seen the security note here, and ...
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 ...
2
votes
3answers
2k views

How to optimize iptables for high DNS traffic?

How to optimize iptables for high DNS traffic? I have a dedicated linux server acting as bridged firewall using iptables. Recently behind firewall was deployed DNS server with high load and firewall ...
6
votes
1answer
1k views

What are some TCP tuning tips for a service hit by iPhone clients on mobile networks like 3G?

I am a developer that has the good+bad situation of designing a network service that will be hit very hard by iPhone clients. The iPhone app has over 10MM downloads in the past year and now I'm ...
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 ...