MySQL Forums
Forum List  »  Performance

Mysql seems to be bogged down
Posted by: Mike Martinez
Date: September 09, 2005 12:40PM

I've inherted a positoin as a webmaster of a company that runs:
SunOS 5.9
MySql 1.3.29
Php 4.34
Apache1.3.29
The web site is all this machine is used for. Ive included a few copies of my top posting.
The web site is really slow. Looking at the top readout I can only guess that it has something to do with MySql due to the first line (PID 1733). The coding that is used to generate the web page is really basic php and sql. Is there a way I can do further tests on MySql to determine the source of the problem? Any advise or suggestions would be greatly appreciated.

P.S. when I restart the server with init 6 things run faster but after 30 minutes or so it's slow again. We get about 15,000 unique visitor a day.



load averages: 73.50, 78.14, 76.26 xxxxxxxx 10:42:13
303 processes: 198 sleeping, 76 running, 21 zombie, 7 stopped, 1 on cpu
CPU states: 0.0% idle, 66.3% user, 33.7% kernel, 0.0% iowait, 0.0% swap
Memory: 4.0G real, 2.1G free, 2.9G swap in use, 1.1G swap free

PID USERNAME THR PR NCE SIZE RES STATE TIME FLTS CPU COMMAND
1733 mysql 30 49 0 1.9G 404M run 316:09 1 7.31% mysqld
12876 nobody 1 48 0 39.2M 37.3M run 1:45 0 2.36% httpd
29288 nobody 1 59 0 7552K 5560K sleep 0:11 0 1.16% httpd
16401 nobody 1 59 0 8696K 6832K sleep 0:59 0 1.07% httpd
176 nobody 1 49 0 8752K 6888K run 1:34 0 0.80% httpd
11891 nobody 1 59 0 41.5M 39.5M sleep 18:34 0 0.64% httpd
7692 nobody 1 59 0 7552K 5528K sleep 0:02 0 0.60% httpd
13264 nobody 1 49 0 8784K 6904K run 1:44 0 0.59% httpd
1238 nobody 1 59 0 9320K 7464K sleep 0:50 0 0.58% httpd
19725 nobody 1 59 0 8616K 6752K sleep 0:37 0 0.53% httpd
27582 nobody 1 59 0 8552K 6672K sleep 0:08 0 0.53% httpd
17640 nobody 1 59 0 7552K 5496K sleep 0:03 0 0.53% httpd
11907 nobody 1 49 0 41.4M 39.4M run 16:19 0 0.51% httpd
18696 nobody 1 59 0 8616K 6720K sleep 1:48 0 0.51% httpd
15654 nobody 1 59 0 8512K 6592K sleep 0:40 0 0.50% httpd
-------------------------------------------------------------------------------------

load averages: 69.01, 75.55, 75.46 xxxxxxxx 10:43:26
270 processes: 197 sleeping, 49 running, 15 zombie, 8 stopped, 1 on cpu
CPU states: 0.0% idle, 55.8% user, 44.2% kernel, 0.0% iowait, 0.0% swap
Memory: 4.0G real, 4.1G free, 5.8G swap in use, 2.2G swap free

PID USERNAME THR PR NCE SIZE RES STATE TIME FLTS CPU COMMAND
1733 mysql 33 49 0 1.9G 404M run 316:21 2 8.09% mysqld
12876 nobody 1 44 0 39.2M 37.3M run 1:48 0 2.42% httpd
23918 root 1 54 0 4568K 2712K run 0:09 7 1.02% w3-daemon
20650 root 1 54 0 2760K 1648K cpu02 0:00 0 0.82% top
14170 nobody 1 59 0 9968K 7080K sleep 1:27 0 0.78% httpd
15583 nobody 1 54 0 8800K 6928K run 0:48 0 0.72% httpd
6999 nobody 1 49 0 7576K 5512K run 0:01 0 0.63% httpd
4970 nobody 1 49 0 8224K 6232K run 0:19 0 0.63% httpd
6937 nobody 1 54 0 8216K 6256K run 0:03 0 0.63% httpd
12454 nobody 1 59 0 8112K 6144K sleep 0:17 0 0.62% httpd
27130 nobody 1 49 0 8872K 6792K run 0:40 0 0.62% httpd
21387 nobody 1 59 0 8800K 6912K sleep 0:37 0 0.61% httpd
26280 nobody 1 59 0 10.2M 8664K sleep 0:20 0 0.57% httpd
1238 nobody 1 59 0 9320K 7464K sleep 0:50 0 0.56% httpd
1279 nobody 1 59 0 8664K 6784K sleep 0:48 0 0.56% httpd

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql seems to be bogged down
2347
September 09, 2005 12:40PM
1453
A F
September 09, 2005 01:45PM
1693
September 09, 2005 09:32PM
1498
A F
September 12, 2005 07:50AM
2011
September 12, 2005 11:31AM
1354
September 12, 2005 05:13PM
1340
September 16, 2005 05:28PM
1513
September 20, 2005 09:54AM
1541
September 22, 2005 04:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.