Hi All, I have setup slave db. The machine configuration details of this slave is same as master.
OS=redhat 8 cpu 16GB RAM key_buffer_size=3000M innodb_buffer_pool_size=10000M. 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+ COMMAND 28706 mysql 15 0 14.3g 13g 4688 S 6 84.1 540:21.55 mysqld On 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+ COMMAND 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