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
3answers
2k 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
558 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
1k 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 ...
0
votes
2answers
737 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
57 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 ...
4
votes
1answer
987 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
136 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
633 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 ...
1
vote
1answer
159 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
248 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
409 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 ...
1
vote
1answer
417 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
1answer
39 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
482 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
149 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
190 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
1k 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 ...
0
votes
1answer
103 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
501 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
139 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
557 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
564 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
464 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
117 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 ...
1
vote
0answers
101 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
586 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
129 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
267 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
33 views

Performance Issue on Centos Server

I hava VPS from OVH (has 2 GB of RAM, dual core 2.8 Ghz wth 2MB cache, 25 GB RAID 10) with Zpanel 10.1.1 and currently there are 6 websites running on it (2 phpbb3, 3 wordpress and one other script). ...
0
votes
0answers
107 views

Cron Job Crashes the Server?

Can a CURL Cron Job fired every minute crash a server, or it's a problem with the code? I had a shared hosting that worked great, then I added a cron job with enters, using CURL, to a specific URL ...
0
votes
0answers
48 views

Optimizing Performance for a Reverse Proxy Apache Server Hosted on a Virtual Machine

I am relatively new to web hosting, and I'd like to learn how to go about optimizing a server setup. Let me start off by describing my setup. I have an apache server, which sits on a vmware virtual ...
0
votes
0answers
1k 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
47 views

Will pfctl -sr show ordered rules when using -o profile?

When I enable the -o profile option with pf will pfctl -sr show me the new order of the rules?
0
votes
0answers
164 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
242 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 ...