NAV: SLTechnology News&Howtos > Database >

• 

  Compile and install rlwrap-0.42 tools

  Oracle uses the sqlplus tool, which is very inconvenient. Now it is convenient and practical to use the rlwrap tool to realize the historical command of switching between the up and down keys. First, install the required package yum install ncurses-devel-yyum install r

  2022-06-01 12:03:45 Views: 218
• 

  How to use the Thinkphp open source framework?

  (1) first of all, prepare to download the latest version of the thinkPHP framework and extract it to the location of the project you are going to develop. The operation demonstration is shown in the figure: where index.php is the entry file, that is, all requests can only be completed through this file. Application is an application

  2022-06-01 12:03:40 Views: 236
• 

  [MongoDB Learning Notes 12] in-depth MongoDB update (update) operation: array modification

  View a document whose key value comments is an array ["test1", "test2"]: > db.post.findOne ({"id": 1}) {"_ id": ObjectId ("5")

  2022-06-01 12:03:39 Views: 222
• 

  MySQL 5.6Building semi-synchronous replication

  Determine if the plug-in show variables like'% have_dynamic_loading%';ls / usr/local/mysql-5.6.38-linux-glibc2.12- can be installed dynamically

  2022-06-01 12:03:39 Views: 223
• 

  Performance differences between RDS Mysql Single-AZ and Multi-AZ

  High availability is the most important aspect of system architecture for many database engineers / architects. On AWS, Multi-AZ is a very important HA scheme for RDS. However, whether enabling Multi-AZ has an impact on system performance and how much performance is sacrificed is the point of many user relations. Today

  2022-06-01 12:03:24 Views: 309
• 

  There are two ways to view db2 error code information

  There are two ways to view db2 error code messages: first: go to IBM DB2 Infocenter (http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.)

  2022-06-01 12:03:23 Views: 233
• 

  MongoDB slow log query

  MongoDB system.profile preface Part1: when it comes to the slow log analysis of MongoDB, we have to mention the profile analyzer, which writes the recorded slow log to system.profile.

  2022-06-01 12:03:20 Views: 240
• 

  Percona Xtrabackup backup mysql (full backup and incremental backup)

  Percona Xtrabackup backup mysql (full backup and incremental backup) introduction to Xtrabackup Percona XtraBackup is an open source free hot backup software for MySQL databases, which can support InnoDB and Xtr

  2022-06-01 12:03:20 Views: 281
• 

  Linux 056 Notebook DATABASE, MySQL

  Rookie study Linux 056 Notes DATABASE, MySQLMySQL www.mysql.com data query method dichotomy first sorts the data, and then takes the middle position to query and match each time, requiring an average of 14 Btree index queries

  2022-06-01 12:03:20 Views: 222
• 

  Examples of mysql profile my.cnf with explanation

  # change the disk scheduling algorithm echo 'deadline' > / sys/block/xvdb/queue/scheduler# turn off the NUMA feature # numactl-- below interleave=all is my.cnf

  2022-06-01 12:03:19 Views: 302
• 

  [MongoDB] the solution of chunk too big to move

  When the amount of data in some blocks is so large that a very large block is formed, Balancer cannot split the data block and move it. Using MongDB 3.2, the solution is as follows: 1. First turn off Balancersh.sto

  2022-06-01 12:03:19 Views: 269
• 

  Mongo-connector integrates MongoDB to Solr to realize incremental indexing

  Mongo-connector integrates MongoDB into Solr to implement incremental indexing configuration MongoDB replication set reference: "deploy a replication set for testing and development" install Solr5.3 reference: "install Solr5.3 under CentOS" installation

  2022-06-01 12:03:19 Views: 243
• 

  Introduction to special data types in postgresql

  Hstore is a special data type that stores data with multiple attribute values. Acquire key/value = > reference: https://www.postgresql.org/docs/8

  2022-06-01 12:03:04 Views: 264
• 

  Series of related principles of CBO

  The related principle of CBO CBO is introduced in oracle7 to calculate the execution cost of the execution plan based on the statistical information of the data object (including the number of rows of the data set, the number of unique values, etc.). With the evolution of the version, CBO gradually perfected and began to use system statistics (s) in 9i

  2022-06-01 12:03:04 Views: 295
• 

  High availability Scheme of Redis based on Sentinel

  Data storage is a very important part of our application design process. There are many highly available solutions for relational databases, or non-relational databases such as Redis and MongoDB, as well as middleware designed for different businesses, which makes its performance more distinctive and data guaranteed.

  2022-06-01 12:03:04 Views: 232
• 

  The case of Oracle Study-- installing Oracle Kernel Parameter configuration

  Case of Oracle Study-install Oracle kernel parameters are configured under Linux system. Before installing Oracle, in addition to checking whether the hardware and software of the operating system meet the installation needs, one of the key points is to modify the kernel parameters, the most important of which is and memory.

  2022-06-01 12:03:00 Views: 285
• 

  Oracle12.2RAC configuration

  Yum install-y binutils-yum install-y compat-libcap1yum install-y compat-libstdcyum install-y elf

  2022-06-01 12:03:00 Views: 219
• 

  Source package upgrade of Linux7-mariadb database

  Mariadb source package upgrade installation database installation method: 1, RPM package 2, source package 3, general binary format package detailed parsing source package upgrade: here take mariadb-5.5.46-linux-x86_64.tar.gz as an example [roo

  2022-06-01 12:03:00 Views: 242
• 

  A brief introduction to JEESZ distributed Framework-Technical introduction document

  Abstract: Jeesz is mainly located in the Internet enterprise architecture, and has built in the basic functions of the enterprise information system and efficient code generation tools, including: system authority components, data permissions components, data dictionary components, core tool components, view operation components, workflow components, code generation and so on. Mining

  2022-06-01 12:02:51 Views: 235
• 

  Oracle database delete user (schema) operation

  First close App 1) View the user's default and temporary tablespaces set lines 300col username for a30select username, default_tablespace,TEMPORAR

  2022-06-01 12:02:50 Views: 270