Questions tagged [optimization]

Optimization is the process of modifying a system to make some aspect of it work more efficiently or use fewer resources.

A system may be optimized so that it executes more rapidly, or is capable of operating with less memory storage or other resources, or draw less power. The optimized system will typically only be optimal in one application or for one audience. For example, one might reduce the amount of time a task takes to perform at the price of making it consume more memory.

339 questions
1
vote
1 answer

Directadmin Apache server finetuning advice

I currently have a dedicated server from which I provide shared hosting for some clients of mine. Server specs AMD Athlon(tm) 64 X2 Dual Core Processor 4000+ 4GB DDR RAM 1x Seagate 1000GB And I'm running Apache 2.2.24 on a CentOS 6.0 64-Bit…
1
vote
2 answers

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 RES SHR S %CPU %MEM TIME+ COMMAND 16058 mysql …
moh
  • 11
  • 2
1
vote
1 answer

Drop caches in Linux

I have an embedded Geode-based application server with 512MB RAM and I'm about to try to maximize free memory during applications workload, which uses MySQL database 5.5 with InnoDB quite aggressively. As part of the whole optimization I'd want to…
BerserkEVA
  • 153
  • 1
  • 1
  • 5
1
vote
1 answer

MySQL occasional non-responsive only on one database

I have an issue that occasionally (once or twice a week, not necessarily during peak hours) that queries on a certain db (the db of the largest of my sites) suddenly stop responding for about an hour. The queries start to pile up, mostly in "sending…
Sherif Buzz
  • 283
  • 1
  • 3
  • 16
1
vote
1 answer

SBS 2003 exchange database optimization period, should it be before the sbs full backup or after backup is done

i just want to check something. i always thought that a full sbs 2003 backup (through backup wizard) actually optimized the database of the exchange server. i was curious to see if you would suggest maybe doing an exchange database optimization…
dasko
  • 1,244
  • 1
  • 22
  • 30
1
vote
2 answers

Can my mysql server be fully tweaked?

I'm on a quadcore CENTOS 5.9 i686 standard running WHM 11.36.0. It's a dedicated LAMP server with lots of websites, most of which are using databases. I'm monitoring the server using Munin and notice the load is always quite high, pushing the limits…
Phred
  • 13
  • 2
1
vote
1 answer

MysqlTunner and query_cache_size dilemma

On a busy mysql server MySQLTuner 1.2.0 always recommends to add query_cache_size no matter how I increase the value (I tried up to 512MB). On the other hand it warns that : Increasing the query_cache size over 128M may reduce performance Here are…
wbad
  • 187
  • 2
  • 7
1
vote
0 answers

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 around for hours for a solution but all I could find…
1
vote
3 answers

What's the difference of running ab locally and remotely?

I was benchmarking my site with apache ab and I noticed that the response time had big differences when running ab on the server and running ab on a client box remotely. So what's the biggest difference between running ab on the server and running…
Mickey Shine
  • 939
  • 4
  • 17
  • 33
1
vote
0 answers

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 IOwait is like 100% on all cpu cores.I tried to…
Werulz
  • 315
  • 1
  • 5
  • 16
1
vote
3 answers

Lots of files being used by blank web page. What are they?

I am trying to optimise a website and I was using the network waterfall facility in Google Chrome. When I looked at the results there were lots of files which I didnt recognise. I first thought they might be something to do with Google Chrome…
byronyasgur
  • 190
  • 8
1
vote
2 answers

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 to do a single-page read. With the hardware (i7,…
Asaz
  • 11
  • 1
  • 2
1
vote
2 answers

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 to batch optimize (and replace) these images…
user1603240
  • 59
  • 1
  • 4
1
vote
2 answers

Optimize Apache - should I use APC / nginx?

I've read many posts regarding Apache optimization. While reading, two names repeated over and over again, nginx and php-apc. I've tried to understand which of them might be helpful for me, but i could not find a definite answer. I need my server to…
Kuf
  • 449
  • 2
  • 8
  • 25
1
vote
2 answers

gzip compression increases performance, then eventually increases response time from server

Here is my current server scenario. I'm running on a Rackspace Cloud instance (16GB of RAM), using cPanel/WHM on a CentOS 5.5 install. I'm currently running about 10 Magento sites, all varying in size (from medium size to small) Over time I noticed…
Axel
  • 111
  • 2