Questions tagged [optimization]

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

A system may be optimized so that it executes more rapidly, or is capable of operating with less memory storage or other resources, or draw less power. The optimized system will typically only be optimal in one application or for one audience. For example, one might reduce the amount of time a task takes to perform at the price of making it consume more memory.

339 questions
0
votes
2 answers

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 -c | sort -n 134 207.x.xx.134 //This was the…
Moe
  • 13
  • 5
0
votes
1 answer

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' AND amp_ads.en_w = '1' AND amp_c.en_u = '1' AND…
Continuation
  • 3,080
  • 5
  • 30
  • 38
0
votes
1 answer

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 for query execution. I'm interested in whether…
0
votes
3 answers

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 appears to only affect the web server and not the…
MattB
  • 238
  • 2
  • 3
  • 10
0
votes
3 answers

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 very long chains. This link shows an example. My…
Khaled
  • 36,533
  • 8
  • 72
  • 99
0
votes
0 answers

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 tomorrow according to iotop and slowing the site. …
OneOfOne
  • 222
  • 4
  • 13
0
votes
3 answers

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 virtualized infrastructure and we've always…
luison
  • 282
  • 1
  • 7
  • 22
0
votes
2 answers

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 innodb_buffer_pool_size = 1G innodb_log_file_size =…
0
votes
2 answers

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 subdomain. Furthermore, I have 1000 cron jobs…
GTE
  • 1
0
votes
1 answer

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 of page faults I am seeing if it were larger, say…
Adam Fox
  • 137
  • 5
0
votes
1 answer

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 full performance of speed as I use heavy data…
bbnn
  • 219
  • 1
  • 3
  • 10
0
votes
1 answer

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 devices (with 5 minute interval pulls to the…
Andres SK
  • 238
  • 3
  • 7
  • 22
0
votes
1 answer

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 database via the IP address 127.0.0.1) to add the…
doron
  • 101
  • 1
0
votes
2 answers

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 table cache value is probably too small. I just…
Ben
  • 3,800
  • 18
  • 65
  • 96
0
votes
1 answer

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 we start to analyse it? It is PHP based with a…
jigs
  • 91
  • 1
  • 1
  • 2