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

0
votes
2answers
1k views

MySQL 2,500+ opened tables

I'm running 16 GB of RAM with dual 3.0 Ghz processors with Ubuntu Server My PHPMyAdmin is showing: Opened_tables 2,573 - The number of tables that have been opened. If opened tables is big, your ...
1
vote
2answers
302 views

Recommend a good guide for MySQL optimization

I just upgraded my RAM on my server from 4 GB to 16 GB and I'm told that I can utilize this memory to a huge advantage with certain MySQL settings if I get then just right. Do you know of any guides ...
4
votes
3answers
970 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
1answer
47 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
1answer
119 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
4answers
240 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 ...
8
votes
1answer
1k 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 ...
0
votes
3answers
227 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
1answer
3k 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 ...
3
votes
2answers
988 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
3answers
315 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
1answer
209 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
5answers
299 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
1answer
646 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
1answer
160 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
1answer
909 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
111 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? ...
1
vote
1answer
160 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
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 ...
0
votes
1answer
59 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
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 ...
0
votes
4answers
88 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
4answers
964 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
1answer
271 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
3answers
3k 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
3answers
2k 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
1answer
111 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 ...
1
vote
1answer
3k 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
3answers
295 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 ...
16
votes
2answers
16k 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
2answers
2k 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
2answers
905 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 ...
3
votes
2answers
137 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 ...
2
votes
5answers
7k 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
3answers
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
2answers
165 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
1answer
1k 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
3answers
387 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
5answers
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
1answer
2k 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 ...
0
votes
2answers
84 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
2answers
473 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
1answer
431 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
1answer
344 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
3answers
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
1answer
80 views

Cost of Parameterization in SQL Server 2008

Does Anybody know absolute or relative cost of forzed parameterization in SQL Server 2008?
1
vote
4answers
2k 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 ...
6
votes
6answers
10k 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
1answer
355 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 = ...
7
votes
1answer
3k 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, ...