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
5
votes
6 answers

Method for finding unnecessary indexes of an operational SQL Server database?

Besides wasting space on the database, unnecessary indexes on SQL Server can slow down insert and update operations. Developers who lack experience in database principles sometimes tend to create table indexes which don't make sense for the running…
splattne
  • 28,508
  • 20
  • 98
  • 148
4
votes
2 answers

XFS with No Barrier Mount option deprecated

I tried to perform SQL Server database restore with xfs filesystem and barrier=0 in Azure cloud environment. It performs restore of some 15GB data in around 8 minutes. I heard this option is getting deprecated in near future. Without this option…
4
votes
1 answer

Any guide to set values for fastcgi_buffers in Nginx config?

I just moved our blog-network to ngnix (from apache) which is powered by WPMU. Everything is running smoothly and fine. During my quest to optimize server to the max level - I came across this thread on nginx forum…
rahul286
  • 1,647
  • 5
  • 20
  • 25
4
votes
0 answers

`nginx reload` and `nginx -t` very slow - how to investigate

I have a quite small VPS on AWS (EC2 t2.nano) that is running an nginx server. while sometimes a sudo service nginx reload or nginx -t is blazing fast, most of the time it is horribly slow (>60 seconds) without any load on the server. There are ~10…
Tobi
  • 237
  • 3
  • 12
4
votes
2 answers

LVM cache in writeback mode is equivalent to external ext4 journal?

I am running ext4 filesystems on LVM. The two big speedup options I'm looking at are, LVM cache and the external ext4 journal. It sounds like if I'm using a single SSD for this, LVM cache in writeback mode is the same thing as having your ext4…
RobC
  • 143
  • 1
  • 4
4
votes
0 answers

Identifying bottleneck with nginx VPS load testing

I'm trying to optimize a Digital Ocean droplet (512mb), testing using loader.io I'm testing on my homepage, which is HTTPS / PHP. I setup FastCGI page cache, which got me from 100 req/sec to 2,000 req/sec. But anything beyond 2,000 req/sec is…
4
votes
4 answers

MySQL taking too much CPU

Below is my .cnf file and if I see my CPU consumption 99.99% of it my the mysqld commands. The MySQL server is connected from remote machines that update data in it frequently, but I make sure that the remote server's open a connection,…
Sana
  • 143
  • 1
  • 1
  • 6
4
votes
1 answer

Tuning Apache KeepAlive Timeout for HTTPS

My website forces HTTPS everywhere and has an average first load time of 3-5 seconds. Thanks to caching, repeat load time is 0.8 seconds. The SSL negotiation takes 150-300ms on my server, so I want to keep each connection alive as frequently as…
4
votes
2 answers

PHP + Apache long wait time

I've run into a bit of a brick wall with troubleshooting my dedicated websever. Recently, my website spiked with the amount of request/per second and it crashed. The box original had 8GB of RAM, 8 Core Xeon E3-1230, 1TB 7,200 RPM Disk (No Raid),…
Moe
  • 167
  • 1
  • 1
  • 8
4
votes
2 answers

Performance problems when running Java desktop applications on Citrix Metaframe

We have a desktop Java application running within a Citrix Metaframe server farm and the performance, specially while starting up the app, is very unreliable. Sometimes it takes 15 seconds and sometimes it takes over a minute. It's really…
Demetrius Nunes
  • 181
  • 1
  • 4
4
votes
3 answers

run local MySQL instance for fast mysql_real_escape_string calls

Currently all MySQL data/API calls are handled by a remote DB cluster (i.e. network latency is a factor in total script execution time). To reduce execution time in this context, would it be sensible to run a local MySQL instance on each app server…
Andy
  • 5,230
  • 1
  • 24
  • 34
4
votes
8 answers

Optimize a fresh Ubuntu server installation

After installing a fresh Ubuntu server (I personally use 8.04 LTS) what do you do to optimize it in terms of memory consumption, disk usage and speed? What services and pre-installed packages do you remove to make your system as lean and mean as…
Luke
  • 3,826
  • 8
  • 36
  • 40
4
votes
0 answers

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 am not sure if by RAM they mean only memcached,…
Lance
  • 233
  • 2
  • 8
4
votes
5 answers

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 in processes for PostgreSQL. When the problem…
4
votes
3 answers

Way to configure apache for ~125 django sites to optimize memory usage (mod_python v mod_wsgi; worker vs prefork; static files)

I'm currently running 125 Django sites on a single dedicated box at GoDaddy. The sites are relativelly low traffic and I'm wondering what i can do to optimize the memory usage in my apache config. Before I tuned the prefork directives to a lower…
user8550