NAV: SLTechnology News&Howtos > Database >

• 

  Oracle11g listener log listener.log file is too large

  The snooping log and warning log of oracle 11g are in the / opt/oracle/app/diag/tnslsnr/ machine name / listener directory where the warning log is in the alert directory and the snooping log is in the trace directory. List

  2022-06-01 09:18:12 Views: 216
• 

  Oracle12c DB character set ZHS16GBK changed to AL32UTF8

  First, check the character set SQL > select * from vicious version Banner.

  2022-06-01 09:18:11 Views: 214
• 

  Mysql cross connect

  # Cross-connect: the Cartesian product of sql99 syntax SELECT b.coach journal bo.coach from beauty bCROSS JOIN boys bo

  2022-06-01 09:18:09 Views: 297
• 

  PostgreSql Master-Slave replication of Asynchronous flow based on Standby

  First, an overview of PostgreSQl has introduced a log delivery similar to Oracle's active dataguard and MySql relay logs after version 9.0. With the help of this function, we can realize the master-slave replication of PostgreSql. Basic

  2022-06-01 09:18:09 Views: 232
• 

  XtraBackup backup restore MySQL 5.6database

  Download XtraBackup:# wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.6/binary/tar

  2022-06-01 09:17:39 Views: 268
• 

  Centos7.2 compilation and installation of mysql5.5.32

  Red Hat 7 and above the default database is no longer mysql, rpm and yum are installed in mariadb, but it is not impossible to install mysql, you can use compiler installation to install mysql. Lab environment: centos7.2 lab objective: install and configure

  2022-06-01 09:17:39 Views: 229
• 

  Cascade replication is transformed into one master and two slaves

  1. As shown in the picture, if cascaded replication is converted to one master and two slaves? GTID replication processing method: just stop the replication of S2, and then re-change to M; S2:stop slave;reset slave all;change maste

  2022-06-01 09:17:34 Views: 281
• 

  SQL server database materials

  SQL server database is not widely used in China, except for the government and large state-owned and foreign enterprises, so it has not been studied in depth. Here are some simple reference materials for follow-up reference: SQL server common management and maintenance commands: https://blog.

  2022-06-01 09:17:34 Views: 257
• 

  Sample mysql configuration file

  [client] port=3306socket=/data/mysqldata/ mysql.sock[mysql] socket=/data/mysqldata/mysql.sockport=3306n

  2022-06-01 09:17:34 Views: 289
• 

  MYSQL database-aliases that define tables and fields

  Define aliases for tables and fields when querying, you can give tables and fields an alias that replaces their specified tables and fields. Aliasing fields and tables makes the query more convenient. And the query results can be displayed in a more reasonable way. Alias the table when the name of the table is very long.

  2022-06-01 09:17:25 Views: 224
• 

  MYSQL Master / Slave Library Construction (original)

  MYSQL Master-Slave Library Construction (original) 1. Single master library configuration 1.1 environment description this section describes the environment for a master library, two slave libraries, the specific environment is as follows. 1.1.1Linux versionRed Hat Enterprise Linux Ser

  2022-06-01 09:17:25 Views: 205
• 

  The use of stored procedures and triggers in mysql and the calling methods in php

  As its name implies, a stored procedure is equivalent to a set of sql statements that are compiled and stored in the database in order to complete a specific function. The user executes it by specifying the name of the stored procedure and giving parameters (if the stored procedure has parameters). Stored procedure is an important object in the database, any

  2022-06-01 09:17:13 Views: 298
• 

  Solutions that SQL Server does not allow you to save changes

  When designing a SQL Server database, there are times when saving changes is not allowed. This is because it is enabled to prevent saving changes that require the table to be recreated, which is a protection mechanism for SQL Server. 1 when modifying the structure and data type of the table, the error prompt 2 clicks on

  2022-06-01 09:17:13 Views: 249
• 

  An example of MySQL subpartition

  This is a real-world example, but I do not recommend using MySQL partition to produce CREATE TABLE `tlog` (`ID`int (11) NOT NULL AUTO_INCREMENT COMMENT')

  2022-06-01 09:17:13 Views: 237
• 

  Query of MongoDB

  MongoDB uses find to query and does not specify any parameters to indicate that it is a document query for the entire collection. The find query specifies that the returned key sometimes does not need to return all the key-value pairs in the document, and the desired key can be specified through the second parameter of find (or findOne)

  2022-06-01 09:17:13 Views: 201
• 

  ORACLE authorization

  Mainly use keywords: grantgrant create table to test;// authorization to build tables to test users grant unlimited tablespace to test;// to authorize the use of tablespaces to t

  2022-06-01 09:17:12 Views: 236
• 

  The use of sql turning advise

  Sql turning advise (sta) SQL optimizer SQL Tuning Advisor (STA) is oracle's sql optimization subsidy tool. In fact, there are two main ways to optimize sql: one is to rewrite sql itself, rewrite

  2022-06-01 09:17:12 Views: 223
• 

  Mysql upgrade and downgrade

  1 two officially recommended upgrade methods: before in-place upgradelogical upgrade2 upgrade: back up all databases, including the system library mysql [root@Darren1 ~] # mysqldump-u

  2022-06-01 09:16:43 Views: 278
• 

  There is no court infighting, the strategy of extending the jubilee in the database world.

  Brothers, have you ever thought about Lao Zhang? recently, Lao Zhang's talent has been limited by the busyness of his work, so there has been no time for more blogging. Today, we finally meet again a few days later (very happy)! Recently, there is a very popular court play. I don't know if you have seen it. It is called "Yanxi Strategy", which tells the story.

  2022-06-01 09:16:43 Views: 212
• 

  Build LAMP by Centos6.5

  1. First install apache (for specific documents, please contact this blogger, there is a blogger's email address on the home page) 2. Set up the system to let Apache boot automatically. 3. Firewall Settings 4.vi / etc/sysconfig/iptables add iptables

  2022-06-01 09:16:42 Views: 244