Category: Tunning

Check app used memory

Posted by in Linux, Monitoring, Tunning

Spesific, check java app: ps aux|grep java | grep -v grep | awk ‘{app+=$6} END {printf”%.1f MB”,app/1024}’ global OS : ps aux| awk ‘{app+=$6} END {printf”%.1f MB”,app/1024}’

CPU High Performance, INNODB Mysql

Posted by in Databases, Tunning

I learned something amazing about MySQL. If you allocate a single monolithic InnoDB Buffer Pool that is bigger that Total Installed Divided By Number of Physical CPUs, your will incite the OS to regular intervals memory swapping due to a full InnoDB Buffer Pool. MySQL 5.5’s option known as innodb_buffer_pool_instances can be used to split…

unauthenticated user on MYSQL

Posted by in Databases, Fixing, Tunning

Most often stuck connections are due to DNS not resolving properly, which the skip-name-resolve option will help with. Skipping with my.cnf option skip-name-resolve restart mysql

Visit Us On TwitterVisit Us On GooglePlusVisit Us On Linkedin

Hi, guest!