|
|
|
|
|||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
memory usage
Hi All,
I have setup slave db. The machine configuration details of this slave is same as master. S=redhat 8 cpu 16GB RAM key_buffer_size=3000M But when i do top, in the master db Cpu(s): 0.5%us, 0.3%sy, 0.0%ni, 87.2%id, 11.9%wa, 0.0%hi, 0.1%si, 0.0%st Mem: 16436956k total, 16350252k used, 86704k free, 9188k buffers Swap: 16386292k total, 37232k used, 16349060k free, 2358944k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ CMMAND 28706 mysql 15 0 14.3g 13g 4688 S 6 84.1 540:21.55 mysqld slave db Cpu(s): 0.7%us, 0.2%sy, 0.0%ni, 87.3%id, 11.8%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 16436956k total, 16351536k used, 85420k free, 16400k buffers Swap: 16386292k total, 164k used, 16386128k free, 4289520k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ CMMAND 14042 mysql 18 0 14.0g 11g 4652 S 7 72.5 265:08.62 mysqld 435 root 10 -5 0 0 0 S 0 0.0 3:29.07 kswapd0 As you can see the RES in master is 13g, but on slave its 11G any specific reason for this. This is causing some of the sql's on the slave to be slower than master for the same select statement on both master and slave. regards anandkl |
![]() |
| Viewing: Web Development Archives > Mailing Lists > MYSQL > memory usage |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|