Multiple MySQL Instance and only one working
Hi
I'm facing some performance issues and when i execute top or ps-ef , i see multiple mysqld instance but only one is working. I want to increase the amount of memory for the java process. A Good idea ?
Tasks: 59 total, 1 running, 58 sleeping, 0 stopped, 0 zombie
Cpu(s): 50.0% us, 8.3% sy, 0.0% ni, 0.0% id, 40.7% wa, 1.0% hi, 0.0% si
Mem: 906660k total, 901380k used, 5280k free, 2428k buffers
Swap: 1502036k total, 2812k used, 1499224k free, 471580k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5862 root 19 0 501m 146m 19m S 28.0 16.6 9:21.89 java
5940 root 15 0 268m 263m 2672 D 17.8 29.7 5:46.09 mysqld
5942 root 15 0 268m 263m 2672 D 12.2 29.7 0:05.71 mysqld
1 root 16 0 1552 508 444 S 0.0 0.1 0:00.46 init
2 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
3 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/0
4 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 khelper
22 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 kacpid
115 root 5 -10 0 0 0 S 0.0 0.0 0:00.17 kblockd/0
158 root 14 -10 0 0 0 S 0.0 0.0 0:00.00 aio/0
157 root 15 0 0 0 0 S 0.0 0.0 0:00.31 kswapd0
745 root 15 0 0 0 0 S 0.0 0.0 0:00.00 kseriod
1115 root 15 0 0 0 0 D 0.0 0.0 0:00.72 kjournald
1140 root 7 -10 1532 364 288 S 0.0 0.0 0:00.01 udevd
1583 root 15 0 0 0 0 S 0.0 0.0 0:00.00 khpsbpkt
3090 root 23 0 0 0 0 S 0.0 0.0 0:00.00 shpchpd_event
3338 root 15 0 0 0 0 S 0.0 0.0 0:00.00 khubd
4675 root 25 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
4676 root 15 0 0 0 0 S 0.0 0.0 0:00.00 ahd_dv_0
4684 root 19 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
4685 root 15 0 0 0 0 S 0.0 0.0 0:00.00 ahd_dv_1
4894 root 15 0 0 0 0 S 0.0 0.0 0:00.00 knodemgrd_0
5347 syslog 16 0 1740 716 596 S 0.0 0.1 0:00.01 syslogd
5416 root 16 0 1552 380 316 S 0.0 0.0 0:00.01 dd
5418 klog 16 0 2432 1468 436 S 0.0 0.2 0:00.06 klogd
5450 root 20 0 1580 528 460 S 0.0 0.1 0:00.00 inetd
5596 root 16 0 2992 1144 964 S 0.0 0.1 0:00.00 master
5606 postfix 16 0 3000 1068 900 S 0.0 0.1 0:00.00 pickup
5607 postfix 16 0 3032 1100 920 S 0.0 0.1 0:00.00 qmgr
5613 root 16 0 3476 1504 1252 S 0.0 0.2 0:00.00 sshd
5628 ntp 16 0 3148 3148 2504 S 0.0 0.3 0:00.01 ntpd
5643 daemon 19 0 1728 608 524 S 0.0 0.1 0:00.00 atd
5654 root 16 0 1784 816 676 S 0.0 0.1 0:00.00 cron
5679 root 16 0 1548 472 408 S 0.0 0.1 0:00.00 getty
5682 root 16 0 1548 472 408 S 0.0 0.1 0:00.00 getty
5683 root 16 0 1548 472 408 S 0.0 0.1 0:00.00 getty
5684 root 16 0 1548 472 408 S 0.0 0.1 0:00.00 getty
5685 root 16 0 1548 472 408 S 0.0 0.1 0:00.00 getty
5686 root 16 0 1548 472 408 S 0.0 0.1 0:00.00 getty
5769 root 16 0 6220 1916 1580 S 0.0 0.2 0:00.00 sshd
5771 snet 16 0 6352 2012 1628 S 0.0 0.2 0:00.25 sshd
5772 snet 15 0 3960 1740 1248 S 0.0 0.2 0:00.01 bash
5840 root 15 0 2684 1548 1180 S 0.0 0.2 0:00.08 bash
5861 root 15 0 1644 596 504 S 0.0 0.1 0:00.01 wrapper
5921 root 23 0 2364 1080 880 S 0.0 0.1 0:00.00 sh
5925 root 17 0 268m 263m 2672 S 0.0 29.7 0:00.15 mysqld
5926 root 16 0 268m 263m 2672 S 0.0 29.7 0:00.00 mysqld
5927 root 20 0 268m 263m 2672 S 0.0 29.7 0:00.00 mysqld
5928 root 16 0 268m 263m 2672 S 0.0 29.7 0:00.00 mysqld
5929 root 15 0 268m 263m 2672 S 0.0 29.7 0:00.33 mysqld
5930 root 16 0 268m 263m 2672 S 0.0 29.7 0:00.36 mysqld
5933 root 16 0 268m 263m 2672 S 0.0 29.7 0:00.00 mysqld
5934 root 16 0 268m 263m 2672 S 0.0 29.7 0:00.02 mysqld
5935 root 16 0 268m 263m 2672 S 0.0 29.7 0:00.63 mysqld
5936 root 16 0 268m 263m 2672 S 0.0 29.7 0:00.00 mysqld
5978 root 15 0 268m 263m 2672 S 0.0 29.7 0:00.02 mysqld
6160 root 16 0 2080 1036 820 R 0.0 0.1 0:00.23 top
6165 root 15 0 0 0 0 S 0.0 0.0 0:00.00 pdflush
6166 root 15 0 0 0 0 S 0.0 0.0 0:00.00 pdflush
regards
I'm facing some performance issues and when i execute top or ps-ef , i see multiple mysqld instance but only one is working. I want to increase the amount of memory for the java process. A Good idea ?
Tasks: 59 total, 1 running, 58 sleeping, 0 stopped, 0 zombie
Cpu(s): 50.0% us, 8.3% sy, 0.0% ni, 0.0% id, 40.7% wa, 1.0% hi, 0.0% si
Mem: 906660k total, 901380k used, 5280k free, 2428k buffers
Swap: 1502036k total, 2812k used, 1499224k free, 471580k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5862 root 19 0 501m 146m 19m S 28.0 16.6 9:21.89 java
5940 root 15 0 268m 263m 2672 D 17.8 29.7 5:46.09 mysqld
5942 root 15 0 268m 263m 2672 D 12.2 29.7 0:05.71 mysqld
1 root 16 0 1552 508 444 S 0.0 0.1 0:00.46 init
2 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
3 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/0
4 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 khelper
22 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 kacpid
115 root 5 -10 0 0 0 S 0.0 0.0 0:00.17 kblockd/0
158 root 14 -10 0 0 0 S 0.0 0.0 0:00.00 aio/0
157 root 15 0 0 0 0 S 0.0 0.0 0:00.31 kswapd0
745 root 15 0 0 0 0 S 0.0 0.0 0:00.00 kseriod
1115 root 15 0 0 0 0 D 0.0 0.0 0:00.72 kjournald
1140 root 7 -10 1532 364 288 S 0.0 0.0 0:00.01 udevd
1583 root 15 0 0 0 0 S 0.0 0.0 0:00.00 khpsbpkt
3090 root 23 0 0 0 0 S 0.0 0.0 0:00.00 shpchpd_event
3338 root 15 0 0 0 0 S 0.0 0.0 0:00.00 khubd
4675 root 25 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
4676 root 15 0 0 0 0 S 0.0 0.0 0:00.00 ahd_dv_0
4684 root 19 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
4685 root 15 0 0 0 0 S 0.0 0.0 0:00.00 ahd_dv_1
4894 root 15 0 0 0 0 S 0.0 0.0 0:00.00 knodemgrd_0
5347 syslog 16 0 1740 716 596 S 0.0 0.1 0:00.01 syslogd
5416 root 16 0 1552 380 316 S 0.0 0.0 0:00.01 dd
5418 klog 16 0 2432 1468 436 S 0.0 0.2 0:00.06 klogd
5450 root 20 0 1580 528 460 S 0.0 0.1 0:00.00 inetd
5596 root 16 0 2992 1144 964 S 0.0 0.1 0:00.00 master
5606 postfix 16 0 3000 1068 900 S 0.0 0.1 0:00.00 pickup
5607 postfix 16 0 3032 1100 920 S 0.0 0.1 0:00.00 qmgr
5613 root 16 0 3476 1504 1252 S 0.0 0.2 0:00.00 sshd
5628 ntp 16 0 3148 3148 2504 S 0.0 0.3 0:00.01 ntpd
5643 daemon 19 0 1728 608 524 S 0.0 0.1 0:00.00 atd
5654 root 16 0 1784 816 676 S 0.0 0.1 0:00.00 cron
5679 root 16 0 1548 472 408 S 0.0 0.1 0:00.00 getty
5682 root 16 0 1548 472 408 S 0.0 0.1 0:00.00 getty
5683 root 16 0 1548 472 408 S 0.0 0.1 0:00.00 getty
5684 root 16 0 1548 472 408 S 0.0 0.1 0:00.00 getty
5685 root 16 0 1548 472 408 S 0.0 0.1 0:00.00 getty
5686 root 16 0 1548 472 408 S 0.0 0.1 0:00.00 getty
5769 root 16 0 6220 1916 1580 S 0.0 0.2 0:00.00 sshd
5771 snet 16 0 6352 2012 1628 S 0.0 0.2 0:00.25 sshd
5772 snet 15 0 3960 1740 1248 S 0.0 0.2 0:00.01 bash
5840 root 15 0 2684 1548 1180 S 0.0 0.2 0:00.08 bash
5861 root 15 0 1644 596 504 S 0.0 0.1 0:00.01 wrapper
5921 root 23 0 2364 1080 880 S 0.0 0.1 0:00.00 sh
5925 root 17 0 268m 263m 2672 S 0.0 29.7 0:00.15 mysqld
5926 root 16 0 268m 263m 2672 S 0.0 29.7 0:00.00 mysqld
5927 root 20 0 268m 263m 2672 S 0.0 29.7 0:00.00 mysqld
5928 root 16 0 268m 263m 2672 S 0.0 29.7 0:00.00 mysqld
5929 root 15 0 268m 263m 2672 S 0.0 29.7 0:00.33 mysqld
5930 root 16 0 268m 263m 2672 S 0.0 29.7 0:00.36 mysqld
5933 root 16 0 268m 263m 2672 S 0.0 29.7 0:00.00 mysqld
5934 root 16 0 268m 263m 2672 S 0.0 29.7 0:00.02 mysqld
5935 root 16 0 268m 263m 2672 S 0.0 29.7 0:00.63 mysqld
5936 root 16 0 268m 263m 2672 S 0.0 29.7 0:00.00 mysqld
5978 root 15 0 268m 263m 2672 S 0.0 29.7 0:00.02 mysqld
6160 root 16 0 2080 1036 820 R 0.0 0.1 0:00.23 top
6165 root 15 0 0 0 0 S 0.0 0.0 0:00.00 pdflush
6166 root 15 0 0 0 0 S 0.0 0.0 0:00.00 pdflush
regards