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
1answer
1k views

InnoDB options crashing mysql start AND mysql tuning

I have an innodb on a Ubuntu 10.10 server running on an ESXi platform. I have dedicated 8 CPUs, 32 Gigs of ram, and files stored in a Raid 5 HP SAN of SAS 10k rpm disks. I'm expecting FAST queries! ...
0
votes
1answer
645 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
244 views

ionice or chrt for Bonnie benchmark

I am running Bonnie benchmark on an embedded device and I am getting variable results for every run. I am contemplating using ionice and / or chrt to get around it. Can you suggest which option is ...
2
votes
5answers
336 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 ...
0
votes
2answers
102 views

what to check for limitations if a linux machine maxes out at a certain connection/s

I have a linux machine with a dummy HTTP server on it. It accepts a certain number of connections/second. Neither the CPU (it is a multicore) nor the memory nor IO are exhausted. What else can be ...
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
1answer
261 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 ...
2
votes
5answers
401 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 ...
5
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 ...
1
vote
1answer
547 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
332 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
0answers
432 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
428 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
990 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 ...
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
7answers
2k views

Linux tool/command to check file system performance

What is the simplest way to check read/write performance to a specific location (e.g. a mounted iSCSI device). I suspect I can't use hdparm because that's lower level. Am I right?
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 ...
1
vote
2answers
746 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 ...
0
votes
3answers
552 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 ...
2
votes
2answers
312 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
0answers
530 views

Nginx Slower than Apache?

I've just setup 2x identical Rackspace Cloud instances and am doing some comparisons and benchmarks to compare Apache and Nginx. I'm testing with a 3.4k png file and initially 512MB server instances ...
0
votes
0answers
124 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 ...
8
votes
5answers
10k 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 ...
6
votes
4answers
5k views

Windows 7 network performance tuning for LAN

I want to tune Windows 7 TCP stack for speed in a LAN environment. Bit of background info: I've got a Citrix XenServer set up with Windows 2008R2, Windows 7 and Debian Lenny with Citrix kernel, ...
0
votes
2answers
177 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
610 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\" ...
3
votes
1answer
644 views

How to remove the pause during JBoss 5.1.0 GA boot between ProfileServiceBootstrap and AnnotationCreator?

I've managed to strip down my JBoss profile enough that it boots in 1.5 minutes. I started with the web profile and started pulling out stuff I didn't need. The bulk of my boot time can be seen here: ...
1
vote
1answer
691 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 ...
8
votes
2answers
733 views

Linux RAID-0 performance doesn't scale up over 1 GB/s

I have trouble getting the max throughput out of my setup. The hardware is as follow : dual Quad-Core AMD Opteron(tm) Processor 2376 16 GB DDR2 ECC RAM dual Adaptec 52245 RAID controllers 48 1 TB ...
1
vote
2answers
4k 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
2answers
937 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
5answers
3k 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
611 views

Diagnosing poor performance on IIS / ASP.NET / MSSQL app

I'm trying to diagnose the cause of poor performance from a third-party web application we've deployed; the environment is: ASP.NET on IIS, Windows 2003 Server SQL Server 2008 on a separate Windows ...
5
votes
4answers
9k views

Find out which task is generating a lot of context switches on linux

According to vmstat, my Linux server (2xCore2 Duo 2.5 GHz) is constantly doing around 20k context switches per second. # vmstat 3 procs -----------memory---------- ---swap-- -----io---- -system-- ...
3
votes
1answer
302 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). ...
1
vote
3answers
2k 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 ...
0
votes
2answers
154 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
4k 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
1answer
280 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 ...
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 ...
1
vote
2answers
917 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
1answer
904 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 ...
2
votes
2answers
1k views

Can tail slow down log writing speed on Linux (ext3)?

I'm wondering if tailf can generate blocking I/O which will slow down server responsiveness due to logging. For ex. assuming the following setup: Debian 5.1 linux server (foo) which is managed via ...
2
votes
1answer
88 views

Profiling windows performance

I am used to using profilers for software development. I have had multiple windows pcs which all have slowed down over time, as well as had work PCs become slower. I understand this is probably the ...
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 ...
3
votes
3answers
482 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 ...
3
votes
1answer
2k 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 ...
0
votes
2answers
228 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 ...