Questions tagged [optimization]

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

Filter by
Sorted by
Tagged with
10 votes
2 answers
4k views

Linux Slow Start: Changing ip route does not have any effect on initial window

I changed the tcp initial window in my machine to 10 as shown below [user@site etc]$ sudo ip route change default via 17.255.209.1 dev eth0 proto static initcwnd 10 And changed ...
Quintin Par's user avatar
  • 4,443
2 votes
1 answer
4k views

Finding out TCP Initial Window segment size in linux

I run Centos [user ~]$ cat /etc/redhat-release CentOS release 6.2 (Final) With kernel 3.0.4-x86_64-linode21 How do I check the TCP initial window size in my OS? I need to verify that the IW is ...
Quintin Par's user avatar
  • 4,443
1 vote
2 answers
2k views

Mysql 5.5 Defragmentation not reducing the fragmentation percent

We are running OPTIMIZE TABLE , but not seeing any fragmentation reduction. They are as high as 120% to 200%. Am calculating the fragmentation % using this: Data_Free / (Data_Length + Index_Length) ...
Abhishek Ravi's user avatar
1 vote
1 answer
2k views

Optimizing Web Server(apache2+nginx+memcached+eaccelerator) for high-loaded heavy application

I have a server with (Apache2 + nginx as reverse proxy, memcached cache and eaccelerator). The application is Magento - it is very heavy, due to high modularity and a lot of php files(5000-10000+). ...
Jevgeni Smirnov's user avatar
0 votes
2 answers
2k views

MySQL InnoDB database 'hangs'

I have a problem with a MySql server causing it to freeze all the time. In phpMyAdmin when this happens I can see in "Show Processlist" are lots of processes for User "unauthenticated user" with ...
Martin's user avatar
  • 379
2 votes
2 answers
331 views

MySQL query caching - what happens if Server runs out of RAM?

so I have enabled query caching on my server but now from the 8 GB RAM there is almost non left! CPU is around 3% ! Now what happens when there is no more RAM left? Will this just increase CPU load? ...
Jimbo Mombasa's user avatar
6 votes
2 answers
2k views

Cron job for database repair and optimization

I would like to repair + optimize my MySQL database once a week! How could I do this?
Chris wede's user avatar
5 votes
2 answers
6k views

Optimize php-fpm and varnish for a powerful server

My setup is Intel® Core™ i7-2600 and RAM 16 GB DDR3 RAM varnish+nginx+php-fpm+apc for a not very heavy WordPress blog with W3 Total Cache and CDN My problem is that after 55 hits per second ...
Jim's user avatar
  • 410
0 votes
1 answer
367 views

Optimizing Apache2

I have a powerful dedicated server: Intel® Xeon® X3440 Quadcore 4x 2.1 GHz Ram: 16 GB. I run on this server just 1 social network website with max 700 users online. Usually server load is ~0.10-0.30 ...
lars's user avatar
  • 85
6 votes
3 answers
5k views

Can I optimize these APC settings more?

I would like to optimize APC some more but I am not sure where I could do something. First here is the screenshot after one week of running with the current configuration: I have now the following ...
Raffael Luthiger's user avatar
0 votes
1 answer
532 views

VDS Memory Optimization

I am new one for rent a server. I choose a CentOS VDS width 2G memory. After apache+mysql+php install and setting, My server cost 750MB and 1297MB free (I use free -m to see it) And then I run one ...
yuli chika's user avatar
2 votes
1 answer
383 views

squid : faster internet but not responsive

I configured my gateway server with squid proxy for my LAN, everything work normally, the browsing maybe faster because of the cache. but it seems not as responsive as without squid, because when ...
uray's user avatar
  • 255
1 vote
3 answers
718 views

Optimization advices to server a lot of small files

I have nginx+php-fpm+apc setup. No DB. In data folder i have a simple php script that when called with filename parameter checks if the file exists, if it does then it gives it away, if not then it ...
Jim's user avatar
  • 410
0 votes
1 answer
192 views

Maxing out shmpages

We've got a Media Temple dv install (running dv 3.5) that keeps hitting its hard limit. Currently, it's using 68,124 of 68950 hard limit. They've been less than helpful in helping us diagnosing this, ...
Keefer's user avatar
  • 101
0 votes
2 answers
3k views

How to reduce ping between server over the world?

I have some servers in France and in Hong Kong. Ping is quick to google.com, < 10ms in france, and < 30ms in HK. But ping between these servers is greater than 250ms. This is very slow and very ...
Xorax's user avatar
  • 358
-2 votes
3 answers
488 views

True or False: a table with large records (rows) and lots of fields (columns) will take longer to return a SQL query? [closed]

True or False: a table with large records (rows) due to lots of fields (columns) will take longer to return a SQL query? That is, if I have a SELECT ... WHERE...query in SQL that operates on a table ...
PaulDecember's user avatar
0 votes
1 answer
169 views

Where server power is lost? [closed]

I have server with 2x2 GHz core but php works very slow on it, I am write syntetic test for($i=0;$i<10000000;$i++) { $x = sqrt($i); } generate ~ 30 sec but on local machine with 2x2Ghz ...
Vyacheslav Loginov's user avatar
1 vote
2 answers
1k views

Apache script for low memory installation

I've been working on improving memory usage on our Centos 5.5 VDS, which now has 512MB of RAM. I've been able to use a tuneup script to greatly improve the MySQL config but am having a bit more ...
John Gardeniers's user avatar
2 votes
2 answers
550 views

How does a SSL Accelerator work, esp in regard to TLS Session IDs?

There is a theory that the TLS Session ID might mitigate the BEAST attack, and one of the comments at the IETF mention that SSL Accelerators may alter this ID. Can someone explain to me (or tell me ...
makerofthings7's user avatar
0 votes
1 answer
146 views

optimize apache for just one client

So I set up apache2 to serve web service. The only consumer of it (and the whole server) will be .net web application. Firstly, is it correct to assume that this way apache will only see one client? ...
ren's user avatar
  • 337
3 votes
1 answer
11k views

Config NGINX to GZip Font Files? ( Different gzip_types for different directories)

SOLUTION: It turns out it is not my config / NGINX faults - my DNS provider, cloudflare, is preventing the fonts from being GZipped for some reason I'm using NGINX with GZIP_Static module installed. ...
Professor Frink's user avatar
1 vote
1 answer
332 views

do you need to reboot after tweaking linux tcp settings?

I'm wondering if you need to reboot if you make changes to settings related to linux tcp such as tcp_window_scaling.
incognito2's user avatar
8 votes
2 answers
18k views

Fixing window scaling problems with Linux TCP

I'm trying to improve the throughput of one of my servers overseas and after monitoring a transfer between the server and my home computer with wireshark I'm pretty sure I have a problem with the ...
incognito2's user avatar
2 votes
2 answers
341 views

how to optimize transatlantic TCP transfers?

I transfer large files between two of my servers one in the US and the other in the Netherlands and I'm wondering if there are any tweaks I can apply that will increase the speed of a transatlantic ...
incognito2's user avatar
0 votes
1 answer
178 views

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 ...
JKZrulaz's user avatar
18 votes
3 answers
9k views

Building a 1,000M row MySQL table

This question is reposted from Stack Overflow based on a suggestion in the comments, apologies for the duplication. Questions Question 1: as the size of the database table gets larger how can I tune ...
Ben's user avatar
  • 283
0 votes
2 answers
2k views

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 ...
J. M. Becker's user avatar
  • 2,461
1 vote
2 answers
5k views

Using CommVault to backup a NAS without NDMP

We have CommVault Simpana 9.0.0 build 84 currently installed and configured on our backup server that is equipped with both a magnetic array and a tape library. I am trying to find a way to backup one ...
unauthorized's user avatar
1 vote
2 answers
3k views

Optmizing tape media usage for CommVault Simpana 9

My employer has CommVault Simpana 9.0.0 build 84 currently installed and configured on our backup server that is equipped with both a magnetic array and a tape library. It may be a newbie question, ...
unauthorized's user avatar
0 votes
1 answer
111 views

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 ...
pbz's user avatar
  • 199
3 votes
4 answers
7k views

How to troubleshoot a big memory issue with Apache and mySQL

I've read a lot of this website to optimize my server but nothing has really helped me :( Im having a memory trouble I think , I have just one website (Drupal) with 860K page views month but when the ...
atom's user avatar
  • 41
1 vote
2 answers
22k views

Mysql Optimization - table_open_cache, query_cache

I have already optimize many times my Mysql server but now I want to have your advices. mysqltuner: -------- General Statistics -------------------------------------------------- [--] Skipped ...
scraly's user avatar
  • 11
10 votes
2 answers
43k views

What are typical NFS read/write rates

I have just installed a server that is sending HTTP video streaming files to a Web server over NFS and I want to make sure that I have the transfer speed optimized. But I don't know what sort of read/...
Adam Salkin's user avatar
9 votes
2 answers
2k views

Speed up MySQL inserts with partitions on MyISAM with unique key

I have a large MyISAM table (~30M rows). At some point I've switched it to fixed row format, so now table takes ~40Gb on disk and 2Gb for indexes. Table has a unique index and there are 100 'insert on ...
d0rc's user avatar
  • 91
1 vote
1 answer
547 views

Addressing slow to connect time issues on NGINX

I intermittently perform 3rd party speed tests using http://tools.pingdom.com on my server. Recently, I have started to see long yellow bars for some of the static content on my sites, like images and ...
Professor Frink's user avatar
0 votes
3 answers
4k views

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 ...
Ben Brocka's user avatar
1 vote
1 answer
984 views

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 ...
evilpenguin's user avatar
0 votes
1 answer
118 views

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 ...
Macgyver's user avatar
  • 135
1 vote
2 answers
3k views

How to enable /dev/shm RAM disk for MySQL?

How to enable /dev/shm RAM disk for MySQL? (temp dir in /dev/shm) $ vi /etc/fstab tmpfs /dev/shm tmpfs defaults,size=512m 0 0 $ mount -o remount /dev/shm Is this correct? Now what? ...... ...... ...
user avatar
2 votes
1 answer
149 views

how to optimize postgresql81 for a hug query but not a complicated one?

i have a query which execution takes 15s on the server. the server is bi-xeon 5130 (2GHz) with 2GB of RAM and 160GB of scsi hardrive in RAID. Database is PostgreSQL 8.1 on Debian 4 etch. This query ...
Michael REMY's user avatar
0 votes
2 answers
136 views

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 ^/...
Catalin's user avatar
-1 votes
4 answers
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 ...
dennisg's user avatar
2 votes
1 answer
11k 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 ...
Denis's user avatar
  • 21
0 votes
2 answers
798 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 ...
Alex's user avatar
  • 29
-2 votes
2 answers
818 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 ...
Prakash's user avatar
  • 193
0 votes
1 answer
42 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 ...
Chani's user avatar
  • 145
3 votes
1 answer
1k 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:...
user avatar
6 votes
2 answers
4k 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 ...
András Szepesházi's user avatar
-1 votes
1 answer
214 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 ...
James Simpson's user avatar
0 votes
1 answer
160 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 ...
Juanma's user avatar
  • 132

1 2 3
4
5
7