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

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
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
781 views

mysql configurations for best performance

I have a huge magazine on dedicated server(1 website only on the server), all time the server have big load, "top" tool show me that the user "mysql" make this load: PID USER PR NI VIRT ...
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 ...
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 ...
0
votes
2answers
853 views

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

MySQL stop responsing when modify main tables

It's an InnoDB database. The query cache has 1.2GB in size with 300k queries in the cache. Most of the cached queries are related to 3 major tables (260MB data length plus 600MB index length ...
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
1answer
138 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 ...
2
votes
1answer
770 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:...
1
vote
1answer
193 views

Check VPS resource consumption of a website

I've got a website (I'd say poorly optimized as it's my own code and I've never optimized a website before) and now that it's getting more visits the server load increases to up to 4-5 when there are ...
1
vote
1answer
303 views

Apache/PHP Elastic Beanstalk - Track Which Request is CPU Intensive

At certain seemingly random parts of the day, my CPU usage will spike up from ~10% on 1 m1.large to 70% on 4 large servers. This all happens within 20 minutes and stays this way for a few hours and ...
1
vote
1answer
459 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
1answer
83 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
1answer
116 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 ...
0
votes
1answer
566 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) ...
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 ...
0
votes
1answer
243 views

Why this server is so slow?

I hired a VPS in DigitalOcean, it's hosted in Amsterdam, I'm in Turkey. But server is responding slowly and page is freezing/lagging even at ajax POST-GET request.(there is a basic browser game in ...
0
votes
1answer
252 views

Centos help optimize Apache and kernel

I am looking for tips/articles on how to optimize CentOS for production use I will have 2 servers 1 web server where haproxy will also running Haproxy will be in front of apache and will be proxying ...
0
votes
1answer
104 views

Windows 2008 R2 VPS resource footprint reduction

Given a Windows 2008 R2 Standard VM with: 4x vCPU Intel Xeon E5620 1GB RAM 15GB HDD What can I do to reduce the amount of CPU/RAM/HDD utilised by the OS? The VM will be used exclusively as a web ...
0
votes
1answer
600 views

Random Lag in Apache before serving files

I've been trying to troubleshoot some random lag that happens in less than 3% of requests I'm sending to my server. I wrote a testing script that uses PHP's file_get_contents on a seperate server and ...
0
votes
1answer
146 views

MySQL's Query Optimizer's take on disk access time

I don't have a ton of background with MySQL, and I was wondering of anyone can give me some insight into MySQL's query optimizer and the impact on the cost of disk accesses in determining a query plan ...
0
votes
1answer
566 views

Optimize windows 2008 performance

I have windows server 2008 sp2 installed as virtual machine on my personal laptop. I use it only for source control (visual svn) and continuous integration (teamcity). As the virtual machine resources ...
-1
votes
1answer
594 views

Nginx , Apache , Mysql , Memcache with server 4G ram. How optimize to enought memory?

i have 1 dedicated server with Nginx proxy for Apache. Memcache, mysql, 4G Ram. These day, my visitor on my site wasn't increased, but my server get overload always in some specified time. (9AM - ...
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 ...
2
votes
0answers
592 views

High latency on domain with CDN

High latency on domain with CDN I have problems with latency on my server, these are the tests I made with blitz.io Latency album http://imgur.com/a/bCmwo I would uploaded images here but it ...
2
votes
0answers
121 views

Why does this one file not respect .htaccess' cache-control header?

Testing performance improvements, I added an .htaccess file with the following directives to my /assets folder (where I store a few images of various types). <FilesMatch "\.(jpg|jpeg|png|gif)$">...
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 ...
1
vote
0answers
153 views

How to use an origin-pull CDN with external CNAMEs?

I have a particular issue that I'm struggling with regarding setting up a CDN. To describe our situation: We are running an ASP.NET based CMS(DotNetNuke), configured with two different web heads on ...
1
vote
0answers
884 views

Extremely slow response when connecting to remote MySQL database (LAMP Server)

I installed a LAMP server and enabled MySQL remote connections but I'm experiencing really bad response times when connecting to the database remotely from a WordPress install. I've been looking ...
1
vote
0answers
133 views

Nginx for a site allowing downloads

My friend have a site that allows users to download files.However the moment one guy start downloading server load change from 0.00 to 3.50 in a matter of minutes.Nginx and php-fpm reach D state and ...
1
vote
0answers
314 views

page loading stops half-way, no server or sql load

i'm running a hostgator vps php/apache/linux/mysql i have a problem that i cannot seem to properly diagnose/fix : sometimes when loading a page, the browser will load have the page, then it hangs ...
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 ...
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 ...
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
0answers
3k views

Apache Worker MPM / PHP-FPM Tuning

I have a VPS running CentOS 6.5, Apache 2.2, PHP-FPM v5.4 and MySQL 5.5. I take advantage of APC and Memcache. The VPS has 8 cores and 8GB RAM. I'm running a medium volume site (15,000 users / day, ...
0
votes
0answers
224 views

PHP-FPM showing 34 worker process despite adjusting configuration

I recently asked this question and I got an answer about how I should limit php-fpm from running 34 worker process, considering that I get on average 20 visits for one light website. So, I ...
0
votes
0answers
322 views

samba over NFS large file

For several months we encounter problems delays : we have a server ( os: ubuntu server 12.04 ) with samba and ldap service . Our clients are on Mac, Windows and Linux client ubuntu . Huwaei NAS ...