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
2
votes
2 answers

How can I optimize Apache to use 1GB of RAM on my website?

My VPS plan gives me 1GB of RAM burstable to 2GB. Of course I cannot use 2 GB, nor > 1 GB, everyday, so I'm planning to optimize the performance of my webserver. The average of hits-per-hour is about 8'000-10'000. This means about 2…
Markon
  • 143
  • 1
  • 1
  • 7
2
votes
6 answers

What are the practical differences between an IP address and a server?

My understanding of IPs and other DNS-type server-related issues really falls short (read: exteme noob). I know a dedicated server would increase speed. What, if any, difference in speed would a dedicated IP make? Am I correct in understanding the…
JakeParis
  • 123
  • 6
2
votes
1 answer

How to set query_cache_size and join_buffer_size in my.cnf file?

I have been monitoring my server the past two days and realised that 60% of my temp tables are stored on the hhd instead of memory. Also I ran MySQL Performance Tuning Primer script that adviced me to set the query_cache_size. Now, to do this, I…
LittleSnitch
  • 23
  • 1
  • 1
  • 3
2
votes
1 answer

MySQL logging slow queries

I've told MySQL to log queries that take longer than a second (1 in the config)... however I'm seeing queries like this that take much less than a second.... # Time: 101108 6:39:32 # User@Host: source_member[source_member] @ localhost [] #…
Ben
  • 3,800
  • 18
  • 65
  • 96
2
votes
4 answers

What's the fastest way to server a single static webpage from a single server in memory?

Been dealing with growing demands for system resources on a website, and got me thinking: What's the fastest way to server a single static webpage from a single server in memory? Feel free to ask for clarifications, basically trying to reduce the…
blunders
  • 813
  • 7
  • 14
  • 30
2
votes
5 answers

mysql - is there a good way of storing it in ram

I'm trying to think of ways to make mysql faster. Is there a proven way of storing it in ram to allow it to work faster?
Matthew
  • 1,859
  • 4
  • 22
  • 32
2
votes
1 answer

mysql my.cnf for a 50GB of RAM server

I am having load problems on my database server (dual quad core 50 GB RAM) load average: 4.26, 6.78, 11.25 here is the current my.cnf, can i optimize it? [client] port = 3306 socket =…
user54963
  • 123
  • 2
2
votes
3 answers

MySQL too many connections

On my server I have 7 databases. Our server has 512 MB of RAM which I'm getting upgraded this evening to 2GB and has a 2.4 single processor. I've gotten an error about the connection limit exceeded. With increasing my RAM, is it ok to increase the…
Ben
  • 3,800
  • 18
  • 65
  • 96
2
votes
2 answers

Will spreading your servers load not just consume more recourses

I am running a heavy real-time updating website. The amount of recourses needed per user are quite high, ill give you an example. Setup Every visit The application is php/mysql so on every visit static and dynamic content is loaded. Recourses:…
Saif Bechan
  • 10,960
  • 10
  • 42
  • 63
2
votes
1 answer

How to optimize a postgreSQL server for a "write once, read many"-type infrastructure?

Greetings, I am working on a piece of software that logs entries (and related tagging) in a PostgreSQL database for storage and retrieval. We never update any data once it has been inserted; we might remove it when the entry gets too old, but this…
user39530
  • 68
  • 5
2
votes
3 answers

PostgreSQL lots of writes

I am using postgreSQL for a scientific application (unsupervised clustering). The python program is multi-threaded so that each thread manages its own postmaster process (one per core). Hence, their is a lot of concurrency. Each thread-process loop…
2
votes
1 answer

CPU bound process?

I have a postgresql server process running on my windows computer. When running a query I can see in the process manager that it is using 49% of CPU capacity on my dual core processor and it is also reading about 5 mb/s. My question is if it is…
David
  • 447
  • 1
  • 5
  • 11
2
votes
3 answers

How to optimize iptables for high DNS traffic?

How to optimize iptables for high DNS traffic? I have a dedicated linux server acting as bridged firewall using iptables. Recently behind firewall was deployed DNS server with high load and firewall began to work slow. Some tips, how to make…
2
votes
1 answer

NGINX Redirect to Cached File in Subfolder

I have a program that creates optimized versions of pictures that are uploaded to the /images/ folder on the web server. It traverses subfolders and in each one, creates a .optimized folder that holds the optimized version, if it is at least a…
Timothy R. Butler
  • 703
  • 2
  • 11
  • 22
1
vote
4 answers

Lower Maximum Possible Memory Usage

I've been using MySQLTuner to optimize my database, and the only problem I am having is: [!!] Maximum possible memory usage: 14.8G (126% of installed RAM) I'm not sure what I should be changing to get this down under my 12G of RAM. I have a…
James Simpson
  • 1,651
  • 2
  • 15
  • 31