NAV: SLTechnology News&Howtos > Database >

• 

  Solution to excessive temporary tablespace

  There are two ways to solve the problem of excessive temporary tablespace. One is to increase the size of temporary tablespace, the other is to reconstruct temporary tablespace to solve the problem of excessive temporary tablespace. Option 1: increase the size of the temporary tablespace-1. Usage of temporary tablespaces SELECT D

  2022-06-01 14:29:03 Views: 266
• 

  Backup and restore of SQL server Database

  There are three kinds of SQL server backups: 1. Full backup: full backup includes the backup of the whole database, part of the transaction log, database structure and file structure. It represents the database at the time when the backup is completed. Is the basis for all backup types. 2. Differential backup: refers to the last time

  2022-06-01 14:28:42 Views: 274
• 

  How Oracle creates tablespaces

  How to create tablespaces in Oracle? There are two main ways: one is to use the SQL command, and the other is to create it through the Oracle client Enterprise Manager Console. The following are introduced separately: 1 through SQL

  2022-06-01 14:28:36 Views: 219
• 

  MySQL 5.7.22 binary installation

  MySQL 5.7.22 binary installation 1. Download mysql-5.7.22 binary package from the official website, create mysql user: useradd mysql- s / sbin/nologin-M 3, decompress my

  2022-06-01 14:28:36 Views: 225
• 

  Automatic initialization of SQL Server 2017 AlwaysOn AG (10)

  The performance of creating an availability group for automatic seeding takes into account that SQL Server uses a fixed number of threads for automatic seeding. In the primary instance, SQL Server uses one thread for each LUN to read the changes. In the secondary instance, SQL Ser

  2022-06-01 14:28:35 Views: 208
• 

  Mysql master-slave building

  Mysql master-slave build operating system: [root@localhost ~] # cat / etc/redhat-releaseCentOS release 6.8 (Final) Master (master): 192.16

  2022-06-01 14:28:35 Views: 294
• 

  Use replace into to create a root privileged user after skipping authorization table login

  Cause: just built the mysql database, do basic optimization, accidentally deleted all users, and quit. We have no choice but to skip the authorization table and log in and create a new root user. The process is as follows: first, stop mysql and skip authorization login [root@explnk]

  2022-06-01 14:28:35 Views: 215
• 

  Practice of moving Master Database Files in Asynchronous Mirror

  In asynchronous database mirroring, moving the master database file in practice A database is deployed as an asynchronous database mirror, and the disk space where the main database is located is insufficient, so I have to move the master database file to a new disk. In asynchronous database mirroring, the application connects to the primary database access. We need to follow your online here.

  2022-06-01 14:28:26 Views: 229
• 

  Customer server and its server commands commonly used in mariadb

  1. Install MariaDB and its configuration step 1) create a data directory and its user mkdir-pv / mydata/datagroupadd-r mysqluseradd-g mysql-r mysql2) number of authorizations

  2022-06-01 14:28:25 Views: 256
• 

  What's New in Project Server 2016

  From an IT Pro perspective, Project 2016 mainly has the following new features: resource booking resource booking is a new feature in Project Server 2016 that helps project managers and resource managers focus on specific resources associated with the project

  2022-06-01 14:28:25 Views: 260
• 

  Using wt tools to recover the data of wiredtiger Storage engine

  First, the preparatory work 1. Download and install the wt utility kit wget http://source.wiredtiger.com/releases/wiredtiger-2.9.1.tar.bz2tar xvf wired

  2022-06-01 14:28:20 Views: 253
• 

  Why SQL Server instances are under pressure

  Why are SQL Server instances under pressure to translate from: https://www.simple-talk.com/sql/database-administration/why-is-that-sql-serv

  2022-06-01 14:28:19 Views: 230
• 

  How to use limit in mysql

  This article shows you how to use limit in mysql. The code is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article. Limit syntax supports two parameters, offset and limit, the former table

  2022-06-01 14:28:19 Views: 221
• 

  Mysql data optimization method

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

  2022-06-01 14:28:19 Views: 214
• 

  Solution to the problem of invalid host name when building oracle12c rac

  Build an oracle 12c rac cluster on windows 2012 64-bit Enterprise Edition. The hosts file is as follows: # add for rac config11.14.72.83 rac111.14.72.84 rac

  2022-06-01 14:28:13 Views: 298
• 

  Data integration: Flume and Sqoop

  Flume and Sqoop are Hadoop data integration and collection systems, and their positioning is different. Here is an introduction based on personal experience and understanding: Flume is developed by cloudera and has two major products: Flume-og and Flume-ng.

  2022-06-01 14:28:06 Views: 258
• 

  Sqlplus: error while loading shared libraries

  Just after installing ORACLE11g, the error is reported as follows: [oracle@oracle ~] $sqlplussqlplus: error while loading shared libraries: / u01/ap

  2022-06-01 14:28:06 Views: 222
• 

  The low memory of Hbase heap in a bug life-and-death experience leads to regionser

  The environment is as follows: Centos6.5Apache Hadoop2.7.1Apache Hbase0.98.12Apache Zookeeper3.4.6JDK1.7Ant1.9.5Maven3.0.5 is currently under testing.

  2022-06-01 14:27:54 Views: 246
• 

  Mysql database read-write separation simple configuration

  Environment: Master:192.168.71.128 mysql-sql-node1Slave:192.168.71.140 mysql-data-node1Mysql-Proxy:192.168.71.

  2022-06-01 14:27:24 Views: 249
• 

  Forcibly release the occupied port, the quickest and most convenient way to release the occupied port, the complete solution of port occupation

  Forced release of port occupancy can use my newly developed version of PHPWAMP_IN2 (the latest version so far, the tutorial is the old picture). The latest version of PHPWAMP supports custom Mysql version and custom PHP version, and is currently the only true pure green software integrated with the VC runtime.

  2022-06-01 14:27:24 Views: 253