NAV: SLTechnology News&Howtos > Database >

• 

  The way to shell-- install yum version with one click of LAMP

  #! / bin/bashcat < / var/www/html/index.php < EOFsystemctl restart httpdsystemctl restart mariadb-servicee

  2022-06-01 15:03:33 Views: 254
• 

  Performance problems caused by Buffer Pool pollution

  Background: after a database application migrates the database from Aliyun rds to Beijing aws, it is found that all queries will be analyzed slowly: pick several problematic query statements, compare the execution statement, index, execution plan, and find that the execution plan, index and database building statements are all the same version of the database.

  2022-06-01 15:03:32 Views: 239
• 

  Mongodb performance monitoring

  Use / var/soft/mongodb2.2/bin/mongostat-- port port number to monitor the number of inserts/s inserts per second, query/s queries per second, update/s updates per second

  2022-06-01 15:03:29 Views: 255
• 

  Plug-in principle of Mybatis

  Lu Chunli's work notes, good memory is not as good as bad notes reproduced from: simple Mybatis- plug-in principles Mybatis adopts the responsibility chain model, through dynamic agents to organize multiple interceptors (plug-ins), through these interceptors can change the default behavior of Mybatis (such as SQL heavy

  2022-06-01 15:03:26 Views: 243
• 

  Summer School experiment

  1. Experimental purpose 1. Master the method of connecting HADOOP cluster 2, enter and exit HBASE3, create and delete table 4, insert record 5, modify record 6, delete record 7, basic SCHEMA design 2, experimental environment 1, HADOOP cluster 2, HBASE client 3

  2022-06-01 15:03:09 Views: 239
• 

  Insufficient permissions When Creating a Materialized View Log

  The privileges required to create a materialized view log are directly relatedto the privileges nece

  2022-06-01 15:03:08 Views: 211
• 

  Multi-source replication practice of MySQL5.7 based on GTID

  Environment description: host IPMySQL version port copy account replication password Master1192.168.1.2255.7.253306repl123456Master2192.168.1.1005.7.253306repl

  2022-06-01 15:03:08 Views: 292
• 

  ORCLE RMAN backup script

  1. Oracle backup script export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=/u01/app/oracle/product/11.2.

  2022-06-01 15:03:08 Views: 246
• 

  Quickly and silently install Oracle11GR2 database and create an instance under linux CentOS7

  Quickly and silently install Oracle11GR2 database and create instances under linux CentOS7 this article is suitable for installation and deployment if you are already familiar with the installation process. Commands with multiple lines can be copied and executed together; beginners suggest learning step by step: https:/

  2022-06-01 15:02:55 Views: 217
• 

  Mgo self-increment id of golang

  Import ("fmt", "gopkg.in/mgo.v2", "gopkg.in/mgo.v2/bson", ".. / funcs") / / id increments func GenId (

  2022-06-01 15:02:55 Views: 233
• 

  Backup and restore of etcd database

  1. Backup etcd1.1 manual backup data etcdctl backup--data-dir / var/lib/etcd/default.etcd-- backup-dir backup directory 1.2 script backup data to

  2022-06-01 15:02:55 Views: 284
• 

  What is varchar in mysql

  What is varchar in mysql? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something. Varchar is a variable-length class in mysql

  2022-06-01 15:02:54 Views: 299
• 

  XAPI of XenServer architecture

  First, XAPI manages the resource pool as the management tool set of XenServer, and XAPI manages the host, network and storage of XenServer. Whether it is OpenStack or CloudStack, if you use XenServer as the virtual base

  2022-06-01 15:02:46 Views: 207
• 

  Self-study of MySQL database

  MySQL database self-study preface Dear yourself and readers: Hello! This is a series of self-taught Java programming and development articles by the author, which does not have a certain authority, but also can be regarded as his own learning notes and summary. I hope that I will make my own learning efficiency in the form of blog.

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

  MYSQL-- stored procedure

  MYSQL's stored procedure 1 is a precompiled collection of SQL statements and control statements, which is stored in one name and processed as a unit of 2 stored procedures to enhance the function and flexibility of SQL statements to achieve faster execution speed to reduce network traffic 3 considerations to create stored procedures

  2022-06-01 15:02:45 Views: 233
• 

  MongoDB uses the skip () method to skip the number of limit specified

  1. View the collection show collections2. Add data db.runoob.insertMany ([{'title':'data1','url':' https://blog.51cto.com] to the collection

  2022-06-01 15:02:31 Views: 216
• 

  Talking about MGR-a separate communication mechanism

  Although MGR uses Slave's channel, it only uses the execution thread (Applier Thread) of this channel to execute Binlog Event, and does not use this channel to transmit Binlog Event. MGR does not use asynchronous replication

  2022-06-01 15:02:31 Views: 283
• 

  Suse11 installation Test redis

  Suse11 installation test Redis 1, download and install the latest redis source package wget http://redis.googlecode.com/files/redis-2.6.13.tar.gz--2013-05

  2022-06-01 15:02:30 Views: 304
• 

  Ambari 2.4 installation tutorial, with configuration haodoop lzo

  Preparation work 1. To install JDK, the path and version of JDK installed by each member host in the cluster must be unified. two。 Install a MySQL Server on the host in the cluster (MySQL is optional, Ambari default database is PostgreSQL) 1.

  2022-06-01 15:02:30 Views: 285
• 

  Oracle silent installation cadb error TNS-12547: TNS:lost contact

  After installing oracle 11g using clones, and then using cadb to build a database to report errors: ORA-12547: TNS:lost contact for such an unobvious error, it is really difficult to locate and confirm the problem. There are a lot of suggestions online: 1. Missing package, li

  2022-06-01 15:02:26 Views: 234