Optimization is the process of modifying a system to make some aspect of it work more efficiently or use fewer resources.

learn more… | top users | synonyms

2
votes
5answers
6k views

CPU's on Hyper-V host system is just idling, even though VM's are at full throttle

I have a server that is running Windows 2008 64 bit Hyper-V, with 8 gigs of RAM and Intel Xeon X3440 @ 2.53 Ghz, which gives me 8 logical cores in the performance monitor on the host system. I have ...
3
votes
3answers
2k views

Have I pushed the limits of my current VPS or is there room for optimization?

I am currently on a mediatemple DV server (basic) 512mb dedicated ram, this is a CentOS based VPS with Plesk and Virtuozzo. My experience with it from day 1 has been bad and I only could sooth my ...
2
votes
2answers
164 views

Will spreading your servers load not just consume more recourses

I am running a heavy real-time updating website. The amount of recourses needed per user are quite high, ill give you an example. Setup Every visit The application is php/mysql so on every visit ...
2
votes
1answer
1k views

How to optimize a postgreSQL server for a “write once, read many”-type infrastructure?

Greetings, I am working on a piece of software that logs entries (and related tagging) in a PostgreSQL database for storage and retrieval. We never update any data once it has been inserted; we might ...
2
votes
3answers
373 views

PostgreSQL lots of writes

I am using postgreSQL for a scientific application (unsupervised clustering). The python program is multi-threaded so that each thread manages its own postmaster process (one per core). Hence, their ...
0
votes
5answers
1k views

Subversion/Hudson/Sonar/Artifactory - too much for my little server to handle! Help!

I have a little dedicated server. It's at a cheap price and has a simple AMD 1800+ (1.5ghz), 256mb DDR RAM, ...need I continue? And I think I'm overloading it already. I have installed the following, ...
1
vote
1answer
2k views

MySQL Created_tmp_disk_tables

I'm trying to improve the performance of our primary MySQL server. It's a Dual Quadcore Intel X5450, with 8GB of RAM. It's a dedicated MySQL box. I'm only in the beginnings of configuring it, so ...
0
votes
2answers
84 views

Second server instance (for static files) on a standard host?

Serving static files from an independent host from the rest of my website is supposed to improve performance. I'm cheap, so I was wondering if I can do that within one standard hosting service. ...
6
votes
2answers
462 views

Do you remove unwanted packages (*NIX), or do you disable them?

Im currently building a cobbler and puppet setup. One thing I do is disabling unwanted services with puppet, but then I thought: Should I remove them with cobbler, rather than disabling them after ...
1
vote
1answer
312 views

What is the fastest way to optimize a MySQL table?

I've ran many different DELETE queries against many tables in the huge database (hundreds of millions records). What would be faster - to run OPTIMIZE TABLE against each modified table. Or just to ...
2
votes
1answer
340 views

CPU bound process?

I have a postgresql server process running on my windows computer. When running a query I can see in the process manager that it is using 49% of CPU capacity on my dual core processor and it is also ...
2
votes
3answers
1k 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 ...
0
votes
1answer
79 views

Cost of Parameterization in SQL Server 2008

Does Anybody know absolute or relative cost of forzed parameterization in SQL Server 2008?
1
vote
4answers
2k 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 ...
6
votes
6answers
7k views

How many files in a directory is too many? (Downloading data from net)

Greetings, I'm writing some scripts to process images from various photo websites. Right now I'm storing all this data in individual text files in the same directory. The directory is web ...
1
vote
1answer
341 views

LEFT JOIN Server Performance optimization

I have a query that I want to execute that fastest possible. Here it is: select d.InvoiceDetailId,a.Fee,a.FeeTax from InvoiceDetail d LEFT JOIN InvoiceDetail a on a.AdjustDetailId = ...
7
votes
1answer
3k views

How to select the best Stripe Size when configuring a RAID Array

There are various "references" on the Internet that delve into some discussion about what factors to consider when selecting a particular RAID stripe size (4KB to 128KB or more) for an array of disks, ...
0
votes
2answers
126 views

mySQL Database Performing Extremely Poor on INSERT, DESTROY, but fine on FIND and UPDATE

I believe I've encountered a database scaling issue. I have a table with nearly a million rows in it now and our rails application appears to be hanging whenever we try to create a new instance. I ...
0
votes
1answer
194 views

Oracle hardware requirements and optimization [closed]

I'm an application developer. We have some reporting solution for our client on Oracle database 10g. They would like to speed up execution of some calculation stored procedures. Ok, I know about query ...
2
votes
1answer
3k views

Any guide to set values for fastcgi_buffers in Nginx config?

I just moved our blog-network to ngnix (from apache) which is powered by WPMU. Everything is running smoothly and fine. During my quest to optimize server to the max level - I came across this thread ...
0
votes
2answers
2k views

How to optimize my.cnf and httpd.conf for speed on a powerful dedicated server?

I have a dedicated server that has 12GB of RAM and Dual Nahalem Quad Core processors. My site usually only has about 50-100 users online at a time (though once I get the server optimized I plan on ...
0
votes
1answer
518 views

What is star query optimization?

I found in a features table for SQL Server 2005 a row named "Star query optimization" but it is not explained anywhere. Could this be a feature that optimizes a query like : SELECT * FROM Table
2
votes
1answer
289 views

Recommendations for Java Web Server [closed]

I am currently using DBCP for connection pooling since it is more or less provided with tomcat and easy to setup. I am thinking about migrating to Glassfish or Jetty and haven't yet determined which ...
1
vote
1answer
546 views

Optimizing Apache

I've been reading multiple optimization guide for apache and found a lot of data (Although I have no idea what is the experience of the authors). I have a production server with apache 2.2.3, MySQL ...
1
vote
1answer
1k views

Performance issue with Apache, PHP and Symfony

Updated: ================================================================ I finally found the reason with oprofile. It was because the routing cache of Symfony. We have lots of pages with different ...
0
votes
2answers
3k views

Can I safely stop running Update Statistics on my SQL Server 2005 instance?

I've got a SQL 2005 database which has some maintenance plans on it set up by someone else. One runs Update Statistics on all databases early in the morning. It seems this is causing tempdb to fill up ...
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 ...
19
votes
3answers
42k views

Optimal values for ServerLimit, MaxClients, MaxRequestsPerChild directives

I'm running a traffic intense site plenty of dynamic content, mostly user-generated. The server is a dedicated one and has a total of 4 Intel(R) Xeon(R) CPU X3210 @ 2.13GHz proccesors. I need to know ...
1
vote
1answer
59 views

Image optimization tools?

I'm trying to do research on finding a good jpeg and gif optimizer for linux command but the ones I'm finding date back to 2001 which may be good but it's hard to believe there have been no advanced ...
2
votes
3answers
629 views

What optimizations can be performed on SQL Server with SAN?

This question is a bit general since I am not exposed to SAN (Storage Area Network). Are there any optimizations or configuration changes that can be performed with SAN to improve SQL Server ...
0
votes
3answers
843 views

How to optimize postgresql for use with Jackrabbit (a lot of blobs)?

Jackrabbit is a implementation of the JCR (Java Content Repository API), and it is used for instance by Artifactory which stores the maven artifacts in it. Therefore most of the stuff consists of ...
1
vote
1answer
176 views

SBS 2003 exchange database optimization period, should it be before the sbs full backup or after backup is done

i just want to check something. i always thought that a full sbs 2003 backup (through backup wizard) actually optimized the database of the exchange server. i was curious to see if you would suggest ...
4
votes
2answers
2k views

Performance problems when running Java desktop applications on Citrix Metaframe

We have a desktop Java application running within a Citrix Metaframe server farm and the performance, specially while starting up the app, is very unreliable. Sometimes it takes 15 seconds and ...
4
votes
3answers
188 views

run local MySQL instance for fast mysql_real_escape_string calls

Currently all MySQL data/API calls are handled by a remote DB cluster (i.e. network latency is a factor in total script execution time). To reduce execution time in this context, would it be sensible ...
3
votes
4answers
7k views

Windows file server performance tuning

I seek your opinion and tips/suggestions in optimizing the performance of a new Windows file server I'm building. I've inherited a Dell NF500 storage server (basically Dell 2950 with Windows 2k3 ...
6
votes
3answers
4k views

Guest optimization tips for Ubuntu on VirtualBox [closed]

I was wondering if anyone could shed light into "Guest optimization tips for Ubuntu (guest)" I came across http://serverfault.com/questions/18290/virtual-machine-guest-optimization-tips, for Windows. ...
0
votes
2answers
1k views

NFS Caching Causing Intermittent Lag

We're running nfs over a cluster of isilons and are intermittently experiencing quite a lag when creating a dir on one machine and reading on another (of about 30s). This only seems to happen when ...
0
votes
2answers
928 views

Best practices and tools for monitoring performance and status of IIS server, PHP, MySQL

What would you guys use to monitor an IIS server performance, detect and respond to errors etc, find bottlenecks, visualize CPU utilization under load, monitor PHP MySQL performance etc. cheers
2
votes
2answers
365 views

TCP Optimization for WinXP

Is there any benefit to optimizing my network connections (TCP) using tools like the TCP Optimizer? http://www.speedguide.net/downloads.php If there is a benefit, how does one do it right?
4
votes
8answers
4k views

Optimize a fresh Ubuntu server installation

After installing a fresh Ubuntu server (I personally use 8.04 LTS) what do you do to optimize it in terms of memory consumption, disk usage and speed? What services and pre-installed packages do you ...
17
votes
6answers
13k views

Optimize apache/php/mysql running on VPS for heavy load

Question about optimizing an apache/mysql server on a VPS with 512m of RAM. Under normal load everything runs fast, no connection lag. However when we get our heavy traffic days (50k+ visits) the ...
1
vote
3answers
657 views

Apache rewrite rule (that already works) optimization : any good advice?

Here's my goal : I have 9 websites running (names changed of course) : we.com we.fr doo.com doo.fr fpp.com ke.com wpp.com wgg.com t-y-u.fr I wanted for each website : a directory to put a ...
4
votes
3answers
2k views

Way to configure apache for ~125 django sites to optimize memory usage (mod_python v mod_wsgi; worker vs prefork; static files)

I'm currently running 125 Django sites on a single dedicated box at GoDaddy. The sites are relativelly low traffic and I'm wondering what i can do to optimize the memory usage in my apache config. ...
3
votes
6answers
2k views

Method for finding unnecessary indexes of an operational SQL Server database?

Besides wasting space on the database, unnecessary indexes on SQL Server can slow down insert and update operations. Developers who lack experience in database principles sometimes tend to create ...
0
votes
7answers
511 views

High performance web server with no database interactivity

I'm getting ready to setup a server that will be responsible for tracking statistical data from a high volume traffic source. It will be handling requests at about 6-7mil/hour on average, all of ...
1
vote
9answers
1k views

What default Windows setting to change to optimize for performance?

Introduction: I am responsible for more than 100 PC's in a medium sized company, and when I install new PC's with the default windows settings, I always wonder which settings could actually be ...
3
votes
8answers
2k views

Scaling a LAMP stack

Once you move beyond 100k hits/month, what would people in this community say is the biggest hurdle? My situ: Tons of static media (audio/video/images) being served off of S3/CDN, but being stored ...
1
vote
4answers
388 views

Setting up an environment optimized for hosting apps based on Zend Framework

I would like to setup a hosting environment on a VPS that is used to host Magento. Magento is an eCommerce platform based on Zend Framework. The OS is definitely going to be Linux. As a first timer, ...
9
votes
1answer
914 views

How can I tell when it is time to defrag my SQLServer database?

What is the best practice for measuring SQLServer database fragmentation/performance rolloff and determining when to defrag a SQLServer database table? I'm most interested in learning what the useful ...
5
votes
4answers
5k views

Profiling Apache+Mysql+Php server - which is the bottleneck?

How do I profile an Linux + Apache + Mysql + Php server for speed? I have a server with a heavily modified MediaWiki instance running on Ubuntu 8.04. It's a bit sluggish - I haven't done anything to ...