NAV: SLTechnology News&Howtos > Database >

• 

  The difference between Redis and memcached

  The difference between REDIS and MEMCACHED (turn) if you simply compare the difference between Redis and Memcached, most of you will get the following point of view: 1 Redis not only supports simple data of KLV type, but also provides list,set,has.

  2022-06-01 09:22:27 Views: 207
• 

  Jeesite4.0 connection sql server 2008 R2

  1. Just execute the error reported by init-data.bat 2. Execute the error reported by InitCoreData.java org.springframework.transaction.CannotCreateTransac

  2022-06-01 09:22:27 Views: 234
• 

  First acquaintance of MySql in index

  1 mysql index type [mainly divided into 4 types of indexes] create indexes: 1. Add PRIMARY KEY (primary key index) [primary key: a unique index that must be specified as primary key] mysql > ALTER TABLE `tab

  2022-06-01 09:22:26 Views: 240
• 

  MySQL 5.7sync_relay_log of replication delay

  1. Describe the master-slave replication of MySQL version 5.7, with a delay of tens of thousands of seconds in batch display. 2. Phenomenon 1. High utilization rate of io # iostat-dxm 1 1000Device: rrqm/s wrqm/s r

  2022-06-01 09:22:26 Views: 235
• 

  Radius Authentication of Wireless 802.1x implemented by FreeRadius + Daloradius + Ubuntu Server

  FreeRadius is the most widely used software in open source applications at present. It supports various authentication protocols that are commonly used at present. The server runs on the PHP-based web platform to provide a user management tool called dialupadmin. It is for nearly 500 enterprises

  2022-06-01 09:22:26 Views: 274
• 

  Oracle official documentation (11G r 2) [documentation for installation]

  Notes related to the official document of Oracle: for your reference only, you are welcome to come to correct and make suggestions. Step: click Master Book List in the upper left corner and enter a book directory and find the following figure: then find the corresponding one according to the version of your system.

  2022-06-01 09:22:14 Views: 218
• 

  Keybox building

  Keybox is a ssh terminal management software based on web. In the production and test environment, the server is generally placed in the internal network. If you want to connect remotely through the external network, you need to connect to the proxy server with the external network first, and then ssh the machine in the internal network. With keybox, you can avoid the trouble. one

  2022-06-01 09:22:06 Views: 223
• 

  OGG Operation and maintenance Optimization script (7)-Information Modification Class-Quick comments

  File name: note.sh path: $HOME/ggscript/ggnote function: this script is used to comment on the configuration table of the specified line, in conjunction with the duplicate value checking script repeat.sh to initialize .profile or .bash _ p through alias

  2022-06-01 09:22:05 Views: 216
• 

  MariaDB backup

  After 10.2, pt xtrabackup is no longer supported and replaced by mariabackup, a very useful tool, like pt.

  2022-06-01 09:22:05 Views: 301
• 

  MySQL lesson 3 functions and time-related problems

  1) delete records before a certain time delete from cs_storage_video_file where date (start_time) < = '2017-10-27'. Currently, only accurate to day is supported.

  2022-06-01 09:22:05 Views: 294
• 

  Oracle reported an error at Patch Missing command: fuser

  Today, I typed Patch Times error: [oracle@xxy01 24006111] $opatch applyOracle Interim Patch Installe when installing the Oracle database for the development test environment.

  2022-06-01 09:22:05 Views: 262
• 

  Oracle gets the trace file name of the current session

  The default file name SQL is as follows:-- Type 1 SELECT u_Dump.Value | |'/'| | Lower (Db_Name.Value) | |'_ ora_' | | V$process.S

  2022-06-01 09:22:04 Views: 232
• 

  Using Maxscale to achieve read-write separation of mysql

  MaxScale is one of the products of MariaDB, which can easily implement read-write separation scheme, and provides load balancing and high availability guarantee for read-write separation. First, the premise of installation and configuration: first configure the master and slave of mysql, and Maxscale will automatically follow the master and slave

  2022-06-01 09:22:04 Views: 270
• 

  Filter after mysql grouping

  The condition for screening after grouping is to do screening on the results of the first-level screening, and put it at the end. If the screening has nothing to do with the results of the first-level screening, then put it in the middle grouping function as the condition, it must be the screening after grouping # case 1: query the number of employees in which department > 2SELECT COUNT.

  2022-06-01 09:22:04 Views: 218
• 

  Reveal the inconsistency between master and slave data of MySQL

  At present, the most commonly used MySQL database is the master-slave architecture, and most of the highly available architectures are evolved from the master-slave architecture. However, the master-slave architecture is prone to data inconsistencies after running for a long time, such as misoperation caused by writable slave libraries or copying bug, which will be detailed in this article

  2022-06-01 09:22:04 Views: 217
• 

  SQL Server AlwaysOn deployment

  Introduction to AlwaysOn AlwaysOn availability group is a new feature provided in SQL Server 2012, which ensures the availability of application data and achieves zero data loss. AlwaysOn availability group technology integrates database cluster and database.

  2022-06-01 09:21:34 Views: 268
• 

  What is a MySQL connection query

  What is a MySQL connection query? I believe that many inexperienced people are at a loss about this, so this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem. 1 the join operation in the database is called a join, and the function is the number that can join multiple tables

  2022-06-01 09:21:30 Views: 266
• 

  Oracle12cR2_ASM_on_LINUX7.3 installation documentation

  Oracle12cR2_ASM_on_LINUX7.3 OCP learning installation documentation, for reference only, if you have any questions, please leave a message. Https://pan.baidu.com/s/1HydRrDeVa508pjej-h2BMA

  2022-06-01 09:21:30 Views: 243
• 

  Reconstruction control file error

  SQL > CREATE CONTROLFILE REUSE DATABASE "EMREP" NORESETLOGS FORCE LOGGING ARCHIVELOG2 MAXLOGFILES 163

  2022-06-01 09:21:30 Views: 278
• 

  Oracle 11g rac dbca prompts to create listeners when building a database

  Oracle 11g rac dbca prompts to create listeners when building a library. When installing oracle 11g rac, you are prompted to create listeners in the process of building a library using dbca: Default Listener "LISTENER" is n

  2022-06-01 09:21:30 Views: 298