1
vote
3answers
130 views

Load Balancing - PHP/Mysql [closed]

I have a server which relies heavily on a MYSQL database. Recently, there have been load issues and max mysql connection issues. My idea is to have a primary server with the php code and files and a ...
-1
votes
1answer
880 views

Best Apache & MySQL config for 16GB and 8 Cores [closed]

I'm having some trouble with my servers. I'm having a peak and my servers load are very high. I have 3 servers, one for frontend, one for database (mysql) and one for delivery images (no problem with ...
-1
votes
2answers
50 views

server busy threshold? [closed]

i have a server with 512MB RAM running mysql and apache service. I have joomla site inside my server. I want to ask, is there a brief threshold limit of RAM when the server will be stated as busy? ...
0
votes
1answer
25 views

Listing all httpd accesses

I have a server with several domains. The server is having a heavy load but I don't know what domain is the guilty one. Is there a way to list on terminal the load per server? or what servers are ...
4
votes
3answers
517 views

Which user is hogging the MySQL database server's CPU?

I maintain webhosting servers and more often than not sometimes a server slows up as a result of increase in load or a large amount of CPU resources used up. I've observed that its the MySQL usage ...
5
votes
5answers
956 views

Ubuntu Server 12.04 CPU Load

I have a Server (2x Hexa-Core Xeon E5649 2.53GHz w/HT with 32GB RAM and 20000 GB Bandwidth) running Ubuntu Server 12.04 LTS. The server runs LAMP and serves one website only, the estimated number of ...
-1
votes
2answers
192 views

Is this Mysql database server load too high?

I'm running a php website. I have two servers. Please help me to check is this Mysql Database Server load too high? I found the mysql CPU usage is always higher than 100%. Any suggestions to ...
-5
votes
3answers
95 views

A good long term strategy to support the increasing workload [closed]

Let's make this simple. I have a website hosted on a single dedicated server (LAMP). All static content are alraedy on an external CDN. PHP pages aren't a problem because they take pretty low time to ...
0
votes
1answer
417 views

MySQL is always taking 200% - 300% CPU during day time. Normal or bad?

MySQL daemon is always taking 200% - 300% CPU during day time. Normal or bad? ( Website has a concurrent connections 200 about but it's running Drupal without reverse proxy with many many writes ...
2
votes
0answers
392 views

MySQL INSERT … SELECT renders server unresponsive

Solution: Although I haven't found a proper solution yet I'm at least sure that this is purely a disk I/O problem and has nothing to do with MySQL... I have a MySQL server (5.1.54-1ubuntu4-log) ...
0
votes
2answers
8k views

Why MySQL doesn't use settings specified in my.cnf?

I've installed MySQL 5.5.15 on debian-lenny server. I used default instruction & settings to install it. Now, my server starts successfully, but seem non of my specified settings in /etc/my.cnf ...
-1
votes
1answer
476 views

Mysql taking too much memories, how to solve

I had a Drupal website on a test box and I am the only visitor. When I do nothing. Mysql is taking like 7% mem. When I click homepage. I can literally see that mem ramps up to 15% of the mem by ...
2
votes
3answers
194 views

Load balancing - Multiple servers, different locations

I've been scaling out a service very rapidly, and have found a problem in the way I've been balancing the load. My servers do not need a perfectly even distribution, so I was simply using a round ...
0
votes
2answers
79 views

load on php mysql linux performance

I have multiple scripts under PHP execution on linux server, which do constant operations on MySQL residing on the same server. I observed that many 'deadlocks' and 'longer wait timeout exceeded' ...
2
votes
3answers
265 views

mysql having loads

My website and server both are huge and heavy, my server is having 8GB RAM and 6 cores of processor. I got a mail from my hosting team, regarding the load of mysql database, Now-a-days my site is ...
0
votes
1answer
313 views

MySQL database server on a VPS: can it handle the spike in traffic I'm anticipating?

I have VPS service with Hostican.com. 2.7GHz CPU, 2GB RAM (level 5, if you look at the site). I have a smartphone app that makes requests to PHP forms, which query the MySQL DB. I'm anticipating a ...
3
votes
3answers
124 views

We are moving to two servers from one server due to performance issues. How do we monitor the value of this change?

We are moving to two servers from one server due to performance issues. We are moving our MySQL DB to its own dedicated server and will keep the original machine as the front end machine running ...
0
votes
2answers
430 views

Mysql: less than half of memory used. High load

I have an Ubuntu 8.04 LTS, with 8Gb memory, with dual E3110@3.00GHz, software raid on sata II. For a couple of monts now I try to tune the server and it seems that I'm still far from being done. ...
0
votes
3answers
287 views

Problem with load Apache + MySQL

I have tried configuring both Apache and MySQL but I still get very high peaks in load: http://d.pr/aD9L I'm pretty sure these peaks are not caused by increase in traffic, because no peaks can be ...
1
vote
2answers
1k views

How to determine approximate maximum number of requests?

I'm building a quite simple web application, and need to get some rough understanding of how much load my server can take. Of course, this depends on a whole lot of factors, but I just need a rough ...
1
vote
1answer
779 views

MySQL failed to start after killed a long running “LOAD DATA INFILE” process

I killed a MySQL process which is running a LOAD DATA INFILE command to load a 9GB .csv file into a table in a InnoDB database. Now, when I run mysql DATABASE, it just stopped and showed Reading ...
2
votes
1answer
948 views

What method of MySQL mirroring should I use for this?

I'm running an web application hosting service (basically hosting forums for free), and I have two remote servers at my disposal. The code for the application is stored on both servers and isn't a ...
17
votes
6answers
13k views

Optimize apache/php/mysql running on VPS for heavy load

Question about optimizing an apache/mysql server on a VPS with 512m of RAM. Under normal load everything runs fast, no connection lag. However when we get our heavy traffic days (50k+ visits) the ...