NAV: SLTechnology News&Howtos > Database >

• 

  Standard operation flow of database start and stop

  1. Process description 1.1. The purpose of the process is to restart the database, restart ORACLE cluster software and hosts in order to cooperate with application changes, host maintenance, abnormal downtime and restart. In order to ensure the standardization of database start and stop operation, the operation specification is customized. The specification is only for databases

  2022-06-01 21:29:48 Views: 292
• 

  How to get started with MySQL

  On how to start MySQL, there are many students in the background to consult me, maybe some readers have just begun to learn MySQL, the article I posted before is temporarily out of touch with some students. Originally, the purpose of writing technical articles is to record their own work and study, without taking into account the reader's MySQL technology water.

  2022-06-01 21:29:47 Views: 213
• 

  The solution to the emergence of ERROR 1819 (HY000) in mysql

  This article mainly introduces in detail the solution to the emergence of ERROR 1819 (HY000) in mysql, which has a certain reference value. Interested friends can refer to ERROR 1819 (HY000): Your passwo

  2022-06-01 21:29:17 Views: 279
• 

  Simple installation and use of redis for nosql

  Redis basic application scenario: session sharing among web, that is, multiple war projects share a session distributed cache. Because redis is key-value pair storage, it provides rich adapter to support C, .net and java clients, so it is flat.

  2022-06-01 21:29:17 Views: 270
• 

  The first knowledge of MySQL-- the Foundation of SQL language

  In the daily management and application of the database, no matter whether the administrator is suitable to access a database, almost all use SQL language. Therefore, it is very important to master the SQL language and its script writing. SQL (structured query language) is the most popular number of relational types at present.

  2022-06-01 21:29:17 Views: 205
• 

  Database Operation of python

  1. Insert data import MySQLdb# to create a connection conn = MySQLdb.connect (host='127.0.0.1',user='root',passwd='123456',db='tes

  2022-06-01 21:29:17 Views: 218
• 

  Auto-run script after Sybase user logs in

  Recently began to learn sybase, the problems encountered in the learning process will be recorded here, I hope to learn with you. Sybase (ASE) can specify that a script be run automatically to perform the specified action after the user logs in. It is generally a custom stored procedure. Before 15.7

  2022-06-01 21:29:17 Views: 296
• 

  Mongo3.03 enables authentication.

  When mongo3.03 enables auth authentication, there will be some problems that did not exist in previous versions, such as the addition of SCRAM-SHA-1 verification method to mongodb after 3.03. The day before yesterday, I found that the newly built mongo development could not be connected. I tested it with software.

  2022-06-01 21:29:16 Views: 228
• 

  Installation of Extman,maildrop and clamav-0.97.7 in the fifth series of mail services

  Before we have completed the installation and configuration of the basic mail system, let's install and configure Extman-1.1,maildrop and clamav-0.97.7 to complete the construction of the entire mail service system. one。 Install Extm

  2022-06-01 21:29:16 Views: 220
• 

  PHP, MYSQLI implementation pagination (beginners)

  / / the idea of implementing the paging function for the first time (of course, it's someone else's idea, I just wrote it down) / / 1. Calculate the total number of entries if 13 / / prepare sql statements (query the total number of data in the database bbs_ user table) $sql =

  2022-06-01 21:28:55 Views: 271
• 

  Full-text search-Lucene

  01. Description-full-text search (concept) when there is a large amount of data, high requirements, a lot of database content, database search when there is great pressure on the database server, please use full-text search-what is the data searched by the Lucene framework? The side of important multimedia search

  2022-06-01 21:28:43 Views: 264
• 

  Create a database using CREATE DATABASE statements

  This article refers to the way you create a database using create database in Chapter 2 of "Administrator's Guide." In general, the first thing we come across is to create a database using dbca, compared to using create d

  2022-06-01 21:28:42 Views: 300
• 

  SQL Server View the number of connections

  1. Start with Administrative tools-> Administrative tools-> performance (or enter mmc in the run), then add the common statistics of SQL by adding counters and then select user connections in the items listed below to query the number of connections to the database from time to time. However, for this method, you need to

  2022-06-01 21:28:42 Views: 228
• 

  Oracle work record

  Job describes the INTERVAL parameter value as 12:00 every midnight TRUNC (SYSDATE + 1) '08:30 every morning' TRUNC (SYSDATE + 1) + (8: 60: 30) / (24: 60)'in every Tuesday

  2022-06-01 21:28:42 Views: 223
• 

  Navicat usage tutorial: how to identify duplicates with non-unique keys

  Download the latest version of Navicat Premium Navicat Premium is a management tool that can connect to multiple databases. It allows you to connect to MySQL, Oracle and PostgreSQL databases in a single program at the same time.

  2022-06-01 21:28:39 Views: 300
• 

  Oracle_052_lesson_p14

  The concept of Backup and Recovery Concepts backup and recovery you should be able to:Identify the types of failure that can oc

  2022-06-01 21:28:09 Views: 221
• 

  Master-Slave replication of MySQL under Windows

  First of all, the environment I need: I installed two MySQL locally, versions 5.7and 5.5.After installation, they are as follows: 1. Principle of replication: there is a binary log called bin in MySQL, which records all changes to this database.

  2022-06-01 21:27:39 Views: 262
• 

  Master-Slave replication of MySQL based on GTID

  1. What is GTID? 1. Globally unique: a transaction corresponds to a GTID2, replacing the traditional binlog+pos replication; use master_auto_position=1 to automatically match GTID breakpoints for replication 3. MySQL5.6 start support

  2022-06-01 21:27:29 Views: 241
• 

  Linux establishes php script scheduled tasks and scheduled backup database

  1 log='vi 2 and 3, so that you can back up the database directly without entering a password.

  2022-06-01 21:27:06 Views: 268
• 

  Adaptive carousel graph

  $(".slider") .yxMobileSlider ({width:640,height:260,during:3000})

  2022-06-01 21:27:06 Views: 255