nixCraft
Linux / UNIX Tech Support Forum
MYSQL having a heavy load
This is a discussion on MYSQL having a heavy load within the Databases servers forums, part of the Mastering Servers category; My mySQL server has always seemed to have a high load on the server, but I wasn't sure what to ...
|
|||||||
| Databases servers Discussions of databases of all types - especially MySQL. |
 |
|
|
LinkBack | Thread Tools | Display Modes |
21-10-2008, 08:11 AM
|
|||
|
|||
MYSQL having a heavy load
My mySQL server has always seemed to have a high load on the server, but I wasn't sure what to do about it. Recently I decided to try and be proactive about it and try to fix it or at least reduce the load on the server.
I'm running: RHEL4, mySQL 4, PHP4, 4gb ram. Any suggestions on where to start? Here is my recent top: Code:
top - 19:29:43 up 18 min, 1 user, load average: 0.79, 1.45, 1.68
Tasks: 145 total, 1 running, 143 sleeping, 0 stopped, 1 zombie
Cpu(s): 17.4% us, 1.9% sy, 0.0% ni, 80.2% id, 0.5% wa, 0.0% hi, 0.0% si
Mem: 4151256k total, 832876k used, 3318380k free, 64260k buffers
Swap: 2040212k total, 0k used, 2040212k free, 400100k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11722 mysql 15 0 139m 45m 3276 S 18.6 1.1 4:10.44 mysqld
12295 nobody 15 0 29352 13m 3428 S 8.0 0.3 0:08.19 httpd
12316 nobody 15 0 29368 13m 3236 S 6.0 0.3 0:09.12 httpd
16644 nobody 15 0 26908 11m 3872 S 2.7 0.3 0:09.66 httpd
12318 nobody 15 0 26848 11m 3392 S 1.0 0.3 0:02.48 httpd
13890 root 16 0 2816 1044 764 R 0.3 0.0 0:01.43 top
16645 nobody 16 0 26304 10m 3304 S 0.3 0.3 0:00.53 httpd
18930 nobody 15 0 29000 13m 3192 S 0.3 0.3 0:01.58 httpd
19849 nobody 15 0 25936 10m 3120 S 0.3 0.3 0:00.15 httpd
20668 nobody 15 0 25800 9864 2660 S 0.3 0.2 0:00.02 httpd
20680 nobody 15 0 25800 9864 2660 S 0.3 0.2 0:00.04 httpd
1 root 16 0 2536 552 472 S 0.0 0.0 0:00.46 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.01 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
6 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/0
|
| Sponsored Links | ||
|
|
|
03-03-2009, 01:56 AM
|
|||
|
|||
|
How to tweak ????
What options i should tweak ?
When i use show processlist It shows a few sleeping queries nothing else, still load is very high like 400% use by mysql alone. Any suggestion Regards anil
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Apache Load blance | vimalgoel | Web servers | 3 | 23-07-2007 04:51 PM |
| Howto Load Balancing Mysql and a web server | zafar466 | Databases servers | 1 | 27-03-2007 10:04 AM |
| increasing load | kasimani | Web servers | 3 | 21-02-2007 08:50 AM |
| Load Balancing. | asim.mcp | Linux software | 1 | 17-10-2006 05:49 AM |
| how much load a web server can take? | jerry | Linux software | 4 | 17-06-2006 01:41 PM |
All times are GMT +5.5. The time now is 02:15 PM.
