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

WordPress with APC Cache - MySQL Load

I've installed APC on my server and the load is cached very good with it, no problems so far. The number of concurrent users is good < 90 but after 100 it gets shaky. Htop shows a constant use ...
2
votes
1answer
131 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
462 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
477 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 ...
1
vote
1answer
501 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
1answer
134 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
182 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
334 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
331 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
vote
1answer
633 views

XDEBUG/PHP doesn't dump profile even when set up properly?

I installed xdebug from source, but also tried my package manager (separately) and they both are loaded correctly (verified by restarting Apache and seeing the xdebug copyright info in phpinfo()) but ...
1
vote
1answer
126 views

Bacula optimization/profiling tools

I'm trying to get an idea of where the bottlenecks are in our backup system. Are there tools available for profiling this? If not, any pointers to a home grown method would also help. I guess most ...
0
votes
1answer
63 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
92 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
65 views

Mysql proxy in comparison with two database connection

We have a situation in which we have master salve databases, we write in master and read from slave. in application we defined two connections one for write and other for read. I came to know know ...
0
votes
1answer
428 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
132 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
536 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 ...
2
votes
0answers
927 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
0answers
519 views

Nginx “ssl_stapling” ignored, no OCSP responder URL in the certificate

I'm trying to setup OCSP stapling on Nginx because I ran a test and it suggested the idea and well, you know. https://sslcheck.globalsign.com/en_GB/sslcheck?host=aj2jewellers.co.uk#176.58.103.165 ...
1
vote
0answers
265 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 ...
1
vote
0answers
299 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
114 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
106 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
229 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
56 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 ...
0
votes
0answers
43 views

eAccelerator causes the server to deliver gibberish data

I'm trying to integrate eAccelerator into my server infrastructure using the ELS script. But when I activate it, it causes the gibberish data (shown below) to appear instead of the real content. There ...
0
votes
0answers
94 views

Performance optimization of Amazon EC2 site

I have a site hosted on Amazon EC2 (USA West) running on a micro-instance. Unfortunately these are the load times as reported from Google Analytics Avg. Page Load Time (sec): 9.94 Avg. Redirection ...
0
votes
0answers
367 views

How do I make mediawiki take less memory and run faster?

I am running MediaWiki on dreamhost for two websites. The first gets about 50,000 page views a day, the second gets 12,000. Dreamhost is using mediawiki version 1.16.4 and shows no interest in ...
0
votes
0answers
142 views

Please help me debug occasional apache http request 'hangs'

i'm running my site on a VPS with apache/php/fastcgi/mysql - occasionally (1 in every 30 requests or so), when i open a page it seems to hang until it times out and returns a 500 error. I do not ...