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

-1
votes
1answer
159 views

Should a well-optimized ad server be able to run fine on a single dedicated server?

This is a completely hypothetical question that myself and a colleague have been wondering/debating about, and we thought some of the knowledgeable people at SF could shed some light. Say, for ...
0
votes
1answer
144 views

MySQL Optimization in Many Inserts Few Selects Environment

I am working with a MySQL database that is mainly used to do inserts and almost never selects. Unfortunately, the system is already deployed and working, 24x7 roughly 14k inserts/day, and I cannot ...
0
votes
1answer
517 views

Random Lag in Apache before serving files

I've been trying to troubleshoot some random lag that happens in less than 3% of requests I'm sending to my server. I wrote a testing script that uses PHP's file_get_contents on a seperate server and ...
1
vote
1answer
121 views

Caching functions - fwrite vs memcache

Which will be faster and best option? Page will load faster with fwrite or memcached cached function? I need to store some functions in cache, they will not update very often, so need only to read it. ...
1
vote
1answer
110 views

volatile partitions on linux

I thought I've read somewhere that you can take a slice of RAM and turn it into a partition with a FS on it and everything. What is the relevant terminology and the tools to accomplish this? I need ...
0
votes
2answers
310 views

Server is too optimized?

I have a linux 4gb Quad core server w/ apache that is used for this website. I notice when I go to SSH and type TOP to see load averages, they are usually around 0.80. Now from what I understand, if ...
0
votes
1answer
125 views

Optimizing MySQL Database for wordpress

I am maintaining a blog with self hosted wordpress. For the last 5 months, my blog isn't really active as I hit "Server Error 500". The error says "The FastCGI process exceeded configured activity ...
0
votes
1answer
2k views

MySQL temp tables being created on Disk

I recently started noticing that a large sum of my tmp tables of my MySQL is being created on my Disk rather then in the memory. TEMP TABLES Current max_heap_table_size = 128 M Current tmp_table_size ...
27
votes
8answers
22k views

Why rsync is faster than NFS?

Few days ago I noticed something rather odd (at least for me). I ran rsync copying the same data and deleting it afterwards to NFS mount, called /nfs_mount/TEST. This /nfs_mount/TEST is ...
0
votes
2answers
748 views

Switching on MySQL query profiler for a website?

I want to "swtich" on the sql query profiler for my php/mysql site and leave it ru nnig for a while. The idea is to capture usage details over a day and then analayze the queries and work out which ...
1
vote
1answer
7k views

key efficiency 99.97% mysql

using the mysql workbench administrator - my key efficiency is at 99.97% i have read about adding 'key_cache_size=100M' to my.cnf and increasing it as needed is this the correct fix for the problem? ...
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
793 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
172 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
572 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
92 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 ...
18
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
138 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
782 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
584 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
9k 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
4k 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
79 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
277 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
421 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
196 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
981 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
5k 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
752 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
401 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
248 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
369 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
315 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
469 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
395 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
338 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
293 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
627 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
284 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
214 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: ...