Questions tagged [performance-tuning]
Performance tuning is the process of modifying a system to improve its efficiency. This is also known as optimizing.
413
questions
1
vote
3
answers
2k
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
4
answers
4k
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 ...
7
votes
1
answer
11k
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+...
0
votes
2
answers
322
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
3
answers
2k
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?
2
votes
2
answers
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
1
answer
617
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
1
answer
668
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 ...
5
votes
2
answers
3k
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
2
answers
767
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 ...
0
votes
1
answer
181
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 ...
30
votes
7
answers
19k
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 ...
1
vote
1
answer
4k
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 ...
1
vote
1
answer
1k
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
2
answers
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 ...
2
votes
2
answers
679
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
2
answers
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
2
answers
207
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
2
answers
813
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 ...
0
votes
3
answers
1k
views
Increase the performance of sort command on a multi-processor Sun Solaris box
I have a bunch of (rather large i.e. >100MB) comma separated files which needs sorting on 4 processor box with SunOS 5.10
Sort appears to run rather slow (minutes)
I am wondering if there is any way ...
1
vote
4
answers
584
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 ...
10
votes
2
answers
8k
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 ...
0
votes
1
answer
1k
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
2
answers
2k
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 ...
2
votes
3
answers
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 ...
1
vote
2
answers
513
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 ...
6
votes
1
answer
2k
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 ...
2
votes
1
answer
2k
views
Very long (>300s) request processing time on Apache Server serving static content from particular IP's
We are running an Apache 2.2 server for a very large web site. Over the past few months we have been having some users reporting slow response times, while others (including our resources, both on ...
1
vote
1
answer
969
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
4
answers
3k
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 changing ...
4
votes
1
answer
2k
views
apache and ajp performance
I have an apache sitting in front of two tomcat app servers(one on the same physical server, the other on a different one) that does time consuming work(0.5 sec to 10sec per request). The apache http ...
1
vote
2
answers
7k
views
Interpretation of non-zero vmstat “bi/bo” values
What are useful rule-of-thumbs with regard to interpreting non-zero vmstat "bi/bo" values? When are the values "okay" and when are they an indication of that the system is under heavy stress?
The ...
1
vote
2
answers
674
views
How well does Windows 7 Handle High Bandwidth-Delay Product Networks
As WAN bandwidths increase default network settings in older operating systems are less and less able to efficiently use the network.
A description of the problem with high bandwidth-delay product ...
3
votes
3
answers
323
views
How to profile for HDD usage pattern?
I'm considering upgrading the storage system for some of my servers, and all the guides and manuals advise to consider the storage usage patterns of your app before deciding on a (RAID? SSD? iSCSI? ...
1
vote
4
answers
5k
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 ...
1
vote
3
answers
110
views
SQL Server Tuning Resources
I want to learn more about tuning SQL Server instances (2005/2008), does anyone have any good resources they can point me at?
Dave
NB: I'm talking about the hardware/instance configuration side of ...
3
votes
4
answers
1k
views
How can I make this setup faster?
Hey StackOverlow Community,
I currently am using some software that stores a bunch of XML files. All the files are under 25k bytes. The makers of the software state the performance is based on ...
9
votes
3
answers
7k
views
What are your tricks for optimizing your Subversion configuration?
For a Linux or Windows system, what tricks do you do to optimize your Subversion server?
The following are my current tricks for a Linux system serving over Apache with HTTPS and backed by Active ...
19
votes
2
answers
71k
views
Tuning (and understanding) table_cache in mySQL
I ran the excellent MySQL performance tuning script and started to work through the suggestions. One I ran into was
TABLE CACHE
Current table_cache value = 4096 tables You have a total
of 1073 ...
1
vote
5
answers
221
views
Network Monitoring and Filtering [closed]
As the IT administrator for my company I have been tasked with deciding what traffic to filter, shape, and othewise monitor on our network. What protocols, applications, and other network traffic do ...
1
vote
1
answer
279
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 ...
0
votes
1
answer
1k
views
How to use oprofile to find the bottle-neck of our web server?
Updated:
================================================================
I finally found the reason with oprofile. It was because the routing cache of Symfony. We have lots of pages with different ...
133
votes
4
answers
184k
views
FreeBSD performance tuning: Sysctl parameter, loader.conf, kernel
I wanted to share knowledge of tuning FreeBSD via sysctl.conf / loader.conf
/ KENCONF / etc. It was initially based on Igor Sysoev's (author of nginx)
presentation about FreeBSD tuning up to 100,000-...
3
votes
6
answers
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
3
answers
6k
views
How can I improve NFS performance on a gigabit LAN?
I have a Solaris 10 server with a Mac OS X clients on a gigabit LAN. The Solaris server exports a RAID-Z backed NFS share and all the clients connect to it. However, transferring files is slower ...
20
votes
7
answers
38k
views
yslow says etags are misconfigured. how to configure etags properly on IIS7?
running ySlow on a website I support, I noticed it reported that the etags are misconfigured for the site images (e.g. *.jpg, *.png, *.gif). Can anyone help explain what I have to do to get IIS7 ...
1
vote
1
answer
880
views
Virtual server freeze (apache ?)
I rent a small virtual server at 1und1.de. (Link, but German only) (2GB RAM dynamic, 512MB at least, 20 GB HDD) I choose to run a Ubuntu 8.04 LTS as operating system (64 Bit). I installed apache2 + ...
1
vote
1
answer
4k
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 ...
-3
votes
2
answers
744
views
What are the optimal tuning values for RHEL 5.3 Xen kernel on a Dell 2950? [closed]
How to do Linux Tuning and Performance? any one has done for xen kernel ?
10
votes
6
answers
15k
views
Configuring NTFS file system for performance
We have an application that is planning to store around 1.1TB of XML files which average 8.5kb in size.
These represent a rolling 18 months of data, with around 200,000 new files being created every ...