NAV: SLTechnology News&Howtos > Database >

• 

  Oracle database 12cR2 (part two of the project): Linux system installation Oracle12.2

  Oracle database 12cR2 (project practice II): linux system installation Oracle 12.2, course topic: Fengge Oracle database tutorial 12cR2 (project practice II): install Oracle12.2 in the linux operating system. two

  2022-06-01 21:13:52 Views: 270
• 

  The solution of Galera Cluster crater

  Some students will find some pits after using Galera Cluster, such as: 1) the large table DDL operation will make the whole cluster unavailable. No transactions can be written to the cluster until the DDL operation is completed, making the service unavailable. Solution: use pt-onlin directly

  2022-06-01 21:13:52 Views: 222
• 

  MySQL-Master-Slave synchronization delay

  1. Principle of master-slave synchronization delay in MySQL database? 2. How is the master-slave synchronization delay in MySQL database generated? 3. MySQL database master-slave synchronization delay solution? -

  2022-06-01 21:13:51 Views: 230
• 

  MySql Learning Notes (8): extra of explain

  There are mainly cases of extra: Using index, Using filesort, Using temporary, Using whereUsing where, needless to say, use the where filter. Number

  2022-06-01 21:13:51 Views: 280
• 

  How to query user permissions in oracle

  The types of data dictionary views are: USER,ALL and DBA.USER_*: about the object information owned by the user, that is, the object information created by the user, the information about the object that the user can access, that is, the information of the object created by the user plus other users.

  2022-06-01 21:13:51 Views: 259
• 

  Instructions for using AMM

  The introduction of AMM by oracle 11g certainly makes sense, but the production environment recommends that AMM be disabled. Automatic memory management (AMM): automatic memory management target automatic memory management 0, if LOCK_SGA = true, disable

  2022-06-01 21:13:50 Views: 249
• 

  Disasters caused by Undo tablespaces

  I have built three sets of oracle clusters in the company. According to my colleagues, cluster 3's undo table space is always full and resources are not released. Because of business problems, there can be no downtime. Then he kept building new undo tablespaces all the way to undotbs6, which was originally two by default.

  2022-06-01 21:13:44 Views: 209
• 

  Six tricks up your sleeve for the use of MySQL DBA essential tools

  Lao Zhang, I am not only a fan of Jin Yong, but also a fan of the three Kingdoms. Just like to watch the battle of wits between Zhuge Liang of Shu and Ma Yi of Wei Guoshi in the later period. The use of all kinds of tricks can be called a classic. For the management of MySQL database, Mr. Zhang also has a lot of brilliant ideas, which will be introduced to you one by one in the future. Back to the three Kingdoms

  2022-06-01 21:13:44 Views: 279
• 

  MySQL transaction autocommit autocommit

  The default operation mode of MySQL transaction autocommit autocommit MySQL is autocommit autocommit mode. This means that each query is automatically executed as a separate transaction unless a transaction is explicitly started. We can set up aut

  2022-06-01 21:13:43 Views: 251
• 

  50 suggestions for MongoDB developers Tip24

  This series of articles are translated from "50 Tips and Tricks for MongoDB Developers". I can't find the Chinese version for the time being. Anyway, I have been studying mongodb deeply recently, so I just want to translate it. On the one hand, strengthen yourself.

  2022-06-01 21:13:43 Views: 277
• 

  The Learning Road of Mysql DBA Advanced Operation and maintenance-preliminary incremental recovery of mysql Database

  1. Open the mysql log (1) configure the my.cnf configuration file first open the log-bin parameter in the my.cnf configuration file, and set log-bin to mysqlbin_linzhongniao, so as to update in the mysql database

  2022-06-01 21:13:43 Views: 246
• 

  DB2 performance optimization-- how to create tablespaces

  The conceptual database of tablespaces consists of components called tablespaces. Tablespaces are the locations where tables are stored. When you create a table, you can decide to store data for specific objects, such as indexes and large objects, separately from the rest of the table data. Tablespaces can also be distributed over one or more physical storage devices. We are the master of this section.

  2022-06-01 21:13:40 Views: 258
• 

  Initialization of mysql database prompt missing Data:dumper module solution

  The following error occurred while initializing the mysql database due to the missing Data:dumper module [root@bogon mysql] #. / scripts/mysql_install_db-- user=mysqlFATA

  2022-06-01 21:13:39 Views: 262
• 

  MariaDB 10.3 master-slave semi-synchronous replication

  This article introduces MariaDB master-slave semi-synchronous replication, and introduces the master-slave semi-synchronous replication configuration based on the previous article "MariaDB 10.3 master-slave replication". 1. Introduction MariaDB has added a semi-synchronous plug-in to Server since 10.3.3, so

  2022-06-01 21:13:18 Views: 262
• 

  How to optimize MySQL database better

  1. Selecting the most suitable field property MySQL can well support access to a large amount of data, but in general, the smaller the table in the database, the faster the query will be executed on it, so when creating the table, in order to achieve better performance, we can set the width of the fields in the table as wide as possible.

  2022-06-01 21:13:10 Views: 276
• 

  MySQL Text types are not omnipotent

  The maximum length of the three text types of MySQL is as follows: TEXT 65535 bytes ~ 64kbMEDIUMTEXT 16777215 bytes ~ 16MbLONGTEXT 4294967295

  2022-06-01 21:13:09 Views: 263
• 

  Mysql basic Syntax 1

  Software architecture of MySQL 1. Enable MySQL server: open it as windows service, net startmysql under cmd | net stop mysql, and use mysqld-default-fil under cmd.

  2022-06-01 21:13:09 Views: 293
• 

  Linux Uninstall mysql,apache,php

  Uninstall Mysql1 and find out whether the mysql command was previously installed: rpm-qa | grep-I mysql can see the package of mysql: mysql-3.23.58-9php-mysql-4.3.4-11 modulated auth_

  2022-06-01 21:13:09 Views: 218
• 

  The mall system backs up the MySQL database regularly in the linux system and deletes the backup files from seven days ago.

  Database is an important part of mall software, and timing tasks can periodically automatically execute the necessary business logic of the program. Take the daily store settlement business logic of DSMall open source mall system as an example:! / bin/bashName:bakmysql.shThis

  2022-06-01 21:13:09 Views: 272
• 

  Access the remote mysql database locally under linux or mac (remote access is not enabled by the database itself)

  1. Using ssh forward, forward port 3306 of the remote server to the native ssh-nNT-L 3306:localhost:3306 user@remote_db_server. Be careful not to shut down the native ter.

  2022-06-01 21:13:08 Views: 256