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
2answers
2k views

How can I lower MySQL single-page reads?

My innodb buffer pool size is 8GB and my database is 6GB in size but I see this: Innodb_buffer_pool_reads 263.5k - The number of logical reads that InnoDB could not satisfy from buffer pool and had ...
8
votes
1answer
1k 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 ...
2
votes
2answers
3k views

Optimize php-fpm and varnish for a powerfull 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 ...
1
vote
2answers
82 views

Track what is causing AWS RDS to use insanely high bandwidth

We are having a high traffic (100K hit/day) Drupal news website hosted on AWS. Its behind cloudflare & 2 Load Balanced Varnish servers. For some reason the bandwidth usage is very high for RDS. ...
2
votes
3answers
3k views

Centos MySQL optimization 4gb ram

I am using Centos 6 64bit on vps with 4gb ram. 1 wordpress website and 2 wallpapers script websites. Wordrpess have 10k visits daily. Site is slow. My.cnf # Example mysql config file for large ...
2
votes
0answers
9 views

Move htaccess rules to apache configuration files

I'm running a website with Joomla on a dedicated server (Debian), and i've read that moving .htaccess rules to apache2 configuration files may result in a good performance improvement (Apache HTTP ...
0
votes
0answers
27 views

About Raid5/6 merge small files in single stripe element

I have look a lot of articles, but I can 't understand how the raid save some of small files in single stripe element. Here is the raid 5 example: 4 disk * 16K stripe element size = 64K stripe ...
-2
votes
1answer
27 views

How to choose database and backend server locations?

I could not find a tutorial for beginners for how to locate my servers. For instance I use Compose.io for my MongoDB and DigitalOcean for my Meteor.js app. Lets say I want to have fast service in ...
8
votes
2answers
6k 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.
0
votes
1answer
115 views

How to allocate more resources to Node.JS process?

I'm not a (very good) back-end developer so understanding processes and memory are a little about my pay grade. I'm currently building an app using the MEAN stack. I have a separate Express server ...
16
votes
3answers
17k views

Maximizing rsync performance and throughput - directly-connected gigabit servers

I have two Dell R515 servers running CentOS 6.5, with one of the broadcom NICs in each directly attached to the other. I use the direct link to push backups from the main server in the pair to the ...
1
vote
2answers
485 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 ...
-1
votes
4answers
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 ...
1
vote
0answers
151 views

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 ...
9
votes
1answer
2k 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
1answer
176 views

nginx time to first byte

I running several project on one machine, below with all the info. on nginx config if PHP project use fastcgi cache, Node.js project use proxy_pass , and all project use gzip. I'm new to maintain ...
0
votes
0answers
23 views

Way to know what source is reading the most from MySQL Server(RDS)?

I have a mysql server which is registering very large bandwidth usage. I want to know what options I have for: Knowing what source is using the MySQL server most. (server ip?) What tables or queries ...
7
votes
7answers
15k views

How many files in a directory is too many? (Downloading data from net)

Greetings, I'm writing some scripts to process images from various photo websites. Right now I'm storing all this data in individual text files in the same directory. The directory is web ...
1
vote
1answer
109 views

Ubuntu LAMP server busy at peak hours

I'm running a Ubuntu 14 server with LAMP on virtual cloud hosting (CityCloud). The server is usually doing very well with response time<0.5s. However, the problems start at peak hours, mainly ...
0
votes
0answers
9 views

installing lampp or installing separately for those components [duplicate]

Should I install lamp package or Should I install separately like apache2,mysql and php packages? What installing method is better for VPS server optimization, fast and safe to run website? ...
-4
votes
1answer
79 views

My website is superslow but the %CPU is only 25%

I have 2 servers for my website : One server 256GO RAM 20c/40t for MySQL One server 256GO RAM 20c/40t for Apache The MySQL server is always ok (30-50% of CPU is used). But the Apache ...
1
vote
1answer
435 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 ...
0
votes
1answer
82 views

Hyper-V failover cluster auto load balancing

We have a 2 unit Hyper-V cluster and I was wondering if there is a way to auto load balance the two? If one unit is restarted then I need to manually reassign some of the VMs to the unused hypervisor, ...
0
votes
0answers
17 views

Go server response times

I just started playing around with a hosted VPS (running Ubuntu). I let it run the simplest Go server that listens to port 8080 and returns "hello world" on path /hello. Then I started sending ...
0
votes
1answer
2k views

Why is hash join slow in postgresql 9.1?

I transfered my DB from Postgresql 8.4 to new server with Postgresql 9.1. Size of DB is 9.9GB Data directory is situated on ssd 60GB disk. And server has 16GB RAM and 16 proccessor cores. But today ...
2
votes
1answer
842 views

Nginx performance when running multiple instances on the same machine

I'm trying to understand the performance impact of having multiple nginx instances (masters) running on the same machine, rather than having them all load into a single instance using different server ...
0
votes
0answers
11 views

ExpressJS + MongoDB: Better to make one API call with 10,000 objects, or 10,000 individual API calls? [duplicate]

I'm building an app that relies on a web scraper built in Node/Express, which operating on the same localhost as my front-facing Node/Express app. I'm trying to optimise as much as possible and I'm ...
0
votes
1answer
125 views

Optimizing mysql and apache ovh vps [duplicate]

My website is 100% mysql php so it gets slowdown and sometimes server shutdown. I'm using VPS Classic: The best cheap VPS - $2.99/month - OVH (VPS Classic 4 - 4 vCores and 8GB RAM). I want some ...
2
votes
4answers
5k 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 ...
0
votes
1answer
104 views

whats the best practice to do a long query like deletion of big chunks in mysql

On production servers I need sometime to delete a few 100,000s of rows . The query is optimized but deleting at once will cause servers freeze so I do it manually in chunks deleting for example 5000 ...
3
votes
0answers
109 views

Optimal server stack for Wordpress [closed]

There are numerous tutorials/articles(some even with benchmarks) on how to create an optimized stack to run Wordpress(or any dynamic site, for that matter). The site doesn't get frequently updated(...
0
votes
1answer
565 views

NGINX and failed (12: Cannot allocate memory)

could someone be so nice and explain me how to solve this problem? in log nginx print: 2015/06/24 11:12:19 [alert] 2151#0: mmap(MAP_ANON|MAP_SHARED, 33554432) failed (12: Cannot allocate memory) ...
-2
votes
1answer
121 views

Mysql Optimization For VPS [closed]

I've a bit in a problem optimizing my VPS's (Linux / Cpanel) mysql settings. I don'n know much about Mysql and I'm using this VPS for about 50 different websites. They all had below 100 visitors daily,...
5
votes
1answer
182 views

redhat tuning for single application with few TCP clients [closed]

I know linux is built for multi-user / concurrent-process, but in corporate level, many of them are used for single (but big application) to support internal service, of which serving only very few ...
0
votes
2answers
17k views

Optimal MySQL my.cnf setting for large Magento site on a dedicated server

Our dedicated server is running a large Magento store with a MySQL database approximately 250MB in size. The server spec is listed as having 5 Xeon 2Ghz processors (4MB cache) and 12GB of memory. I'...
3
votes
4answers
643 views

What is a core, and will purchasing more cores for my VPS speed up page load times?

I recently purchased a premium WordPres plugin called Hide my WP. I planned on using this plugin for my nonprofit organization's website, which is a multisite WordPress installation with an SSL. ...
4
votes
4answers
3k views

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 ...
-1
votes
1answer
118 views

Tracking the slow - how to list all processes related to web-server?

I wanted to ask people in this community about administration of the Debian based web server - its a dedicated server, hosting a single website. From time to time the web site is slowing down, on ...
22
votes
3answers
52k views

Optimal values for ServerLimit, MaxClients, MaxRequestsPerChild directives

I'm running a traffic intense site plenty of dynamic content, mostly user-generated. The server is a dedicated one and has a total of 4 Intel(R) Xeon(R) CPU X3210 @ 2.13GHz proccesors. I need to know ...
6
votes
4answers
7k views

Profiling Apache+Mysql+Php server - which is the bottleneck?

How do I profile an Linux + Apache + Mysql + Php server for speed? I have a server with a heavily modified MediaWiki instance running on Ubuntu 8.04. It's a bit sluggish - I haven't done anything to ...
2
votes
2answers
2k views

RAID 10 Stripe Size for XenServer

Below is our current server configuration. In a few weeks I will be simulating a disaster recovery by installing 5 new disks (1 hot spare) and restoring all VMs from the backups. Will I gain anything ...
7
votes
1answer
5k views

How to disable keys in MySQL InnoDB tables?

Is it possible to disable keys in InnoDB tables? If yes, how? If not, why?
1
vote
1answer
116 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 ...
0
votes
4answers
89 views

What's the best way to debug and enhance the speed of your server?

My server has been running slightly slower than normal. I was wondering what strategies I could do to evaluate the speed of my server, and enhance it This question covers database interaction, I/O, ...
0
votes
1answer
937 views

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 ...
2
votes
2answers
188 views

Would software RAID0'ing SSDs help or hinder maximization of useful CPU work throughput?

My question is in the title... here is some background: [OS is Linux.] [UPDATE: The contents of this RAID0 is redundant (sync'd from SCM). I am not worried about the increased risk of data loss.] ...
5
votes
2answers
866 views

How can I handle big traffic spikes on my dedicated server?

I have an E-Commerce site, which gains a sudden peak of very high traffic when I turn on different ads campaigns. From this moment on, my current dedicated server (Hostgator, 4GB Memoray, 100mbps ...
3
votes
1answer
3k 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
2answers
1k views

Best way to optimize (loss-less) thousands of jpgs in a windows folder structure?

Using Smush.it or Firebug's built-in image optimizer I realize we can reduce the file size of all of our web jpgs. By quite much actually. As we have hundreds of thousands of images, is there any way ...
0
votes
3answers
12k views

Evaluating the CPU I/O wait on Linux

Doing a top to check the io wait, I get these figures: Cpu(s): 6.7%us, 1.4%sy, 1.2%ni, 85.5%id, 5.0%wa, 0.0%hi, 0.3%si, 0.0%st Looking at these figures (%us ~= %wa), do they mean that: ...