NAV: SLTechnology News&Howtos > Database >

• 

  Perform a database-wide search in Navicat Premium

  If you've ever tried to locate specific columns in a large database, I'm sure you'll agree that this can be a daunting task. You can gather a lot of information about the structure of DB from the information_schema schema. It has a list of all tables and all fields in the table. And then,

  2022-06-01 13:15:46 Views: 293
• 

  From shallow to deep learning JDBC 1

  JDBC: although due to fast-paced development and the pursuit of programming speed, more and more MVC frameworks appear, such as hibernate,mybatis in the persistence layer, their support for the Dao layer is very strong, both fast and easy. But they also use J at the bottom.

  2022-06-01 13:15:34 Views: 222
• 

  The solution that RAC cannot start the instance because the archive table space is full

  Today, if you want to test something, log in to the test library; find that the instance is closed; SQL > startupORACLE instance started.Total System Global Area 2722467840 byte

  2022-06-01 13:15:33 Views: 246
• 

  Swingbench- 's free oracle performance stress testing tool

  SwingBench introduction: SwingBench consists of a load generator, a coordinator, and a cluster overview. The software makes it possible to generate load and map the transaction / response time of the chart. SwingBench can be used to demonstrate and test such as practical application clusters, online table reconstruction

  2022-06-01 13:15:03 Views: 229
• 

  Bad blocks caused by ORA-01578 and ORA-26040--NOLOGGING operations-error interpretation and solutions

  (1) introduction to bad blocks caused by NOLOGGING operation (ORA-01578 and ORA-26040) if it is only an error ORA-01578, but not accompanied by ORA-26040, then this bad block is caused by other reasons, so you can try to use RM

  2022-06-01 13:15:02 Views: 301
• 

  ProxySQL! As powerful as Ronaldo!

  Brothers, Lao Zhang has seen you again many days later. Every time I meet with you, there will be good news to tell you, and this time is no exception. Some time ago, the book "the Road to Promotion of the King of MySQL" was published, and the response was good. Strive to publish another practical book on MongoDB operation and maintenance this year for

  2022-06-01 13:14:52 Views: 275
• 

  MYSQL remote connection to the database

  Today, a friend of mine for many years came to me and told me how to use MYSQL remote database, under normal circumstances. Will separate the business system server from the database server. So it involves connecting to the MYSQL server remotely. Now let me introduce how to solve this problem. 1. Authorization law. Would you

  2022-06-01 13:14:51 Views: 243
• 

  Msyql startup error cannot find pid file

  After installing mysql, start the mysql database and report an error Starting MySQL.The server quit without updating PID file & # 40 * MySQL * *

  2022-06-01 13:14:51 Views: 283
• 

  [book Review: Oracle query Optimization rewriting] Chapter 3

  [book Review: Oracle query Optimization rewriting] Chapter 3 BLOG document structure figure 1. 1 introduction to technical enthusiasts, after reading this article, you can master the following skills, you can also learn some other knowledge that you do not know, ~ O (∩ _ ∩) oPCll: ① implied parameter _ b_tr

  2022-06-01 13:14:48 Views: 223
• 

  Detailed explanation of ORACLE PL/SQL programming

  SQL language is only a language to access and operate the database, not a programming language with flow control, but only a programming language can be used in the development of application software. PL / SQL is a high-level database programming language designed specifically for ORACL in a variety of environments

  2022-06-01 13:14:18 Views: 289
• 

  Django Session Universal configuration

  Django has some default common configurations for Session. These default configurations are: SESSION_COOKIE_NAME = = "sessionid" # ke when the cookie of Session is saved on the browser

  2022-06-01 13:14:17 Views: 248
• 

  Development specification of MySQL production library

  MySQL development specification file status: [] draft [√] official release [] document identification: current version: V1.0 author: he Lei completion date: 2016-05-24 change record serial number modification date revision content reviewer

  2022-06-01 13:14:17 Views: 215
• 

  MySQL Storage engine SQL data Import / Export Operation Table record query and matching conditions

  Configuration of MySQL storage engine SQL data import / export operation table record query and match condition 1 MySQL storage engine configuration 1.1 this case requires the use of the MySQL data storage engine to complete the following tasks: available storage engine types view default storage type

  2022-06-01 13:14:17 Views: 278
• 

  S-lock and X-lock of database, two-stage lock protocol

  There are two basic types of locking: exclusive lock (X lock) and shared lock (S lock). The so-called X lock is that when transaction T adds an X lock to data A, transaction T is only allowed to read and modify the data. The so-called S lock means that when transaction T adds an S lock to data A, other transactions can only add S lock to data An instead of

  2022-06-01 13:14:16 Views: 288
• 

  Data synchronization between oracle and oracle under GoldenGate Architecture

  The oracle under the GoldenGate architecture is consistent with the scott data on the oracle data migration host updba and the scott data on the scott.1: updba and upgg on the host upgg. (can be achieved through migration) 2:

  2022-06-01 13:14:13 Views: 225
• 

  Set up FreeRadius to realize remote login authentication (part I)

  Linux+FreeRadius+Mysql implements Radius authentication the first part of the server configuration 1, basic system preparation 1, install Redhat-Linux operating system, system version number 5.52, install all three components of Mysql, as shown in the following figure

  2022-06-01 13:13:58 Views: 226
• 

  A brief introduction to Redis installation

  Redis database installation: under ubuntu: 1. Download the database wget http://download.redis.io/releases/redis-4.0.9.tar.gz [finally, the version, adjust as needed

  2022-06-01 13:13:55 Views: 268
• 

  Implementation of MySQL Master-Slave data consistency check based on pt-table-checksum and pt-table-sync

  In the master-slave architecture based on the principle of MySQL logical replication, the master-slave data is often inconsistent for some reason, which leads to the interrupt of the master-slave replication process. Based on periodically checking the status of the IO and SQL threads of the show slave status\ G of the slave library

  2022-06-01 13:13:55 Views: 239
• 

  ORACLE silent installation prompt monitor detection failed

  [oracle@test tmp] $/ mnt/runInstaller silent-ignorePrereq\-responseFile\ / home/oracle/db_install.rs

  2022-06-01 13:13:54 Views: 281
• 

  Linux disk Management

  Liunx disk management 1, the first hard disk / dev/sda second block / dev/sdb third block / dev/sbc generally install RAID,LVM less commonly used partitions before installing the system-> format-> mount disk first partition / dev/sda1 to

  2022-06-01 13:13:54 Views: 209