Stopping MySQL database server

Here is the instructions in case MYSQL needs to be shutdown or restarted:

1. Check 'innodb_max_dirty_pages_pct' global variable value.
   
   

   mysql> show global variables like 'innodb_max_dirty_pages_pct%'; +----------------------------+-------+ | Variable_name              | Value | +----------------------------+-------+ | innodb_max_dirty_pages_pct | 90    | +----------------------------+-------+ 1 row in set (0.00 sec)

2. Set global 'innodb_max_dirty_pages_pct' value to 0.
   
   

   mysql> set global innodb_max_dirty_pages_pct = 0;

3. Check if 'innodb_max_dirty_pages_pct' value dropping from 90 to 0.
   
   

   $ mysqladmin ext -i10 | grep dirty

4. Proceed with normal MYSQL service restart if 'innodb_max_dirty_pages_pct' value is zero.
   
   

   /etc/init.d/mysql stop

• Twitter
• Facebook
• Google
• Tumblr
• Pinterest