Topic: Any Linux pros able to lend a hand to tune a server for high load? - page 2. (Read 6553 times)
January 24, 2013, 11:55:38 PM
The default configuration for MySQL (especially innodb) are not optimized for heavy load. Do you know which storage engine you are using?
January 24, 2013, 11:45:47 PM
How was the software transferred to you? Presumably it's all custom software. First place I'd look would be the SQL. There are ways of seeing what's tying up mysql queries. Often all that's needed is an index in the right place.
January 24, 2013, 11:34:45 PM
Ok, maybe we can work this out on the forum (let anybody chime in who knows).
I just opened CoinURL.com and yes, it's slow. So I timed the request. It took 3 seconds just to get the first HTTP request back!
Can you try running 'top -d1' and look at what processes are using the most CPU. I know it's only 20-30% load, but it seems like a badly tuned process, so top should identify that.
Basically my first guess is that it's either the apache config (too few workers) or the PHP (bad config, bad SQL, or bad external library). Either of these will show apache using the most cpu, so if it's something else we'll know to look at that.
I just opened CoinURL.com and yes, it's slow. So I timed the request. It took 3 seconds just to get the first HTTP request back!
Can you try running 'top -d1' and look at what processes are using the most CPU. I know it's only 20-30% load, but it seems like a badly tuned process, so top should identify that.
Basically my first guess is that it's either the apache config (too few workers) or the PHP (bad config, bad SQL, or bad external library). Either of these will show apache using the most cpu, so if it's something else we'll know to look at that.
January 24, 2013, 10:29:54 PM
Howdy folks!
Long story short, I just acquired CoinURL.com and it is configured on my server and functioning properly... Except my server cannot handle the load. But my server is the same as the previous owners' server except I have double the memory he had.
The CPU utilization is nominal (20-30% load), the server can handle 30 megabit connections (easily) during file transfer but CoinURL is only requiring 100-300 kb/s and it seems to just be crawling under that amount.
Many, many small connections. It would appear that a standard Ubuntu server with Apache, MySQL, and PHP at default settings cannot handle the load and I am having a hard time finding exactly what the bottleneck is.
Any advice would be greatly appreciated.
I can probably pay you a bit too but I'm a bit strapped at the moment, but if you could solve the problem it would inevitably save me from renting a dedicated server, which I'm not convinced would be necessary, it seems to be a configuration issue. Solving the problem would not be forgotten and I would not hesitate to offer a reward of some sort.
Long story short, I just acquired CoinURL.com and it is configured on my server and functioning properly... Except my server cannot handle the load. But my server is the same as the previous owners' server except I have double the memory he had.
The CPU utilization is nominal (20-30% load), the server can handle 30 megabit connections (easily) during file transfer but CoinURL is only requiring 100-300 kb/s and it seems to just be crawling under that amount.
Many, many small connections. It would appear that a standard Ubuntu server with Apache, MySQL, and PHP at default settings cannot handle the load and I am having a hard time finding exactly what the bottleneck is.
Any advice would be greatly appreciated.
I can probably pay you a bit too but I'm a bit strapped at the moment, but if you could solve the problem it would inevitably save me from renting a dedicated server, which I'm not convinced would be necessary, it seems to be a configuration issue. Solving the problem would not be forgotten and I would not hesitate to offer a reward of some sort.
Jump to: