NAV: SLTechnology News&Howtos > Database >

• 

  Key points of realization of shopping cart

  First, shopping cart module 1.1 the difference between the two implementation of the shopping cart: using session to save shortcomings: browser closed, session failure when saved in the session shopping information will disappear. After optimization, the information of purchased goods will be saved in session.

  2022-06-01 11:03:44 Views: 270
• 

  Database index

  Indexes (index): an index enables mysql to quickly find and retrieve a set of records in a table that contains millions or even billions of data. If you have ever used mysql, no matter how long it takes, you may have used indexes to get query results more easily. You may also find m

  2022-06-01 11:03:44 Views: 278
• 

  Oracle's disk testing tool orion

  It hasn't been used for a long time. Use it again before putting it online: usage:-run [normal] | | [advanced]-testname: the name corresponds to your file name-num_disks: number of hard drives-size_small: small random workload.

  2022-06-01 11:03:43 Views: 277
• 

  MySQL/MariaDB partition

  View the table creation command SHOW CREATE TABLE my_table_name; to see if the table is partitioned (the Create_options field is partitioned or empty) SHOW TABLE STATUS

  2022-06-01 11:03:43 Views: 215
• 

  The solution of Oracle ASM Database failure data recovery

  [fault description] the ASM disk group is offline and the ASM instance cannot be mount. The ASM disk group is composed of four 500G disks, and the database and ASM software is 10.2.0.1. It is urgent to restore the oracle database. [fault Analysis] analyze the disks that make up the ASM disk group

  2022-06-01 11:03:31 Views: 202
• 

  Lamp compilation and installation + discuz+ Zen

  The required software prepares systemctl stop firewalldsetenforce 01. Compile and install httpdyum install-y net-tools pcre-devel zlib-deve

  2022-06-01 11:03:31 Views: 234
• 

  The relationship between Oracle password File and user password

  Today, a colleague received a task to change the passwords of database SYS and SYSTEM users. The boss also brought a sentence to synchronize the password files when assigning the task, so he thought of a blog he wrote a few days ago about Oracle password files. At that time, he only wrote about how to create passwords.

  2022-06-01 11:03:30 Views: 228
• 

  Ora-03113 problem solving

  Oracle 11g ora-03113 problem solving 1. When the database has been closed: Sql > startup nomount 'start the database to NOMOUNT state 2, modify the flashback space size Sql > alter system s

  2022-06-01 11:03:30 Views: 299
• 

  MySQL client execution process

  From the following example, when the client connects to MySQL, the execution statement includes the following procedure: 1. Verify whether you can log in to the MySQL server. two。 Syntax analysis determines whether the execution statement is legal and there are no statement errors. 3. Permission analysis determines whether the execution statement has the relevant permissions on the target. 4. Language

  2022-06-01 11:03:30 Views: 274
• 

  How to connect to the database after the loss of mysql.sock

  Security code: it is impossible to have inner peace without a considerable degree of loneliness. [phenomenon] mysql.sock was deleted, resulting in unable to connect to the database. [root@MySQL-01 ~] # mysql-uroot-pEnter password:

  2022-06-01 11:03:30 Views: 286
• 

  Mango database configuration file

  Configuration file: mongod.confsystemLog: destination: file logAppend: truestorage: journal: enabled: true

  2022-06-01 11:03:29 Views: 233
• 

  Understanding of parameters related to db links

  Db link related parameters understand the number of times the max_connect_errors:tcp/ip link is established waiting for client to send account, password and other authentication information after the connect_timeout:tcp/ip link is established

  2022-06-01 11:03:29 Views: 280
• 

  Conceptual understanding of Server_name and SID in ORACLE

  Blog description [preface]: this article will introduce the related concepts of Server_name and instance name SID in ORACLE in a personal tone. At the current time point [May 22,2017], the technical level mastered is limited, and there may be a lot of knowledge that is not deep enough or

  2022-06-01 11:03:29 Views: 213
• 

  Access date and time query

  Access date and time condition query if the data type of the field is Date/Time, the data that is accurate to minutes and seconds cannot be queried in a common way. The solution is as follows: accurate to date: select * from user where userI

  2022-06-01 11:03:28 Views: 282
• 

  Solution to the failure of sqlserver Database Log shrinkage

  1. Database-shrink-log-can shrink by more than 90%, but after shrinking, the capacity has not been reduced. It is possible that the log is occupied and cannot be contracted for the time being. 2. Select log_reuse_wait_desc from sys.data

  2022-06-01 11:03:28 Views: 268
• 

  Innodb-Binary Search algorithm

  1. Background * Binary Search (binary search), also known as half-and-half search, is used to find a record in an array of ordered records. The basic idea is to sort the records in order (increasing or decreasing) * to find them in a jumping way during the search process. two。 Excellent

  2022-06-01 11:03:25 Views: 215
• 

  Construction and configuration of Oracle11g Data Guard physical standby database (part 1: creation of primary database instance)

  Environment preparation in my test environment, I prepared two CentOS7.4 virtual machines and installed Oracle11gR2 11.2.0.1.0 enterprise version of database software at the same time, in which only the primary server created a database instance and the standby server only installed Orac

  2022-06-01 11:02:55 Views: 277
• 

  Management of Oracle UNDO tablespace

  The management of UNDO table space is one of the most important daily tasks of Oracle DBA. UNDO table space is used to store data of DML operations temporarily. Its main functions are: 1, transaction rollback 2, instance recovery 3, read consistency 4, flashback the following are some operations on UNDO table space 1

  2022-06-01 11:02:29 Views: 270
• 

  Several Writing methods of arranging sequence in TSQL order by clause

  The Order by clause is used to sort the results, and the execution order is after the select clause. The sort column is written in 4 words: column_namecolumn_alias, because the execution order of the order by clause is after the select clause.

  2022-06-01 11:02:13 Views: 227
• 

  MySQL5.5 multi-instance installation

  one。 To put it simply, it means to open different ports on a server and run multiple MySQL service processes. These service processes provide their own service 1.2MySQL by listening to different service ports through different socket.

  2022-06-01 11:02:10 Views: 239