NAV: SLTechnology News&Howtos > Database >

• 

  Redis Notes-installation and configuration of Redis (1)

  The general installation part is as follows, there are many online tutorials, abbreviated here 1. Decompress 2. Enter the src directory 3. Execute the make install command 4. Execute the redis-server command to start 5. Execute the redis-cli command to connect to Redis

  2022-06-01 12:51:00 Views: 232
• 

  CentOS 7, amp + xcache, rpm package, php-fpm

  1. Experimental requirements: 1) CentOS 7, amp + xcache, rpm package, php-fpm;a) depth: httpd, php, mariadb are deployed on a separate host, and all on the same host; b) one

  2022-06-01 12:50:57 Views: 232
• 

  Mongodb monitoring index

  Insert insert / query / update / delete mongostat-- port 21000-- rowcount=1 | grep-v insert | awk'{print $1} 'query per second

  2022-06-01 12:50:57 Views: 239
• 

  DBUtils usage transaction

  1.DBUtils is a database operation utility in java programming. It is small, simple and practical. How does it manage things? We all know that in jdbc, things are controlled by Connection objects. The core of the DBUtils utility class is Quer.

  2022-06-01 12:50:57 Views: 238
• 

  NoSQL-- Mongodb installation uses replica set backup restore

  Mongodb is an open source database system based on distributed file storage written by C++, which is between relational database and non-relational database. Under high load, multiple nodes are added to ensure server performance, in order to provide scalable high-performance storage for web applications.

  2022-06-01 12:50:45 Views: 283
• 

  Database ORA-03113 troubleshooting

  Prompt ORA-03113: the end of the file of the communication channel solves SQL > exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.

  2022-06-01 12:50:42 Views: 252
• 

  Compile and deploy mysql5.7.13

  Deployment environment centos7.2+mysql5.7.131, dependency package Note: the role of related dependency packages cmake: since the conventional configure compilation method has been abandoned since the MySQL5.5 version, a CMake compiler is required

  2022-06-01 12:50:35 Views: 208
• 

  MariaDB 10.3 solved the problem that UPDATE does not support subquery updates of the same table.

  MariaDB 10.3 eliminates subquery updates that UPDATE does not support for the same table. Let's look directly at the case CREATE TABLE T1 (C1 INT, c2 INT); INSERT INTO T1 VALUES (

  2022-06-01 12:50:21 Views: 252
• 

  10g data pump export, 12c data pump import

  10g1, create test user related information create directory dump_dir as'/ home/oracle';grant read,write on directory dump_dir

  2022-06-01 12:50:21 Views: 218
• 

  SQL of Oracle Learning (2) Restricting and Sorting Data

  Restrict the return row syntax of the SELECT statement: use the WHERE keyword to restrict the return of data rows, with the WHERE clause following the FROM clause. SQL > select * from emp where deptno=10

  2022-06-01 12:50:15 Views: 282
• 

  Oracle connects to oracle through DBlink

  1.1 empower (empower the crh_snp user to create dblink permissions) under the sys user, the CREATE PUBLIC DATABASE LINK,DROP PUBLIC DATABASE LINK permission is granted to you

  2022-06-01 12:50:14 Views: 234
• 

  Oracle backup script

  #! / bin/shexport ORACLE_BASE=/app/oracle/export ORACLE_HOME=/app/oracle/productexport PATH=$ORACLE_HO

  2022-06-01 12:50:14 Views: 214
• 

  Mysql ibtmp1 reclaim space

  About ibtmp1 recycling space can only restart the database, a bit of a hole ah ah! [root@raca1 data] # ls-lhtotal 7.6GMurray rwmurr-1 mysql mysql 56 Jul 1

  2022-06-01 12:50:14 Views: 279
• 

  List object lock (lock) information and its killed session (sid,serial#) information

  The check_lock.sql script lists the object lock (lock) information and its killed session (sid,serial#) information set linesize 132 pagesize 66 break on Kill on us

  2022-06-01 12:49:44 Views: 284
• 

  Detailed explanation of OSPF message

  1. OSPF Overview 1. IGP (Interior Gateway Protocol), AS Interior Gateway routing Protocol. 2. Link-state dynamic routing protocol. 3. IP protocol number 89. 4. Area. Area consists of a number of network

  2022-06-01 12:49:44 Views: 232
• 

  Rac ORA-001157 data file mistakenly creates local disk shared storage ASM cannot identify/lock data file

  Mistakenly create the data file on the local disk instead of the shared storage error: not the data file in the shared storage, other instances can not access the solution and solution: move the local data file to the shared storage. Step: 1. Offline table space or data file 2. Copy data file

  2022-06-01 12:49:43 Views: 235
• 

  Run multiple mysql instances under Windows

  To test the Mysql group replication mechanism, create multiple mysql instances on windows. The steps are as follows: first, create a folder to store database data files, for example, create a separate folder: d:\ Ser

  2022-06-01 12:49:43 Views: 292
• 

  [book Review: Oracle query Optimization rewriting] chapters 5 to 13

  [book Review: Oracle query Optimization rewriting] Chapter 5 to 13. 1. 1 BLOG document structure figure 1. 2 preface part 1. 2.1 introduction to all technical enthusiasts. After reading this article, you can master the following skills, and you can also learn some other knowledge that you do not know. ~ O (∩ _

  2022-06-01 12:49:13 Views: 215
• 

  Oracle start

  Su-oraclesqlplus "/ as sysdba" startup;exitlsnrctl start # starts network snooping, which must be started, otherwise other servers cannot connect

  2022-06-01 12:49:13 Views: 247
• 

  Configuration of 11g kernel parameters for linux and aix installation

  Linux x86 Kernel Settingskernel.shmmni = 4096 kernel.sem = 4096 32000 100128 fs.file-max = 6815744ne

  2022-06-01 12:49:12 Views: 293