NAV: SLTechnology News&Howtos > Database >

• 

  SuSE11 installation MySQL5.6.40: compilation and installation mode, single instance

  Summary: SuSE11sp3 64-bit operating system, MySQL5.6.40 compilation and installation, single instance Note: kingtry is my hostname 1, environment ready operating system: SuSE version 11sp3jue 64-bit kingtry:~ # uname

  2022-06-01 10:38:49 Views: 209
• 

  Tips for installation and simple use of mysql 1

  # mysql_install_db-- user=mysql-datadir=/var/lib/mysql initialization data vncviewer 172.40.50.117datadir=/var/lib/mysql 6000 memory cpu hard disk #

  2022-06-01 10:38:44 Views: 289
• 

  MySql5.6 performance optimization study notes

  Target  understand what is optimizing  mastering the method of optimizing query  mastering the method of optimizing database structure  mastering the method of optimizing MySQL server what is optimization?  arranges resources reasonably and adjusts system parameters to make MySQL run faster and save resources.  optimization is multifaceted.

  2022-06-01 10:38:44 Views: 276
• 

  The first part is the basis of data processing

  Chapter 1 SQL Foundation reviews the practice of omitting field names in INSERT statements, which is very rare and risky, so don't do it unless there is some special reason, don't make your SQL statements too fragile, because you can't predict when the structure of the table will change. For example

  2022-06-01 10:38:43 Views: 252
• 

  RAC+ADG off-machine recovery, automatic recovery of control files

  1, first of all, to set up automatic backup of control files 2, automatic recovery script, use the following command restore controlfile from autobackup; this command will find the latest control files to restore, the following do a test to verify. Multiple backups

  2022-06-01 10:38:43 Views: 261
• 

  The user data of the system was not imported before the batch query.

  User data select name from users_temp where (select count (1) from users where users.name = use) that was not imported into the system before batch query

  2022-06-01 10:38:43 Views: 238
• 

  Problems needing attention in flashback points

  Sys@newtestCDB > select * from vs. recoveryfiledestinationNAMESPACELIMIT SPACE_USED SPACE_RECLAIMABLE NUMB

  2022-06-01 10:38:43 Views: 270
• 

  Install SQL Server 2017 offline on Linux

  If your Linux cannot access the online Repo, you can download the RPM package file directly. These packages are located in Microsoft's database: https://packages.microsoft.com. CU9 (July 2018) SQL Server

  2022-06-01 10:38:43 Views: 274
• 

  Related to Oracle patches

  1.Oracle software version naming rules main database publishing number, database maintenance publishing number, application server publishing number, component-related publishing number, platform-related publishing number. The fourth is patch set, the fifth is patch set update, 2. Version and

  2022-06-01 10:38:42 Views: 226
• 

  RStudio installation caret error repair process

  Version information: RStudio-0.99.902R 3.2.2install.packages ('caret', dep = TRUE) error message is as follows: load required program package: lattice load required program package: ggp

  2022-06-01 10:38:42 Views: 257
• 

  Azure documents (SQL data warehouse, Azure SQL database documents)

  Azure documents: https://docs.azure.cn/zh-cn/#pivot=products&panel=databasesSQL data warehouse documents: https://docs.azure.cn

  2022-06-01 10:38:42 Views: 256
• 

  Xtrabackup incremental backup, recovery, principle

  Integrated some materials on the Internet, combined with my own understanding, and carried out experiments to verify understanding 1: 1 what is Xtrabackup? Xtrabackup is a tool for data backup of InnoDB, which supports online hot backup (backup does not affect data reading and writing), and is a commercial backup.

  2022-06-01 10:38:42 Views: 202
• 

  Mysql common commands

  Connect to the local mysql mysql-uroot-p # and enter the password to log in to the remote mysql mysql-h210.110.110.110-uroot-p 123; (note: U

  2022-06-01 10:38:41 Views: 260
• 

  Application of simple sql

  SHOW COLUMNS FROM `weibo_ user` displays the column information of the data table weibo_user. The result is displayed in navicat for mysql as shown in the figure above. It is displayed as an array in php code

  2022-06-01 10:38:35 Views: 283
• 

  MongoDB Notes XVIII-GridFS

  1. Concept GridFS is the file system that comes with mongodb. He uses binary format to store the vast majority of large file systems, which can be completed by GridFS. 2. Use the tool mongofiles.exe3 and use GridFS to view Gr

  2022-06-01 10:38:32 Views: 306
• 

  Oracle uses delimiters to combine whatever the query wants to say.

  In the implementation, we may encounter customer requirements for the display title. For example, the original title was: notice of Guangxi Longtan Hospital on further strengthening the reporting of government information. Then the format they want to display is: "File name" (Guilong Medical hair (2015) No. 23). Then we just need to use s

  2022-06-01 10:38:32 Views: 237
• 

  TokuDB hot standby test

  1. Try to install the TokuDB plug-in [root@es3 mysql] # export PATH=$PATH:/usr/local/mysql/bin [root@es3 mysql] # ps_tokudb after startup

  2022-06-01 10:38:31 Views: 246
• 

  The treatment method of GAP incremental recovery in Oracle 12c DataGuard

  Don't forget to write a document on the weekend! There are basically two methods for DG failure, one is full backup recovery, the other is incremental backup recovery, here we test the incremental backup recovery method. 1. Environment description Oracle 12c ASM RHEL 7. 0 single-instance to single-instance Da

  2022-06-01 10:38:31 Views: 263
• 

  Backup and upload of SQL Server database

  Following the previous article, this article introduces the backup and upload of SQL Server2008. First, the target backs up the database files to ensure the data security of the production system. Second, SQLBackupAndFTP uses SQLBackupAndFTP: it is mainly used to automatically back up the database.

  2022-06-01 10:38:01 Views: 209
• 

  Oracle series: (29) stored procedures and stored functions

  1. Stored procedure [procedure] what is a stored procedure? A segment of a program with business functions written in advance using oracle syntax, which is stored in the oracle server for remote access by oracle clients (for example, sqlplus) and program languages

  2022-06-01 10:37:46 Views: 233