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

0
votes
2answers
1k views

How to speed up a server using netstat & httpd.conf?

I'm using netstat commands to help optimize my httpd.conf correctly. Here are the results: netstat -an | grep -c :80 579 netstat -anp |grep 'tcp\|udp' | awk '{print $5}' | cut -d: -f1 | sort | uniq ...
1
vote
2answers
766 views

How to optimize Xen Virtual Machine

My server is Core i7 Quad Core I7-860 2.8GHz, and 4 GB DDR3-1333 SDRAM How many xen could I create if each of them has 256 MB memory? How much memory should I leave to the Xen Server(1G?512MB?why?) ...
4
votes
0answers
171 views

What does it mean when Twitter says their entire database is in RAM?

I am wondering where to begin with database scaling/optimization strategies. After reading articles like highscalability.com's facebook architecture article, and this twitter architecture article, I ...
3
votes
1answer
506 views

Memcached - one large instance vs many smaller

I will be adding a memcached server to my web app to offload lots of db requests. I'll be mostly caching different small id-name pairs (memberid-membername, blogid-blogname, etc) and expect total ...
1
vote
4answers
90 views

Requesting Oracle DBA to use SCSI instead of IDE

We want to improve the performance of our oracle database which stores around 10 TB and is OLTP. I noted that the Oracle server uses IDE hard drive, and have heard that SCSI is faster than IDE. Will ...
17
votes
2answers
9k views

IIS 7.5 optimizations for a site serving only static content

I'm looking to setup a cookie-free domain intended to serve static content for a web application, similar to the http://sstatic.net/ site that the stack exchange sites use. My question is, what ...
1
vote
2answers
136 views

Where should you do WAN optimization?

Interested in this technology - some vendors do WANop up at layer7, others down in the network layer. Those who are app-aware say that accelerating apps is the way to enhance their performance, the ...
2
votes
1answer
2k views

optimize nginx for large file downloading

Hey, I'm wondering what are some general options I should look into for optimizing an nginx server for large file downloading (typically 100mb to 6gb). I just migrated from lighttpd and I'm noticing ...
1
vote
2answers
728 views

Php + Apache + Mysql + [anything] Server cluster - pitfalls, hints and roadmaps to efficiency

The need has arisen for a clustered server setup (is that what it's called?) in my company. We have our hosting rented abroad, and as such have limited access to the actual hardware, but we have total ...
0
votes
1answer
1k views

Weird MySQL query plan: why is this query using temporary & filesort? How to optimize it?

I have a query: SELECT * FROM amp_ads,amp_c,amp_c_countries WHERE (amp_c.zone = '24' OR amp_c.zone = '25') AND amp_ads.ad_complete = '1' AND amp_ads.ad_type = '17' AND amp_ads.accept = '1' ...
0
votes
1answer
139 views

MySQL's Query Optimizer's take on disk access time

I don't have a ton of background with MySQL, and I was wondering of anyone can give me some insight into MySQL's query optimizer and the impact on the cost of disk accesses in determining a query plan ...
1
vote
3answers
536 views

Any open source software for measuring & monitoring MySQL performance?

I'm working on improving the performance of a MySQL server. I'm looking for something to measure & monitor the performance of MySQL (as query per second) over time so that I can measure any ...
3
votes
5answers
8k views

How to Best Manage High PostgreSQL CPU Use?

I am trying to fix a high PostgreSQL CPU use problem. We are using PostgreSQL 8.0.9 and when our JEE web application (in JBoss) is used in certain load increase conditions, top shows a slow increase ...
7
votes
1answer
3k views

How to disable keys in MySQL InnoDB tables?

Is it possible to disable keys in InnoDB tables? If yes, how? If not, why?
0
votes
3answers
77 views

LAMP server has gone down a few times. Ideas for server optimization?

Our production web server has gone down a few times over the course of the last half year. In the end, we've needed to contact the web host and have them restart as I'm unable to even SSH in. This ...
0
votes
3answers
1k views

iptables performance optimization

Iptables can be optimized by putting the mostly used rule on the top such as the known related rule that matches after connection establishment. Also, optimization can be done by using jumps to avoid ...
2
votes
2answers
7k views

How can I optimize Apache to use 1GB of RAM on my website?

My VPS plan gives me 1GB of RAM burstable to 2GB. Of course I cannot use 2 GB, nor > 1 GB, everyday, so I'm planning to optimize the performance of my webserver. The average of hits-per-hour is ...
1
vote
0answers
258 views

page loading stops half-way, no server or sql load

i'm running a hostgator vps php/apache/linux/mysql i have a problem that i cannot seem to properly diagnose/fix : sometimes when loading a page, the browser will load have the page, then it hangs ...
1
vote
1answer
398 views

Moving mod_rewrite rules in .htaccess to httpd.conf

I've got a massive set of URL rewriting rules that I am trying to: optimize transition to use within httpd.conf But I'm facing problems in getting the final product to work. Note: There are ...
0
votes
0answers
194 views

MySQL is killing the server IO

I manage a fairly large/busy vBulletin forums (running on gigenet cloud), the database is ~ 10 GB (~9 milion posts, ~60 queries per second), lately MySQL have been grinding the disk like there's no ...
1
vote
6answers
973 views

MySQL is killing the server IO [duplicate]

Possible Duplicate: MySQL is killing the server IO. I manage a fairly large/busy vBulletin forums (running on gigenet cloud), the database is ~ 10 GB (~9 milion posts, ~60 queries per ...
0
votes
3answers
1k views

Serving images from another hostname vs Apache overload for the rewrites

We are trying to improve further the speed of some sites with older HTML in order as well to obtain better SEO results. We have now applied some minify measures, combined html, css etc. We use a small ...
6
votes
1answer
4k views

Nginx auto minify html output

does anyone know of a way to get nginx (or any other method) to minify html output on the fly? It seems straightforward to me and can shave a few kb off and help speed up the site.
5
votes
2answers
3k views

Optimizing MySQL for small VPS

I'm trying to optimize my MySQL config for a verrry small VPS. The VPS is also running NGINX/PHP-FPM and Magento; all with a limit of 250MB of RAM. This is an output of MySQL Tuner... -------- ...
0
votes
2answers
735 views

changing innodb_buffer_pool_size makes error

i want to increase my innodb_buffer_pool_size value to get some more performance and when i try, my select queries arises error such as "Incorrect information file in .." i'm just adding ...
0
votes
2answers
399 views

Nginx and 1000 WordPress Installs - Optimization

I'm trying to create a rather unusual (imo) configuration where I have: nginx php-fastcgi mysql 1000 seperate WordPress installs (with WP Super Cache). Each WP install corresponds to a separate ...
2
votes
6answers
243 views

What are the practical differences between an IP address and a server?

My understanding of IPs and other DNS-type server-related issues really falls short (read: exteme noob). I know a dedicated server would increase speed. What, if any, difference in speed would a ...
0
votes
1answer
359 views

Changing the memory page size in Windows 2003 Server

I asked a question about soft page faults here without any answer yet optimization of soft page faults I wonder whether changing the default page size (4Kb) would make any difference to the number ...
0
votes
1answer
311 views

Optimal my.cnf settings for MacBook Pro 15" i7 (localhost)

What is the most recommended optimal my.cnf settings for the newest MacBook Pro 15" i7 with 4GB of RAM. http://www.apple.com/macbookpro/specs.html Only for local processing only. I want it to be ...
1
vote
1answer
464 views

vmware esxi linux guest optimization

I'm currently experiencing a problem whereby load on one guest is adversely affecting load on other guests located on the same host. What I'm curious about is what best practices are there for ...
1
vote
1answer
380 views

Optimization of Soft Page Faults

I am currently doing performance analysis on a server and I see an application is generating a large number of page faults/sec. After checking the page reads/sec it seems these are all soft page ...
1
vote
3answers
2k views

Why is there high load on my cpu if both %cpu usage is low and %memory is low?

I have a Rackspace cloud server running Ubuntu with 2GB memory that is being used as an application server (the html & php files are loaded from this server and the mysql database is on another ...
0
votes
1answer
336 views

Rackspace: optimizing LAMP environment (using memcached)

i recently moved a web app to Rackspace (CentOS). It runs pretty well with 512mb RAM but im sure i will have to upgrade it to 1024mb RAM pretty soon. The bad news, is that the service runs on mobile ...
2
votes
1answer
10k views

How to set query_cache_size and join_buffer_size in my.cnf file?

I have been monitoring my server the past two days and realised that 60% of my temp tables are stored on the hhd instead of memory. Also I ran MySQL Performance Tuning Primer script that adviced me to ...
1
vote
4answers
2k views

Adjusting MySQL settings to handle big load of users

I have developed a php game that is obviously depending on mysql queries. Im running it on a monster server: Intel Xeon 7550 with 32GB RAM (Redhat x86_64 ES 5.0) with cPanel installed. I released the ...
0
votes
1answer
291 views

Postgresql Optimization

I am running a more or less out the box Postgresql installation which is running really slowly. I am parsing a whole bunch of logs files using Perl and using Perl's DBI interface (connecting to the ...
1
vote
1answer
620 views

Magento and Media Temple, playing nicely

I am trying to get the page load time as low as possible in my Magento store. I am using a Media Temple (dv) Extreme, which has 2GB of RAM. I have had APC setup along with Fooman Speedster plugin for ...
2
votes
1answer
275 views

The cost of MySQL filesort and what's the solution?

I'm new to optimizing MySQL (cheers for having a high traffic site!) and I'm a little confused by filesort. I stumbled onto this article: ...
2
votes
1answer
208 views

MySQL logging slow queries

I've told MySQL to log queries that take longer than a second (1 in the config)... however I'm seeing queries like this that take much less than a second.... # Time: 101108 6:39:32 # User@Host: ...
0
votes
2answers
1k views

MySQL 2,500+ opened tables

I'm running 16 GB of RAM with dual 3.0 Ghz processors with Ubuntu Server My PHPMyAdmin is showing: Opened_tables 2,573 - The number of tables that have been opened. If opened tables is big, your ...
1
vote
2answers
299 views

Recommend a good guide for MySQL optimization

I just upgraded my RAM on my server from 4 GB to 16 GB and I'm told that I can utilize this memory to a huge advantage with certain MySQL settings if I get then just right. Do you know of any guides ...
3
votes
3answers
943 views

How to determine bottlenecks on Ubuntu LAMP environment

What kind of tests should I run to determine bottlenecks on my server? I'm trying to optimize so I can maintain heavy load spikes when they occur. I'm running Ubuntu in a LAMP environment.
1
vote
1answer
47 views

Compile primary services for performance gain

Greetings, Is it worth it to compile primary services like Apache, MySql and on another note, the kernel to squeeze out more performance? Ubuntu 10.04 64bit // EDIT I mean compile from source with ...
0
votes
1answer
119 views

Optimizing a Facebook application… where should I start?

We have developed a Facebook application... we launched and had over a thousand users in 12 mins. The problem is the application did not handle it and so we had to take it back offline. Where should ...
2
votes
4answers
239 views

What's the fastest way to server a single static webpage from a single server in memory?

Been dealing with growing demands for system resources on a website, and got me thinking: What's the fastest way to server a single static webpage from a single server in memory? Feel free to ask ...
7
votes
1answer
1k views

When should you use and not use Etags?

I was just looking at our site on WebPageTest.org and one of their recommendations for speeding up a website is: ETag headers should generally not be used unless you have an explicit reason to ...
0
votes
3answers
227 views

Does this top look healthy to you?

I run a server with the following specs: Intel i7 920 8 GB RAM Linux 2.6.32-25-server #44-Ubuntu 10.04 SMP Fri Sep 17 21:13:39 UTC 2010 x86_64 GNU/Linux 75 Apache processes Low-end hardware RAID-1 ...
0
votes
1answer
3k views

What are the kernel and cflags for AMD Phenom II x6 (K10 / Thuban)?

In the 2.6.35 kernel I have a choice of: Operon/Athlon64/Hammer/K8 Generic-x86-64 The first option seems best but I'd like confirmation. I have no idea whether there is a specific -mcpu / -march ...
3
votes
2answers
934 views

Do access logs (from nginx) slow down a website?

Does it slow down a website if your webserver (in my case, nginx) is writing to an access log? I'm mostly wondering if it's noticeable. Plus, what's the point of knowing the user agents / ips that ...
0
votes
3answers
314 views

Load balancing w/out a “front server”

I don't know too much about complex server setups (that's why I'm asking the question). My understanding is that generally you have a "load balancing" server that sends requests to other backend ...