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
vote
1answer
373 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
3answers
991 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 ...
5
votes
1answer
3k 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
694 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
387 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
233 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
342 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
293 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
458 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
359 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
1k 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
335 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
9k 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
283 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
603 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
256 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
203 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
290 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 ...
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
237 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
226 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
842 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
312 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 ...
1
vote
1answer
202 views

Accurately benchmarking a server

I'm getting a server ready for production, and I'm trying to accurately estimate how much it can handle. For example, on one of the static pages (the whole page is the same all the time), If I run ...
2
votes
5answers
295 views

mysql - is there a good way of storing it in ram

I'm trying to think of ways to make mysql faster. Is there a proven way of storing it in ram to allow it to work faster?
2
votes
1answer
624 views

mysql my.cnf for a 50GB of RAM server

I am having load problems on my database server (dual quad core 50 GB RAM) load average: 4.26, 6.78, 11.25 here is the current my.cnf, can i optimize it? [client] port = 3306 socket ...
0
votes
1answer
156 views

Scaling horizontally

I know next to nothing about having more than one server work together. Right now I've been playing around with the cloud servers offering from rackspace. All the time when people talk about these ...
2
votes
1answer
764 views

XDEBUG/PHP doesn't dump profile even when set up properly?

I installed xdebug from source, but also tried my package manager (separately) and they both are loaded correctly (verified by restarting Apache and seeing the xdebug copyright info in phpinfo()) but ...
1
vote
1answer
108 views

Mysql- How can I find the memory usage of indexes

mysqltuner tells me to increase key_buffer_size dramatically. I dont have free memory to do it therefore I prefer to remove unnecessary indexes if any. How can I find the memory usage of indexes? ...
1
vote
1answer
153 views

how to make a server that handles 1000 clients [closed]

I am looking for server software to handle data for thousands of clients (internal company employees). This server should be multi-threaded to handle all the clients with good client overhead ...
1
vote
1answer
134 views

Bacula optimization/profiling tools

I'm trying to get an idea of where the bottlenecks are in our backup system. Are there tools available for profiling this? If not, any pointers to a home grown method would also help. I guess most ...
0
votes
1answer
56 views

Can having native mobile app for your website reduce server load?

Sorry guys, I'm a bit new to this. I'm not sure if I'm asking the right questions here. I'm creating an iPhone app for my website, and most of my users are going to use it through the iPhone rather ...
0
votes
1answer
548 views

Optimize windows 2008 performance

I have windows server 2008 sp2 installed as virtual machine on my personal laptop. I use it only for source control (visual svn) and continuous integration (teamcity). As the virtual machine resources ...
0
votes
4answers
793 views

Do i need to allocate more resources to mysql server?

I have feeling that mine mysql server is slower than normal while processing queries from the PHP website. Is there anything like i can allocate more resources to Mysql server to make it speedy? I ...
5
votes
4answers
191 views

Is it good or not to include all frequently used and important addresses in /etc/hosts?

Is it generally considered a good or bad practice to include all frequently used and company's important hosts in /etc/hosts? Now I can see the following pros and cons: Pros: improved speed, ...
1
vote
1answer
264 views

optimizations for a server with nginx as the front and apache as the back?

Are there any general optimizations for this sort of setup? I read something about nginx not using the most recent protocol in http, so are there things that I could tune apache for? Also, is there ...
2
votes
3answers
2k views

MySQL too many connections

On my server I have 7 databases. Our server has 512 MB of RAM which I'm getting upgraded this evening to 2GB and has a 2.4 single processor. I've gotten an error about the connection limit exceeded. ...
1
vote
3answers
2k views

Disable Memory Modules In BIOS for Testing Purposes (Optimize Nehalem/Gulftown Memory Performance)

I recently acquired an HP Z800 with two Intel Xeon X5650 (Gulftown) 6 core processors. The person that configured the system chose 16GB (8 x 2GB DDR3-1333). I'm assuming this person was unaware these ...
1
vote
1answer
105 views

SQL Server 2008 Optimization

I've learned today, if you append to your query OPTION (MAXDOP 0) your query will run on multiple processors and if it's huge query, query will perform faster. I know general guidelines on query ...
1
vote
1answer
2k views

How to get the best LINPACK result and conquer the Top500?

Given a large Linux HPC cluster with hundreds/thousands of nodes. What are your best practices to get the best possible LINPACK benchmark (HPL) result to submit for the Top500 supercomputer list? To ...
0
votes
3answers
289 views

Speed up MySQL for inserts (for testing purposes)

I have a bit of software that needs to do a lot of INSERTs. In production environment there'll be some serious tweaking and testing and stuff like that, but now when I need to test it I'd like to ...
14
votes
2answers
11k views

How to determine the best byte size for the dd command

I know that doing a dd if=/dev/hda of=/dev/hdb does a deep hard drive copy. I've heard that people have been able to speed up the process by increasing the number of bytes that are read and written at ...
1
vote
2answers
2k views

AB failed requests - What can I do about them?

So, in the past I've never had any problems with this app. All benchmarks had 100% success rate. Yesterday I set up nginx to server static content and pass on other requests to apache. Now, if I have ...
1
vote
2answers
875 views

MySQL Config on Large Machine

We have a Windows 2003 Enterprise Edition server (64bit) running only MySQL 5.1.45 64-bit. It has 16G RAM and 10T of hard-drive space in RAID 10. We are having horrible performance from mysqld ...