NAV: SLTechnology News&Howtos > Database >

• 

  Multi-node installation redis cluster installation deployment-4.0.1

  Number of environment nodes IP:172.17.7.11 CPU: 12-core MEM:96G startup service: 6 use port: 7001~12IP:172.17.7.25 CPU: 12-core MEM:9

  2022-06-01 08:34:10 Views: 265
• 

  MySQL performance tuning

  1 Mysql working principle 1.1 mysql architecture: connection pool sql interface analyzer query cache storage engine file system management tool 1.2 permanent definition: modify configuration file / etc/my.cnf [mysql] variable name = value 1.3 temporary

  2022-06-01 08:34:09 Views: 240
• 

  Oracle's redo log

  When the Oracle database is running, the data changed by the user will first be stored in the database cache. In order to improve disk read and write, the oracle mechanism will not write the buffer data to disk frequently, but will not write until the checkpoint or the data cache reaches a certain amount.

  2022-06-01 08:33:46 Views: 259
• 

  Practical Guide to Oracle job Automated tasks

  As the scheduled task of oracle, oracle job is between the crontab at the server level and the application (such as the scheduled task of java spring). It has important value for data processing in the database layer. Let's briefly share oracle jo.

  2022-06-01 08:33:46 Views: 206
• 

  PXC5.7.21 for linux7.2 installation

  PXC installation is very simple! -- Software download https://www.percona.com/downloads/Percona-XtraDB-Cluster-57/LATEST/-- basic environment preparation [ro

  2022-06-01 08:33:45 Views: 231
• 

  The oracle stored procedure traverses the cursor twice

  There are two cursors in a stored procedure, and the second cursor uses the value of the first cursor. Here is an example: create or replace procedure DYNAMIC_CONFIRMascurs

  2022-06-01 08:33:45 Views: 238
• 

  Oracle login without password

  The use and maintenance of oracle wallet starts from Oracle10gR2, through the use of Oracle Wallet to enable any user to log in to the database without a password (non-operating system authentication), which is very useful for using scripts to log in to the database.

  2022-06-01 08:33:45 Views: 244
• 

  Oracle Grid 11.2.0.4 $GI_HOME/crs/config/config.sh appears INS-06001

  Grid Infrastructure Configuration: Error In OUI "SSH Connectivity" Section (document ID 1997480.1Grid Infr

  2022-06-01 08:33:45 Views: 260
• 

  Introduction to OSWatcher usage

  OSWatcher Black Box, or OSW for short, is a small but very useful tool provided by oracle. It records some performance parameters of the OS runtime, such as CPU/Memory/Swap/Ne, by calling commands provided by OS itself.

  2022-06-01 08:33:44 Views: 204
• 

  Three hosts deploy LAMP respectively

  Three hosts are required to deploy LAMP: httpd, php and mariadb are deployed on a separate host, one virtual host provides phpMyAdmin, the other virtual host provides wordpress, and provides h for phpMyAdmim

  2022-06-01 08:33:33 Views: 246
• 

  Linux binary package installation Mysql8 master-slave replication

  1. Download the installation package wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.18-el7-x86_64.tar.gz2 and delete the rpm-qa included in the system.

  2022-06-01 08:33:23 Views: 217
• 

  How to realize data backup and recovery by mysql

  This article mainly explains mysql how to achieve data backup and recovery, the content is clear, interested friends can learn, I believe that after reading it will be helpful. Content of this article: copy file method using mysqldump and select into ou

  2022-06-01 08:33:17 Views: 250
• 

  How to realize mysql user Rights Management

  This article mainly explains how to achieve mysql user rights management, the content is clear, interested friends can learn, I believe it will be helpful after reading. Content of this article: what are the appropriate user permissions? user permissions to view permissions to modify permissions to delete permissions? initial date: 20

  2022-06-01 08:32:53 Views: 206
• 

  Generate the other five major inventory according to STOCK_LOT_STORAGESPACES

  -generate the other five major inventories according to STOCK_LOT_STORAGESPACES. Just call the table STOCK_LOT_STORAGESPACES and BEGINFOR C IN (SELECT DIST)

  2022-06-01 08:32:52 Views: 222
• 

  Optimize it through case study-- Partition Table Index

  Optimized by case study-- partitioned table index Just like partitioned tables, partitioned indexes improve manageability, availab

  2022-06-01 08:32:38 Views: 210
• 

  Mysql deletes unused table data

  MySQL deletes data and whether to free disk space: 1. Drop table table_name immediately releases disk space, whether it is Innodb or MyISAM; 2. Truncate table table_

  2022-06-01 08:32:38 Views: 256
• 

  Usage of mysql user Management

  This article mainly explains the use of mysql user management, the content is clear, interested friends can learn, I believe it will be helpful after reading. The content of this article: the introduction of the user to view the user to create the user account to modify the account to delete the account about the anonymous user launch date: 20

  2022-06-01 08:32:38 Views: 251
• 

  DATETIME FORMATE (time format)

  From the official Oracle documentation, for ease of use at work, it is intercepted here for reference: http://docs.oracle.com/cd/E11882_01/server.112/e41084/sql_elements

  2022-06-01 08:32:37 Views: 200
• 

  What is the mysql code execution structure

  What the editor wants to share with you this time is what is the mysql code execution structure. The article is rich in content. Interested friends can learn about it. I hope you can get something after reading this article. Content of this article: what is the code execution structure, sequence structure, branch structure, loop structure, first release date:

  2022-06-01 08:32:34 Views: 212
• 

  Sysbench stress test mysql database

  Sysbench is a stress testing tool, which can not only test the hardware performance of the system, but also can be used to benchmark the database. It is very convenient to use. At the same time, sysbench supports the following test modes: 1. CPU computing performance 2, disk IO performance 3, scheduler performance.

  2022-06-01 08:32:29 Views: 277