Database Administrator

Mysql master-slave configuration parameters and stepsMaster-slave configuration steps:Create the database to be synchronized in the master database, create the account of the master database, and modify the configuration of the master and slave

Mysql master-slave switchover steps 1> normal switchover 1) Check the output of the show processlist statement from the server until you see Has read all relaylogwaiting for the slave I/O thread to update it 2) Make sure that the slave server has

[Mysql] Mysql database processes Chinese characters transmitted in Servlet, mysqlservlet The default encoding of many Mysql instances is latin1. If Mysql does not change the encoding during installation, it cannot be entered into Chinese directly

Specific operation commands for adding and deleting new users in mysql, and specific operations in mysqlMethod 1: Use the mysql root (root permission) user to log on and directly grant permissions to users. You can also create

TNS-01251: Cannot set trace/log directory under ADR, tns-01251adr 11204 RAC environment error TNS-01251: Cannot set trace/log directory under ADR   LSNRCTL> set current_listener listenerCurrent Listener is listenerLSNRCTL> set current_listener

Imp import and exp export, Imp Import and Export exp Import as needed (log files must be added ):C: \ Users \ Administrator> exp scott/scott @ orcl11g file = 'd:/temp/1. dmp 'Log = 'd:/temp/log. Log' Note: The data of the current user is exported.

Set, setup SQL> set echo on ----------------- set whether to display the statement when running the command SQL> set feedback on ---------------- set to show "XX rows selected" SQL> set colsep | ----------------- sets the delimiter between a column

SQL Performance, SQL Performance Analysis Tool --- ExecutingSelect a. username, a. sid, B. SQL _TEXT, B. SQL _FULLTEXTFrom v $ session a, v $ sqlarea BWhere a. SQL _address = B. address --- ExecutedSelect B. SQL _TEXT, B. FIRST_LOAD_TIME, B. SQL

Oracle Installation, oracle Installation Diagram# Oracle EnvironmentExport ORACLE_BASE =/opt/oracleExport ORACLE_HOME =/opt/oracle/product/11gR2/dbExport ORACLE_SID = ora8Export ORACLE_TERM = xtermLD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib: $

Two-step commit of the MongoDB operation manual CRUD transaction, mongodbcrudPerform Two-Step submissionOverview This section provides a multi-record update or multi-record transaction template that uses two-step commit to complete multi-record

MySQL trigger for each row, mysqltriggerFor each, each row is affected and all triggers are executed, which is called a row-Level Trigger. In oracle triggers, row-level triggers and statement-level triggers can be executed only once regardless of

Oracle cannot import the empty table solution. oracle Solution Oracle cannot import empty tables C: \ Users \ Administrator> sqlplus/as sysdba SQL * Plus: Release 11.2.0.1.0 Production on Sunday August 17 19:24:29 2014 Copyright (c) 1982,201 0,

Mysql installation on linux 3 (Binary installation), mysqllinuxInstall the Binary source package:1. Download the binary Mysql installation package from the http://www.mysql.com // This MYSQL is a binary version, do not compile2. Change

Power-BI helps kangdi create a first-class hotel chain, and power-bi kangdi creates   Company Profile Kangdi is committed to becoming a well-known hotel management company in China and is constantly moving towards international management. Currently,

SQL exists, in, sqlexistsinTips:1. When the External table is a large table and the inner table is a small table, use exist2. When the External table is a small table and the internal table is a large table, the inExample: The External table is

Sets the MySQL transaction isolation level and mysql transaction level.Select @ tx_isolation; // view isolation levelSet transaction isolation level read uncommitted; // you can specify the read uncommitted level.Start transaction; // open the

The alert log shows the Private Strand Flush Not Complete processing method, strandflushAlert. log also reports the following error in the database of the customer in Nanjing:Fri Oct 17 19:59:51 2014 Thread 1 cannot allocate new log, sequence 4722

Collect oracle statistics and oracle statistics Manual refreshing of ORACLE statisticsSelect count (1) from LOG_TRX_DETAIL;Select * from user_tab_statistics where table_name = 'Log _ TRX_DETAIL ';Exec dbms_stats.gather_table_stats ('ardb', 'acct _

Redis source code analysis (17) --- multi transaction operation, redismulti As a non-relational database, redis has the same transaction operations with RDBMS, which surprised me. A dedicated file in redis is used to perform transaction-related

Mysql automatic backup and Mysql backupMysql automatic backup batch processing command: Set "Ymd = % date :~, 4% % date :~ 5, 2% % date :~ 8, 2%" Set "hMs = % time :~, 2% % time :~ 3,2% % time :~ 6, 2%" Mysqldump-uroot -- password = password weixin>