Database Administrator

Common InnoDB Parameter Parsing Common InnoDB Parameter Parsing 1. Files (data files and log files) 1. related parameters: Innodb_data_home_dir Innodb_data_file_path = file_name: file_size [: autoextend [: max: max_file_size] Note: A. The value of

Use Python to send MySQL slow log emails Requirement 1Because development performs Stability Construction for a system, it is necessary to audit the slow logs of the database system and check and optimize the system. Communicate with developers by

Space occupied by Oracle computing tables In Oracle databases, how does one calculate the storage space occupied by a table? You can view the space occupied by a table in the System View DBA_SEGMENTS, USER_SEGMETNS, and DBA_TABLES, as shown

EXP-00091: Exporting questionable statistics troubleshooting When using EXP tool to export backup or migrate data, sometimes a lot of "EXP-00091: Exporting questionable statistics" error will be reported, the specific phenomenon and solution please

How to view the innodb version in MySQL How to view the innodb version in MySQL SELECT * FROM information_schema.plugins \ G The innodb version of mysql 5.6.3-m6 is 1.2.3. View the version method to see the major version SELECT * FROM

ORA-01219 database not opened Today after the connection data, a look at the prompt that the ORA-01219 database is not open, closed the service re-opened is still like this, in the Baidu found the problem. I deleted a data file and looked at the

Summary of basic mysql usage and mysql usage1. Download and install Download from the official website: Http://www.mysql.com/ Note that you need an Oracle account to download it. 2. Start mysql Run the following command to install mysql: Set it

My MYSQL Study Notes (4) -- functions and mysql Study Notes Functions Numeric Functions 1. Evaluate the remainder function MOD (X, Y) MOD (X, Y) returns the remainder of x after division by y. MOD () also applies to values with decimals. It returns

Understanding the storage structure 2, understanding the Storage Structure Next http://blog.csdn.net/ashic/article/details/44117867In the previous article, we dumped L1 L2 L3 blocks. Now let's take a look at the information they contain.

[Oracle] Sequence object usage, oraclesequence object**************************************** ********************************* *** Original article: blog.csdn.net/clark_xu Xu changliang's column**************************************** **************

Oracle deletes users and tablespaces, and oracle deletes1. view the tablespace and its name.SQL> SELECT FILE_NAME, TABLESPACE_NAME FROM dba_data_files;2. query the user and the corresponding tablespaceSQL> select username, default_tablespace from

MySQL architecture and various file types learning summary, mysql Architecture1. mysql Architecture Composed of databases and database instances, it is a single-site multi-thread architecture. Database: a collection of physical operating system

The Oracle Instant Client facilitates the use of the PLSQL Developer method, plsqldeveloperBackground: Oracle-32bit clients are not installed in 64-bit operating systems for ease of use of PLSQL Developer (64bit Oracle clients not supported) 1.

SQL statement fuzzy query review and tips: SQL statement fuzzy query General Fuzzy statements are as follows: SELECT field FROM table WHERE a field Like Condition SQL provides four matching modes for conditions:1.%: Represents any 0

Mysql views database objects (Summary of SQL commands) and Mysql SQLView database objects in Mysql (Summary of SQL commands)The data objects include tables, views, triggers, and so on. (To View statistics, you must enter the information_schema

Temporary tables, external tables, and partition tables in Oracle, Temporary tables, external tables, and partition tables in OracleTemporary table In Oracle, a temporary table is "static". It only needs to be created once like a common data table.

How to solve the case-sensitivity problem when comparing SQLite strings. sqlite strings are case-insensitive. Most databases are case insensitive when comparing strings. However, when we recently used SQLite, we found that the opposite is

Windows platform listeners cannot start reporting TNS-12560 TNS-00530, tns-12560tns-00530Windows platform listeners cannot start reporting TNS-12560 TNS-00530Symptom -- 01: C: \ Users \ Administrator> lsnrctl startLSNRCTL for 64-bit Windows: Version

Oracle sets auto-start upon startup, oracle starts upon startup By default, Oracle databases in Linux do not start on their own, but many times we need to start the Database on their own, so we need to set the settings as follows: System

Case study of incomplete log records of RAC split-brain due to not configured diagwait, diagwaitrac1. Fault A rac with the CRS version 10.2.0.4. After the server goes DOWN at the second node, the server goes DOWN at the first node.2. CRS log