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

learn more… | top users | synonyms

2
votes
2answers
143 views

Does deleting unused files such as images, javascript, xml, html, asp etc make your Windows Server faster?

I have an IIS7 Windows 2003 Dedicated server. I just wanted to know if I delete old files such as XML, HTML, ASP, PHP, images, CSS, JavaScript.. etc.. files that are no longer used.. Does this ...
6
votes
2answers
5k views

Best sysctl.conf configuration for high load - extremely busy content streaming server

What is the best sysctl.conf configuration for a high load, extremely busy content streaming server ? The server fetches the content from remote servers like amazon, s3, etc. then uses php to ...
3
votes
2answers
2k views

How to adjust MySQL performance

I'm facing a real problem with MySQL instance for a service online. We use hibernate and c3p0 pool with these settings: c3p0.max_size=200 c3p0.min_size=5 c3p0.timeout=60000 c3p0.max_statements=20 ...
1
vote
1answer
481 views

Why is MySQL table_cache full but never used

I have been using the tuning-primer.sh script to tune my my.cnf settings. I have most things working well but the part about TABLE CACHE makes no sense: TABLE CACHE Current table_cache value = 900 ...
3
votes
2answers
587 views

PostgreSQL tuning recommendation for large server and dataset

I'm working with a PostgreSQL (8.1) server on a dedicated machine with 64 GB of RAM and a fast RAID disk. The data set itself is pretty huge -- we have several tables around 200 GB, more in the 50-100 ...
1
vote
2answers
147 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 ...
0
votes
4answers
332 views

Trying to scale my dedicated server for high traffic

I have a quad core xeon, 8GB ram, and only 2 x 1TB SATA drives right now. I am trying to figure out how to scale my application to handle as much load and traffic per day as possible. I have an ...
1
vote
2answers
726 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 ...
23
votes
7answers
9k views

Is it OK to run perfmon on production servers? And why?

Or should perfmon be limited to a Dev/QA server with load tests that simulate production activity? I'd like to run perfmon for two days (like Sql Server master Brent Ozar suggests) to get an overall ...
0
votes
1answer
785 views

MySQL hosting: What are the recommended specs and w

I have two specific cases of MySQL hosting. 1) I have a case where I have 2000 plus concurrent users to a single MySQL Database. They are not simple web users, but actual business users who need to ...
0
votes
1answer
311 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
455 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
308 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
2k 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
413 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
610 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
441 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 ...
2
votes
5answers
2k views

What could be causing memory creep on a VPS?

I've got a VPS package. I cannot log into my lxadmin because it is "out of memory". In HyperVM I see that my VPS is using 240 MB of 256 MB. When I reboot the HyperVM, the memory goes down to 2 MB. ...
1
vote
2answers
495 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.
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 ...
2
votes
2answers
317 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
3k 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
1k 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
1k 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
594 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
125 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 ...
10
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
181 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
713 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
645 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
774 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 ...
1
vote
2answers
5k 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
46 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
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
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
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 ...
3
votes
1answer
311 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
155 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 ...
0
votes
2answers
5k 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 = ...
0
votes
3answers
2k views

Faster Option: Redirect via PHP to PHP or Apache mod rewrite redirect to PHP?

I want to determine if using Apache's .htaccess mod rewrite is a faster way to redirect to a PHP file, compared to redirecting from one PHP file to another, using the header redirect core function of ...
2
votes
2answers
2k 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
148 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
7k 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
965 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
595 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 ...