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
1 answer

Windows 7 RC Optimizations for Netbook

I am installing Windows 7 RC on a Dell Mini 9 (netbook) and wanted to know what the community suggested for tweaks and optimzations that I could configure to ensure the OS performed well on the scaled down hardware.
JPrescottSanders
  • 519
  • 2
  • 5
  • 12
0
votes
1 answer

SQL express 08 R2 running on Windows datacenter server 08 optimization

I am running SQL server express R2 on Win Server Data Center 08 (basically Ec2 micro instance). My total allowed memory is 613 MB. When I launched the instance for the first time my total consumed memory in task manager (performance) was hovering…
0
votes
2 answers

MySQL: view read/write proportion, per specific table

I'm optimizing the configuration of a MySQL server, running only Bromine. This is non specific to application, and was just noted for completeness. I am trying to determine if switching from MyISAM to InnoDB is a better option, on few write dominant…
J. M. Becker
  • 2,471
  • 1
  • 17
  • 21
0
votes
1 answer

Optimize Xeon 1270

We have a new server with a Xeon 1270 processor. Looking at CPU-Z I see the Core Speed as 1596MHz, with a Multiplier of x16, and a Bus Speed of 99.8MHz. I've been watching it for a while and sometimes noticed how the core speed jumps up to about…
pbz
  • 199
  • 1
  • 4
  • 12
0
votes
3 answers

Steps to optimize an IIS server for PHP

I've inherited a very slow PHP site running on IIS and I'm trying to maximize it's performance. The issue is all in the Time to First Byte (TTFB), with 1500ms TTFB for an almost empty page and an average of 2500ms TTFB on most pages. The Database…
Ben Brocka
  • 229
  • 1
  • 4
  • 12
0
votes
1 answer

NGINX config for many small files

I'm trying to configure an NGINX server that's sole purpose is to serve as many 10k JPEGs as it can. I have 16 GB RAM and 2 Intel Xeon E5506 processors, running CentOS. I'm looking to configure this server in order to serve as many concurrent…
evilpenguin
  • 781
  • 3
  • 9
  • 16
0
votes
1 answer

Optimizing Server

Let me lay it all out: Lamp environment Mysql is already optimized. I've got memcached setup I've got APC setup Traffic on these web servers is going to come in hard and fast, its not going to be spread out, think more 10,000 visitors …
Macgyver
  • 135
  • 4
0
votes
2 answers

Optimal mod_rewrite regex. Does the way the matching patterns are arranged inside the regex matter?

I have the following: RewriteRule ([a-zA-Z0-9]{5})?/load_page/([0-9]+) Which arrangement would be optimal for the regex: RewriteRule ^/([a-zA-Z0-9]{5})?/load_page/([0-9]+) OR RewriteRule ^/load_page/([a-zA-Z0-9]{5})?/([0-9]+) OR RewriteRule…
Catalin
  • 3
  • 1
0
votes
2 answers

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 could stop me from serving double the amount of the…
Alex
  • 29
  • 3
0
votes
1 answer

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

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 to help him optimize his queries ? What kind of…
Chani
  • 145
  • 8
0
votes
1 answer

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 make many inserts in my test environment as it is…
Juanma
  • 132
  • 8
0
votes
2 answers

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 you have a quad core, your load average is…
Greatestswordsman
  • 397
  • 1
  • 7
  • 19
0
votes
1 answer

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 timeout" I seriously doubt that this is a server…
sarat
  • 213
  • 3
  • 11
0
votes
1 answer

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 = 128 M Of 73993 temp tables, 46% were created on…
Chirag
  • 271
  • 1
  • 4
  • 11
0
votes
2 answers

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 ones need tweaking... I did this from the command…
siliconpi
  • 1,807
  • 6
  • 32
  • 46