Questions tagged [optimization]
Optimization is the process of modifying a system to make some aspect of it work more efficiently or use fewer resources.
340
questions
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 ...
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 ...
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)
...
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+).
...
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 ...
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?
...
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?
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
-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 ...
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 ...
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 ...
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 ...
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?
...
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.
...
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.
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
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/...
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 ...
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 ...
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 ...
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 ...
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 ...
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?
......
......
...
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 ...
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 ^/...
-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 ...
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
...
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 ...
-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 ...
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 ...
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:...
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 ...
-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 ...
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 ...