NAV: SLTechnology News&Howtos > Database >

• 

  Installation and use of Mysql performance testing tool sysbench

  You need to use AWS and Azure Mysql services at work, and you need to test and compare the performance of the two cloud services. So start Baidu + google, looking for performance testing tools. Finally decided to use sysbench. Sysbench introduced that sysbench is

  2022-06-01 13:28:20 Views: 284
• 

  MongoDB create and delete collections

  1. Create the database testuse test2. Display the database show dbs3. Create the runoob collection db.createCollection ("runoob") 4. Create a fixed collection db.createCollect

  2022-06-01 13:28:06 Views: 241
• 

  PowerShell analyzes the correlation between the fields to be created by SQL Server and the existing indexes

  This paper introduces how to analyze the correlation between an index to be created and an existing index from the table level. Briefly analyze the aspects to be considered in creating an index: 1, related sql statements 2, Table 3, steps affecting performance: 1, analyze and extract fields of table and index from related SQL statements, 2, combine the reality of the table.

  2022-06-01 13:27:51 Views: 229
• 

  Pure manual creation of Redis Cluster cluster, the most original method of creating three masters and three slaves

  Cluster cluster Redis Cluster is an official highly available solution, a decentralized Redis cluster scheme, in which all Redis nodes are interconnected with each other (PING-PONG mechanism). Clients can connect directly to any node to connect to the Cluste.

  2022-06-01 13:27:51 Views: 288
• 

  Build production-level Knative based on APIGateway

  Guide: in practical applications, through APIGateway (API Gateway), you can provide protection, unified authentication management, current limit, monitoring and other capabilities for internal services. Developers only need to pay attention to the business logic of internal services. Author Yuan Yi will introduce you in this article.

  2022-06-01 13:27:43 Views: 297
• 

  UUID of MySQL

  MySQL will generate a UUID during initialization: [root@mha03 opt] # mysql/bin/mysqld-- initialize-- user=mysql-- basedir=/opt/my

  2022-06-01 13:27:41 Views: 291
• 

  11g ocm certification exam experience

  It has been nearly five years since Beijing drifters in 2012. In fact, in the past two or three years, the school did not have a deep understanding of sql server. He only learned some simple sql sentences. From 2012 to 2014, he worked as an operation and maintenance officer at the university.

  2022-06-01 13:27:41 Views: 274
• 

  MySQL- View and stored procedure

  1. Increase the basic knowledge of MySQL: add a single piece of data: insert into table (column name, column name.) Values (value, value, value...) Add multiple pieces of data: insert into table (column name, column name...) Values

  2022-06-01 13:27:41 Views: 285
• 

  Mongo simple operation

  Use admin # enter database admindb.addUser ('name','pwd') # add or modify user password db.system.users.find () # View user list db.auth (' name'

  2022-06-01 13:27:37 Views: 295
• 

  MySQL Database Backup Methods Season 3-Percona XtraBackup

  About Percona XtraBackup it is an open source, free MySQL database hot backup tool that can complete and add non-blocking to the InnoDB storage engine, while also supporting compression, encryption and streaming features. Install G

  2022-06-01 13:27:37 Views: 231
• 

  Oracle backup controlfile and find the backup file directory

  Last login: Fri Jul 11 15:25:49 2014 from chenjh [oracle@dbachenjh ~] $sqlplus / nologSQL*Plus: Releas

  2022-06-01 13:27:37 Views: 218
• 

  Characteristics of mongodb database (including database field design for comments and likes)

  The biggest difference between mongo and traditional database: traditional database: structured data. After the table structure is determined, the content of each row must conform to the table structure, that is, the number of columns and type are the same. Mongo document database: every document under the table can

  2022-06-01 13:27:22 Views: 226
• 

  Enterprise backup recovery case

  In MySQl, we generally have several ways to back up data: hot backup, warm backup, cold backup, hot backup means that when the database is backed up, the read and write operations of the database are not affected, that is, when the database is backed up, the database read operation can be performed, but the write operation cannot be performed.

  2022-06-01 13:27:21 Views: 270
• 

  On the combined index, oracle uses only some columns for query (leading columns must be included in the query, otherwise the whole table will be scanned)

  Experimental environment: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production1, create table insert data SQL > creat

  2022-06-01 13:27:21 Views: 216
• 

  Mongo simple command

  1. Check date db.errTrades.find ({"date": {$gt:ISODate ("2016-08-02T00:00:00.00")}})

  2022-06-01 13:27:21 Views: 214
• 

  RAC manually shuts down the startup process

  [oracle@rac2] $srvctl stop database-d RAC [oracle@rac2 ~] $exitlogout [root@rac2 ~] # / u01/app/11.2.

  2022-06-01 13:27:20 Views: 218
• 

  [MySQL] Master-slave asynchronous replication configuration

  Summary: master-slave synchronization of Mysql is an asynchronous replication process that replicates from one Master to another Slave. The whole replication process between Master and Slave is mainly completed by three threads, two of which (SQL line)

  2022-06-01 13:27:20 Views: 214
• 

  Redhat6.4 easy to install oracle 12C

  Here is just to post the three scripts used in the installation. For detailed installation documents, please download attachment service_close.sh instructions: shut down unnecessary services #! / bin/bash#description: the script is after installing the system.

  2022-06-01 13:27:20 Views: 247
• 

  Rhel7.4 installs oracle 11G 11.2.0.4.0 RAC

  I. operating system red hat 7.4oracle database version 11.2.0.4oracle grid version 11.2.0.4 corresponding to the file p13390677_112040_Linux-x86-64_1of7.zip

  2022-06-01 13:26:50 Views: 222
• 

  Mongodb extension installation for php

  1. First download php's mongodb extension download mongodb's extended source package from this URL download mongodb's extended source package wget h from http://pecl.php.net/package/mongo

  2022-06-01 13:26:50 Views: 277