Talk Lowy(jp)

  Management Connect from shell mysql -u root -h giipdb.mysql.com -p -P 3306 -u  : user -p  : ask password -h  : host -P  : Port show running SQL show processlist; show full processlist \G Cursor https://codeday.me/jp/qa/20190213/271235.html  - jp Binlog(Binary Log) https://www.ritolab.com/entry/98 managing binary log https://www.percona.com/blog/2015/07/30/why-base64-outputdecode-rows-does-not-print-row-events-in-mysql-binary-logs/ Decode binary log Start option Official :  https://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html stop mysqladmin -u root -p shutdown Run from sql file Official :  https://dev.mysql.com/doc/refman/8.0/en/mysql-batch-commands.html Tuning Innodb Check tuning point using mysqltuner You can tune easy by suggestion on mysqltuner $ wget https://github.com/major/MySQLTuner-perl/zipball/master $ unzip master $ cd master $ ./mysqltuner.pl https://corporate.inter-edu.com/developper/1373 innodb storage engine https://enterprisezine.jp/dbonline/detail/3829

Product detail Product by edition and additional products(jp) https://docs.oracle.com/cd/E16338_01/license.112/b56284/editions.htm#CJACGHEB Management Start and stop Starting Oracle service Switching Oracle Account root@localhost#>su - oracle execute sqlplus oracle@localhost$>sqlplus / as sysdba start oracle instance SQL>startup exit from sqlplus SQL>quit startup listener oracle@localhost$>lsnrctl start referral docs kr :  https://mkil.tistory.com/336 Stop oracle service su - oracle change oracle account emctl stop dbconsole Stop oracle enterprise manager lsnrctl stop Stop listener sqlplus / as sysdba Login sqlplus shutdown immediate shutdown oracle process when waiting exist connection shutdown abort shutdown oracle process aborting all connection use when take too long time on  shutdown immediate  command Delete log files Listner log delete $ adrci adrci > show homepath adrci > show control adrci > purge -age 50000 -type alert -aget 50000 : 50000min. when p