Database Administrator

Solve the Problem of MySQL Chinese garbled characters In the case of MySQL Chinese garbled characters, first use the status command to check the database configuration, as shown below: The information about the database configuration is

PostgreSQL Select Source Code Analysis This time sequence diagram is relatively large, but it roughly describes the general process for PostgreSQL to process simple SQL statements. The client initiates an SQL statement. After receiving the Statement

Oracle 11g creates the second instance on Linux The Linux server host is not enough, and the tester needs a new Oracle environment for testing. Therefore, the tester is prepared to create a second instance on the existing Oracle Linux host. This

Create split and splitstr functions in Oracle It is recommended that SQL statements be created in sequence. /*************************************** Name: split* Author: sean zhang.* Date: 2012-09-03.* Function: returns the table type after a string

Oracle stored procedures and Java calls I found many bugs for the first time, so I paid a lot of attention. It took me three days to get rid of all the bugs. I will list all the points of attention, and there may be drops, please correct and discuss

Clear the WRH $ _ LATCH_CHILDREN table of the sysaux tablespace On Saturday, the system was suddenly woken up by text messages. 63 messages appeared, all of which were monitored. The tablespace size exceeds a warning value. It is found that the

Brief description of Oracle physical storage structure The database is actually composed of a pile of physical files, mainly including four:1. control files)2. Data files (Date files)3. redolog)1. Control File The control file is the root file of

The problem that the UUID cannot be returned when rac asm udev is installed on the VM Use UDEV service to solve the rac asm storage device name1. Confirm that necessary UDEV packages have been installed on all RAC nodes. [Root @ rh2 ~] # Rpm-qa |

SQL query beginner's Guide Reading Notes (I) Introduction to relational databases and SQL, beginner's Guide Reading Notes Part I: Relational Databases and SQL Chapter2, Ensuring Your Database Structure IsSound. Database Design Guidelines   What is

Mysql allows remote login configuration, mysql allows remote login Two steps: 1. Change the "host" in the "user" table in the "mysql" Database (you can log on remotely after this step) X: \> mysql-u root-pvmwareMysql> use

Features of mysql Data Table engine InnoDB and MyISAM, innodbmyisam1. MyISAM Table Engine Features (1) MyISAM is the default storage engine of MySQL. (2) Most tools with table checking and repair. (3) tables can be compressed. (4) full-text search

There are many Database Data Optimization stories and Database Data Optimization stories Base call evaluation system interface, we can see that the IIS process remains high when running the program. So I tried several methods to optimize the

Synchronization practices between Mysql and Redis and mysqlredisI. testing environment in Ubuntu kylin 14.04 64bit You have installed Mysql, Redis, php, lib_mysqludf_json.so, and Gearman.Click here to view the test database and Table referenceSome

Awk skills, diagram of reversing warehouse receiving skills Awk uses spaces and tabs by default. If you want to specify a TAB, you can use awk-F' \ t'. If you want to specify multiple tabs as one, you can use awk-F' \ t + '************************ 1.

Extended SQL flexibility-static T_ SQL, dynamic SQL, and sqlt_ SQL In fact, I think this blog is best written in web-based application development, because at present we seldom implement the sorting and filtering functions on the client side, and

Mysql installation/registration/download, mysql Registration 1. copy the file to disk D and Directory 2. Set profile properties "D: \ mysql-5.6.24-winx64/my-default.ini" basedir = "D: \ mysql-5.6.24-winx64/" datadir = "D: \

Install Oracle instant client and configure PL/SQL Developer, instantdeveloper1. Download the Oracle client : Http://www.oracle.com/technetwork/topics/winsoft-085727.html Latest Version Version 12.1.0.2.0 Select the first Instant Client for

MySQL query optimization and MySQL OptimizationThere are many things to optimize database queries. The following is a summary:Basic Principles: Reduces disk I/O count during Database Query Rational use of Indexes Avoid full table

PL/SQL and SQLPLUS query results are different-Never forget commit !, Sqlpluscommit For the same SQL statement, the query results in PLSQL and SQLPLUS are different. Have you ever seen them? Today, we executed a query select * from t_user in the

Reflection on Ctrip event: it is time to pay attention to database disaster recovery! Last week, a major news in the internet technology circle was the paralysis of a tourism portal website. It is said that this situation was caused by the physical