mayhems1/drafts_mysql.md

## drafts_mysql.md

      
    Raw
  

              drafts_mysql.md
            
          
    MySQL

Check version

mysql -V
SHOW VARIABLES LIKE "%version%";
Create database

CREATE DATABASE `mydatabase` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Check connections

show status where variable_name = 'threads_connected';
show processlist;

select id,user,host,db,command,time,state,info from information_schema.processlist;

The General Query Log

SET GLOBAL general_log = 'OFF';
SET GLOBAL general_log = 'ON';
Links

https://dba.stackexchange.com/questions/76788/create-a-mysql-database-with-charset-utf-8
https://dev.mysql.com/doc/refman/5.7/en/log-destinations.html

  
## drafts_mysql_slave_to_master.md

      
    Raw
  

              drafts_mysql_slave_to_master.md
            
          
    MySQL slave to master

Recipe to promote a slave to a master for simple replication.

On Master:
FLUSH LOGS;
On Slave:
STOP SLAVE;
RESET MASTER;
Optional: CHANGE MASTER TO MASTER_HOST='';
Links

https://blog.pythian.com/mysql-recipes-promoting-a-slave-to-master-or-changing-masters/