1
vote
1answer
935 views

MySQL high CPU usage on small website

I have a small website hosted on a dedicated server (FreeBSD 9.2, MySQL 5.6.1 and php 5.5.5). The problem is that MySQL eats a lot of cpu resources even if the website have a few visitors. The ...
1
vote
1answer
2k views

How to troubleshoot slow performance on AWS EC2/RDS?

We recently moved our web servers from some 10 year old boxes to AWS EC2. Usage of the site is currently higher now (it's our busy season) and the site has become much slower, which is unexpected ...
6
votes
2answers
529 views

Why is Postgres sitting 95% idle, with no file I/O?

I have a TileMill/PostGIS stack running on an 8 core Ubuntu 12.04 VM on an OpenStack cloud. It's a rebuild of a very similar system which was running nicely on very similar hardware (same cloud, but ...
2
votes
4answers
4k views

Flush-0:n processes causing massive bottleneck

I have a LAMP cluster that shares files via NFS and occasionally one of them will be stricken for a while when mysterious flush processes start appearing. Can anyone help me? The only way to resolve ...
2
votes
1answer
330 views

Solaris/UNIX: Does snoop have the potential to slow down network traffic?

This is the way I see it. A copy of the network activity is written to a buffer, and snoop reads from the buffer. As long as snoop is able to get the data out fast enough (writing directly to a file ...
1
vote
1answer
184 views

Server freeze (Disk I/O possibly)

I have a Windows Server 2008 machine that is resyncing disks after a powerloss. The issue is that the system becomes unresponsive after about 10 minutes. We've checked with resource monitor and found ...
1
vote
1answer
1k views

Mysql hangs up the server. How to avoid this?

Sometimes my website 'goes down' due to Mysql consuming all the resources, but I think it does not stop creating more httpd processes. Is that possible? If I restart apache, these processes disappear ...
4
votes
2answers
2k views

Steps to diagnose performance bottlenecks on Mac OS X

If you wanted to track down performance issues on a machine running Mac OS X and find out what was causing slowdowns, which command-line or graphical tools would you use, and how would you use them? ...
0
votes
1answer
668 views

Looking for a bottleneck in MySQL server

I have two Ubuntu servers with very similar, if not identical, configuration: both have 16 cores (4 E5540 Xeons), 16GB RAM, HP Smart Array P212 controllers with 2 HDDs in RAID1. I/O scheduler used is ...
0
votes
2answers
125 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
2answers
234 views

How do I know when server “runs at speed limit”?

Basically I'd like to know if it's possible to speed up my server or not by using caching like squid, checking for possible errors in configuration, optimizing various server software parameters, etc. ...
6
votes
6answers
6k views

Find the bottleneck: disk I/O on Windows XP

One of our development boxes has developed a problem wherein performance will occasionally drop through the floor. When this happens, you can hear the hard drive thrashing, but I don't know what's ...