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

2
votes
5answers
298 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
643 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
158 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
845 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
109 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
156 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
58 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
556 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
879 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
268 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
2k 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
109 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 ...
15
votes
2answers
14k 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
891 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
135 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
6k 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 ...
3
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
164 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
380 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
468 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
377 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
343 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
1k 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
8k 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
348 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, ...
0
votes
2answers
129 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
1answer
194 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 ...
2
votes
1answer
4k views

Any guide to set values for fastcgi_buffers in Nginx config?

I just moved our blog-network to ngnix (from apache) which is powered by WPMU. Everything is running smoothly and fine. During my quest to optimize server to the max level - I came across this thread ...
0
votes
2answers
2k views

How to optimize my.cnf and httpd.conf for speed on a powerful dedicated server?

I have a dedicated server that has 12GB of RAM and Dual Nahalem Quad Core processors. My site usually only has about 50-100 users online at a time (though once I get the server optimized I plan on ...
0
votes
1answer
541 views

What is star query optimization?

I found in a features table for SQL Server 2005 a row named "Star query optimization" but it is not explained anywhere. Could this be a feature that optimizes a query like : SELECT * FROM Table
2
votes
1answer
306 views

Recommendations for Java Web Server [closed]

I am currently using DBCP for connection pooling since it is more or less provided with tomcat and easy to setup. I am thinking about migrating to Glassfish or Jetty and haven't yet determined which ...
1
vote
1answer
555 views

Optimizing Apache

I've been reading multiple optimization guide for apache and found a lot of data (Although I have no idea what is the experience of the authors). I have a production server with apache 2.2.3, MySQL ...
1
vote
1answer
1k views

Performance issue with Apache, PHP and Symfony

Updated: ================================================================ I finally found the reason with oprofile. It was because the routing cache of Symfony. We have lots of pages with different ...
0
votes
2answers
3k views

Can I safely stop running Update Statistics on my SQL Server 2005 instance?

I've got a SQL 2005 database which has some maintenance plans on it set up by someone else. One runs Update Statistics on all databases early in the morning. It seems this is causing tempdb to fill up ...
3
votes
6answers
1k views

MySQL performance tuning

I'm looking for a succinct list of common pitfalls and optimizations for tuning a MySQL server as used for mid-size websites. In general, the type of advice I'm looking for here is information that ...
20
votes
3answers
45k views

Optimal values for ServerLimit, MaxClients, MaxRequestsPerChild directives

I'm running a traffic intense site plenty of dynamic content, mostly user-generated. The server is a dedicated one and has a total of 4 Intel(R) Xeon(R) CPU X3210 @ 2.13GHz proccesors. I need to know ...
2
votes
3answers
651 views

What optimizations can be performed on SQL Server with SAN?

This question is a bit general since I am not exposed to SAN (Storage Area Network). Are there any optimizations or configuration changes that can be performed with SAN to improve SQL Server ...