NAV: SLTechnology News&Howtos > Database >

• 

  LNMP PHP software installation steps

  1.1.1 solving the dependency of PHP Software install the basic dependency package yum install zlib-devellibxml2-devel libjpeg-devellibjpeg-turbo-devel libi

  2022-06-01 18:19:43 Views: 257
• 

  Why choose mysql database?

  1. Mysql has excellent performance, stable service, and rare abnormal downtime. 2. Mysql has the advantages of open source code, no copyright restriction, low autonomy and low cost. 3. Mysql has a long history, the community and users are very active, if you encounter problems, you can ask for help. 4. Mysql software volume

  2022-06-01 18:19:42 Views: 220
• 

  Oracle Learning-data Migration

  If you are just moving a tablespace or data file, you can first move the tablespace or data file offline and write the location change through alert database rename and alter tablespace rename

  2022-06-01 18:19:42 Views: 208
• 

  Programming fundamentals of shell Learning

  Students who have studied programming languages can quickly start with shell because of the basic character types, circular statements and C language. Let's learn about the following novice basics: 1. Learn some basic character information before learning loop statements: $0, $1, $2, $?, $*, $

  2022-06-01 18:19:35 Views: 226
• 

  The aggregation Framework of mongodb-- aggregate

  The simple operation of the pipe operator in the aggregation framework 1. Mongodb in Mongodb, the first braces in the data query statement db.collection.find ({}, {}) in Mongo are used to control the filter conditions, and the second broad braces

  2022-06-01 18:19:34 Views: 260
• 

  MongoDB Notes 11-count+Distinct+Group

  1. Count () query the number of students whose nationality is the United States. 2. Distinct () find out which countries have students db.runCommond ({distinct: "persons", key: "country"}) .valu

  2022-06-01 18:19:33 Views: 275
• 

  Self-increasing primary key rearrangement of Mysql database tables

  Rearrange the self-increasing primary key of the Mysql database table 1, delete the original primary key: ALTER TABLE `table name `DROP `id`; 2, add a new primary key field: ALTER TABLE `table name `ADD `id` MEDIUMINT (

  2022-06-01 18:19:33 Views: 264
• 

  Learn from me the development of Spring Security-- online Pet Store (2)

  Let's start with a simple Spring Security login. First, we need to set up the environment. Here we use Spring+SpringMVC+Spring Security, Hibernate4+Oracle for the database, and ja.

  2022-06-01 18:19:28 Views: 293
• 

  An example to solve the problem that Oracle 12.2 snooping cannot be started

  When I was doing an experiment in my virtual machine, I suddenly found that I could not connect to the database using PL/SQL Developer, and I reported an error ORA-12514, saying that the monitoring was not started. Let's first introduce the virtual machine environment: redhat7.2+GI 12.2.0.1+Ora

  2022-06-01 18:19:28 Views: 263
• 

  Solve the problem that sqlplus keys and Back Space keys cannot be used.

  When using Sqlplus, we will find that when we want to delete the wrong words with Back Space, we will find ^ H garbled. There are two ways to solve this problem: first, you can delete it by using the key combination of Ctrl+Back Space directly. Second, use it in root.

  2022-06-01 18:19:28 Views: 215
• 

  MySQL engine feature GIS-R-TREE

  MySQL engine feature GIS-R-TREEGeohash is used to encode the latitude and longitude of a location into a string, and the spatial data types that support WGS 84 Coordinate SystemMySQL include GEOMETRY,POIN

  2022-06-01 18:19:27 Views: 285
• 

  TNS-12542: TNS:address already in use

  Research and development said that unable to access the database, the database is running normally, it may be a monitoring problem, a wave of simple operations. [oracle@entegor-1 ~] $lsnrctl startLSNRCTL for Linux: Version

  2022-06-01 18:19:27 Views: 224
• 

  Cannot be solved with backspace and flip up and down commands in oracle

  1. Resolve the backspace cannot be used: edit the .bash _ profile file vi / home/oracle/.bash_profile under the oracle user folder and add the following code stty erase ^ hsource / hom

  2022-06-01 18:19:27 Views: 212
• 

  Install Greenplum5.3

  1. Installation environment two server environment configuration: centos7 + install as follows, one master, one segment. Master is used on a separate server. Two Segment share a server. Different Segment uses different end

  2022-06-01 18:18:57 Views: 241
• 

  Xtrabackup building master-slave

  Using innobackupex to build MySQL slave library knowledge preparation: 1. In the process of backing up InnoDB, the recorded changes are saved in the xtrabackup_logfile file, so when prepare (- apply-log), you need to

  2022-06-01 18:18:51 Views: 296
• 

  Oracle RAC uses Jumbo Frames

  Let's take a look at what Jumbo Frames is. We know that in the TCP/IP protocol cluster, the unit of Ethernet data link layer communication is the frame (frame). The size of 1 frame is set at 1518 bytes, and the MTU (Maxi) of the traditional 10m network card frame.

  2022-06-01 18:18:33 Views: 216
• 

  MHA cluster building

  At the beginning of this article, we mainly introduce how to build a MHA cluster. I hope it will help you to introduce the basic environment of Linux:CentOS 7.4MySQL binlog server 5.7.21 + traditional replication (enable GTID without building binlog server) VIP:192.168

  2022-06-01 18:18:33 Views: 291
• 

  Dealing with the problem of Oracle11gADG standby database downtime caused by ORA-04021

  Find the database alarm, check the alert log, and find the following error Errors in file / u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_lgwr_26383.

  2022-06-01 18:18:33 Views: 213
• 

  Oracle 11g Health Monitor Checks

  Description: Health Monitor is 11g introduced to check the various components of the database (including files, memory, transaction integrity, metadata and process usage). These inspectors will generate a report of the results of the inspection and recommendations for resolving the problem. Available offline in the database (nom

  2022-06-01 18:18:32 Views: 233
• 

  Create tables in mysql database

  The record creates its own database, which needs to be modified in more circumstances. This is an example of a student checking score system: create table info (student_id int not null auto_increment, / / will automatically add value.

  2022-06-01 18:18:32 Views: 261