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
4answers
4k views

Improve server performance by configuring MySQL [closed]

I have a server with 8GB of memory, running CentOS 5.4, php 5.2.9, mysql 5.0.77. I have a very large databse of about 20GB (InnoDB and MyIsam tables) and website using it. Website has about 20000 ...
1
vote
1answer
7k views

MySQL config and optimization

Here is the info for my server Giga Dedicated 6-Core: Intel Core i7 (6 x 3,20GHz) 24 GB RAM 160 GB SSD + 2000 GB HDD I have CentOS 5.6 (64bit) installed and Plesk Panel 10 Apache version is 2.2.19 ...
0
votes
2answers
481 views

what is the best way to find the bottlenecks on my LAMP web server?

can you help me find the bottle neck on my server. In the previous question I asked on SF, I was told that memory is no problem and I have plenty of it. I'm curious about CPU, perhaps HDs ... what ...
-2
votes
2answers
763 views

how to optimize apache on web-server

how can I optimize the server with following configuration. It takes too much time to load a page. IBM X3200 M3 Server - 1 Intel Xeon Processor with 4 GB Ram Below is my current configuration for ...
0
votes
1answer
36 views

If i were to develop a software for DBA's to help them in query optimization, what features could i incorporate? [closed]

What would be your expectations from such a software. I am planning to show the DBA a list of the top cpu and memory intensive queries along with the query plan, etc. How could i assist the DBA more ...
2
votes
1answer
770 views

Apache Server status, is this a bad sign?

I've been monitoring my Apache Status lately, and a lot of my users are saying how slow the site is to respond. Here is the Apache Status: Current Time: Tuesday, 21-Jun-2011 20:58:45 EDT Restart Time:...
4
votes
2answers
1k views

Does it makes sense to run “optimize table” when the mysql database is stored on SSD?

The manual says about "optimize table": "Deleted rows are maintained in a linked list and subsequent INSERT operations reuse old row positions. You can use OPTIMIZE TABLE to reclaim the ...
-1
votes
1answer
171 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
147 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
602 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
123 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
135 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
311 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
133 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 ...
29
votes
8answers
26k 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 hosted/...
0
votes
2answers
853 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
8k 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
2k 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
850 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
792 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
93 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 ...
19
votes
2answers
10k 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
147 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
899 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
2k 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
146 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
748 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 ...
4
votes
5answers
12k 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
5k 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
8k 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
314 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
2answers
485 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
199 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
1k 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 second), ...
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 ...
8
votes
2answers
6k 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
816 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
409 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
259 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
395 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
327 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
483 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
435 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 ...