Questions tagged [optimization]
Optimization is the process of modifying a system to make some aspect of it work more efficiently or use fewer resources.
340
questions
4
votes
3
answers
2k
views
How to determine bottlenecks on Ubuntu LAMP environment
What kind of tests should I run to determine bottlenecks on my server? I'm trying to optimize so I can maintain heavy load spikes when they occur. I'm running Ubuntu in a LAMP environment.
1
vote
1
answer
52
views
Compile primary services for performance gain
Greetings,
Is it worth it to compile primary services like Apache, MySql and on another note, the kernel to squeeze out more performance?
Ubuntu 10.04 64bit
// EDIT
I mean compile from source with ...
0
votes
1
answer
124
views
Optimizing a Facebook application... where should I start?
We have developed a Facebook application... we launched and had over a thousand users in 12 mins. The problem is the application did not handle it and so we had to take it back offline. Where should ...
2
votes
4
answers
283
views
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 ...
10
votes
1
answer
4k
views
When should you use and not use Etags?
I was just looking at our site on WebPageTest.org and one of their recommendations for speeding up a website is:
ETag headers should generally not be used unless you have an explicit reason to need ...
0
votes
3
answers
243
views
Does this top look healthy to you?
I run a server with the following specs:
Intel i7 920
8 GB RAM
Linux 2.6.32-25-server #44-Ubuntu 10.04 SMP Fri Sep 17 21:13:39 UTC 2010 x86_64 GNU/Linux
75 Apache processes
Low-end hardware RAID-1 ...
0
votes
1
answer
4k
views
What are the kernel and cflags for AMD Phenom II x6 (K10 / Thuban)?
In the 2.6.35 kernel I have a choice of:
Operon/Athlon64/Hammer/K8
Generic-x86-64
The first option seems best but I'd like confirmation. I have no idea whether there is a specific -mcpu / -march ...
4
votes
2
answers
5k
views
Do access logs (from nginx) slow down a website?
Does it slow down a website if your webserver (in my case, nginx) is writing to an access log?
I'm mostly wondering if it's noticeable.
Plus, what's the point of knowing the user agents / ips that ...
0
votes
3
answers
327
views
Load balancing w/out a "front server"
I don't know too much about complex server setups (that's why I'm asking the question).
My understanding is that generally you have a "load balancing" server that sends requests to other backend ...
1
vote
1
answer
286
views
Accurately benchmarking a server
I'm getting a server ready for production, and I'm trying to accurately estimate how much it can handle.
For example, on one of the static pages (the whole page is the same all the time), If I run ...
2
votes
5
answers
818
views
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?
2
votes
1
answer
893
views
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 ...
0
votes
1
answer
233
views
Scaling horizontally
I know next to nothing about having more than one server work together. Right now I've been playing around with the cloud servers offering from rackspace.
All the time when people talk about these ...
3
votes
1
answer
3k
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
1
answer
294
views
Mysql- How can I find the memory usage of indexes
mysqltuner tells me to increase key_buffer_size dramatically. I dont have free memory to do it therefore I prefer to remove unnecessary indexes if any.
How can I find the memory usage of indexes? (...
0
votes
1
answer
296
views
how to make a server that handles 1000 clients [closed]
I am looking for server software to handle data for thousands of clients (internal company employees).
This server should be multi-threaded to handle all the clients with good client overhead ...
0
votes
2
answers
70
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 ...
0
votes
1
answer
98
views
Can having native mobile app for your website reduce server load?
Sorry guys, I'm a bit new to this. I'm not sure if I'm asking the right questions here. I'm creating an iPhone app for my website, and most of my users are going to use it through the iPhone rather ...
0
votes
1
answer
599
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 ...
0
votes
4
answers
103
views
What's the best way to debug and enhance the speed of your server?
My server has been running slightly slower than normal.
I was wondering what strategies I could do to evaluate the speed of my server, and enhance it
This question covers database interaction, I/O, ...
0
votes
4
answers
4k
views
Do i need to allocate more resources to mysql server?
I have feeling that mine mysql server is slower than normal while processing queries from the PHP website.
Is there anything like i can allocate more resources to Mysql server to make it speedy?
I ...
1
vote
1
answer
303
views
optimizations for a server with nginx as the front and apache as the back?
Are there any general optimizations for this sort of setup? I read something about nginx not using the most recent protocol in http, so are there things that I could tune apache for? Also, is there ...
2
votes
3
answers
11k
views
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. ...
1
vote
3
answers
6k
views
Disable Memory Modules In BIOS for Testing Purposes (Optimize Nehalem/Gulftown Memory Performance)
I recently acquired an HP Z800 with two Intel Xeon X5650 (Gulftown) 6 core processors. The person that configured the system chose 16GB (8 x 2GB DDR3-1333). I'm assuming this person was unaware these ...
1
vote
1
answer
131
views
SQL Server 2008 Optimization
I've learned today, if you append to your query
OPTION (MAXDOP 0)
your query will run on multiple processors and if it's huge query, query will perform faster.
I know general guidelines on query ...
3
votes
1
answer
5k
views
How to get the best LINPACK result and conquer the Top500?
Given a large Linux HPC cluster with hundreds/thousands of nodes. What are your best practices to get the best possible LINPACK benchmark (HPL) result to submit for the Top500 supercomputer list?
To ...
0
votes
3
answers
376
views
Speed up MySQL for inserts (for testing purposes)
I have a bit of software that needs to do a lot of INSERTs. In production environment there'll be some serious tweaking and testing and stuff like that, but now when I need to test it I'd like to ...
27
votes
3
answers
35k
views
How to determine the best byte size for the dd command
I know that doing a dd if=/dev/hda of=/dev/hdb does a deep hard drive copy. I've heard that people have been able to speed up the process by increasing the number of bytes that are read and written at ...
1
vote
2
answers
9k
views
AB failed requests - What can I do about them?
So, in the past I've never had any problems with this app. All benchmarks had 100% success rate. Yesterday I set up nginx to server static content and pass on other requests to apache. Now, if I have ...
1
vote
2
answers
1k
views
MySQL Config on Large Machine
We have a Windows 2003 Enterprise Edition server (64bit) running only MySQL 5.1.45 64-bit. It has 16G RAM and 10T of hard-drive space in RAID 10. We are having horrible performance from mysqld (85-...
3
votes
2
answers
160
views
Snow Leopard: Optimization
I have bunch of questions:
I have a Mac network, which has five Mac's. Right now, they are individually getting software updates. Is there a way to download the patches/security updates in a single ...
6
votes
5
answers
11k
views
CPU's on Hyper-V host system is just idling, even though VM's are at full throttle
I have a server that is running Windows 2008 64 bit Hyper-V, with 8 gigs of RAM and Intel Xeon X3440 @ 2.53 Ghz, which gives me 8 logical cores in the performance monitor on the host system.
I have ...
4
votes
3
answers
2k
views
Have I pushed the limits of my current VPS or is there room for optimization?
I am currently on a mediatemple DV server (basic) 512mb dedicated ram, this is a CentOS based VPS with Plesk and Virtuozzo. My experience with it from day 1 has been bad and I only could sooth my ...
2
votes
2
answers
172
views
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 ...
2
votes
1
answer
2k
views
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 ...
2
votes
3
answers
943
views
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 ...
0
votes
5
answers
1k
views
Subversion/Hudson/Sonar/Artifactory - too much for my little server to handle! Help!
I have a little dedicated server. It's at a cheap price and has a simple AMD 1800+ (1.5ghz), 256mb DDR RAM, ...need I continue? And I think I'm overloading it already.
I have installed the following, ...
1
vote
1
answer
4k
views
MySQL Created_tmp_disk_tables
I'm trying to improve the performance of our primary MySQL server. It's a Dual Quadcore Intel X5450, with 8GB of RAM. It's a dedicated MySQL box. I'm only in the beginnings of configuring it, so I'...
0
votes
2
answers
93
views
Second server instance (for static files) on a standard host?
Serving static files from an independent host from the rest of my website is supposed to improve performance. I'm cheap, so I was wondering if I can do that within one standard hosting service. ...
6
votes
2
answers
539
views
Do you remove unwanted packages (*NIX), or do you disable them?
Im currently building a cobbler and puppet setup. One thing I do is disabling unwanted services with puppet, but then I thought: Should I remove them with cobbler, rather than disabling them after ...
1
vote
1
answer
2k
views
What is the fastest way to optimize a MySQL table?
I've ran many different DELETE queries against many tables in the huge database (hundreds of millions records). What would be faster - to run OPTIMIZE TABLE against each modified table. Or just to ...
2
votes
1
answer
382
views
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 ...
2
votes
3
answers
2k
views
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 ...
0
votes
1
answer
90
views
Cost of Parameterization in SQL Server 2008
Does Anybody know absolute or relative cost of forzed parameterization in SQL Server 2008?
1
vote
4
answers
3k
views
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 ...
25
votes
7
answers
56k
views
How many files in a directory is too many? (Downloading data from net)
Greetings,
I'm writing some scripts to process images from various photo websites. Right now I'm storing all this data in individual text files in the same directory.
The directory is web ...
1
vote
1
answer
379
views
LEFT JOIN Server Performance optimization
I have a query that I want to execute that fastest possible.
Here it is:
select d.InvoiceDetailId,a.Fee,a.FeeTax
from InvoiceDetail d
LEFT JOIN InvoiceDetail a on a.AdjustDetailId = d....
7
votes
1
answer
4k
views
How to select the best Stripe Size when configuring a RAID Array
There are various "references" on the Internet that delve into some discussion about what factors to consider when selecting a particular RAID stripe size (4KB to 128KB or more) for an array of disks, ...
0
votes
2
answers
157
views
mySQL Database Performing Extremely Poor on INSERT, DESTROY, but fine on FIND and UPDATE
I believe I've encountered a database scaling issue. I have a table with nearly a million rows in it now and our rails application appears to be hanging whenever we try to create a new instance. I ...
0
votes
1
answer
209
views
Oracle hardware requirements and optimization [closed]
I'm an application developer. We have some reporting solution for our client on Oracle database 10g. They would like to speed up execution of some calculation stored procedures. Ok, I know about query ...